Select latest entry from MySQL database error

Question

<?php
mysql_connect("localhost", "user", "password") or die(mysql_error());
mysql_select_db("jmvarela_jacket") or die(mysql_error());

$query = 'SELECT * FROM `quote` ORDER BY `id` DESC LIMIT 1'; 

$row = mysql_fetch_array( $query );
echo $row['frase'];
?>

I cant get this to work.

I get this error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/jmvarela/public_html/ihateyourjacket.com/latest/index.php on line 7

I am trying to select the latest entry to the mysql database.

The table is called "quote"

There are three fields: id, frase and name.

Just to clarify (because this could be VERY bad coding) I am trying to get the "biggest" id and to display it´s correspondant "frase".

Thanks!!

Answer 1

Looks like you are not running the query.

// construct the query.
$query = 'SELECT * FROM `quote` ORDER BY `id` DESC LIMIT 1'; 

// run the query..THIS IS MISSING.
$result = mysql_query($query);

Also it's better to change SELECT * to SELECT frase, since you're interested only in the frase column. This will not bring all the unwanted columns from MySql to PHP, making your program perform better.

Answer 2

you have not perform your query

$result = mysql_query($query);

$row = mysql_fetch_array( $result );

try this

Answer 3

I´m not sure if this should be done but ill leave the complete running code for future refence.

<?php
mysql_connect("localhost", "user", "password") or die(mysql_error());
mysql_select_db("jmvarela_jacket") or die(mysql_error());

// construct the query.
$query = 'SELECT * FROM `quote` ORDER BY `id` DESC LIMIT 1'; 

$result = mysql_query($query);

$row = mysql_fetch_array( $result );
echo $row['frase'];
?>

Thanks to everyone!