Thank You very much bastien!
But these resourses are too confusing... i've examined them months ago.
Well! Let me just show you an idea, may be this could help:
Database(MySQL)
create database autodealer;
use autodealer;
create table makes(
makeID int(11) not null primary key default "0",
make_name varchar(20) not null);
/*
Let's say it is populated with:
+--------+------------+
| make_ID | make_name |
+--------+------------+
| 1 | Buick |
| 2 | Cadillac |
| 3 | Chevrolet |
| 4 | Chrysler |
*/
create table models(
mod_id int(11) primary key auto_increment,
mod_name varchar(60) not null,
mod_year int(4) not null default "0";
mod_price varchar(100) not null
transmission varchar(30) default "autometic",
body_type varchar(40),
mod_image varchar(40),
// foreign key
make_id int(20));
//Let's say it is populated with:
-+-----------+------------+------------+------------+--------+
| mod_id | mod_name | mod_year | mod_price | engine | Transmission | body_type
| mod_image |mak_id |
+--------+------------+----------+-----------+--------+--------------+----------
-+-----------+------------+------------+------------+--------+
| 5 | Eldorado | 1997 | 6400 | 3.0 V6 | | sedan
| 01.jpg | 2 |
| 6 | Corvette | 1999 | 19400 | 5.0 V6 | | coupe
| 03.jpg | 3 |
I know that I am wrong but this the database structure I came with.
Now the idea is to make about (I guess) four PHP queries to MySQL with dynamic drop-down search menus ("make" "model", "year", "price"), and as the user picks a make the models should be triggered dynamicly from MySQL. I know very little javascript so could this be done in PHP?
Come on boys, may be somebody has any suggetions. I will apprecite any information, any suggetions to database structure and of course the script. Thanks in advance!
