Bonjour, I have make this to have a button, it's an error, it's the first time I have a problem with this. I'm sorry to have get your time. 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:56:56 +0200 "Evert Lammerts" <evert.lammerts@xxxxxxxxx> a écrit: >an anchor around a submit button...........?? I'm amazed that >works!! :-) > >A real link doesn't make a difference? > ><a href="index.php?deleteid=139">DELETE</a> > >[Make sure to replace 139 with an existing id...] > >On Wed, Sep 3, 2008 at 9:50 PM, David DURIEUX ><d.durieux@xxxxxxxxxxxxx> wrote: >> 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 >> >> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php