Re: Probleme with MySQL queries

Can you turn on mysql query logging and see what is actually happening? Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com David DURIEUX 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 : 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@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 >>> >>> >>> > > >