PHP Source Code »

 

Store query result in an associate array



<?php

   mysql_connect("mysql153.secureserver.net","navioo","password");
   mysql_select_db("navioo");


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

   while ($row = mysql_fetch_array($result,MYSQL_ASSOC)) {
      $name = $row['name'];
      $developerid = $row['id'];
      echo "Product: $name ($id) <br />";
   }

?>


           
       



HTML code for linking to this page:

Follow Navioo On Twitter

PHP Source Code

 Navioo