Hello,
I change my code to catch error query. I have a table with 4 files
(Query,
Error_no, create_date, create_time).
When I have an error on a query, I call a page and I add a row in a
table
log_query.
The query (with error is like that) :
$query="
SELECT
auteur.NO AS AUTEUR_NOM,
auteur.PRENOM AS AUTEUR_PRENOM,
auteur.EMAIL AS AUTEUR_EMAIL,
auteur.EMAILVISIBLE AS AUTEUR_EMAILVISIBLE,
auteur.LANGUE_ID AS AUTEUR_LANGUE_ID
FROM auteur
WHERE
ID = '$Auteur_id'";
When I have an error, I put the query in a new row in the log_query
table
$query_error="
INSERT INTO log_error_sql (QUERY, QUERY_NO, CREATE_DT, CREATE_TIME)
VALUES ('$query', '3', '$NDate', '$NTime')
";
The problem when I execute this query, I have a trouble with the ''
around
$query when I look the query_error I see something linke that :
.....FROM auteur WHERE ID = '1'', '2', '2002-10-08', '14:06:31')
I have twice a single quote. What can I do in the query_error to solve
that
?
Bye
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
