[SOLVED] I want to view a specific result

[pcbguy]

I have this code that shows all the entries in my database with the picture. I want to be able to select a specific entry from the database to display. I have the "position" column set to be the primary key.

 

How can I change this to work?  Thanks.

<?php
//Connects to your database
include "connect.php";

//Retrieves data from MySQL
$data=mysql_query("SELECT * FROM for_sale")or die(mysql_error());

//Puts it into an array
while($info=mysql_fetch_array($data))
{
	//Outputs the image and other data
	Echo"<img src=http://www.mysite.net/images/".$info['picture']."><br>";
	Echo"<b>Position:</b>".$info['position']."<br>'";
	Echo"<b>Year:</b>".$info['year']."<br>'";
	Echo"<b>Make:</b>".$info['make']."<br>'";
	Echo"<b>Model:</b>".$info['model']."<br>'";
	Echo"<b>Price:</b>".$info['price']."<br>'";
	Echo"<b>Description:</b>".$info['description']."<hr>'";
}
?>

[revraz]

Easiest way is to create a URL for each Row, include that Position (id) as link.php?id=$info.  Then have a new page with $_GET['id'] which reads that URL, gets the id in $info and you can just display that one.

[therealwesfoster]

Change your SQL query

 

$data=mysql_query("SELECT picture,position FROM for_sale")or die(mysql_error());

 

You can choose whichever ones you want to SELECT

[pcbguy]

So

Change your SQL query

 

$data=mysql_query("SELECT picture,position FROM for_sale")or die(mysql_error());

 

You can choose whichever ones you want to SELECT

 

So if I change it to 'position' I can select the position number and it will only call that one result?

 

[pcbguy]

Okay. I changed it to:

 

$data=mysql_query("SELECT position FROM for_sale")or die(mysql_error());

 

But now the picture doesn't display and the rest of the info does. Do I have to add something after the web address?

 

[pcbguy]

Easiest way is to create a URL for each Row, include that Position (id) as link.php?id=$info.  Then have a new page with $_GET['id'] which reads that URL, gets the id in $info and you can just display that one.

 

Not sure how to do this. I am a definite newby. Could you expand?

[revraz]

Thats because the SELECT position means you are only grabbing the position data and not the rest.  You want to SELECT * FROM for_sale WHERE position = $info

 

But that wont work until you set the Varialble $info, which you can do with $_GET

[pcbguy]

Okay. It is starting to make sense. Thanks for your help. I'm sure I will have another question.

 

I set the $info at the top with $_GET, right?

 

[pcbguy]

could I just set position=991 if I only wanted that entry to appear?

 

[revraz]

Give it a try

[pcbguy]

It worked. Outstanding. You are my hero. Thanks for the help. Now I can move onto the next phase. 

[revraz]

No problem.  If you want to make a page full of Links that point to each record, then you'll want to use a $_GET function.

 

Also, don't forget to mark the Topic as Solved.

[pcbguy]

Okay. Still not sure about the $_GET. Can you give an example?

 

[revraz]

Check out Wildteen's post here

 

http://www.phpfreaks.com/forums/index.php/topic,169952.msg750668.html#msg750668

[pcbguy]

Thanks again.