I need to pull a variable number of fields from a table from the last
inputted fields. For example, instead of doing something like
"SELECT * FROM table"
I am looking for a way to do something like this(hypothetical, I don't
really know what I should do).
"SELECT LAST_TEN_FIELDS FROM table"
which would then pull the most recent ten rows from the table. The reason
why I am asking this mailling list is because I am writing a small program
using PHP and want to get the ten most recent fields. However, since it
is PHP and the script is going to have high traffic, I need to know the
most efficient way of pulling the last ten fields. I know I can do it
through PHP by sorting out the results, but I want the whole thing to be
as streamlined as possible and don't want to have the PHP script in 4
months chugging away for hours trying to work with the data of 1000 fields
pulled from mySQL.
This is the structure I have in mind for the table, and this is not 100%
official, but was the way I had initially planned it to go.
id INT NOT NULL AUTO_INCREMENT,
data VARCHAR(200),
PRIMARY KEY(id)
The script is going to take a little bit of data, and is only going to
need to display the most recent(top ten probably) results entered, which
is why I need to know if there is an efficient way to do this in mySQL
without causing thousands of chunks of data to have to be handled by PHP.
All help is appreciated,
-Eric
---------------------------------------------------------------------
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
