note 65278 added to function.date

From: 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

« previous php.notes (#109926) next »