Re: Problems with displaying results

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux