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 <[EMAIL PROTECTED]> 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 : [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:43:25 +0200
> "Evert Lammerts" <[EMAIL PROTECTED]> 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
>><[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
>>>
>>>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
