Ok I know how to display the first or last 10 results of a query...
$result = mysql_query("SELECT * FROM messages ORDER BY timemsg DESC LIMIT 10");
In a perfect world all the rows ID's would be in perfect order (i.e.- 10,9,8,7,6,5,4,3,2,1), so to display messages 30 to 40 I would just do LIMIT 30,10
but because of certain unforseen situations the actual results will end up being more like-
457
455
454
453
449
448
447
419
418
410
So I can display the last 10 results in descending order but then to show the "previous 10" results (using the above numbers for an example), I'm thinking I need to somehow
capture the last result in this query (410) so when you hit "previous 10" link it passes it through GET to the next page and the next page will use something like LIMIT $start,10
to display the 10 results with before "410" and so on. Any idea how to do this, I don't think it should be that hard, just can't figure it out. Sorry, if this is in wrong thread,
feel free to move to MYSQL board if it belongs there.. Thanks for any help!
confused between ' ' and " "
there is a php i set:$begin_date_query = mysql_query( "SELECT SUBDATE(due_date, INTERVAL $days_expected DAY) AS begin_date FROM baby WHERE baby_id = $_SESSION['baby_id']" );'coz of the
Hardcopy printing is to wide
I want to make a hardcopy at runtime of my active form like this
Tracking Unique Clicks
Hi guys and gals,Basically I have a database which tracks clicks on my outbound links, I do this by linking to a page like so.../redirect.php?id=1The page then reads the id and increments the click
present value of sequence?
Hi
Must be a string? Huh, what? HELP?
with the following script, I get Fatal error: Property name must be a string in /home/content/e/s/o/esone/html/test/123.php on line 24Anyone maybe know what is causing it?Code: <?phpfunction
Wrong Info sent Using $get in form
Hi i have this code that i tried to make to send some info from one page to aother with lots of ppls help and it works ok but when i have multiple files it doesnt send the correct info.What im tryin
PHP - HTML
Could anyone give me some GOOD sample links for php - html email tutorial.Thanks!
generating all possible random letters
hi'how can i randomize the letters a,b,c,d,e all possible ways, and i want to print the resultand unique from each?thanx
Preg_match question
I want to use preg_match to make sure a string is always 6 characters long and only contains 0-9 and the letters A-F.I have this but it does not work:'/^[0-9A-F]{6}$/'
Mysql error message
help me find out what this error message means:"Duplicate entry '0' for key 'PRIMARY'"the sql for it is Code: INSERT INTO accounts (firstname, lastname, username, password, joined, email,
