INSERT Statement Does Not Work

[wayne_yellow]

Hi,

I am trying to write below INSERT sql statement to insert a row of data.

I check the mySQL table, the data is not being inserted and there is no error shown. However, the INSERT statement works fine when I manually input through the mySQL command line.

** NOTES:
- I am using PHP 5.2.6, mySQL 5, Ms. IIS Web Server, and MySQL ODBC 5.1 driver.
- I tried on odbc_exec and odbc_execute but both does not work

<?php
$conn=odbc_connect('myDSN','root','password');
if (!$conn)
{exit("Connection Failed: " . $conn);}
$sql="INSERT INTO user_profile (user_id, fname, lname) VALUES ('LISA', 'LISA', 'SIMPSON')";
echo $sql;
$rs=odbc_exec($conn,$sql);
odbc_close($conn);
?>

Could anyone help please, thanks a lot.

/.. Wayne.

[reddrum]

Hey Wayne,
Is your user_id an auto increment field? If so "LISA" is the wrong value for that field, should be 0.

[wayne_yellow]

Hi Reddrum,

Thanks for answering my question.

Below are the details of the "user_profile" table:

mysql> describe user_profile;
+---------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| user_id | varchar(20) | YES | | NULL | |
| pwd | varchar(20) | YES | | NULL | |
| fname | varchar(50) | YES | | NULL | |
| lname | varchar(50) | YES | | NULL | |
| rights | int(11) | YES | | NULL | |
+---------+-------------+------+-----+---------+-------+

From addUser.php, I printed: INSERT INTO user_profile (user_id, fname, lname) VALUES (LISA, LISA, SIMPSON) when processing this statement on the scree and I managed to manually execute this statement via mySQL Command Line Client to insert the data into "user_profile" table.

Thanks and regards,
/.. Wayne.

[sheephat]

$conn=odbc_connect('myDSN','root','password');

is root actually root, or is it a user that could posibly not have access to the database, or be allowed to write to such.??

[sheephat]

LOL

i sussed it, it was so easy.

You havent selected your database!

[sheephat]

I cant believe i didnt see that, i have been looking at this for the past 20 mins, here you go:

http://uk.php.net/manual/en/function.mysql-select-db.php