I'm not sure why the following code isn't returning the name of the Venue instead of a list of Resource ID numbers.
Here is a code snippet. Code truncated after place where "Resource ID #" appears.
$result = mysql_query("SELECT * FROM SHOWS ORDER BY ID DESC");
while($row = mysql_fetch_array($result))
{
$showdate = date("m/d/y",$row['DATETIME']);
$showtime = date("h:i A",$row['DATETIME']);
$venueid = $row['VENUE'];
$getvenue = "SELECT DISTINCT VENUENAME FROM VENUES WHERE VENUEID = $venueid";
$venuename = mysql_query($getvenue);
$venue = $venuename;
echo "
";
echo "| " . $row['ID'] . " | ";
echo "" . $showdate . " | ";
echo "" . $showtime . " | ";
echo "" . $venue . " | ";
Thank you for any advice you can offer!
8:37 am on May 2, 2010 (gmt 0)
Hello,
Your problem is because you are trying to reference a query, rather than data pulled from the query:
$venuename = mysql_query($getvenue);
$vname = mysql_fetch_array($venuename);
$venue = $vname['VENUENAME'];
dc
4:06 pm on May 7, 2010 (gmt 0)
Thank you! Problem solved.
|
| 
