simple select based on user input
Posted by: meiz arebel
Date: October 19, 2009 05:42AM

good day,

i am a total novice and need to produce a query for a mysql database and display the results on a web page (php). thesee are two tables.

Table = Area
Attribute Description Null Default Comments
areaID varchar(4) No
areaName varchar(50) Yes Null
areaAddress varchar(50) Yes Null
areaPhoneNo char(11) Yes Null
areaFaxNo char(11)

Entity = Driver
Attribute Description Null Default Comments
driverID char(4) No
areaID varchar(4) Yes Null
driversPermitNo varchar(8) Yes Null
driversFirstName varchar(50) Yes Null
driversLastName varchar(50) Yes Null
driversAddress varchar(50) Yes Null
driversPhoneNo char(11) Yes Null

I need to deliver a report of for all drivers who belong to an area (the area of choice would be based on user input when the query is run)

Please help.

Options: ReplyQuote

Written By
simple select based on user input
October 19, 2009 05:42AM

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.