PHP/MySQL: Last Updated Date

5Sasha5 · 26th April 2003, 12:57 PM

Hi everyone,
I'm having a problem with a very simple script I'm trying to run.
I want to display the date one of the tables in my MySQL database was last updated.
This is the coding I'm using (obviously with my real username and password instead of the ****):

Code:

&lt;?
$database=&quot;eliza-d_com&quot;;
$user=&quot;******&quot;;
$pass=&quot;******&quot;;
mysql_connect(localhost,$user,$pass);
mysql_select_db($database) or die( &quot;Unable to select database&quot;);

$info = mysql_fetch_array(mysql_query(&quot;show table status from eliza-d_com like 'missy'&quot;));
echo $info[&quot;Update_time&quot;];
?&gt;

But no matter what I try, I get the following error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/virtual/site61/fst/var/www/html/datetest.php on line 21

I have tried several variations on this little script, and none work. I can connect to the database just fine, other queries I put in to test that, worked fine. If I leave off the fetch_array, the script executes fine too, with no errors. It just doesn’t display anything because I can’t seem to access the results of the query. You can see it in action here: http://eliza-d.com/datetest.php

I have googled this for like 3 days now, but to no avail. All resources I found that mention how to do this, use the code I’m using. Even the PHP and MySQL Manuals instruct to do it this way. I have no idea what I’m doing wrong.

Any help with this would be very much appreciated!

ec8or · 26th April 2003, 03:00 PM

I think the problem is with your database name containing a hyphen, try using backticks around it instead, like this:

SHOW TABLE STATUS FROM `eliza-d_com` LIKE 'missy'

Peace
Nisse

Euge · 26th April 2003, 03:03 PM

You can also report the error message by checking the query result:

Code:

$result = mysql_query(&quot;show table status from eliza-d_com like 'missy'&quot;);
if (!$result) {
    echo mysql_error();
    exit();
}
$info = mysql_fetch_array($result);
echo $info[&quot;Update_time&quot;];

5Sasha5 · 26th April 2003, 04:28 PM

[quote author=ec8or link=board=7;threadid=833;start=0#msg5242 date=1051369226]
I think the problem is with your database name containing a hyphen, try using backticks around it instead, like this:

SHOW TABLE STATUS FROM `eliza-d_com` LIKE 'missy'
[/quote]

That was it! I changed it and now it works like a charm. Thanks sooo much!!!!

UH-Matt · 26th April 2003, 04:33 PM