Posted 02 August 2006 - 06:34 PM
pagenumber user comment commentnumber
34 john Hey, I like to post comments! 305 (auto increment)
and to get the comments for the page:
select * where pagenumber = '$pagenumber'
Would this be the best method for getting the comments if I expect the comments to get into the hundred-thousands?
I really can't think of any other way.
Posted 02 August 2006 - 06:38 PM
SELECT top 10,* from (table)
WHERE blah blah
What exactly do you want to see?
Posted 02 August 2006 - 06:40 PM
Posted 02 August 2006 - 06:43 PM
My way is a tad complicated though, and I'm not sure if there's a better way.
Posted 02 August 2006 - 07:17 PM
Why don't you set the first letter of the script title as "startswith" in the database at the posting of the script into database, then do
select * where startswith = '$letter' SORT BY title
Posted 02 August 2006 - 07:26 PM
SELECT * FROM table LIMIT 0,10Show 10 records, starting from row 0.
or [php] * 1000... PLEASE READ THE POSTED SOLUTIONS CAREFULLY * 1000000...
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users