Problem with
| From: | webmaster at tececo dot com | Date: | Sun, 19 May 2002 03:05:19 +0000 |
| Subject: | Problem with | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-98318@lists.php.net to get a copy of this message | ||
I have the following code for a mySQL query in php:
$text = "sort_text";
$query = "SELECT code FROM links ORDER BY $text WHERE ".$text." like
'".$l."%'";
$result = mysql_query($query) or die("Query failed");
When I do the query I get Query failed.
When I remove the sort parameter they are all printed correctly(except the fact the aren't in
alphabetical order)
I am a newbie so be nice.
Any Ideas?
JJ Harrison
webmaster@tececo.com
www.tececo.com