I'm not sure what Dreamweaver produces, but you appear to want the supplier_name that corresponds to the supplier_id. As you have the suppier_id already, it is quite simple the get the name from the supplier table.
The sequence of events is:
1. connect to database.
2. get the supplier name that corresponds to the supplier_id from the supplier table.
3. create a variable with the supplier name.
4. display the supplier name (echo the variable) at the correct place on your page.
Here's what the code should look like:
$db_user="Your user name";
$db_database="The database name";
$link_id = mysql_connect("$db_host","$db_user","$db_password");
if (mysql_select_db("$db_database", $link_id));
$select =" SELECT supplier_name FROM suppliers WHERE supplier_id = ' $supp_id ' ";
$results = mysql_query("$select", $link_id);
$query_data = mysql_fetch_row($results);
$supplier_name = $query_data;
Now you have a variable called "$supplier_name" that contains the supplier name that corresponds to the supplier_id.
Hope this helps.