Problem with PHP out put

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">&nbsp;</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.

bradgrafelman

When posting PHP code, please use the board's [PHP][/PHP] bbcode tags - they make the code much, much easier to read (as well as aiding the diagnosis of syntax errors). You should edit your post now and add these bbcode tags to help others in reading/analyzing your code.

Also, I see no <?php ?> tags in your code... these are, of course, essential.

Finally, since the script isn't working properly - debug it! Make sure display_errors is set to On, error_reporting is set to E_ALL, and that you remove all of the '@' error suppressors from the script.