unexpected T_while [php]

[wickedgenius]

When I try to use the following script i get an error:

mysql_connect("localhost", "aurillia_wicked", "maisie")or die("cannot connect"); 
mysql_select_db("aurillia_clandb")or die("cannot select DB");

$sql = "select * from news limit 5";
$sql_result = mysql_query($sql) or die(mysql_error());

$display_block = "<table cellpadding=10 border=1>"

while ($row = mysql_fetch_array($sql_result)) {
    $news = $rows["content"];
    $author = $rows["author"];
    $added = $rows["added"];
    $display_block .= "<tr>
                           <td>
                               <div align=left>
                               ". $added ."
                           </td>
                           <td>
                               <div align=right>
                               ". $author ."
                           </td>
                       </tr>
                       <tr>
                           <td rowspan=2>
                           ". $news ."
                           </td>
                       </tr>";
}

And the error says:

Parse error: syntax error, unexpected T_WHILE in /home/aurillia/public_html/login_success.php on line 21

Can anyone help me.

 

[fireshark]

This often confuses people, since you concentrate on finding what's wrong with the while.
Change this:

$display_block = "<table cellpadding=10 border=1>";

 

[themoose]

What fireshark said will fix it You missed the ";".

 

[wickedgenius]

Thanks!

They should rethink the whole error thing to tell the bit bit of code thats wrong.

I bet loads of people have had this sort of problem.

 

[fireshark]

Why make debugging easier?

 

[krakjoe]

Thanks!

They should rethink the whole error thing to tell the bit bit of code thats wrong.

I bet loads of people have had this sort of problem.

Once you know all about php and how it works, the errors do actually make sense.

In the most basic terms, php expects every statement to end with a semi-colon so an unexpected T_* will mean you forgot to end the statement immediately before it, thus Ze does not expect to encounter it.

 

[wickedgenius]

Fair enough Joe thats makes sense to me now.

 

[BrandonTheG]

This is a bit off topic, but why do do while $row, then define everything inside the while with $rows?

 

[stuffradio]

Because I think that's a syntax error

 

[themoose]

This is a bit off topic, but why do do while $row, then define everything inside the while with $rows?

People use $row because it's what's written as default in the php manual, and therefore most tutorial sites, so it's how people learn it when they don't have a specific variable name to use. I believe he's using $rows because he's creating rows of a table to display his data in HTML.

 

[iBrightDev]

looks to me like $rows needs to be changed to $row also to make it work.

 

[BrandonTheG]

looks to me like $rows needs to be changed to $row also to make it work.

That's exactly what I was trying to say, thanks for clearing it up.

 

[themoose]

I missed that .

 

[iBrightDev]

shame on you moosey.