Try escaping the quotes: $ssql="select concat(category, \"-\", code) as ..."
Either that, or try surrounding the - with single quotes, as in '-'. What's probably happening is that the query is being rendered as "select concat (category, ", which isn't a valid query. At 10:15 AM 10/24/2001, you wrote: >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 >value='".$row["submit_column"]."'>'".$row["fill_column"]."'</OPTION>"; > } > >Help is appreciated. > >Regards, >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] Sliante, Richard S. Crawford http://www.mossroot.com mailto:[EMAIL PROTECTED] AIM: Buffalo2K ICQ: 11646404 Y!: rscrawford "It is only with the heart that we see rightly; what is essential is invisible to the eye." --Antoine de Saint Exupéry "Push the button, Max!" -- 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]