[SOLVED] good SQL but dying

[Q695]

output:

sql error

sql : SELECT * FROM criteria WHERE id='2';

 

<?php
$sql="SELECT * FROM criteria WHERE id='$row_id';";
$result=@mysql_query($sql,$con) or die(death($sql));
//get the results
$row_pull=@mysql_fetch_array($result);?>

[Lodius2000]

try

<?php
$sql="SELECT * FROM criteria WHERE id=".$row_id;
$result=@mysql_query($sql,$con) or die(death($sql));
//get the results
$row_pull=@mysql_fetch_array($result);?>

 

you dont need a ; in a sql statement, thats only in raw sql

[Q695]

That was the exact same thing lodius

[Q695]

It was trying to pass $con into the function when it's not assigned

[Lodius2000]

my bad... as it was a snippet I was assuming $con was defined