[php-learner]

Help....

I am new to php programming and i am designing a site whereby users add information of their cars. I have created the add_cars page and i can search for them aswell.

What i need help with is a code whereby i search for the cars but i only want to display say 3 out of the 5 pieces of information. I would like a (more details) link which will open up a link to the information on that car.

I have been doing some research and i have read that there are two files which are needed to be created, one to create the id and the other to display the results. I dont really understand this. Has anyone created any code or know of a well explained tutorial where i can learn how to do this.

THANKYOU

[PerHP]

Hi there,

Your questions are a bit difficult to answer immediately without some more info, but I'll give it a try.

DISPLAY:
$search=$_GET['search'];
- Create a form and send the query away to a page with this code:
$sql="SELECT id, model, year, price FROM cars WHERE model LIKE '$search' OR year LIKE '$search' OR price LIKE '$search' ORDER BY price";

MORE DETAILS:
- A new page which displays the info for the car with the designated id:
$sql="SELECT * FROM cars WHERE id=$id";

Of course it can be made more advanced and functional, but this hopefully gives you an idea.