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 <[EMAIL PROTECTED]> 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 : [EMAIL PROTECTED]
> 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" <[EMAIL PROTECTED]> a écrit:
>
>>On Wed, Sep 3, 2008 at 7:58 PM, Evert Lammerts
>><[EMAIL PROTECTED]> wrote:
>>> On Wed, Sep 3, 2008 at 7:41 PM, Dee Ayy <[EMAIL PROTECTED]> 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
>
>

Reply via email to