Excellent, thank you!

Suzanne — Fri, 10 Aug 2001 00:45:56 +0000

This is pretty intuitive, once I get the syntax conventions sorted out.

Thanks!

Suzanne

Mark Hensler — Thu, 09 Aug 2001 16:00:40 +0000

Another source to look at is http://www.mysql.com
They have pretty good documentation and examples.

I did it!

Suzanne — Thu, 09 Aug 2001 09:04:44 +0000

Thanks to knowing what to look for, I went over to http://www.php.net and searched for "ORDER BY" and in the results was:

$result = mysql_query ("select * from phpcal where approved=0 order by sdato"); 

Which I adapted to:

$result2 = MYSQL_QUERY("SELECT * FROM members ORDER BY lastname, firstname");

Which WORKS!! I was missing the right way to type the darn thing, I guess.

WHEE HA! Thank you, Mark!

Suzanne

this part?

Suzanne — Thu, 09 Aug 2001 08:17:23 +0000

  $usertable = 'members';
  $query2 = "SELECT * FROM $usertable";
  $result2 = MYSQL_QUERY($query2);

Is this what I'm looking to append? Sorry to be so daft but an example would be much appreciated.

Learning MySQL and PHP is on the "when I'm on mat leave" list...

Suzanne

Edited to add: I've tried the suggested commands (and looked them up in my books, thank you! it's nice to have at least a rough idea of what I'm looking for) and it doesn't seem to matter where I put it, it causes some weird nonvalid error report.

I'll keep trying, but a good example would be much appreciated!

Mark Hensler — Thu, 09 Aug 2001 07:32:53 +0000

Can you post the query for $result2?

You should be able to append the query with "ORDER BY field_name ASC"
ASC=ascending
DESC=descending