Re: Re: Newbie Questions
| From: | anirudh dutt | Date: | Mon, 06 Sep 2004 18:14:36 +0000 |
| Subject: | Re: Re: Newbie Questions | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-36073@lists.php.net to get a copy of this message | ||
> > Well, I have this:
> >
> > $result=mysql_query('SELECT * FROM $table ORDER BY lastname, street, housenum
> > ASC');
> >
if u're trying to use variables like $table in the query (which i
think u are), they need to be in double quotes : " " not single
quotes. so the line should be:
$result=mysql_query("SELECT * FROM $table ORDER BY lastname, street,
housenum ASC");