Bonjour, Humm if I go on page index.php?deleteid=139 it works If I click on the link <a href="index.php?deleteid=139"><input type="submit" value="Supprimer" style="width: 100px; " /></a> I have the SELECT problem I will be crazy 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 21:08:25 +0200 David DURIEUX <d.durieux@xxxxxxxxxxxxx> a écrit: >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@xxxxxxxxxxxxx >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@xxxxxxxxx> 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@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 >>>>> >>>>> >>> >>> > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
