(I also need to somehow put a variable in for the warranty table data so it is tied to the product_status table data. You can see there is a WHERE in the first query of pid, but no WHERE in the second query. That is a seperate question, though. It would make this way too long, so I will post it separately).
Code: Select all
<?php
include "configgg.php";
if (isset($hostname) and isset($database) and isset($db_login) and isset($db_pass)) {
$dbconn = mysql_connect($hostname, $db_login, $db_pass) or die("Could not connect");
mysql_select_db($database) or die("Could not select database");
if (!isset($pid)) {
$pid = 0;
}
$query = "SELECT product_name FROM product_status WHERE product_id='$pid'";
$result = mysql_query($query) or die("Query failedeww");
$line = mysql_fetch_array($result);
$product_name = $line[0];
print "<html><body>";
print "<p align='center'><font face='arial' size='2'><b>$line[0]</b></font></p>";
$query = "SELECT warranty_comment,aw_tag FROM warranty";
$result = mysql_query($query) or die("Query failedeww");
$line = mysql_fetch_array($result);
$warranty_comment = $line[1];
$aw_tag = $line[2];
print "<p align='center'><font face='arial' size='2'><b>$line[1]</b></font></p>";
print "<p align='center'><font face='arial' size='2'>$line[2]</font></p>";
print "</body></html>";
mysql_close($dbconn);
}
?>