Get field value

[ZOR]

I am using PHP with MySql. I have a statement:

$sql = "select * from Validnames where UserID = '$UID' && Location = '$Location'";

Am I correct this gets a single matching row of data from the database. If so, how do I pull out the value of 1 of the fields in the row. (2nd column)

Sorry if this is more PHP but its half and half.

Thanks

Regards

 

[r937]

your query may or may not get a single row -- it depends on how many rows actually have those values in the UserID and Location columns

how you pull the value of the 2nd column? that's a php question



r937.com | rudy.ca

 

[ZOR]

Thanks for the reply. There should only be 1 row meeting the criteria. I will look at it from a PHP angle. Thanks again