How to use mySQL WHERE clause in PHP?

[sensitive]

Can't seem to pass anything from the "securityinfo" field. \[code\]for ($k = 1; $k < $fieldscnt; $k++) { $selectsecurityname = mysql_query("SELECT `security name` FROM securityinfo WHERE symbol = '$symbol[$k]'") or die(mysql_error()); $securityname = mysql_fetch_array($selectsecurityname); $sym = $symbol[$k] echo "<td>$securityname[$sym]</td>";\[/code\]Basically, I want to to search for the row that has a match in the "symbol" field, then return the value from the "securityinfo" field in the same row. Any suggestions would be greatly appreciated