eggie

I'll be direct, below is the problem I am having. I tried to explain it as best as I can. If I missed something, please let me know. This has been trying my patiences and I have a feeling there is an easy solution, but for the life of me I can't figure it out.Description of what's what and coming from where:A = cat_a from categoryA Space 888-555-1234 = bname and btel from directoryGolfer = cat from cateforyWorking code, but not in the order I am trying to output: mySQL = "SELECT category.idcat, directory.idcat, cat, cat_a, bactive, bname, btel FROM category, directory WHERE bactive=-1 AND category.idcat=directory.idcat ORDER BY cat_a, bname ASC" A Art Group 888-555-1234 Architects AT Pages 888-555-1234 Advertising Barthrop 888-555-1234 Attorneys Brackett 888-555-1234Gardener _____________________________________________________________________________Working code, but only half of what I need to output mySQL = "SELECT bname, btel FROM directory WHERE bactive=-1 ORDER BY bname ASC" A Space 888-555-1234 A Center 888-555-1234 A Clinic 888-555-1234etc... to Z's _____________________________________________________________________________The other half: mySQL = "SELECT cat_a, cat FROM category ORDER BY cat_a" ABCetc... to Z_____________________________________________________________________________What I am trying to do is combine mySQL = "SELECT bname, btel FROM directory WHERE bactive=-1 ORDER BY bname ASC" mySQL = "SELECT cat_a, cat FROM category ORDER BY cat_a" To output:AA Space 888-555-1234Golfer A Center 888-555-1234Sailor A Clinic 888-555-1234TennisBB Space 888-555-1234Groomer B Center 888-555-1234Trainer B Clinic 888-555-1234AutoCC Space 888-555-1234 PlummerC Center 888-555-1234 PlanterC Clinic 888-555-1234Stemmeretc... to Z_____________________________________________________________________________So I try this: mySQL = "SELECT bname, btel, cat_a FROM directory, category WHERE bactive=-1 ORDER BY bname ASC, cat_a" I get page can not be displayed. HTTP500