What is mysql_fetch_array() function in PHP?
How does mysql_fetch_array() works?
<?php //Attempt to connect to the default database server $link = mysql_connect("mysql_host", "mysql_user", "mysql_password")or die ("Could not connect"); //select database mysql_select_db("my_database",$link);//execute simple query $result = mysql_query("SELECT * FROM mytable",$link);//query result is passed to mysql_fetch_array to fetch each row while ($row = mysql_fetch_array($result, MYSQL_NUM)) {//access array with number index printf ("ID: %s Name: %s", $row[0], $row[1]); } mysql_free_result($result); ?> |
<?php //Attempt to connect to the default database server $link = mysql_connect("mysql_host", "mysql_user", "mysql_password")or die ("Could not connect"); //select database mysql_select_db("my_database",$link);//execute simple query $result = mysql_query("SELECT * FROM mytable",$link);//query result is passed to mysql_fetch_array to fetch each row while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {//access array with field name as index printf ("ID: %s Name: %s", $row["id"], $row["name"]); } mysql_free_result($result); ?> |
<?php //Attempt to connect to the default database server $link = mysql_connect("mysql_host", "mysql_user", "mysql_password")or die ("Could not connect"); //select database mysql_select_db("my_database",$link);//execute simple query $result = mysql_query("SELECT * FROM mytable",$link);//query result is passed to mysql_fetch_array to fetch each row while ($row = mysql_fetch_array($result, MYSQL_BOTH)) { //access array either with field name or number as index printf ("ID: %s Name: %s", $row[0], $row["name"]); } mysql_free_result($result); ?> |