mysql_result

Get result data (PHP 4, PHP 5, PECL mysql:1.0)
string mysql_result ( resource result, int row [, mixed field] )

Example 1460. mysql_result() example

copy to clipboard

<?php

$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');

if (!$link) {

    die('Could not connect: ' . mysql_error());

}
$result = mysql_query('SELECT name FROM work.employee');

if (!$result) {

    die('Could not query:' . mysql_error());

}

echo mysql_result($result, 2); // outputs third employee's name

mysql_close($link);
?>

Related Examples ( Source code ) » mysql_result

Examples ( Source code ) » Use mysql_result function to get query result

Examples ( Source code ) » Use for loop to read all query result

Examples ( Source code ) » Creates an image from an image stream

Code Examples / Notes » mysql_result

erelsgl dot nospam

two simple but very useful functions, for converting a query to a value or an array: <?php function mysql_evaluate($query, $default_value="undefined") { $result = mysql_query($query); if (mysql_num_rows($result)==0) return $default_value; else return mysql_result($result,0); } function mysql_evaluate_array($query) { $result = mysql_query($query); $values = array(); for ($i=0; $i<mysql_num_rows($result); ++$i) array_push($values, mysql_result($result,$i)); return $values; } ?> http://tora.us.fm/_script/highlight.php?file=sql Usage examples: <?php $customer_count = mysql_evaluate("SELECT COUNT(*) FROM customers"); $customer_names = mysql_evaluate_array("SELECT name FROM customers"); $customer_type = mysql_evaluate("SELECT type FROM customers WHERE name='$name'", "DEFAULT_TYPE"); ?>

raz0

If you want to fetch the result from a mysql query similar to one of these two queries... $query = mysql_query("SELECT COUNT(*) FROM table"); $query = mysql_query("SELECT LAST_INSERT_ID()"); ... you would use mysql_result() like shown below to retrieve the output as an int. $result = mysql_result($query, 0, 0);

gack

if you want to do something based on the fact that the data is the same in the next row, then looking ahead is easy with this. <?php $i=0; $rows=mysql_num_rows($result); while($i < $rows) { $x = mysql_result($result, $i, 0); if ($x = mysql_result($result, $i+1, 0)) { echo "It's the same thing!"; } } ?>

djurredenboer

<? $link = mysql_connect("host", "user", "passw"); mysql_select_db("database", $link); $number = 3; $insert = mysql_query("SELECT `test1`.*, `test2`.*, FROM `test1`, `test2`, ` WHERE ((`test1`.`author` = `test2`.`ID`) AND (`test2`.`ID` ='$number')) ORDER BY `toetsen`.`autoID` DESC",$link); echo mysql_result( $insert , 0, 'test1.question') ; #here he echoes the questions the stuff out of the first table echo mysql_result( $insert , 0, 'test2.name') ; #here he echoes the questions the stuff out of the second table ?>

Change Language

mysql_affected_rows
mysql_change_user
mysql_client_encoding
mysql_close
mysql_connect
mysql_create_db
mysql_data_seek
mysql_db_name
mysql_db_query
mysql_drop_db
mysql_errno
mysql_error
mysql_escape_string
mysql_fetch_array
mysql_fetch_assoc
mysql_fetch_field
mysql_fetch_lengths
mysql_fetch_object
mysql_fetch_row
mysql_field_flags
mysql_field_len
mysql_field_name
mysql_field_seek
mysql_field_table
mysql_field_type
mysql_free_result
mysql_get_client_info
mysql_get_host_info
mysql_get_proto_info
mysql_get_server_info
mysql_info
mysql_insert_id
mysql_list_dbs
mysql_list_fields
mysql_list_processes
mysql_list_tables
mysql_num_fields
mysql_num_rows
mysql_pconnect
mysql_ping
mysql_query
mysql_real_escape_string
mysql_result
mysql_select_db
mysql_set_charset
mysql_stat
mysql_tablename
mysql_thread_id
mysql_unbuffered_query