Jump to content

Archived

This topic is now archived and is closed to further replies.

Guest PcGamerz13

Help with PHP,MySQL

Recommended Posts

Guest PcGamerz13
Deleted

Share this post


Link to post
Share on other sites
You've got too many close braces "}" I always label my close braces, otherwise I end up with errors like you have. See my //comments in your code snippett

[!--quoteo(post=353423:date=Mar 9 2006, 03:55 PM:name=PcGamerz13)--][div class=\'quotetop\']QUOTE(PcGamerz13 @ Mar 9 2006, 03:55 PM) [snapback]353423[/snapback][/div][div class=\'quotemain\'][!--quotec--]
1. I get this error Parse error: parse error, unexpected '}' in Not Telling on line 142
2. I got four field in table mail: Sent_By,Sent_To,Message,Date. I need this to show From: Sent_By, Message: Message,Date: Date. Please help fix this.

[code]<?
$sql = "SELECT * FROM `mail` WHERE Sent_To='$Username'";
$result = mysql_query($sql);
if (mysql_num_rows($result) > 0) {  // Opens the IF Clause

    while ($row = mysql_fetch_row($result)) { //Opens The While Loop

        echo '<div>';
        echo '<p>----<br /><font face="verdana" size="2" color="red">From: </font>' . $row[1];
        echo '<br /><font face="verdana" size="2" color="red">Message: </font>' . $row[2];
            echo '<br /><font face="verdana" size="2" color="red">Date: </font>' . $row[3];
            echo '<br />----</p>' . '</div>';

}  //  CLOSES the While Loop

}else{   // Continue the IF Clause
echo ("<font face='verdana' size='2'>You have no messages</font>");

} // CLOSES the IF Clause

} // Dunno what this is closing?
} // Dunno what this is closing?

mysql_free_result($result);
?>[/code]
[/quote]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.