note 65278 added to function.date
| From: | php-general at lists dot php dot net | Date: | Fri, 28 Apr 2006 05:26:52 +0000 |
| Subject: | note 65278 added to function.date | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-109926@lists.php.net to get a copy of this message | ||
Hi All,
anyone have any ideas why this dosent work? It creates the follwing error.
You have an error in your SQL syntax near 'LIMIT 18446744073709551615' at line 1
Query 1 - Creates the above error.
$query_project_list = sprintf("SELECT *, date_format(p_startdate, '%d/%m/%y') as
p_startdate FROM projects, user, client WHERE p_status = '%s' AND client.cl_id =
projects.p_client AND user.u_id = p_user AND user.u_username = '$PHP_AUTH_USER' ORDER BY
client.cl_name", $colname__project_list);
$project_list = $eyeprojects->SelectLimit($query_project_list) or
die($eyeprojects->ErrorMsg());
query 2 - WORKS
$query_user_notes = "SELECT *, date_format(un_date, '%d/%m/%y - %T%p') as un_date
FROM user_note WHERE user_note.un_user = '$PHP_AUTH_USER' ";
$user_notes = $eyeprojects->SelectLimit($query_user_notes, $maxRows_user_notes,
$startRow_user_notes) or die($eyeprojects->ErrorMsg());
----
Server IP: 203.16.234.19
Probable Submitter: 220.245.178.131 (proxied: 203.219.151.26)
----
X-Spam-Status: No, hits=3.1 required=5.0 tests=DATE_MISSING,FROM_NO_LOWER
autolearn=no version=2.64
----
Manual Page -- http://www.php.net/manual/en/function.date.php
Edit -- http://master.php.net/note/edit/65278
Del: integrated -- http://master.php.net/note/delete/65278/integrated
Del: useless -- http://master.php.net/note/delete/65278/useless
Del: bad code -- http://master.php.net/note/delete/65278/bad+code
Del: spam -- http://master.php.net/note/delete/65278/spam
Del: non-english -- http://master.php.net/note/delete/65278/non-english
Del: in docs -- http://master.php.net/note/delete/65278/in+docs
Del: other reasons-- http://master.php.net/note/delete/65278
Reject -- http://master.php.net/note/reject/65278
Search -- http://master.php.net/manage/user-notes.php