Help With Database Code

[bradleydh]

I have a mysql database table called 'preferences'

It has two rows, one called "Name" and the other called "Value"

I want to call the "Value" to a variable, where the "Name" = "issue_id"

How do I do this... I want to call this to a variable, which could be printed on a page.

[kevinsequeira]

// set up the database connections
$query = "select * from preferences where Name='".$issue_id."'";
// assuming Name is not an integer

$result = mysql_query($query);
$row = mysql_fetch_array($result);
echo $row['value'];

you might want to look up a tutorial on php also

reg
kevin