Can't get data into MySQL

[Pitmaster]

What's wrong in the next code.....?

<?php
$db=mysql_connect("localhost", "loginname", "password") or die ("Verbinding mislukt");
mysql_select_db("administratie", $db);
$datum = "2003-03-03";
$reden = "The fox etc.....";
$km = 102;
$invoer = "INSERT INTO reiskosten (reis_ID, datum, reden, kilometers) VALUES ('', '$datum', '$reden', '$km')";
//reis_ID is autoincremment
//datum = date
//reden = varchar 120
//kilometers = int
mysql_close();
?>

I hope it is someting simpel, a newbie like mistake 🙂

Nico Berg

[jpmoriarty]

yes im afraid it is a newbie one - you've not actually run your query.

you'll need

mysql_query($invoer);

to run your query afteryou've defined what $invoer is.

[Pitmaster]

And this is it................ Shame on me.

Thank's jpmoriarty.