Quick question please

Dolemite50

Hi,
I just need to know what is the best method to use for just pulling one object from a DB?

$getBname = "SELECT bandName from $table WHERE loginName = '$loginName'";
$result1 = mysql_query($getBname, $conn) or die(mysql_error());
$bName= WHAT DO I PUT HERE?($result1);

I know you use mysql_fetch_array for multiple but what is the best to use for a single item?

Thanks

move3rd

mysql_fetch_row()

Php manual

mysql_fetch_object() Speed-wise, the function is identical to mysql_fetch_array(), and almost as quick as mysql_fetch_row() (the difference is insignificant).

Dolemite50

Thanks, I already checked that page and I'm afraid I didnt get it. What about mysql_fetch_result ?

Dolemite50

The fetch_row would return one item as an array right? Is this OK to use if I only need one item from one column?

Thanks again.

move3rd

Why exactly dont you want to use mysql_fetch_array? If it's not going to effect speed then i dont see a problem.

The fetch_row would return one item as an array right? Is this OK to use if I only need one item from one column?

That would work fine..

bretticus

If you simply need one column from one data row, mysql_result is a good choice too.

$getBname = "SELECT bandName from $table WHERE loginName = '$loginName'";
$result1 = mysql_query($getBname, $conn) or die(mysql_error());
$bName= mysql_result($result1,0);

Dolemite50

Thats what I was looking for!

Thanks alot!