[RESOLVED] PHP/MySQL insert help

pps_dev

This is my first post so hello everybody.

I am relatively new to PHP/MySQL but understand the concepts. I am trying to do execute simple INSERT statement into a MySQL db. Here is the code:

$query = "INSERT INTO ".$tb_basket." (`$b_id`, `$p_id`, `$p_quantity`, `$b_session_id`, `$b_date`) 
VALUES ('".$basket->get_b_session_id().date("Ymd")."', NULL, NULL, '".$basket->get_b_session_id()."', '".$date."' )";
			$result = mysql_query($query) or die("Error: create_basket not completed")

;

which produces:

INSERT INTO tb_basket (`b_id`, `p_id`, `p_quantity`, `b_session_id`, `b_date`) 

VALUES ('u9k0p8cp273cmgt3v35jmrra6720071214', NULL, NULL, 'u9k0p8cp273cmgt3v35jmrra67', '2007-12-14 13:57:11' )

If I enter the query through command line it works, using it through a browser produces the die message and inserts nothing.

Why is this?

Any help greatly appreciated,

Cheers

PPS Dev

Kudose

You can use backticks on the command line, but not in the script. Remove them and it should work.

pps_dev

Thanks for the quick reply.

I tried changing everything to single quotes but it still didn't work. Then I removed the single quotes from the field names, still didn't work.

Also tried it with normal quotes ("value") but this again didn't work.

Quite stuck.

redrage

try this, not sure if it'll work but it looks right to me
also added mysql_error() to the die command that way when/if it fails it will give you a better error as to why or it will confuse you even more. please include that error in future posts makes error tracking easier 🙂

$query = "INSERT INTO " . $tb_basket . " ($b_id,$p_id,$p_quantity,$b_session_id,$b_date)
VALUES ('$basket->get_b_session_id().date('Ymd')', NULL, NULL, '$basket->get_b_session_id()', '$date' )";

$result = mysql_query($query) or die("Error: create_basket not completed: " . mysql_error());

pps_dev

Sorted now thanks, the insert statement was fine, the mysql_error() bit saved me! I had been moving the code which selected the database to use around and not put it back in.

Many thanks for the help.

PPS Dev