What is mysql_result() function in PHP?
How does mysql_result() works?
<?php //Attempt to connect to the default database server $conn = mysql_connect("mysql_host", "mysql_user", "mysql_password")or die ("Could not connect"); //select database $db = mysql_select_db('my_database',$conn);//query to be executed $sql = "SELECT * from emp_table";//execute query $result = mysql_query($sql,$conn);// query result passed to mysql_result function to return the value of a field echo mysql_result($result,2); //outputs third employee's namemysql_close($conn); ?> |
<?php //Attempt to connect to the default database server $conn = mysql_connect("mysql_host", "mysql_user", "mysql_password")or die ("Could not connect"); //select database $db = mysql_select_db('my_database',$conn);//query to be executed $sql = "SELECT * from emp_table";//execute query $result = mysql_query($sql,$conn);//iterate in a loop to return employee name of all the records for($i=0;$i < mysql_num_rows($result);++$i){// query result passed to mysql_result function to return the value of a field echo mysql_result($result,$i,name); } mysql_close($conn); ?> |