Mega Code Archive

 

Categories / Php / MySQL Database

 

Use Column name in select statement as the variable name

<?php    mysql_connect("mysql153.secureserver.net","rntsoft","password");    mysql_select_db("rntsoft");    $query = "SELECT id, firstname FROM Employee";    $result = mysql_query($query);    while (list($id, $name) = mysql_fetch_row($result)) {       echo "$name ($id) <br />";    } ?>