TABLE For 4

Greenman

Hi,

I got the following query to spit out a table that displays a list of users which works fine but what I
need to do is restrict the number of results displayed to 4/#, due to images being displayed in the table. Is it possible to do this and use a next/back button to displys subsequent results?

Thanks

=====================

$query = "SELECT * FROM employees WHERE first = '".mysql_escape_string
($first)."'";
$result = mysql_query($query);
$numrows = mysql_num_rows($result);

{
echo "There are $numrows user(s) in the database, they are";
}

?><html><br><br><?php

echo "<table border=1>\n";
echo "<tr><td>Name</td><td>e-mail</td><td>Department</td><td>Photo</td></tr>\n";

while ($myrow = mysql_fetch_row($result)) {

	printf("<tr><td>%s %s</td><td>%s</td><td>%s</td><td>

%s</td>\n",
$myrow[1], $myrow[2],$myrow[3], $myrow[4], $myrow[5]);

}

echo "</table>\n";

blr32

Yes of course 🙂

A good way is to use the "Limit" parameter of Mysql and carry the values through the URL

So your query becomes:

/* define offset value - set default if empty */
if ($_GET['offset'] == '')
$offset = 0;
else
$offset = $_GET['offset'];

/* number of rows to be displayed */
$num_results = 4;

$query = "SELECT * FROM employees WHERE first = '".mysql_escape_string($first)."' LIMIT $offset, $num_results";

You then make sure that your next button defines the offset of the next four rows you want to retrieve. I.e. the url of your 'next-link' would be something like this: http://somehost/somescript.php?offset=4

The rest should remain unchanged even though I'm not really familiar with that way of retrieving data from a mysql-row.

Hope this helped.

Greenman

That’s fantastic

Thanks you !!!!!!!!

🙂

Greenman

Hi,

I am having a bit of trouble with the back and NEXT button on this
I have tried
<A href="http://localhost/test1/findusers1.php?offset=2">NEXT</A>

When I run it, it doesn’t search for any name so I just get
"There are 0 user(s) in the database" as a result.

Any ides how I can display the first 4 results and then
click on a NEXT/BACK button to display the next results??

Thanks,
G