MySQL database orginization and PHP select

[clan11]

I am setting up a MySQL database and will be querying it with PHP. Is is better to break the information up into multiple tables and do select queries on each of the tables; or is it better to put all the items in one table and do a single select query?For example:It will hold information on upto 7 cars; which would mean that their will be approximately 50 columns or so.\[code\]Table_design 1----------------------table_all username car1_make car1_model car1_year car1_condition car1_tires car1_color car2_make car2_model car2_year car2_condition car2_tires car2_color----------------------Table_design 2----------------------table_1 username car1_make car1_model car1_year car1_condition car1_tires car1_colortable_2 username car2_make car2_model car2_year car2_condition car2_tires car2_color----------------------\[/code\]