- Original Message -
From: Gürhan Özen [EMAIL PROTECTED]
To: Becoming Digital [EMAIL PROTECTED]
Cc: PHP-DB [EMAIL PROTECTED]
Sent: Friday, 06 June, 2003 23:07
Subject: Re: [PHP-DB] Displaying groups from SELECT
On Fri, 2003-06-06 at 21:49, Becoming Digital wrote:
I'm wearing the stupid hat
hey, you can join the two queries and make only one...
?
function get_inventory()
{
$query = SELECT c.cat_id, p.product_name FROM categories as c LEFT JOIN
products as p on (c.cat_id = p.cat_id);
$result = mysql_query( $query );
if ( mysql_num_rows($query) 0 )
On Fri, 2003-06-06 at 21:49, Becoming Digital wrote:
I'm wearing the stupid hat today, so please pardon this. I know I must be
overlooking something.
I have a small catalogue with two tables (categories, products) from which I'm
trying to display items. I'm trying to print the contents as
Digital [EMAIL PROTECTED]
Cc: PHP-DB [EMAIL PROTECTED]
Sent: Friday, 06 June, 2003 23:07
Subject: Re: [PHP-DB] Displaying groups from SELECT
On Fri, 2003-06-06 at 21:49, Becoming Digital wrote:
I'm wearing the stupid hat today, so please pardon this. I know I must be
overlooking something.
I