On Tue, 2009-03-03 at 11:08 -0600, Terion Miller wrote: > On Tue, Mar 3, 2009 at 10:32 AM, Shawn McKenzie <nospam@xxxxxxxxxxxxx>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 > > } > > > > --------------------------------------------------- > > well I looked it up in my book and tried this example but still get the same > thing, the first record > > $result = mysql_query ($query) ; > //$row = mysql_fetch_array($result); > while ($row = mysql_fetch_row($result)){ > for ($i=0; $i<mysql_num_fields($result); $i++) > echo $row[$i] . " "; > //print a return for neatness sake > echo "\n"; What happens if you just change your while loop to this: while($row = mysql_fetch_array($result)) { print_r($row); } Ash www.ashleysheridan.co.uk -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php