Re: Probleme with MySQL queries

Bonjour, It was difficult, I have many files in includes, I will try to execute this code before in the php execution to see what code give problem. I try this now and I tell you the results of investigations Cordialement, David DURIEUX Tel : 04.74.04.81.34 Port : 06.34.99.45.18 Mail : d.durieux@siprossii.com Site Web : http://www.siprossii.com/ SIPROSSII 847 route de Frans (Créacité) 69400 Villefranche sur Saône Le Wed, 3 Sep 2008 21:01:14 +0200 "Evert Lammerts" <evert.lammerts@gmail.com> a écrit: >This is weird. Can you send over the complete file? > >On Wed, Sep 3, 2008 at 8:56 PM, David DURIEUX ><d.durieux@siprossii.com> wrote: >> Bonjour, >> >> Yes DELETE is executed and I have on my page : >> string(3) "140" >> int(0) >> >> Cordialement, >> >> David DURIEUX >> Tel : 04.74.04.81.34 >> Port : 06.34.99.45.18 >> Mail : d.durieux@siprossii.com >> Site Web : http://www.siprossii.com/ >> >> SIPROSSII >> 847 route de Frans (Créacité) >> 69400 Villefranche sur Saône >> >> >> >> Le Wed, 3 Sep 2008 20:51:49 +0200 >> "Evert Lammerts" <evert.lammerts@gmail.com> a écrit: >> >>>But the DELETE is executed? If it is, and it's in the condition, like >>>in the above code: >>> >>>if ($row = mysql_fetch_assoc($query)) { >>> .... DELETE ... >>>} >>> >>>something apparently is fetched.... >>> >>>On Wed, Sep 3, 2008 at 8:49 PM, David DURIEUX >>><d.durieux@siprossii.com> wrote: >>>> Bonjour, >>>> >>>> Yes I'm using this query.... and no row select >>>> >>>> Cordialement, >>>> >>>> David DURIEUX >>>> Tel : 04.74.04.81.34 >>>> Port : 06.34.99.45.18 >>>> Mail : d.durieux@siprossii.com >>>> Site Web : http://www.siprossii.com/ >>>> >>>> SIPROSSII >>>> 847 route de Frans (Créacité) >>>> 69400 Villefranche sur Saône >>>> >>>> >>>> >>>> Le Wed, 3 Sep 2008 20:43:25 +0200 >>>> "Evert Lammerts" <evert.lammerts@gmail.com> a écrit: >>>> >>>>>Are you still using the code we talked about? >>>>> >>>>>if ($row = mysql_fetch_assoc($query)) { >>>>> var_dump ($row); >>>>> mysql_query("DELETE FROM table WHERE >>>>> id={$row['id']}") >>>>> or >>>>>die("delete error: " . mysql_error()); >>>>>} >>>>> >>>>>if so, apparently it does fetch a row. Otherwise, can you send the >>>>>code you're using? >>>>> >>>>>On Wed, Sep 3, 2008 at 8:35 PM, David DURIEUX >>>>><d.durieux@siprossii.com> wrote: >>>>>> Bonjour, >>>>>> >>>>>> I have always the problem, select = 0 rows and it delete it like >>>>>> if delete is before the select :/ >>>>>> >>>>>> Cordialement, >>>>>> >>>>>> David DURIEUX >>>>>> Tel : 04.74.04.81.34 >>>>>> Port : 06.34.99.45.18 >>>>>> Mail : d.durieux@siprossii.com >>>>>> Site Web : http://www.siprossii.com/ >>>>>> >>>>>> SIPROSSII >>>>>> 847 route de Frans (Créacité) >>>>>> 69400 Villefranche sur Saône >>>>>> >>>>>> >>>>>> >>>>>> Le Wed, 3 Sep 2008 20:05:22 +0200 >>>>>> "Evert Lammerts" <evert.lammerts@gmail.com> a écrit: >>>>>> >>>>>>>On Wed, Sep 3, 2008 at 7:58 PM, Evert Lammerts >>>>>>><evert.lammerts@gmail.com> wrote: >>>>>>>> On Wed, Sep 3, 2008 at 7:41 PM, Dee Ayy <dee.ayy@gmail.com> >>>>>>>> wrote: >>>>>>>>> When using mysql_query, the SQL string to be executed should >>>>>>>>> not end in a semicolon. >>>>>>>> >>>>>>>> Ending a query with a semicolon should not be a problem - the >>>>>>>> string is parsed by the mysql server, which handles it fine. >>>>>>> >>>>>>>The manual does mention it, I'm a little too quick with my >>>>>>>replies. I personally never had a problem with it though. Plus, >>>>>>>it seemed to work some mails ago. >>>>>>> >>>>>>>David, did I understand well that your problem is solved? >>>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> PHP Database Mailing List (http://www.php.net/) >>>>>> To unsubscribe, visit: >>>>>> http://www.php.net/unsub.php >>>>>> >>>>>> >>>> >>>> >>>> -- >>>> PHP Database Mailing List (http://www.php.net/) >>>> To unsubscribe, visit: http://www.php.net/unsub.php >>>> >>>> >> >>