need quick help...

brcolow

Ive tried to take this apart but I cant figure out the error in this,

@ $db = mysql_pconnect("localhost", "", "");
 if (!$db)
 {

echo "<b>Could not connect to database, try again later.</b>";

exit; 
}
mysql_select_db("forum");
$result = mysql_query("SELECT * FROM `battle_chat`);
$numrows = mysql_num_rows($result);
if ($numrows > 0)  

{
    	$row = mysql_fetch_object($result);;
		print"$row->id";
		print"$row->message";
}

Whats wrong!?

djo

$result = mysql_query("SELECT * FROM battle_chat);

need another " at the end of your query string

$result = mysql_query("SELECT * FROM battle_chat");

Balefire

Well, to start, I'm pretty sure there is no mysql_pconnect() function. Try mysql_connect().
Also, I'm not sure what that @ symbol is doing in there...my experience of PHP is limited, but I've never had to use it.

Next, your query syntax is wrong.

mysql_query("SELECT * FROM 'battle_chat');

You're missing the double-quote to designate the end of the query. mysql_query("SELECT * FROM 'battle_chat'");

The next line in error that I see is:
$row = mysql_fetch_object($result);; one too many semicolons.

Also, I dunno if it would cause an error or not, but you should probably consider putting spaces in between your print statements and the double-quotes. If not for the sake of error-prevention, this should be done in the interests of making your code easy to read.

print "$row->id";

or consider simply using echo to print out your variables...
echo $row->id;

brcolow

there is a mysql_pconnect it means persistant connection, spacing doesnt matter in php, djo already pointed otu the missing quote, and no there are not too many semicolons and print and echo dont matter I read somewhere that print is more efficient so STFU 🙂 everything u just said was wrong.

[mod edit] try to frame your reponses in a polite fashion, some people are sensitive 🙂 [/ mod edit]

Balefire

Geez, I was only trying to help. Oh, btw, check out this link for info on print vs. echo.

http://www.faqts.com/knowledge_base/view.phtml/aid/1/fid/40