Bonjour, The problem come from the <a href=""> in the input submit With <a href="">text</a> It works It is very Space 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:50:42 +0200 David DURIEUX <d.durieux@xxxxxxxxxxxxx> a écrit: >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
