[Resolved] [Resolved] Displaying only one colum of MySQL BD when using query

[Ghost_81st]

I just picked up some MySQL stuff yesterday, and I am trying to create a database for image pointers. I have that ok so far. My problems is when I display the vaules of what I want. it displays all the colums, and I only want it to display the colum "Location"
Here is the code I am using:

<?php
/* Connecting, selecting database */
$link = mysql_connect("**", "**", "**")
   or die("Could not connect : " . mysql_error());
echo "Connected successfully";
echo "<br>";

/* Performing SQL query */
$query = "SELECT * FROM table1 schools where Type LIKE 'Hardscape'";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
echo "<br>";



/* Printing results in HTML  */
echo "<table>\n";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
   echo "\t<tr>\n";
   foreach ($line as $col_value) {
       echo "\t\t<td>$col_value</td>\n";
   }
   echo "\t</tr>\n";
}
echo "</table>\n";

/* Closing connection */
mysql_close($link);
?>

Can anyone help me with how to display only certian colums?

[akillez]

1. you say "SELECT *...", this means select all fields
2. why do you alias your table?
   Either your table is called "table1" or "schools", but now you select from the table named table1 and alias that table to schools.
   Aliasing is common practice when selecting from multiple tables, but here it is unnecesary.
3. You have to use wildcards (%) in your like statement.
   If you are providing the complete field-input use Type='Hardscape', if that is only part of the possible search string use Type LIKE '%Hardscape%'.

$query="SELECT Location FROM schools WHERE Type='Hardscape'";
$result=mysql_query($query);

while(list($Location)=mysql_fetch_row($result)) {
echo $Location;
}