Re: Probleme with MySQL queries

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@siprossii.com> 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@siprossii.com > 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@siprossii.com> 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@siprossii.com >>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@gmail.com> 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@siprossii.com> 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@siprossii.com >>>> 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@gmail.com> 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@siprossii.com> 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@siprossii.com >>>>>> 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@gmail.com> 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@siprossii.com> 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@siprossii.com >>>>>>>> Site Web : ŸW5¯ >>>>>>>> óÙ™ÿ¢ÿ¦øThttp://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@gmail.com> a >>>>>>>> écrit: >>>>>>>> >>>>>>>>>On Wed, Sep 3, 2008 at 7:58 PM, Evert Lammerts >>>>>>>>><evert.lammerts@gmail.com> wrote: >>>>>>>>>> On Wed, Sep 3, 2008 at 7:41 PM, Dee Ayy >>>>>>>>>> <dee.ayy@gmail.com> >>>>>>>>>> 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: Ìà,'˜ÐîÎz*À >>>>>> î7¯http://www.php.net/unsub.php >>>>>> >>>>>> >>>> >>>> >> >> > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >