PHP not outputting information

[tigomark]

Hello,

 

I am trying to pull info from a MySQL dbase with a simple script that recieves info from a get request such as

 

http://mysite/subfolder/index.php?where=Alaska

 

The code for the request is as follows

 

 

include "../includes/prefs.php";



$db_name = "weekends";

$table_name = "weekends";

$connection = @mysql_connect("$host", "$root", "$password") or
die("Couldn't connect.");

$db = @mysql_select_db($db_name, $connection) or die("Couldn't select database.");

	$sql = "SELECT *
  FROM $table_name
  WHERE State = \"$where\"   
  ORDER BY WeekendDate 
  
  
  
";

	   $result = @mysql_query($sql,$connection) or die("Couldn't execute query.");

while ($row = mysql_fetch_array($result)) {


	$id = $row ['id'];
	$State = $row ['State'];
	$CityName = $row ['CityName'];
	$WeekendDate = $row ['WeekendDate'];
	$Email = $row ['Email'];
	$Phone = $row ['Phone'];
	$HostCouple = $row ['HostCouple'];




	$weekend_list .="


						<tr>
						<td align=\"center\"  valign=\"top\">$CityName</td>
						<td align=\"center\"  valign=\"top\">$WeekendDate</td>
						<td align=\"center\"  valign=\"top\">$Email</td>
						<td align=\"right\"  valign=\"top\">$Phone</td>
						<td align=\"center\"  valign=\"top\"><a href=\"/echopay/index.php?State=$where&id=$id\">Sign up Here</a></td>

						</tr>


	";

	}


//HTMl Output would then be in the section below



					<div id="you">
					<table width="100%" cellpadding="2" cellspacing="2" border="0" align="center">
					<tr>
					<td align="center" colspan="4"><h2><? echo "$State"; ?></h2></td>
					</tr>
					<tr>
					<th align="center"  valign="top">Location</th>
					<th align="center"  valign="top">Encounter Weekend Date</th>
					<th align="center"  valign="top">Email</th>
					<th align="center"  valign="top">Phone Number</th>
					<th align="center"  valign="top"> </th>
					</tr>
					<? echo "$weekend_list"; ?>
					</table>
					</div>

 

When I test this on my test site and personal site I get the desired output for every state. When I put it to the clients server all that I see is the HTML which is just the Header information. I have never run into this and wanted to see if any one else has run into this.

[trq]

Use <?php tags, not <?

[GingerRobot]

When you say all you see is the HTML - is the php code displayed also? - that is, rather than be executed, the code is just on the screen? In which case, it could be to do with the use of short opening tags (<?). Perhaps your test site you have short tags enabled, but it is disabled on the client server. You may need to use full opening tags(<?php)

 

Also, do you think you could modify you code and put [ code][ /code] tags and full php opening tags- that way we get syntax highlighting.

[tigomark]

No the PHP code is not outputted it is hidden and short tags are enabled (I know it is a bad practice).

[trq]

are you sure your query is returning results? I dont see any call to mysql_num_rows() prior to your loop. Id'e also remove all the error supression if I where you... just to make debuging easier if need be.