Quick one about INSERT

[ozzysworld]

Hi guys, just a quick one.

This page on my site http://websitesbyshane.co.uk/richmond/planthire.php displays all my entries in my database and creates pages for each as they're clicked..

I'm stating that so you understand my database is working ok.

My problem is that I can only insert new data through phpMyadmin.

Here's an example of what my code does

/
<?php

//bla bla bla

include_once('login.php');
$sql = "INSERT INTO `Mydatabase`.`richplant` (`ID`, `name`, `desc`) VALUES ('7', 'Plant 7', 'Plant 7 description');";
mysql_query($sql);
?>

The script runs ok, but the data never enters the database.

Any ideas why?

Thanks, you've helped a million times before!

[bradgrafelman]

Check if [man]mysql_query/man is returning boolean FALSE and, if so, check to see what [man]mysql_error/man has to say.