This is weird. Can you send over the complete file? On Wed, Sep 3, 2008 at 8:56 PM, David DURIEUX <d.durieux@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxx> 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@xxxxxxxxx> 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@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxx>>> 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@xxxxxxxxx> 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@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxx>>>>> 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@xxxxxxxxx> a écrit:>>>>>>>>>>>On Wed, Sep 3, 2008 at 7:58 PM, Evert Lammerts>>>>>><evert.lammerts@xxxxxxxxx> wrote:>>>>>>> On Wed, Sep 3, 2008 at 7:41 PM, Dee Ayy <dee.ayy@xxxxxxxxx>>>>>>>> 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>>>>>>>>
