Skip to content

Instantly share code, notes, and snippets.

@mrchrisadams
Created January 11, 2011 13:56
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mrchrisadams/774432 to your computer and use it in GitHub Desktop.
Save mrchrisadams/774432 to your computer and use it in GitHub Desktop.
I can't work our why this simple sql query is returning false.
mysql> SELECT max( vid ) FROM `node_revisions` WHERE nid= 280;
+------------+
| max( nid ) |
+------------+
| 280 |
+------------+
1 row in set (0.00 sec)
<?php
$max_vid_value_for_nid = db_fetch_object(db_result("SELECT MAX(nid) FROM {node_revisions} WHERE nid= 280"));
// this should return an object
var_dump($max_vid_value_for_nid);
// this should return an integer, 280, but returns null
var_dump($max_vid_value_for_nid->MAX);
?>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment