[LinChang]

Originally Posted by calorie

Tip... if you know you are only looking for one result, you can use query_first instead of query_read

$info = $db->query_first("SELECT foo FROM table WHERE id = 5");
// $info['foo']

Then do you still need to fetch the array? or by just doing $info['foo'] your able to get that result?

Also what about lets say query_read

for example if I am grabbing a row with which contains more than one column, so say

$info = $db->query_first("SELECT foo,moo,boo FROM table WHERE id = 5");

which selects foo,moo,boo where id=5

so can you do $info['foo'] $info['moo'] $info['boo'] to get those three column result or should you fetch_array first?