OK, Matt, so you've got the basics =8).
Your beginning is good, using the $Offset. Now you only have to
add navigation-buttons (First, Previos, Next, Last) with html
and a hidden field namded Offset.
LIMIT is defined as a constant. You could also use your $Limit.
here is a snippet of my navigation code:
//////////////////
// Event-Handler
if ( isset( $Offset ) )
{
// First-Button
if ( isset( $First ) and !empty( $First ) )
{
$Offset = 0;
}
// Next-Button
if ( isset( $Next ) and !empty( $Next ) )
{
if ( $Offset <= ( $num_rows - LIMIT ) )
{
$Offset += LIMIT;
}
}
// Previous-Button
if ( isset( $Prev ) and !empty( $Prev ) )
{
if ( $Offset >= LIMIT )
{
$Offset -= LIMIT;
}
else
{
$Offset = 0;
}
}
// Last-Button
if ( isset( $Last ) and !empty( $Last ) )
{
$Offset = ($num_rows - LIMIT);
}
}
else
{
$Offset = 0;
}
// End Event-Handler
//////////////////////
Hope this helps. If there are still questions ... ask =8)
Greetinx,
Mike
Michael Rudel
- Web-Development, Systemadministration -
_______________________________________________________________
Suchtreffer AG
Bleicherstraße 20
D-78467 Konstanz
Germany
fon: +49-(0)7531-89207-17
fax: +49-(0)7531-89207-13
e-mail: mailto:[EMAIL PROTECTED]
internet: http://www.suchtreffer.de
_______________________________________________________________
> -----Original Message-----
> From: Matt Coyne [mailto:[EMAIL PROTECTED]]
> Sent: Monday, March 26, 2001 1:39 PM
> To: PHP DB
> Subject: [PHP-DB] Another newbie question
>
>
> Hi guys/gals
>
> Having had my head sorted out by this list already today, I
> am in need of
> some more help...!!
>
> I have an input form that, through php queries a MySQL db and
> passes results
> back and the browser displays them (at this stage just as a list).
>
> I have been looking into the LIMIT command to split my
> results into sections
> (ie results 1-10 then 11-20 etc). No problem in understanding
> how LIMIT
> works and I have LIMITed the first set to the first 10
> results. I understand
> that to show results 11-20 I would use LIMIT 10, 10 in my SQL query.
>
> However, how am I to update the LIMIT n, 10 dynamically
> depending on what
> split of results they are viewing. ie How do I recall the SQL
> query but with
> an update LIMIT value
>
> Here is what I have been doing:
>
> // ASSEMBLE SQL QUERY
> // make the select
> $select = "SELECT ref, firstname, surname ";
>
> //add the tablename to the query
> $fromtable = "FROM $table_name";
> //$fromtable .= "$tablename";
>
> //build where clause
> $control=1;
> $where = " WHERE $control=1 ";
>
> //determine if field sent value, build statement if true
> if ($sex != '') {
> $Qsex = "AND sex = '$sex' ";
> } else {
> $Qsex = "";
> }
>
> if ($heightFt != '') {
> $QheightFt = "AND heightFt = '$heightFt' ";
> } else {
> $QheightFt = "";
> }
>
> if ($heightIn != '') {
> $QheightIn = "AND heightIn LIKE '$heightIn%' ";
> } else {
> $QheightIn = "";
> }
>
> if ($neck != '') {
> $Qneck = "AND neck LIKE '$neck%' ";
> } else {
> $Qneck = "";
> }
>
> if ($chest != '') {
> $Qchest = "AND chest LIKE '$chest%' ";
> } else {
> $Qchest = "";
> }
>
> if ($waist != '') {
> $Qwaist = "AND waist LIKE '$waist%' ";
> } else {
> $Qwaist = "";
> }
>
> if ($hips != '') {
> $Qhips = "AND hips LIKE '$hips%' ";
> } else {
> $Qhips = "";
> }
>
> if ($leg != '') {
> $Qleg = "AND leg LIKE '$leg%' ";
> } else {
> $Qleg = "";
> }
>
> if ($shoe != '') {
> $Qshoe = "AND shoe LIKE '$shoe%' ";
> } else {
> $Qshoe = "";
> }
>
> if ($dress != '') {
> $Qdress = "AND dress LIKE '$dress%' ";
> } else {
> $Qdress = "";
> }
>
> if ($hair != '') {
> $Qhair = "AND hair LIKE '$hair%' ";
> } else {
> $Qhair = "";
> }
>
> if ($eyes != '') {
> $Qeyes = "AND eye LIKE '$eyes%' ";
> } else {
> $Qeyes = "";
> }
>
> if ($skin != '') {
> $Qskin = "AND skin LIKE '$skin%' ";
> } else {
> $Qskin = "";
> }
>
> if ($nationality != '') {
> $Qnationality = "AND nationality LIKE '$nationality%' ";
> } else {
> $Qnationality = "";
> }
>
> // specify how results are ordered
> $orderby = "ORDER BY surname ";
>
> // offset is a hidden value in the initial form == 0
> if ($offset = '0') {
> $offset = 0;
> }
>
>
> // specify LIMIT
> $limit = "LIMIT ";
> $limit .= $offset;
> $limit .= ", 10";
>
> //build concatenated query
> $concatsql = $select;
> $concatsql .= $fromtable;
> $concatsql .= $where;
> $concatsql .= $Qsex;
> $concatsql .= $QheightFt;
> $concatsql .= $QheightIn;
> $concatsql .= $Qneck;
> $concatsql .= $Qchest;
> $concatsql .= $Qwaist;
> $concatsql .= $Qhips;
> $concatsql .= $Qleg;
> $concatsql .= $Qshoe;
> $concatsql .= $Qdress;
> $concatsql .= $Qhair;
> $concatsql .= $Qeyes;
> $concatsql .= $Qskin;
> $concatsql .= $Qnationality;
> $concatsql .= $orderby;
> $concatsql .= $limit;
>
>
> // make query
> $result=@mysql_query($concatsql, $connection) or die (mysql_error() .
> "<BR><B>from query:</B>$concatsql");
>
> //detect amount of rows in result for display
> $num_rows = mysql_num_rows($result);
>
> //start building set of results to be echoed in browser
> $contact_list= "<UL>";
>
> while ($row = mysql_fetch_array($result)) {
>
> $ref = $row['ref'];
> $firstname = $row['firstname'];
> $surname = $row['surname'];
>
> $contact_list .="<LI><A HREF=\"show_record.php?ref=$ref\">$surname,
> $firstname</A>";
>
> }
>
> $contact_list .="</UL>";
>
> // add 10 to offset for next set of results
> $offset +=10;
>
> So, that all works for the first set of results but I do not
> know where to
> go from here. I am assuming the last sectionis the way to go
> to increase the
> offset value but I don't know what to do with it next!! I
> have been scouring
> phpbuilder and devshed with no luck so far.
>
> Any help very much appreciated
>
> cheers
> matt
>
> t h r e e z e r o : : :
>
> the mill, millstone lane, leicester, le1 5jn
> e : [EMAIL PROTECTED] :: m : 07747 845690
> w : http://www.threezero.co.uk
>
> : : : t h r e e z e r o
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail:
> [EMAIL PROTECTED]
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
