I have created a MySQL addressbook.
I have fields in my Tables as follows;
Field Table Name
Categories Cats
Business Name Bus
Street Bus
City Bus
State Bus
Post Code Bus
Telephone No Bus
I have the following form <INPUTS> in my <HTML and PHP> page;
- Categories = pull down list
- Street = text
- City = text
- State = radio (vic,nsw,qld,all)
- Post Code = text
- Telephone No = text
I have no problems on simple SELECT xxx FROM xxx, xxx WHERE xxxx=xxxxx
But I am having massive problems working out how to do the conditional searchs for example;
I put in business name, and state only or if I put in Categories and post code.
HELP HELP HELP PLEASE I AM CONFUSED.
Maybe someone has already done this type of address book search?
PLEASE HELP.
Thanks,
Mick.
