Jump to content

PLLLLEEEEZZZZZZZZ HELP!! Beginner - just needs to add drop down box


JTapp

Recommended Posts

OK - I will spend HOURS on anything I get from you guys.  Thanks in advance for reading my immature code.

The following is my crap code. 

 

Two tables:

Table 1 is tblLodges and its field is strLodgeName  - Unique field is lngLodgeID

Table 2 is tblOfficers and the fields are strLastName and strFirstName - Unique field is also lngLodgeID

 

I need my statement to work from to a drop down html search page.

 

$query = "SELECT tblLodges.strLodgeName, tblOfficers.strLastName, tblOfficers.strFirstName".

"FROM tblLodges, tblOfficers ".

"WHERE tblLodges.lngLodgeID = tblOfficers.lngLodgeID";

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.