[SOLVED] another sql error...

[mike12255]

So i cant figure out what or how, but aparently in my sql i have a constent escaping the string can anyone spot the error..?? Name is defined earlier it is passed as a paramiter through the function.

 

<?php
$x=2;
$z=1;
while($x != 0){
$temp2 = $name.$x;
$get = "SELECT content FROM " .NC_DB_PREFIX." content WHERE name ='".$temp2"'";
$res = mysql_query($get) or die (mysql_error());
$row = mysql_fetch_assoc($res);
?>

[mrMarcus]

$get = "SELECT content FROM " .NC_DB_PREFIX." content WHERE name ='".$temp2"'";

 

should be:

 

$get = "SELECT content FROM " .NC_DB_PREFIX." content WHERE name ='".$temp2."'";

 

you were missing a connecting . after $temp2