This is weird. Can you send over the complete file?
Advertising
On Wed, Sep 3, 2008 at 8:56 PM, David DURIEUX <[EMAIL PROTECTED]> 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 : [EMAIL PROTECTED] > 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" <[EMAIL PROTECTED]> 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 >><[EMAIL PROTECTED]> 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 : [EMAIL PROTECTED] >>> 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" <[EMAIL PROTECTED]> 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 >>>><[EMAIL PROTECTED]> 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 : [EMAIL PROTECTED] >>>>> 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" <[EMAIL PROTECTED]> a écrit: >>>>> >>>>>>On Wed, Sep 3, 2008 at 7:58 PM, Evert Lammerts >>>>>><[EMAIL PROTECTED]> wrote: >>>>>>> On Wed, Sep 3, 2008 at 7:41 PM, Dee Ayy <[EMAIL PROTECTED]> >>>>>>> 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 >>> >>> > >
