loop to read all query result in php

Page 1 of 1

[ 1 post ]

Author

Article

msi_333

Article subject: loop to read all query result in php

Posted: Sun Oct 26, 2008 7:32 pm

Joined: Tue Mar 27, 2007 10:55 pm
Posts: 2103
Location: Earth
Has thanked: 39 time
Have thanks: 57 time

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 />";
   }

?>

_________________
Currenlty programming with : java , html , php , and javascript . (OCJP-6 certified )

Page 1 of 1

[ 1 post ]

Similar topics
Topic title	Forum	Author	Comments
Read your gmail using Java code	Java examples	msi_333	5
Why will my loop does not work	C-C++	atoivan	0
update query example	PHP examples	msi_333	0
select query example in php	PHP examples	msi_333	0
insert query example	PHP examples	msi_333	0

Codemiles.com » Tutorials Forums » PHP Tutorials

All times are UTC [ DST ]

Users browsing similar posts

Users browsing this forum: No registered users and 1 guest

Jump to:

Previous Article | Next Article