Here’s a handy little function. This comes in handy in many different situations, especially in regards to parsing database results. Here’s a typical way to parse through a MySQL result set:
1 2 3 4 5 6 7 8 9 10 11 12 13 | $conn = mysql_connect("myhost", "myusername", "mypassword") or die(mysql_error()); mysql_select_db("database"); $result = mysql_query("SELECT firstname, lastname, address FROM tablename", $conn); while ($row = mysql_fetch_array($result, MYSQL_NUM)) { echo "Firstname: " . $row[0] . ""; echo "Lastname: " . $row[1] . ""; echo "Address: " . $row[2] . ""; } mysql_free_result($result); |
Here’s an easy way to simplify this with the list() function:
1 2 3 4 5 6 7 8 9 10 11 12 13 | $conn = mysql_connect("myhost", "myusername", "mypassword") or die(mysql_error()); mysql_select_db("database"); $result = mysql_query("SELECT firstname, lastname, address FROM tablename", $conn); while (list($firstname, $lastname, $address) = mysql_fetch_array($result)) { echo "Firstname: " . $firstname . ""; echo "Lastname: " . $lastname . ""; echo "Address: " . $address . ""; } mysql_free_result($result); |