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>>
