Selecting Everything in one row

[ryanmetzler3]

I have a mysql table named store. In that table there are the following rows: name, date, location, and imagelocation. Right now I have this code:

@$term = $_POST['term'];
		$sql = mysql_query("select * from store where name = '$term'");
		$numberofrows=mysql_num_rows($sql);
		while ($row = mysql_fetch_array($sql)) {
			$imgurl = $row['imagelocation'];
			echo "<img id='uploadstyle' src=$imgurl>" . "<br/>";  

Basically the user inputs a name into the form on the site and it displays the 'imagelocation' associated with that name. How can I write some MYSQL to select everything in the 'imagelocation' column and display it?

 

[0xMatt]

I'm not sure what you mean but it sounds like removing the where clause is what you want.

$sql = mysql_query("select imagelocation from store");

[jasmeet]

if your image is stored in some folder like uploads/a.jpg

 

you can use

<img src="uploads/<?php echo $row['imagelocation']; ?>" />

or

something else.. i suppose...!!!