Printing records from 2 different sql tables into one main php table

[paulbray]

Hi,

I am trying to set up a page to display information from mysql database

$listgames = "SELECT * FROM tbl_products ORDER BY product_ID ASC" or die ("Cannot query database.". mysql_error());

$skuinfo = "SELECT * FROM tbl_skus ORDER BY SKU_MerchSKUID ASC" or die ("Cannot query database.". mysql_error());

$results = mysql_query ($connectgames, $listgames);

if ($results)
 {
	 echo '<table align="center" cellspacing="3" cellpadding="3" width="75%">

 <tr><td align="left"><b>SKU ID</b></td>
 	 <td align="left"><b>Name</b></td>
	 <td align="left"><b>Price</b></td></tr>

	 ';

 while ($row = mysql_fetch_array($results, mysqli_assoc)) {

 echo '<tr>
 <td align="left">' . $row['SKU_MerchSKUID'] . '</td>
 <td align="left">' . $row['product_Name'] . '</td>
 <td align="left">' . $row['SKU_Price'] . '</td>
 </tr>
 ';
 }
 echo '</table>';

 mysql_free_result ($results);

 }
 else

{

echo 'This could not be retrieved';

echo '<p>' . mysql_error($connectgames) . '<br><br>Query: ' . $results . '</p>';

}

mysql_close ($connectgames);
?>

I am stumped with this as some fields are in the SKU Table and some are in another product table.

Can anyone assist with this

[bradgrafelman]

For one, you never do anything with $skuinfo so it might as well not even be there.

What you really need, however, is a single query that JOINs the two tables together on some common field.

[paulbray]

bradgrafelman;10991808 wrote:

For one, you never do anything with $skuinfo so it might as well not even be there.

What you really need, however, is a single query that JOINs the two tables together on some common field.

How would I join queries from one to another, both tables use sku value but the column headers are spelt differently, i changed coding adding the obsolete query into the $results

[bradgrafelman]

You aren't joining two queries... you're joining the two tables on a common column (the names don't matter - you can specify the relationship explicitly in the join condition).

[paulbray]

<?php

session_start();


$connectgames = mysql_connect("localhost","root","");
	mysql_select_db("consoleentertainmen_518181_db1") or die ('Could not connect to database');

$findgames = mysql_query("SELECT product_MerchantProductID, product_Name, product_Description, product_OnWeb FROM tbl_products INNER JOIN tbl_skus ON tbl_products.product_MerchantProductID = tbl_skus.SKU_MerchSKUID");

$row = mysql_fetch_assoc($findgames);

while ($row = mysql_fetch_array($findgames, mysql_assoc)) {

echo '<tr><td>' . $row['product_MerchantProductID'] . '</td><td>' . $row['product_Name'] . '</td></tr>
';
}
?>

Basically I need the sku_price linked into a table with the other columns from the other table, can anyone offer any suggestions

[paulbray]

paulbray;10991825 wrote:

<?php

session_start();


$connectgames = mysql_connect("localhost","root","");
	mysql_select_db("consoleentertainmen_518181_db1") or die ('Could not connect to database');

$findgames = mysql_query("SELECT product_MerchantProductID, product_Name, product_Description, product_OnWeb FROM tbl_products INNER JOIN tbl_skus ON tbl_products.product_MerchantProductID = tbl_skus.SKU_MerchSKUID");

$row = mysql_fetch_assoc($findgames);

while ($row = mysql_fetch_array($findgames, mysql_assoc)) {

echo '<tr><td>' . $row['product_MerchantProductID'] . '</td><td>' . $row['product_Name'] . '</td></tr>
';
}
?>

Basically I need the sku_price linked into a table with the other columns from the other table, can anyone offer any suggestions

This can be closed as resolved now

[johanafm]

paulbray;10992295 wrote:

This can be closed as resolved now

You do that yourself under "thread tools" above the posts.