first off, the obvious warning that i am a novice....but here goes...
I have managed to pisece together a script that selects from MySQL, displays the data as I want it and includes 'prev/next' buttons etc....It works fine when the 'WHERE whatever' part of the select query is in the same script, however, when I try and tie up the script with a seperate form to post the WHERE variable (ie WHERE id is '$form_input') to the search script, i find that though it displays the first page of results ok, the 'next' link comes up with no results even though it knows there should be a following page....
Can anyone help? Or even understand what i'm trying to say?
I have managed to pisece together a script that selects from MySQL, displays the data as I want it and includes 'prev/next' buttons etc....It works fine when the 'WHERE whatever' part of the select query is in the same script, however, when I try and tie up the script with a seperate form to post the WHERE variable (ie WHERE id is '$form_input') to the search script, i find that though it displays the first page of results ok, the 'next' link comes up with no results even though it knows there should be a following page....
Can anyone help? Or even understand what i'm trying to say?