whats wrong with this code

[trevor]

Hey sde and others,
ive been away for a while and a problem i was dealing with 3 weeks ago sorta got forgotten........
lol anyways sde, you gave me this code and i am getting a "parse error, unexpected T_STRING" on the "or die(error);" line, so its probably the line above, but i cant figure it out....

here is the code snippet:

PHP Code:

<?
$query = ("Select * from news order by ID desc limit 5");
$result = mysql_query($query, $db)
                        or die("error");

while ($row = mysql_fetch_array ($result)) {

    print("<br><br><p>
    <b><i>posted by</i> -=[$row[author]]=-  <u>$row[header]</u></b>
    <font size='2'><i> $row[date] @ $row[time] </i></font>
    <br>
    $row[content] </p>
    <br>
    <hr width='85%'>");
}
?>

thanks all,
peace,
Trevor

[sde]

sorry, .. i don't take credit for that script... i never use anything like 'or die(error)'

try this:

PHP Code:

<?
$query = ("Select * from news order by ID desc limit 5");
if($result = mysql_query($query, $db))
{
  while ($row = mysql_fetch_row($result)) {

    print("<br><br><p>
    <b><i>posted by</i> -=[" . $row[author] . "]=-  <u>$row[header]</u></b>
    <font size='2'><i> " . $row[date] . " @ " . $row[time] . "</i></font>
    <br>
    " . $row[content] . " </p>
    <br>
    <hr width='85%'>");
   }
}
else
{
  exit;
}
?>

also, .. when posting code with errors.. please communicate which line the error is being reported on =)

thanks,
sde

:: edited ::

[trevor]

yeah........
now i am getting a:

"parse error, unexpected '{'"

on the line:

while ($row = mysql_fetch_array ($result)) {

but i need that '{'?

wtf?
thanks sde

[sde]

i jsut edited the code above .. i think it was the space between mysql_fetch_array - and - the parameter ($result)

however, .. i also switched it to mysql_fetch_row($result)

try that

[trevor]

nope. still doesnt want to work. Same error on the same "{".
i dunno i played around with it for a while and i cant seem to figure it out.
thanks

[Ryan]

Hi,

Try this code out:

PHP Code:

<?
$query = ("SELECT * FROM news ORDER BY ID DESC LIMIT 5");
$result = mysql_query($query);

while ($row = mysql_fetch_array($result)) {

    print("<br><br><p>");
    print("<b><i>posted by</i>");
    print("-=[" . $row[author] . "]=-");
    print("<u>" . $row[header] . "</u></b>");
    print("<font size='2'><i> " . $row[date] . " @" .  $row[time]);
    print("</i></font><br>");
    print($row[content] . " </p>");
    print("<br><hr width='85%'>");
}
?>

I added a lot more "print" functions in there but I tried to make it a bit more organized.

[trevor]

hey,

I'm getting a:
PHP Parse error: parse error, unexpected T_VARIABLE in /var/www/htdocs/ao/main.php on line 177

error on Ryan's code. (btw thanks Ryan)

line 177 is:

PHP Code:

print("<font size='2'><i> " . $row[date] . " @" .  $row[time]); 


thanks everyone so far

[joe_bruin]

try:

PHP Code:

print("<font size='2'><i> " . $row["date"] . " @" .  $row["time"]); 


you're missing alot of other quotes too, but the php parser was smart enough to figure out what you meant in all the other instances.