从mysql数据库中获取一个“单元格”

Question

I have a site which settings are stored in a mysql database table. For getting one setting, I use something like this:

$q = mysql_query("SELECT setting FROM settings WHERE id=1");
$a = mysql_fetch_array($q);
$setting = $a['setting'];

But, isn't there a faster/better way to dump just one "cell" of a mysql table in a variable?

Answer 1

No, that's pretty much it. Some DB libraries offer a ->getOne()-type method, but internally they don't anything different than what you are. Of course, you SHOULD stop using mysql_*() functions. They're deprecated/obsolete. Consider switching to mysqli or PDO