[SOLVED] PHP + SQL

[rhyspaterson]

Hey guys,

 

Trying to run quite a simple piece of code:

 

$query = "SELECT * FROM usr WHERE regno = $registrationID";

 

However i am getting syntax errors at the end of the line, but not sure what i am doing wrong.. any suggestions?

 

Cheers

[teng84]

can you send us the error

[rhyspaterson]

Warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at end of input LINE 1: SELECT * FROM usr WHERE regno = ^ in /var/www/menu/client/form/process.php on line 11

Query failed: ERROR: syntax error at end of input LINE 1: SELECT * FROM usr WHERE regno = ^

[teng84]

$query = "SELECT * FROM usr WHERE regno = ".$registrationID."";

try that

 

or check if $registrationID has value

[trq]

$query = "SELECT * FROM usr WHERE regno = '$registrationID'";

[rhyspaterson]

Thanks for the reply. I have tried that above code previously as well. However i receive a different error message:

 

Warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for integer: "" in /var/www/menu/client/form/process.php on line 11

Query failed: ERROR: invalid input syntax for integer: ""

 

I do checks to ensure $registrationID is not NULL and is only numbers. Any suggestions?

[rhyspaterson]

Ah sorry, yes the above code did work. Thank you v. much