Displaying DB Fields based on &_Get["id"]

Ghost_81st

I am trying to Display two Text fields from my MySQL DB, Type and Job by using &_Get["id"]

PictureNum      Job     Type
1            Untitled        Hardscape
2            LaRoche       Unknown
3            LaRoche       Hardscape

If I use this Link:

[url]http://www.hubbelllandscapes.com/picture.php?id=1[/url]

I am unsure as to where to start. I am new to PHP and MySQL, I started only a few days ago, but how would I go about showing the two fields like this:
"Hubbell Landscapes +Job +Type"

devinemke

you didn't mention what the name of your table is but i'm going to assume it is simply called "table":

$result = mysql_query('SELECT * FROM table WHERE PictureNum = ' . $_GET['id']);
while ($row = mysql_fetch_assoc($result))
{
	foreach ($row as $key => $value) {echo $key . ' = ' . $value . '<br>';}
	echo '<br>';
}

Ghost_81st

That is almost it, is there a way to Just print the vaules of the "Type" and "Job". It was table1, but you gave me some valuable info thanks.

tsinka

Hi,

use $row['Type'] and $row['Job'] inside the while loop and remove the foreach part. If you only need Type and Job use

SELECT Type,Job FROM .....

instead (no need to fetch more than neccessary).

Thomas