Re: simple select based on user input
Posted by: Rick James
Date: November 01, 2009 04:11PM

SELECT d.*
   FROM Area a, Driver d
   WHERE a.areaID = d.areaID
     AND a.areaName = '$name'
   GROUP BY d.driverID;

Suggest using
http://forums.mysql.com/list.php?10 for Newbie questions
http://forums.mysql.com/list.php?52 for PHP questions

Options: ReplyQuote


Subject
Written By
Posted
Re: simple select based on user input
November 01, 2009 04:11PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.