combining data from two fields, displaying with another table

horstuff

What I am trying to do is pull data from two tables and display it on one page. The code below doesn't display any errors, but all it prints is the results from the first query. Ideas? Thanks.

(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).

<?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);
}

?>

sijis

so you are trying to combine 2 tables?

first question, does the table 'warranty' have a field that ties it with the product_status?

if it does try this sql statement:

SELECT * FROM product_status, warranty WHERE product_status.product_id=warranty.field_that_matches AND product_id ='$pid';

(at least it will be somethign similar)

I've noticed, in this line:
$query = "SELECT warranty_comment,aw_tag FROM warranty";

you are getting ALL of the data, not just a specific sorted data.
so if you can't see any data, other than the first row, you have to loop it. so you'd add somehting like this:

while($row = mysql_fetch_array($query)){
echo $row['field1'];
}

if none of this worked, then i just didn't understand your question.

horstuff

No, the aw_id field in table warranty currently doesn't tie in with the product_id field in product_status. That is the big problem, I think. Like I said, product_id, in table product_status in not auto integer, because the number must be manually put in to match the cart. Field aw_id in table warranty is auto integer. I can't figure how to tie the two together.

sijis

all you have to do is create another field in warranty. lets call it aw_of_product (or whatever else you want to call it).

when you put data in your db, make sure that this new field has the same ID as your product_id. (it doesn't matter if its auto_number or if you are specifing the values.)

here's what i mean:

product_status

warranty

aw_id | aw_of_product | aw_text
1 | DVD1012 | Whatever is here
2 | DVD1000 | More text is here.
3 | DVD2019 | ........

now the query would be something like this:

$pid = "DVD1012";
SELECT * FROM product_status, warranty WHERE product_status.product_id=warranty.aw_of_product AND product_id ='$pid';

this query should get this data with it.
in a temp table

Does this make sense to you?