[thelist] MySQL insert error.

[fstorr]

Ken Moore wrote:

> Hi all,
> 
> I am running on a remote server (Interland, inc.) using FreeBSD. I have a
> MySQL database created by root. The problem is an insert error from a PHP
> script.
> 
> This command works:   @ $db =
> MYSQL_PCONNECT('localhost','user_name','user_pass');
> 
> This one did work but now does not:
> $result = mysql_query("insert into client_interest values ('$email',
> '$arr[$i]', '$arr[$j]')");

++++++

Should it not be something like this?:

INSERT INTO 'client_interest' ('client_email','item','level') VALUES 
('$email','$arr[$i]','$arr[$j]');

Regards

Francis