[PHP-DB] RE: [PHP] Re: Trying to delete

[César Aracena]

Thanks. I must apology as I made a mistake when writing the incoming
variable's name. I had it wrong so it would pass the variable but the
incoming script was looking for a variable that wasn't passed. In the
meantime, and now that I correct that, I'm still comparing artid to
'$artid' (with single quotes) and it does it well... it is an int(4)
field and now that you mention it... how is it possible?

C.

 -Original Message-
 From: David Robley [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, August 14, 2002 12:47 AM
 To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
 Subject: [PHP] Re: Trying to delete
 
 In article 01c2433c$e2e3e4c0$e5c405c8@gateway,
[EMAIL PROTECTED]
 says...
  Hi all.
 
  I have a small problem here. I have this full-PHP site working with
a
  MySQL db and came to a dead road when trying to delete a record from
it
  from the Administrator's page. I have PHP to make this decision
after
  the Administrator selected the record to delete and answered YES to
the
  =BFAre you sure...? The last part will pass a hidden value of
$editpic
  which tells the deleting script which artid to delete from the db.
This
  is the code that does the deletion:
 
  else if ($deleteyes)
  {
  $query =3D DELETE FROM saav_arts WHERE artid =3D '$editpic'
LIMIT
  1;
  $result =3D mysql_query($query) or die (mysql_error());
 
  if (!$result)
  {
  echo The Picture could NOT be deletedbr;
  echo form action=3D\.$PHP_SELF.\
method=3D\post\;
  echo input type=3D\submit\ name=3D\cancel\
  value=3D\Back to Edition\;
  echo /form;
  }
  else if ($result)
  {
  echo The Picture was deleted sucsesfullybr;
  echo form action=3D\.$PHP_SELF.\
method=3D\post\;
  echo input type=3D\submit\ name=3D\cancel\
  value=3D\Back to Edition\;
  echo /form;
  }
  }
 
  Cesar Aracena
  CE / MCSE+I
 
 You have made some wrong assumptions in your code here; it is quite
 possible that $result may be true but no entries have been deleted.
You
 perhaps should look at the possibility of testing mysql_affected_rows
to
 determine whether any rows have been updated/deleted.
 
 WHERE artid = '$editpic'
 
 implies that you expect artd to be a text field of type char or
 varchar because you have enclosed the value that you are testing in
single
 quotes; if artid is in fact an integer type, this query will not
affect
 any rows, as the text value will never match an integer field value.
 
 --
 David Robley
 Temporary Kiwi!
 
 Quod subigo farinam
 
 --
 PHP General 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-DB] RE: [PHP] Re: Trying to delete

[Brad Bulger]

On Wed, 14 Aug 2002, [iso-8859-1] César Aracena wrote:

 Thanks. I must apology as I made a mistake when writing the incoming
 variable's name. I had it wrong so it would pass the variable but the
 incoming script was looking for a variable that wasn't passed. In the
 meantime, and now that I correct that, I'm still comparing artid to
 '$artid' (with single quotes) and it does it well... it is an int(4)
 field and now that you mention it... how is it possible?

MySQL lets you compare numbers and strings pretty liberally:

mysql create table foo (x int, y double);
Query OK, 0 rows affected (0.02 sec)

mysql insert into foo values (1, 3.1415);
Query OK, 1 row affected (0.09 sec)

mysql select * from foo where x = '1';
+--++
| x| y  |
+--++
|1 | 3.1415 |
+--++
1 row in set (0.01 sec)

mysql select * from foo where y like '3.14%';
+--++
| x| y  |
+--++
|1 | 3.1415 |
+--++
1 row in set (0.00 sec)



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php