[thelist] Rookie SQL Question...

jsWalter jsWalter at torres.ws
Sun Aug 17 01:29:22 CDT 2003


I have 2 tables, menu_items, menu_type...

In menu_items is an identifier (m_type) that matches an identifier (m_type)
in menu_type (foreign key?).

I want to pull *everything* out of menu_items and have it sorted by its
'm_type' and then by its 'm_sort'.

Yes, the 'm_type' is populated in both tables.

What I have below returns nothing. It should return 50 records (test data)

	$strSql = 'SELECT * ';
	$strSql .= ' FROM menu_items, menu_type ';
	$strSql .= ' WHERE m_id = m_id' ;
	$strSql .= ' WHERE menu_items.m_type = menu_type.m_type ';
	$strSql .= ' ORDER BY menu_items.m_type, menu_items.m_sort ';

Where as this, returns all the rows, but replicated for each row in the
'menu_type' table.

Almost, but not quite what I'm looking for.

What I'm looking of is this...

   menu_items.m_id, menu_items.m_name, menu_items.m_sort, menu_items.m_type,
menu_type.m_name

Thanks

Walter



More information about the thelist mailing list