Mega Code Archive

 
Categories / Php / MySQL Database
 

Store query result in an associate array

<?php    mysql_connect("mysql153.secureserver.net","rntsoft","password");    mysql_select_db("rntsoft");    $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 />";    } ?>