MySQL, how to use returned data?

Question

Well, I know that there is funciton mysql_fetch_array (), and we can use it as follows:

while ($row = mysql_fetch_array($result)) { echo $row['name'] . "<br />"; } 

But is there any other way? For example, if there is only one element that can be returned, not an array.

Thanks)

Answer 1

If there is only one line, you can simply say:

 $row = mysql_fetch_array($result); 

Or you can use mysql_fetch_row if you want.

But I would repeat Eric's comment to go with PDO . Here's a good tutorial that makes heavy use of PDO .

Answer 2

see mysql_result () :

Retrieves the contents of a single cell from the MySQL result set.

Answer 3

You can use mysql_result

 $result = mysql_query($query) or die(mysql_error()); $scalar = mysql_result($result, 0); 

Answer 4

For example, if there is only one element that can be returned, not an array.

Nope.
Only an array or useless object you can get.