D
D.Deveaux
Guest
Hi,
It seems that there's a problem in constructing search strings :
Testing search on table publis
case 1 fields : id,rpublia,rpublib -->pb
Error during query execution.
select * from publis where id = '1' rpublia = '1'
MySQL server said: Something is wrong in your syntax près de 'rpublia = '1'' à la ligne 1
case 2 fields : id,rpublia --> ok
Your SQL query (for debugging purpose): select * from publis where rpublia = '0' limit 0 , 60
Aucun enregistrement trouvé.
case 3 fields : id, rpublia -> ok
Your SQL query (for debugging purpose): select * from publis where rpublia = '1' limit 0 , 60
157 Enregistrements trouvés
case 4 fields : id,rpublia-->pb
Error during query execution.
select * from publis where id = '1' rpublia = '1'
MySQL server said: Something is wrong in your syntax près de 'rpublia = '1'' à la ligne 1
Please, how correct is the problem ?
Thank's
Danièle Deveaux
It seems that there's a problem in constructing search strings :
Testing search on table publis
case 1 fields : id,rpublia,rpublib -->pb
Error during query execution.
select * from publis where id = '1' rpublia = '1'
MySQL server said: Something is wrong in your syntax près de 'rpublia = '1'' à la ligne 1
case 2 fields : id,rpublia --> ok
Your SQL query (for debugging purpose): select * from publis where rpublia = '0' limit 0 , 60
Aucun enregistrement trouvé.
case 3 fields : id, rpublia -> ok
Your SQL query (for debugging purpose): select * from publis where rpublia = '1' limit 0 , 60
157 Enregistrements trouvés
case 4 fields : id,rpublia-->pb
Error during query execution.
select * from publis where id = '1' rpublia = '1'
MySQL server said: Something is wrong in your syntax près de 'rpublia = '1'' à la ligne 1
Please, how correct is the problem ?
Thank's
Danièle Deveaux