readin and writtin

[trev]

Hi
Could any one tell me why this code wont work.
It seems to connect to the DataBase[mySQL] and writes the query. [On my home server it then get the info requested and sends it back to my flash movie]

on the real server it always breaks out at the mysql_query line, well when I test the result. Wot is it that Im missing[apart from sleep]

require 'include.php';

@$db =mysql_pconnect($DBhost,$DBuser,$DBpass);
if(!$db){
		print"&page=3";
		print"&loading=NO";
}else{


	@mysql_select_db($DBName);

	$query = "SELECT * FROM mac";

	$result = mysql_query($query);

//----------------------------------------------------------------------
This is where it breaks on the proper server
//------------------------------------------------------------------------

	if(!$result){
		print"&page=4";
		print"&loading=NO";
		}else{
	$num_results = mysql_num_rows($result);

		$mail = "";
		for($i=0; $i <$num_results; $i++)
		{
		$row = mysql_fetch_array($result);
		$id=stripslashes($row["gid"]);
	  	$nick=stripslashes($row["name"]);
	  	$tim=stripslashes($row["time"]);
	  	$bod=stripslashes($row["comment"]);
	  	$smail=$id.",".$nick.",".$tim.",".$bod.;
	  	$mail=$smail."^".$mail;
		}


		print"&page=5";
		print"&mail=".$mail;
		print"&loading=NO";




	}
}

---

I hope this makes sence to somebody, I realy need help, Im going mad thinking of different ways to say the same thing help.

Trev

[barand]

Try running without suppressing the error messages and see if that gives any clues.

[hand]

$db = mysql_pconnect($DBhost,$DBuser,$DBpass)
          or print "&gt;&gt;&gt; MySQL-Error: ".mysql_errno()." -&gt; ".mysql_error()."<br>\n";

if(!$db){ 
  print "&page=3&loading=NO"; 

} else { 
  mysql_select_db($DBName)
     or print "&gt;&gt;&gt; MySQL-Error: ".mysql_errno()." -&gt; ".mysql_error()."<br>\n"; 

  $query = "SELECT * FROM mac"; 
  $result = mysql_query($query)
     or print "&gt;&gt;&gt; MySQL-Error: ".mysql_errno()." -&gt; ".mysql_error()."<br>\n";

  if(!$result){ 
    print"&page=4&loading=NO"; 

  } else { 
    $num_results = mysql_num_rows($result); 
    $mail = ""; 

for($i=0; $i <$num_results; $i++) { 
  $row  = mysql_fetch_array($result); 
  $id   = stripslashes($row["gid"]); 
  $nick = stripslashes($row["name"]); 
  $tim  = stripslashes($row["time"]); 
  $bod  = stripslashes($row["comment"]);
  $mail = "$id,$nick,$tim,$bod^$mail";
} 
print"&page=5&mail=$mail&loading=NO"; 
  } 
}