[eq1987]

Hi, i have a small script that lets users search through a DB. It will display everything that is relevant. Could someone direct me on how i could have a next page button. Like this: Next - 1 - 2 - 3 - 4 - 5 -
The numbers being links to further pages. Thank you.

[NeverMind]

http://www.sfsj.net/tips.php?id=1

[eq1987]

Ok i tried what he said, although i am getting a parse error (starts at $SQL) , and i see none. Also, could someone scan this code, and determine if it will work (if i get the parse fixed). Here is my code:

<?php
$connect = @mysql_connect("localhost", "asdf", "asdf") or die("could not connect to server");

$db_select = @mysql_select_db("asdf") or die("could not select the database");

$SQL = "SELECT * FROM itemsearch WHERE itemname LIKE \"%$user_input%\" LIMIT $startrow, 10");

//check if this is the first page
if (!isset($_GET['startrow']) or !is_numeric($_GET['startrow'])) {
//we give the value of the first row to 0
$startrow = 0;
//otherwise we take the value from the URL
} else {
$startrow = (int)$_GET['startrow'];
}

$result = @mysql_query($SQL) or die("Could not run query");



while($row = mysql_fetch_array($result))
{
echo("<tr>");
echo("<td class='cntbxleft'> &nbsp;");
$url = ("$row[url]");
echo("<a class='bluetu' href='$url'>$row[itemname]</a></td>");
echo("<td class='cntbxmid'>$row[str] &nbsp;</td>");
echo("<td class='cntbxmid'>$row[agi] &nbsp;</td>");
echo("<td class='cntbxmid'>$row[sta] &nbsp;</td>");
echo("<td class='cntbxmid'>$row[int] &nbsp;</td>");
echo("<td class='cntbxmid'>$row[wis] &nbsp;</td>");
echo("<td class='cntbxright'>$row[effect_one] &nbsp;");
echo("</tr>");
}

//now this is the link..
echo "<tr><td><a href="itemsearch.php?startrow='.($SQL+10).'">Next</a></td></tr>";

?>

[mdhall]

You forgot the opening " ( " in your query.

$SQL = ("SELECT * FROM itemsearch WHERE itemname LIKE \"%$user_input%\" LIMIT $startrow, 10");

[eq1987]

Ok, now i get on my page - Could not run query.
Once again my code:

If anyone can find out why, could you possibly look at my code, and tell me what to fix so it will run proper. Thanks

<?php
$connect = @mysql_connect("localhost", "asdf", "asdf") or die("could not connect to server");

$db_select = @mysql_select_db("asdf") or die("could not select the database");

$SQL = ("SELECT * FROM itemsearch WHERE itemname LIKE \"%$user_input%\" LIMIT $startrow, 10");

$result = @mysql_query($SQL) or die("Could not run query");

//check if this is the first page
if (!isset($_GET['startrow']) or !is_numeric($_GET['startrow'])) {
//we give the value of the first row to 0
$startrow = 0;
//otherwise we take the value from the URL
} else {
$startrow = (int)$_GET['startrow'];
}


while($row = mysql_fetch_array($result))
{
echo("<tr>");
echo("<td class='cntbxleft'> &nbsp;");
$url = ("$row[url]");
echo("<a class='bluetu' href='$url'>$row[itemname]</a></td>");
echo("<td class='cntbxmid'>$row[str] &nbsp;</td>");
echo("<td class='cntbxmid'>$row[agi] &nbsp;</td>");
echo("<td class='cntbxmid'>$row[sta] &nbsp;</td>");
echo("<td class='cntbxmid'>$row[int] &nbsp;</td>");
echo("<td class='cntbxmid'>$row[wis] &nbsp;</td>");
echo("<td class='cntbxright'>$row[effect_one] &nbsp;");
echo("</tr>");
}

//now this is the link..
echo "<tr><td><a href='itemsearch.php?startrow='.($SQL+10).>Next</a></td></tr>";

?>

[ArksI]

$SQL = "SELECT * FROM itemsearch WHERE itemname LIKE \"%$user_input%\" LIMIT $startrow, 10";


ot try the simple thing:
if (!$dbres = mysql_query($SQL)) echo mysql_errno()."::".mysql_error();

this will return number of mistake and explanation if anything fales with the query ....

[NeverMind]

you had some order problems, and in SQL queries always use single quotes to sorround the field values !

also, in the last link you used $SQL+10!! while you should use $startrow+10
there are other problems I fixed ,, try this one :

PHP Code:

<?php

$connect = @mysql_connect("localhost", "asdf", "asdf") or die("could not connect to server");



//check if this is the first page

if (!isset($_GET['startrow']) or !is_numeric($_GET['startrow'])) {

//we give the value of the first row to 0

$startrow = 0;

//otherwise we take the value from the URL

} else {

$startrow = (int)$_GET['startrow'];

}



$db_select = @mysql_select_db("asdf") or die("could not select the database");



$SQL = "SELECT * FROM itemsearch WHERE itemname LIKE '%$user_input%' LIMIT $startrow, 10";



$result = @mysql_query($SQL) or die("Could not run query");



while($row = mysql_fetch_array($result))

{

echo("<tr>");

echo("<td class='cntbxleft'> &nbsp;");

$url = ("$row[url]");

echo("<a class='bluetu' href='$url'>$row[itemname]</a></td>");

echo("<td class='cntbxmid'>$row[str] &nbsp;</td>");

echo("<td class='cntbxmid'>$row[agi] &nbsp;</td>");

echo("<td class='cntbxmid'>$row[sta] &nbsp;</td>");

echo("<td class='cntbxmid'>$row[int] &nbsp;</td>");

echo("<td class='cntbxmid'>$row[wis] &nbsp;</td>");

echo("<td class='cntbxright'>$row[effect_one] &nbsp;");

echo("</tr>");

}



//now this is the link..

echo "<tr><td><a href='itemsearch.php?startrow=".$startrow+10."'>Next</a></td></tr>";



?>

[eq1987]

Ok, i did that and i have one last syntax error, i think. Right here:
echo "<tr><td class='cntbxleft'><a class='bluetu' href='itemsearch.php?startrow=\".$startrow+10.\"'> Next</a></td></tr>;

Notice i put \ to let the " be, but now i dont think its working... what exactly should i use around .$startrow+10.? ' ? Thanks

[eq1987]

Ugh, im sorry for so many questions, but.. since this is for a search, like i search FACE, and all results display containing the word face, will this work with it? So i search FACE, click next, and 10 *more* results from my search (FACE) show up, and continue till there are no more. Thanks

[NeverMind]

Ok, i did that and i have one last syntax error, i think. Right here:
echo "<tr><td class='cntbxleft'><a class='bluetu' href='itemsearch.php?startrow=\".$startrow+10.\"'> Next</a></td></tr>;

why did you change the one I gave you? mine doesn't have errors !

Ugh, im sorry for so many questions, but.. since this is for a search, like i search FACE, and all results display containing the word face, will this work with it? So i search FACE, click next, and 10 *more* results from my search (FACE) show up, and continue till there are no more. Thanks

this is another story!
you have to pass the term in the URL ,again !!
and pass it in the URL of "Next" !

PHP Code:

//now this is the link..

echo "<tr><td><a href='itemsearch.php?startrow=".$startrow+10."&term=$user_input'>Next</a></td></tr>";