php/mysql variable question

[fallenangel1983]

Hey all. im having a small difficulty with this question.

 

say im trying to get a specific ID from a table...lets call it tablename

 

ID        NAME

1          GEOFF

2          ANDY

3          BOB

 

so to try and get the specific ID for BOB the mysql would be:

 

$sql="SELECT ID FROM tablename WHERE NAME='bob'";

$result=mysql_query(sql);

 

My question is this: HOW do i then save this ID i have selected into a PHP variable? 

 

i.e. i want to save it as a variable named $bobID and so when i write...

 

echo "$bobID";

 

it reads    3

[uniflare]

give us the code

[fallenangel1983]

sorry to ask but i dont understand. what code do you want. my ACTUAL table is quite large with a few bits of data. i am unsure of what code it is you require 

 

[paul2463]

<?php
$sql="SELECT ID FROM tablename WHERE NAME='bob'";
$result=mysql_query(sql) or die ("error in query ". mysql_error());
$row = mysql_fetch_assoc($result);
$bobid = $row['ID'];
echo $bobid;
?>

 

[redarrow]

<?php

//databse conection

$sql="SELECT ID FROM tablename where NAME='bob'";

$result=mysql_query($sql)or die(mysql_error());

while($result=mysql_fetch_assoc($result)){

$bobid=$result['ID'];
}

echo $bobid;

?>

[fallenangel1983]

fantastic cheers guys. thanx verymuch