[PHP] Re: Problems with displaying results

2009-03-03 Thread Shawn McKenzie 
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=$AdminIDmsg=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=_TOPimg 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

Re: [PHP] Re: Problems with displaying results

2009-03-03 Thread Kyle Terry 
On Tue, Mar 3, 2009 at 8:32 AM, Shawn McKenzie nos...@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=$AdminIDmsg=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=_TOPimg 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