loop to read all query result in php

Code:

<?php

   mysql_connect("server","database","password");
   mysql_select_db("userdb");

   $query = "SELECT id, firstname FROM Employee";
   $result = mysql_query($query);

   for ($count=0; $count <= mysql_numrows($result); $count++) {
      $id = mysql_result($result, $count, "id");
      $name = mysql_result($result, $count, "firstname");
      echo "$firstname ($id) <br />";
   }

?>

_________________
M. S. Rakha, Ph.D.
Queen's University
Canada

Author: DrRakha
Mastermind

Posts: 2715
Have thanks: 74 time

Page 1 of 1

[ 1 post ]

Related Posts to : loop to read all query result in php
paging JPA Query result -
Store query result in an Object in php -
C++ While loop -
While loop -
do while loop and for loop C++ example help. -
Do while loop -
Using include() Within a Loop -
Why will my loop does not work -
I NEED SOME HELP IN THE FOR LOOP PLZ .. IAM JUST A BEGINNER -
Breaking a Loop -

Topic Tags

PHP Database

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
All copyrights reserved to codemiles.com 2007-2011
mileX v1.0 designed by codemiles team
Codemiles.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com