diff options
Diffstat (limited to 'doc/sql_conventions.bb')
| -rw-r--r-- | doc/sql_conventions.bb | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/doc/sql_conventions.bb b/doc/sql_conventions.bb index 2deb3cff6..f6a4e251f 100644 --- a/doc/sql_conventions.bb +++ b/doc/sql_conventions.bb @@ -56,7 +56,11 @@ $r = q("SELECT * FROM mail WHERE uid=%d AND $sql_extra ORDER BY created DESC LIM [b]NULL dates[/b] [li]To be written -[code]Example[/code][/li] +[code]// Example +$r = q("DELETE FROM mail WHERE expires != '%s' AND expires < %s ", + dbesc(NULL_DATE), + db_utcnow() +);[/code][/li] [b]Storing binary data[/b] [li]To be written |