selecting and variabling a single value ?

[dr4296]

Greetings All!

OK, silly question:

I know how to combine a "select * from..." with a "mysql_fetch_row" or a "mysql_fetch_array"... in order to pull multiple columns from multiple rows... and then set variables with that data so I can manipulate it.

But what if all I want to select is a single column off of a single row? I know how the select statement should be written.

But how do I get that one value thrown into a variable without using mysql_fetch_row or mysql_fetch_array (which seem a bit overkill to have to use for this) ???

Thanks!

-= Dave =-

[yahelb]

simply ..

use mysql_fetch_row or mysql_fetch_array.

when you are using:

while( $row = mysql_fetch_row($rs)) {
// some code
}

you accually pull each row from the database.

that means that if you will have a single row it will still work!

if you look for replacement for mysql_fetch... you may use:
mysql_result .

but i dont think you should cause the line already have been written.

yahel

[dr4296]

Well, yeah, I know you can do that... go through the whole while loop thing.

But if you KNOW you're only selecting one row ANYWAYS... because you're selecting off of the primary key for that table.... it seems to me... why go into a loop when only one row is selected?

Seems like I'm missing some other mysql function in my brain???

Thanks!

-= Dave =-