I am using concat in my sql and it runs fine on mysql client. But when used
in php it gives me an error:
Supplied argument is not a valid MySQL result resource in
<b>/var/www/html/scripts/cfg_code_delete.php</b> on line <

$ssql="select concat(category, "-", code) as fill_column, code_id as
submit_column from sys_code_tbl order by category";
echo "<OPTION  selected value=\"\"></OPTION>";
$result = mysql_query($ssql);
while ($row = mysql_fetch_array($result))
      echo "<OPTION

Help is appreciated.

Harpreet Kaur
Software Developer
Crispin Corporations Inc.

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to