you can do it at sql level by using ORDER BY ... DESC like:
SELECT * FROM categories
WHERE cat_id = '$cat'
ORDER BY cat_id DESC
and then proceed the returned recordset in 'normal' way (order)
--
Douglas Freake wrote:
Hi there,
I need to do a loop where the mysql query starts
at the bottom and
Putting more than one table in the FROM clause means tables are joined,
then at least following problems could arise:
- using WHERE clause you can have empty recordset returned and then
COUNT conflicts with it because there is actually no any data to be
returned;
- joining two (or more)
A bit difficult to debug this without the file included (config.php);
providing the error message would also be helpful.
At first glance, I'm just wondering what does the dot mean in the table
name used in the FROM clause:
FROM school.physics_chris_rockets
It shouldn't generate a php syntacs
if tables are joined correctly it shouldn't be any problem to get count
of a column, and yes - delegating that task to the database should be
more efficient concerning the execution time
boyan
--
[EMAIL PROTECTED] wrote:
maybe mysql cannot COUNT the result from more than 1 table, hence the