I have a form but am i setting my mysql table correctly?

[usman07]

This is a image of my forms and a image of my mysql table.

Have i setting my mysql tables up correctly, im especially unsure about the form which says e.g. number of bedrooms (min) and (max) having my mysql table like this will the form work correctly?

[cpd]

Your HTML table wont affect your MySQL table as you should manipulate the input data in PHP to be correctly formatted for when you execute your mysql_query.

[usman07]

where my form says minimum of bedrooms to maximum bedrooms how would i set that out in my mysql table? at the moment i just have number of bedrooms?will that still work?

[cpd]

I would suggest you create a varchar field and perhaps insert something like "1-5" where 1 is your minimum value and 5 is your maximum. You can then explode this value at the "-" and do whatever you want with the values. Alternatively, you could just create two fields, one called maximum and one called minimum or something more descriptive.

[Pikachu2000]

Use two fields. It will greatly simplify SELECTing the data later.

[trq]

Surely the table is designed to hold properties. Properties have a set number of bedrooms, so the table structure you have is correct.

 

You would then need to select properties that fall into your min max range within your query. eg;

 

SELECT * FROM properties WHERE number_of_bedrooms >= $min and number_of_bedrooms <= $max

 

Also, fix your filed names so that they don't contain spaces.