[SOLVED] Can't call MySQL column

[cheechm]

Hi,

I am trying to show a MySQL column in "review.php"

 

The code inside review.php is:

 

<?php

$eventname = $_GET['eventname'];
$year = $_GET['year'];

$con = mysql_connect("");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("", $con);


$result = mysql_query("SELECT * FROM Results WHERE EventName=$eventname AND Year=$year");

while($row = mysql_fetch_array($result))
  { 
  echo $row['EventName'] . " " . $row['Review'];
  }  

mysql_close($con)

?>	

 

In the table Results are the columns called EventName, Year and Review.

An example inside each of these columns is:

Eventname- foot

Year- Sen

Review- No review present

 

When I go to www.mydomain.com/review.php?eventname=Foot&year=Sen nothing is outputted.

 

What is the problem causing nothing to be displayed?

 

 

Thanks

[Wildbug]

Always check for errors when writing code.

 

$query = "SELECT * FROM Results WHERE EventName='$eventname' AND Year='$year'";
if (mysql_errno()) printf("<b>Error: %s<br>\nOn query: %s</b><br>\n",mysql_error(),$query);
$result = mysql_query($query);

 

(You probably are querying a text/varchar column but not using quotes on the search value.)

[cheechm]

Ah! You were right. Thanks