[php-list] Re: Parent/child mismatch in a PHP/MySQL database

[cdg1111us]

This needs a subquery for each household_id.  Query first for the results of last_name LIKE 
'$startswith%' and then in your WHILE loop fetching those results, make another query for all 
children matching each individual household_id.  





> 
> $result2 = mysql_query("select * from children, heads_of_household
> where ((children.household_id = heads_of_household.household_id) and
> (heads_of_household.last_name like '$startswith%')) order by name") or
> die("Couldn't run query #2.");













Community email addresses:
  Post message: php-list@yahoogroups.com
  Subscribe:    [EMAIL PROTECTED]
  Unsubscribe:  [EMAIL PROTECTED]
  List owner:   [EMAIL PROTECTED]

Shortcut URL to this page:
  http://groups.yahoo.com/group/php-list





  




  
  
  YAHOO! GROUPS LINKS



   Visit your group "php-list" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.