[prev in list] [next in list] [prev in thread] [next in thread] 

List:       php-db
Subject:    [PHP-DB] Re: [PHP] Re: Problems with displaying results
From:       Kyle Terry <kyle () kyleterry ! com>
Date:       2009-03-03 17:00:24
Message-ID: 65a7ac1b0903030900x57ccfbf9n102b5fb33528e3bf () mail ! gmail ! com
[Download RAW message or body]


On Tue, Mar 3, 2009 at 8:32 AM, Shawn McKenzie <nospam@mckenzies.net> wrote:

> Terion Miller wrote:
> > I have two queries one pulls out which users to use and the second pulls
> > those users orders....
> > Looks something like this but is only pulling the first record:
> >
> >
> >     $query =  "SELECT `UserName`, `AdminID` FROM admin
> >       WHERE   Key1 =  'YES' ";
> >
> >     $result = mysql_query ($query) ;
> >     $row = mysql_fetch_assoc($result);
> >
> >     //Reveal Variables for Debugging
> >     // include("VariableReveal2.php");
> >      echo ("Hello <br>");
> >     //echo $row['AdminID'];
> >     echo ($row['UserName']);
> >
> >
> >
> >
> >     if ($row['Key1'] == "NO") {
> >         header ("Location: Welcome.php?AdminID=$AdminID&msg=Sorry, you do
> > not have access to that page.");
> >     }
> >
> > if (isset($_GET['SortBy'])) {$SortBy = $_GET['SortBy'];} else {$SortBy =
> > 'WorkOrderID DESC';}
> > if (isset($_GET['Page'])) {$Page = $_GET['Page'];} else {$Page = 1;}
> >
> > $PerPage = 30;
> > $StartPage = ($Page - 1) * $PerPage;
> >
> >         second query here is using the $row from the first (and yes I
> know
> > not to use *, just did so here to keep post shorter)
> >
> >          $sql= "SELECT * FROM workorders WHERE AdminID =
> > '".$row['AdminID']."' ";
> >       // $sql .= "ORDER BY $SortBy LIMIT $StartPage, $PerPage";
> >       $result = mysql_query ($sql);
> >       $row2 = mysql_fetch_assoc($result);
> >       $Total = ceil(mysql_num_rows($result)/$PerPage);
> >
> >
> >     So this works but only half way as it only displays the first record
> in
> > the table.
> >
> >
> >
> >
> > Thanks
> > Terion
> >
> > Happy Freecycling
> > Free the List !!
> > www.freecycle.org
> > Over Moderation of Freecycle List Prevents Post Timeliness.
> > ------------------------------------------------
> > Twitter?
> > http://twitter.com/terionmiller
> > ------------------------------------------------
> > Facebook:
> > <a href="http://www.facebook.com/people/Terion-Miller/1542024891"
> > title="Terion Miller's Facebook profile" target=_TOP><img src="
> > http://badge.facebook.com/badge/1542024891.237.919247960.png" border=0
> > alt="Terion Miller's Facebook profile"></a>
> > Groucho Marx  - "I have had a perfectly wonderful evening, but this
> wasn't
> > it."
> >
>
> You need to lookup the mysql_fetch_assoc() function.  It only returns
> one row from a result set that may contain multiple rows.  You need
> something like:
>
> while($row = mysql_fetch_assoc($result)) {
>  // do something with $row
> }
>
> --
> Thanks!
> -Shawn
> http://www.spidean.com
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
> You also need to filter your user inputted data.


Kyle Terry | www.kyleterry.com
Help kick start VOOM (Very Open Object Model) for a library of PHP classes.
http://www.voom.me | IRC EFNet #voom


[prev in list] [next in list] [prev in thread] [next in thread]