sql query

squilbert

Hi
I'm fairly new to php and mysql and I'm trying to get the following SQL query to from my php page.

$query = "SELECT DateTime, ShowTitle, Available FROM show WHERE DateTime >= now()";
$result = mysql_query ($query)
or die ("Couldn't execute query. $query");

However, everytime I load this page I get the following error:

Couldn't execute query. SELECT DateTime, ShowTitle, Available FROM show WHERE DateTime >= now()

I originally thought this was a fairly simple page to do as all it does is show forthcoming shows. Therefore this query just checks the database and displays any show on or after the current date.
I've been trying to get this to work for a couple of days now and I'm going a little insane cos of it.

Any help would be much appreciated.

bastien

with out code and a real error message this is hard to debug

try adding this to the or die area in the $result line

$query = "SELECT DateTime, ShowTitle, Available FROM show WHERE DateTime >= now()"; 
$result = mysql_query ($query) 
or die ("Couldn't execute query because ".mysql_error());

That should give you a more meaningful error message that we can then decipher to get you fixed up...

Lars_Berg

Don't use SHOW as a table name. It is a reserved word in Mysql.

squilbert

I've changed the name from show to shows and now when I load the page instead of getting an error message it just displays a blank page. I presume this means the sql query works now yet I've got a problem extracting the data. I'm using the following code which is supposed to extract the data and display it in a table:

$i=1;
while ($row=mysql_fetch_array($result,MYSQL_ASSOC))
{
foreach ($row as $colname => $value)
{
$array[$i][$colname] = $value;
}
$i++;
}
return $array;

echo "<table cellspacing='15'>";
echo "<tr><td colspan='4'><hr></td></tr>";

for ($j=1;$j<=sizeof($array);$j++)
{
echo "<tr>\n
<td>$j</td>\n
<td>{$array['DateTime']}</td>\n
<td>{$array['ShowTitle']}</td>\n
<td>{$array['Available']}</td>\n
<\tr>\n";
echo "<tr><td colspan='4'><hr></td></tr>\n";
}
echo "</table>\n";