php & mysql

slee · 05-27-2003, 08:11 AM

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 · 05-27-2003, 11:35 AM

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 · 05-27-2003, 04:32 PM

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

adam_uk · 05-28-2003, 12:19 AM

np i only started about 3 months ago

already got a school web bassed register 90% complete

unknownz · 08-16-2005, 11:52 AM

is it interesting to learn php and mysql

stscac · 08-16-2005, 11:59 AM

yeah, and easy too!

-Steve

PoorDoggie · 08-16-2005, 12:12 PM

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.

mholt · 08-16-2005, 02:56 PM

Download this - it will help get you started!

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

Click the "download here" link.

Cheers,
-Matt

adam_uk · 08-16-2005, 02:56 PM

talking about digging up the archives lol

mholt · 08-16-2005, 02:57 PM

Oh - geez just saw that

05-27-2003, 08:11 AM	THREAD STARTER #1 (permalink)
slee NamePros Member Join Date: May 2003 Posts: 74	php & mysql 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!!

08-16-2005, 11:52 AM	#5 (permalink)
unknownz NamePros Regular Join Date: Aug 2005 Posts: 727	is it interesting to learn php and mysql __________________ :laugh:...::::Pakisp.net::::...-The Entertainment Pack Pakisp.net :wave: Free Web Directory

05-27-2003, 11:35 AM	#2 (permalink)
adam_uk Senior Member Join Date: May 2003 Posts: 2,187	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

05-27-2003, 04:32 PM	THREAD STARTER #3 (permalink)
slee NamePros Member Join Date: May 2003 Posts: 74	thanks for the help i need to learn the basics first im a total novice

05-28-2003, 12:19 AM	#4 (permalink)
adam_uk Senior Member Join Date: May 2003 Posts: 2,187	np i only started about 3 months ago already got a school web bassed register 90% complete

08-16-2005, 11:59 AM	#6 (permalink)
stscac A Wealth of Knowledge Join Date: Aug 2004 Posts: 3,809	yeah, and easy too! -Steve

08-16-2005, 12:12 PM	#7 (permalink)
PoorDoggie Soon to be RICHdoggie! Join Date: Jan 2005 Location: UK Posts: 2,408	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.

08-16-2005, 02:56 PM	#8 (permalink)
mholt DNOA Member Join Date: May 2004 Posts: 5,040	Download this - it will help get you started! http://www.vibewave.com/test/members Click the "download here" link. Cheers, -Matt

08-16-2005, 02:56 PM	#9 (permalink)
adam_uk Senior Member Join Date: May 2003 Posts: 2,187	talking about digging up the archives lol

08-16-2005, 02:57 PM	#10 (permalink)
mholt DNOA Member Join Date: May 2004 Posts: 5,040	Oh - geez just saw that

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)