how do i select a single post from a database?

[blebba]

hi!

how do i fetch a single post from a database?
the query has only one match since the id in the database is unique...

<?
$picid = $_POST['picid'];
$sql = "SELECT url FROM pictures WHERE picid = '$picid'";

and then what??????
?>

i've tried the following but it does'nt seem to work:

<?
$result = mysql_query($sql,$database_link);
$rows = mysql_num_rows($result);

for ($i = 0; $i < $rows; $i++){
$url = mysql_result($result,$i,"url");
echo "$url";
}
?>

thank you
/blebba

[stolzyboy]

<? 
$picid = $_POST['picid']; 
$query = "select url from pictures where picid = '$picid';";
$result = mysql_query($query) or die ("Could not select $picid");

while ($row = mysql_fetch_array($result))
{
echo $row['url'];
}
?>

[mmilano]

<? 
$picid = $_POST['picid']; 
$result=("SELECT url FROM pictures WHERE picid = '$picid'"); 

$url=mysql_result($result,0,"url");
?>