Getting single value from a single row with Mysql/PHP

Question

Often I just need to get a single value from MySQL that I know exists there. I use the following construct:

$result = end(mysql_fetch_array(mysql_query('SELECT FOUND_ROWS()', $db)));

Is there a proper single function in PHP that would do this?

Zackman · Accepted Answer · 2010-06-03 00:08:30Z

2

Yes, mysql_result will do this.

$result = mysql_result(mysql_query('SELECT FOUND_ROWS()', $db), 0);

answered Jun 3, 2010 at 0:08

Zackman

3141 silver badge7 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

didn't notice the optional params of mysql_result. I guess that this is the limit - there is no function that combines mysql_query and mysql_result?

If you make a lot of these calls you should create your own function that combines the two. As far as I know, no such function exists natively.