fill MySQL table with PHP

[edward hage]

Hello, I don't seem to get the following right.

In the following I try to fill a MySQL table named 'mutation'. The first
element is a date but MySQL sees this as 0000-00-00 instead of the
date 2002-11-01. Other problem is the textstring in
$_POST['verklaring1'], in MySQL this stays empty.

Can anybody help me with these problems, what am I ding wrong ?
<?php
$query = "insert into mutation values (2002-11-01, 1, 4, 1, 4, 10, 330 ,
' $_POST['verklaring1'] ',\N,\N,\N,\N)";
mysql_db_query("projects", $query);
?>

Thanks, Edward

[Aggro]

edward hage wrote:

Hello, I don't seem to get the following right.

In the following I try to fill a MySQL table named 'mutation'. The first
element is a date but MySQL sees this as 0000-00-00 instead of the
date 2002-11-01. Other problem is the textstring in
$_POST['verklaring1'], in MySQL this stays empty.

Can anybody help me with these problems, what am I ding wrong ?
<?php
$query = "insert into mutation values (2002-11-01, 1, 4, 1, 4, 10, 330 ,
' $_POST['verklaring1'] ',\N,\N,\N,\N)";
mysql_db_query("projects", $query);
?>

2002-11-01 is supposed to be string, so it should be inside '' characters.

$query = "insert into mutation values ('2002-11-01', 1, 4, 1, 4, 10, 330

Also do:

echo "My query is: " . $query;

To see how your query looks like. You might found out the reason why
verklaring1 stays empty.

[Aggro]

edward hage wrote:

Hello, I don't seem to get the following right.

In the following I try to fill a MySQL table named 'mutation'. The first
element is a date but MySQL sees this as 0000-00-00 instead of the
date 2002-11-01. Other problem is the textstring in
$_POST['verklaring1'], in MySQL this stays empty.

Can anybody help me with these problems, what am I ding wrong ?
<?php
$query = "insert into mutation values (2002-11-01, 1, 4, 1, 4, 10, 330 ,
' $_POST['verklaring1'] ',\N,\N,\N,\N)";
mysql_db_query("projects", $query);
?>

2002-11-01 is supposed to be string, so it should be inside '' characters.

$query = "insert into mutation values ('2002-11-01', 1, 4, 1, 4, 10, 330

Also do:

echo "My query is: " . $query;

To see how your query looks like. You might found out the reason why
verklaring1 stays empty.