Fetch array warning

[alfpalafox]

Hi,

I'm new to PHP web design, I'm using Mysql and PHP. I have a PHP script to DELETE records but before that I need to be sure that the record exists.

My script goes like this:

line 6 $var1 = " select * from table.field where id_record = '$record' ";
line 7 if( $var2=mysql_fetch_array $var1) )
line 8 {
line 9 deleting ...
line 10 }
line 11 else
line 12 {
line 13 record does not exit ...
line 14 "It is not a valid record"
line 15 }

So when I test it with a record I know it doesn't exist, the script gives me
the message ("It is not a valid record") and this message: Warning: Supplied argument is not a valid MySQL result resource in
c:\apache\htdocs\nuevo\icum\eliminar.php on line 7

Any help will be appreciated

Alfredo Palafox

[[deleted]]

Why do you want to make sure the record exists before you delete it? why don't you just delete it?

Anyway, the error you get means that whatever query you executed was not proper SQL. I suggest you print the query and see what it looks like.

[valmir]

change to:
line 6
$var1 = "select * from database.table where id_record = '$record'";
if( $var2 = mysql_fetch_array($var1) ){
// Remeber $var2 is an array
if( $var2['id_record'] == $record ){
... deleting...
}

Why don't you issue a delete statement and check out for affected rows ? if there's no record there's nothing to delete.

$query="delete from database.table where id_record = '$record'";
$res_id = mysql_query($query);
if( mysql_affected_rows() == 0 ){
echo "record not found!!!";
}
else{
echo "deleted " . mysql_affected_rows() . "record(s)";
}

Regards,

Valmir Filho

[alfpalafox]

Thanks.

I'll try it.