Php & Mysql

[slee]

hi all,

ive finally decided to go ahead and learn php with mysql. so here what i want to do:
as i learn most things better by setting my self a project i want to design a mini site a bit like www.autotrader.co.uk i want to have the cars so thay can be searched and so forth but not with all the other stuff does anyone have advice, tips scripts or anything that might help me?
i just want to do it with a few cars to start as i said this is just so i can learn how to do it. i also want to be able to search through liek they do on www.autotrader.co.uk if possible.
your help is appreciated!!

 

[adam_uk]

give each car an id

then have the mysql stuff in a far called car.php then use this

$sql = "SELECT * FROM `tablename` WHERE id = '$id'";

then car.php?id=3 will select the car with id 3 good if you wanna display info for a certain car

 

[slee]

thanks for the help i need to learn the basics first im a total novice

 

[adam_uk]

np i only started about 3 months ago

already got a school web bassed register 90% complete

 

[unknownz]

is it interesting to learn php and mysql

 

[stscac]

yeah, and easy too!

-Steve:D

 

[PoorDoggie]

php and mysql is interesting and useful.

What you want will probably be to "index" the mysql database in which you are storing your car information. Then you can do a mysql "fulltext" search. Look this up as I have not used it for a while. That is how you can do the search.

 

[user-7256]

Download this - it will help get you started!

http://www.vibewave.com/test/members

Click the "download here" link.

Cheers,
-Matt

 

[adam_uk]

talking about digging up the archives lol

 

[user-7256]

Oh - geez just saw that :lol: