Re: Probleme with MySQL queries

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