[RESOLVED] A little question

LiamBailey

I am thinking about changing something in my website functionality and need to know if this will work before I even consider making the change:

<?
include ("logintodb.inc");
$query = ("SELECT * FROM size ORDER BY id DESC LIMIT 1");
mysql_query($query)
or die (mysql_error());
?>

Will this return only one entry, the most recent entry into the size table?

laserlight

Will this return only one entry, the most recent entry into the size table?

If you have at least one entry in the table, it will return exactly one entry. This entry may or may not be the most recent entry, depending on how the id field is populated. For example, if it is autoincremented, you would get the most recent entry, unless the database engine reuses ids of deleted entries (which is not the case for MySQL, if I remember correctly).

However, it may be better to store the date/time and use that to determine which entry is most recent.

LiamBailey

WOuld it be the same code except ORDER BY date DESC LIMIT 1)

laserlight

Yes.

LiamBailey

I appreciate your help -- if ($celebrate_christmas = "yes") {
echo ("merry christmas laser light");
} else {
echo ("all the best for the new year");
}

liquorvicar

Liam, in your last post, this will always display "merry christmas laser light" as the single equals sign ("=") is an assignation operator in PHP (i.e. make $celebrate_christmas equal to "yes") and hence will always be true. If you want to check for equality use either the double equals "==" (but beware it's implicit type casting, i.e. 0==false is true) or the triple equals "===", whereby 0===false is not true.