PHP & My SQL
| From: | Dewa | Date: | Wed, 06 Sep 2000 00:55:54 +0000 |
| Subject: | PHP & My SQL | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-15409@lists.php.net to get a copy of this message | ||
Hi ... i have some problem ... maybe any of you could help me with this one.
I've made a script that look like this :
<?php
$link=mysql_connect ("xxxx","xxxx","xxxxx")
or die ("Can't Connect to MySQL Server");
mysql_select_db ("xxxx")
or die ("Can't Connect to Database");
$load="LOAD DATA INFILE xxxxx.txt' INTO TABLE logbook
FIELDS TERMINATED BY '\ '";
$dele="DELETE FROM logbook WHERE status='Alert' AND number < 50";
what i wanna ask is
the $dele= .... is working fine when deleting the record with status='Alert' .. but it
doesn't deleting number < 50 .
what is the correct command for it. cause when i do that directly from MySQL command, it worked.