From: "pete M" <pmorgan@xxxxxxxx>
> > do not quite understand your problem.. pls post some code?
> > heres a small snippet that should work well...
> >
> > $qry = 'SELECT `customer` FROM `customerList` ORDER BY `customer`';
> > $res = mysql_query($qry);
> > while($customer = mysql_fetch_object($res)) {
> > echo stripslashes($res->customer).'<br>'."\n";
> > }
>
> why the backticks and not quotes ?????
Because quotes would make it a string. Backticks are used to deliminate
column and table names.
If you said: SELECT 'column' FROM Table
You'd get a result set with the literal string "column" as the value. Works
the same in the WHERE, ORDER BY, GROUP BY, etc clauses, also.
---John Holmes...
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
