Query Works In Query Browser But Not In Php

[Staggan]

Hello

 

I am trying to run a query on a php page but I am getting an error... although the query works fine in MySQL query browser

 

This is the query

 

$result = mysql_query("INSERT INTO challenge ( challenge_game_length, challenger_team_id, opponent_team_id, challenge_due_timestamp_gmt) VALUES  ( 20, $c1, $c2, UNIX_TIMESTAMP());");

 

 

This is the error

"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' , UNIX_TIMESTAMP())' at line 1"

 

I have tried replacing the timestamp with a valid number instead... but get the same error

 

Any ideas?

[gristoi]

$result = mysql_query("INSERT INTO `challenge` ( `challenge_game_length`, `challenger_team_id`, `opponent_team_id`, `challenge_due_timestamp_gmt`) VALUES ( 20, '{$c1}', '{$c2}', NOW());");

[PFMaBiSmAd]

The error is because your $c2 variable is empty or it contains a non-numerical value that is breaking the syntax of the query statement. You need to form your sql query statement in a php variable ($query) and echo it so that you can see exactly what it contains.

 

Where is the $c2 variable being set at and why didn't your validation logic prevent the query from being executed without a valid number in $c2 (opponent_team_id)?