Shoutbox

I am trying to find the url of the latest 'published' wordpress 'post':

code:

---

SELECT guid FROM wp_posts WHERE post_status='publish' AND post_type='post' ORDER BY post_date_gmt DESC LIMIT 1

---

It returns this error

quote:

---

Originally posted by mySQL

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/****/*******/******/************.php on line 666

---

Could mean empty result set?
I removed 'LIMIT 1' and it returned a list of post url's sorted just how I want.
I also tried:

code:

---

SELECT guid FROM wp_posts WHERE post_status='publish' AND post_type='post' ORDER BY post_date_gmt DESC LIMIT 0,1

---

No luck!
Rep
UPDATE: I just read john-t's thread and it seems we are having the same problem, something to do with LIMIT.

Query looks fine to me, I even ran it in PMA and had a result returned. The only way I can see this failing, is if you don't have any posts made yet on WP

Hmmmm, my database is full. However I am using WizMySQLAdmin (pma is kinda slow), so I will try PMA.

EDIT: Works in PMA, thanks MeEtc!