CODEWITHSUNDEEP
phpmysql
Aelyn
Aelyn

Reputation: 13

MySQL/PHP - Display Recent Date

I was able to apply this line onto phpMyAdmin and it worked just fine. 

    SELECT id, date_format(`date`, '%m.%d.%Y') as `date` FROM TABLE ORDER BY date DESC LIMIT 1

The problem is that when I added the rest of the code, the recent date shows up blank on the webpage. Am I missing something in this code?

    <?php        
    $query = "SELECT id, date_format(`date`, '%m.%d.%Y') as `date` FROM TABLE ORDER BY date DESC LIMIT 1";
    $result = mysql_query($query);

    echo "$date";
    ?>

Any help is appreciated. Thank you.

Upvotes: 1

Views: 43

Answers (2)

Randomius
Randomius

Reputation: 350

You didn't set $date variable. You need to use mysql_fetch_array function for your $result variable.

Ex: `

$query = "SELECT id, date_format('date', '%m.%d.%Y') as 'date' FROM TABLE ORDER BY date DESC LIMIT 1";

$result = mysql_query($query);

while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
 print_r($row); }

`

Upvotes: 0

user6063698
user6063698

Reputation:

. Try this

$query = "SELECT id, date_format(`date`, '%m.%d.%Y') as `date` FROM TABLE ORDER BY.  date DESC LIMIT 1";
$result = mysql_query($query);
$r = mysql_fetch_assoc($result); 
$date = $r['date']; 
echo "$date";

Upvotes: 0

Related Questions