Select records based on value

[markspec87]

I know this is really simple (i think) but i cant remember the code.

How do i show records based on the value of another?

i.e select the record where username = "spec" so i can then assign specs age and location etc to different variables.

[onlyican]

$query = "SELECT * FROM table WHERE fieldname LIKE '%value%'";

Is this what u meant?

[markspec87]

yeh i know the code to start with

i.e

[quote]$sql = "SELECT * FROM members WHERE username="spec"[/quote]

But then how can i use this to say output specs age or location? (seperatly ofc)

[AndyB]

[code]$sql = "SELECT * FROM members WHERE username="spec";
$result = mysql_query($sql) or die("Error: ". mysql_error(). " with query ". $sql);
$row = mysql_fetch_array($result);
echo $row['age']. " and ". $echo['location']; // or whatever
[/code]

The above assumes a single match to the query.

[onlyican]

is there is more than one

$query = "SELECT * FROM members WHERE username = 'spec'";
$result = mysql_query($query);
if($result){
while($row = mysql_fetch_assoc($result)){
echo "Age: ".$row["age"]."<br />\n";
}

}else{
echo "There has been an error<br />\n"
.mysql_error();
}