Displaying MySQL Results

[webdes03]

I'm having some trouble with displaying a list of some MySQL results. Does anyone know what I might be doing wrong? I seems to me like it should work, but apparently I've got something wrong.

It's supposed to select unique events (as some of them are duplicated) from a calendar, then display them in a list.

I'm getting an invalid mysql result resource error and an invalid argument for foreach(), however I think the foreach() error will go away when the sql error is fixed. Thats an assumption though.

Any help? Thanks.

<?php
  echo '<b>Events</b><br>';
  $query = "SELECT DISTINCT show FROM calendar ORDER BY caldate LIMIT 10";
  $result = mysql_query($query);
  $event = mysql_fetch_array($result);
  foreach ($event as $element){
    echo $element . '<br>';
  }
?>

[LordShryku]

Add mysql_error() to find out what's wrong

$result = mysql_query($query) or die(mysql_error());

[webdes03]

"You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'show FROM calendar' at line 1"

I copied the code from the manual though, I don't understand how it could be wrong. Any ideas?

From the manual:

mysql> SELECT owner FROM pet;
+--------+
| owner |
+--------+
| Harold |
| Gwen |
| Harold |
| Benny |
| Diane |
| Gwen |
| Gwen |
| Benny |
| Diane |
+--------+
However, notice that the query simply retrieves the owner field from each record, and some of them appear more than once. To minimise the output, retrieve each unique output record just once by adding the keyword DISTINCT:

mysql> SELECT DISTINCT owner FROM pet;
+--------+
| owner |
+--------+
| Benny |
| Diane |
| Gwen |
| Harold |
+--------+

[LordShryku]

SHOW is a MySQL Reserved Word

[webdes03]

ohhhhhh... I guess I'll change my database then. Thanks. Stupid mistake.