[SOLVED] foreach error

[masgas]

I have this code. I get the message: Parse error: syntax error, unexpected T_STRING in /home/..../test.php on line 7   any ideas why???

 

$con = mysql_connect ('','','') or die ("no con");

@mysql_select_db ('$db_name') or die ('error DB');

$col = array('1'=>RED, '2'=>GREEN, '3'=>BLUE, '4'=>BROWN);

foreach ($col as $key => $value){

$sql= "SELECT $value FROM users WHERE nick = '$_SESSION[nick]'";

$res= mysql_query($sql) or die mysql_errno($sql);

while ($row=mysql_fetch_assoc($res)){

if ($row[$valor]!=''){$var= $row[$valor];}

echo $var;

}

}

 

 

?>

[benjaminbeazy]

your query is messed up, echo $sql and see what it looks like

[masgas]

Hi this is what it echoes!

 

SELECT RED FROM users WHERE nick = 'LEVC'SELECT GREEN FROM users WHERE nick = 'LEVC'SELECT BLUE FROM users WHERE nick = 'LEVC'SELECT BROWN FROM users WHERE nick = 'LEVC'

[pocobueno1388]

Change this line:

$res= mysql_query($sql) or die mysql_errno($sql);

 

To This:

$res= mysql_query($sql) or die (mysql_errno($sql));

 

[masgas]

ok... that worked just fine!

 

thank you

 

[pocobueno1388]

No problem Don't forget to click the solved button on the bottom left corner.