note 65278 deleted from function.date by nlopess
| From: | nlopess@php.net | Date: | Fri, 28 Apr 2006 08:44:08 +0000 |
| Subject: | note 65278 deleted from function.date by nlopess | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-109942@lists.php.net to get a copy of this message | ||
Note Submitter:
----
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());