View Single Post
  #8 (permalink)  
Old October 6th, 2010, 04:49 PM
bopjo1 bopjo1 is offline
Authorized User
 
Join Date: Sep 2010
Posts: 20
Thanks: 0
Thanked 2 Times in 2 Posts
Default

Did you remember if you used the exact MySQL code in your first post? (this one:)

Code:
 $query = 'SELECT 
       c.alias, c.real_name, c.alignment, 
       l.address, z.city, z.state, z.zipcode_id 
       FROM 
           comic_character AS c, comic_lair AS l, comic_zipcode AS z 
       WHERE 
           z.zipcode_id = l.zipcode_id AND 
           c.lair_id = l.lair_id AND 
           c.character_id = '. $character_id;
Reply With Quote