prev/next link pages

[paulsam]

hello,

i am creating a search page that shows 1-25 records per page. I want to split the search results:
1 [2] 3 4 5 6 7 8 9 10 <next>
where [2] represents records 26-50 (direct links to remaining pages)

i have found a code for this feature but when i used
variable tablename ($table) )in my query. huh! doesnt work anymore(see below code):

$query = mysql_query(&quot;SELECT * FROM $table WHERE FNAME='$fname' ORDER BY LNAME, FNAME&quot;

i tried not using the variables & it works. i need to use the variables coz the the design of my php has an authentication. im using their usernames as their table name as well as their search input.

is anyone there can help me.... plss..


army
army@idess.com

 

[devnull22]

Verify that the $table variable is passed correctly and
actually has a value.

if you need more example codes go to :

http://www.akawebdesigner.com/php_script.php?category_id=2

cheers
Ken

http://www.akaWebdesigner.com

http://www.clickEval.com