Next | Prv : Where vs LIKE??

[Anon]

hiiiii to alll;

iam vary badly need of help in this script that was downloaded for phpbuilder... for implementing Prv Next Links....

the problem is ... if the sql statement was something with LIKE, the statment is not updated when pointing to the NEXT page as it is not carried forward throug the links to the rest pages..

on the other hand ... if the sql statmeent was just simple Where XX = $XX .. This works fine.. and links are carried forward throug the rest pages..

please have a look at this scrip

http://brilliants.multimania.com/TestPrvNext.txt

Pllllllllllllllese HEEEEEEEELP

Thak You.............

[[deleted]]

First I'd advise you to read a little bit about coding standards. The code you have is completely unreadable.

Second, the query you build uses a var called $Title, but the only place where $Title is used is inside the query. Where do you define what $Text should be?

A few notes on the side:
Why do you first run the query without the LIMIT clause and then again with the LIMIT clause? makes no sense to me.

You check for errors (good boy) but all you do is print the error:

$getTotalRows = mysql_query($sql,$con);
if (!$getTotalRows)
{
echo mysql_error();
}

and then you proceed to work with the query results no matter if there was an error or not.

Have a look at this:
http://www.hvt-automation.nl/yapf/index.php?cmd=viewitem&itemid=12

but most important of all, teach yourself to write readable code!