Try reading into MySQL syntax. That you use dreamweaver doesn't matter by the way, coding works the same in every editor. This is an example of the MySQL SELECT syntax with a WHERE clause. You should definitely read more about in the MySQL Manual. And get familiar with the PHP MySQL commands by reading the PHP Manual
// Specify your ID here
$id = 1;
// Replace below variables with your SQL server host, username and password
$link = mysql_connect('localhost','root','password');
// Enter database name below
mysql_select_db('mydb');
// Get info for ID and output it
$getinfo = mysql_query("SELECT * FROM `table` WHERE id=$id LIMIT 1");
while ($info = mysql_fetch_assoc($getinfo)) {
echo $info['field1'] . "<br>\n";
echo $info['field2'] . "<br>\n";
}
mysql_close($link);
