Re: calling from database
| From: | Daniel Convissor | Date: | Mon, 07 Aug 2000 23:41:44 +0000 |
| Subject: | Re: calling from database | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-10554@lists.php.net to get a copy of this message | ||
owen mcgrann wrote:
>
> $str_sql = "
> select *
> from $table_name
> order by $sort_field $sort_direction
> limit $initial_record, $number_records_to_display
> ";
Maybe it's the missing comma:
order by $sort_field, $sort_direction
In general, if you have a query problem, use mysql_error() or echo the query
string back and copy/paste it into the MySQL command line. You'll find your
problem quickly.
--Dan
--
T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y
More than just answers. Solutions. (SM)
http://www.analysisandsolutions.com/
4015 7 Av #4, Brooklyn NY 11232 v: 718-854-0335 f: 718-854-0409