assign variable from a recordset

[dustinkrysak]

I was wondering what the proper format was to assign a variable a value from a database...

for example - I am deleting a file off the hard drive, and the file path is already stored with a record...

[noimad1]

Here is your whole database connection:

$dbusername = "yourusername";
$dbpassword = "yourpassword";
$dbname ="yourdatabsename";
$whatever = "search string";

$dbh=mysql_connect ($servername, $dbusername, $dbpassword);

$query = "SELECT * FROM table where whatever = '$whatever'";
$result = mysql_db_query ($dbname,$query);

//error checking
if($result == false){
echo mysql_errno().":".mysql_error()."<BR>";
exit;
}

//This is where you asign value to variable:

$variable = mysql_result($result,0,"field_name");