if within else

Anon

im getting a parse error on line 26 when trying to use this code. Im new to php and was curious if someone could help.

Thanks

<head><title>Grab your MySQL Data </title></head>
<body bgcolor="#FFFFFF">

<?
/ declare some relevant variables /
$DBhost = "localhost";
$DBuser = "root";
$DBpass = "7130mysql";
$DBName = "mydb";
$table = "news";

mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to connect to database");
@mysql_select_db("$DBName") or die("Unable to select database $DBName"); $sqlquery = "Select * from news order by id DESC";
$result = mysql_query($sqlquery);
$number = mysql_numrows($result);

$i = 0; / Make sure $i is set to zero /

if ($number < 1) {
print "<CENTER>There Were No Results for Your Search</CENTER>";
}
else {
if ($number < 4) {
while ($i < 4) / loop until $i = 4 then end /
}
else {
($number > 1)
}
$thename = mysql_result($result,$i,"name");
$thestory = mysql_result($result,$i,"story");
$thedate = mysql_result($result,$i,"date");
print "Name: $thename Story:
$thestory Date:$thedate";
$i++; / Add $i by one and loop again /
}
}
?>
</BODY>

Anon

Basically what Im trying to do is select * from a given table and print only the last 4 entries. Okay, I got that but if there is less than 4 entries I get errors.

How can I us if $i < 4 print those 4 but if $i > 4 then just print everything???

Thanks again

Anon

if ($number < 4) {
while ($i < 4) / loop until $i = 4 then end /
}
else {

Where are the curly braces for the while loop? You've closed the if statement and started the else statement before defining the while loop!

Diego

Anon

but this doesnt seem like the most efficient way of getting this accomplished, do you have any other ideas?

Anon

<head><title>Grab your MySQL Data </title></head>
<body bgcolor="#FFFFFF">

<?
/ declare some relevant variables /
$DBhost = "localhost";
$DBuser = "root";
$DBpass = "7130mysql";
$DBName = "mydb";
$table = "news";

$i = 0; / Make sure $i is set to zero /

if ($number < 1) {
print "<CENTER>There Were No Results for Your Search</CENTER>";
}
else {
while ($i < 4) { / loop until $i = 4 then end /
if ($number == $i ) {
break;
}
$thename = mysql_result($result,$i,"name");
$thestory = mysql_result($result,$i,"story");
$thedate = mysql_result($result,$i,"date");
print "Name: $thename Story:
$thestory Date:$thedate";
$i++; / Add $i by one and loop again /
}
}
?>
</BODY>

fitzbean

You say you want the last 4 records in the result...

wouldnt this return the records you want?:

Select * from news order by id ASC LIMIT 4