Two database fetching codes

[marcebra]

Hello,

I have two php pages I need help with:

1. I have a database that lists an ID number and then it has a bunch of different categories like color, size, shape,etc and the productID has a value for most of them (some are missing some info). So i want a php page to spill out all the charactaristics of the product without having to give an "if" clause for each one giving a case if it dosnt have a value. So it could say: Color: black [newline] size: 5cm. and then skip shape if there is none.

2. With that same database, I want to be able to make a nice chart view for all the characteristics (this time I could easily write if one is missing) . The thing is that I also want to see the Product Name next too all the characteristics. There is a separpate database that lists the ProductIDs and the Product Names right next to them. is it possible to query two databases at the same time and post them simultaniously in a table?

thanks in advance

[ScubaKing22]

Assuming you're using MySQL:

1) You could make the default value in that field a "<br>", which would produce a new line in the browser. When the characteristics are inserted into the database, just place "Color: some_color" in the field if the actual color isn't empty.

2) mysql_db_query()

[marcebra]

Thanks,

For the second one, I tried it out, and I cant do it. Here's my code:

<?
 $result = mysql_query("SELECT * FROM Chars ORDER By 'ProductID'",$db);
$myrow = mysql_fetch_array($result);

   do {

$resultt = mysql_query("SELECT * FROM Products_key WHERE $ProductID='$myrow[ProductID]'",$db);
$myroww = mysql_fetch_array($resultt);

echo "<tr><td><a href=\"product.php?ProductID=$myrow[ProductID]\">$myroww[ProductName]</a></td>";


if ($myrow["Shape"]=="0") {
$myrow["Shape"] = "-";
}
echo "<td>$myrow[Shape]</td>";
if ($myrow["Color"]=="0") {
$myrow["Color"] = "-";
}
echo "<td>$myrow[Color]</td>";
if ($myrow["Size"]=="0") {
$myrow["Size"] = "-";
}
echo "<td>$myrow[Size]</td>";
echo "</tr>";
		} while ($myrow = mysql_fetch_array($result));

?>

?

How can I get this to work? It's not displaying the Product Name in the first columnof the row.