You asked:
I'm new to MySQL and loving it. So pardon my lack of the simple things. I
need to index a table where the field is indexed, so when I look at the in
the PHP script it is in order.
Also when I run a query how can I save the results as a new table?
I reply.
1. You need an ORDER BY clause at the end if the SELECT statement.
2. You need the CREATE TABLE .... SELECT statement.
Both are easy to find in the online MySQL manual.
Alec
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
