[SOLVED] if/else question

[secoxxx]

Anyone know how i would go about somthing like this....

 

if

 

"the last record in the database"

 

echo ('NEW!');

 

else

 

blank

[niranjnn01]

could you give more information as to what your requrement is ?

 

There is one suggesstion, not a solution. maybe it will help

 

Try changing your logic to this

 

write a query to get the data in the ascending order [with respect to some field like id or time - which we know, whose data will be in some definite order.]

 

get the data into an array, and do the processing for all elements, till you reach the last element.

 

when you reach the last element, echo ('NEW!');

 

 

or,

 

if you want to detect the last row of the table, then sort the query in descending order with respect to some field like time, id etc

 

Regards

[MasterACE14]

What are you trying to do exactly?

[secoxxx]

i have a list from the database.

SELECT * FROM dvd ORDER BY dvd_id DESC

 

this shows everything i want, but i want to add a NEW! under the lastest dvd added thumbnail

 

im just not sure how to integrate a if else into a query or if i even need to.

[ronnie88]

if ($newdvd == 1); {

  echo "SHOWTHIS";

}

else {

  echo "if not show this";

}

[paul2463]

$query = "SELECT * FROM dvd ORDER BY dvd_id DESC";
$result = mysql_query($query) or die ("Error in query " . mysql_error());
while ($row = mysql_fetch_assoc($result))
{
echo "$row['name'] </BR>";
}
echo "NEW";

[niranjnn01]

I think its better you have an additional field "new_entry", which can be set to 0 or 1,

 

and as you display , check this fields value for each, and if its 1, echo NEW.

 

[secoxxx]

niranjnn01, thanks, i guess that was the easiest way to do it, i didnt want to add another field but this seems to work fine.