Andy B <mailto:[EMAIL PROTECTED]>
on Tuesday, April 06, 2004 4:51 PM said:
> they both use the same identical format to insert the arrays. there
> is an interesting problem though: the first one complains about use
> of undefined constant add - assumed 'add' in the second query...the
> first one doesnt do that??
>
> everything is set up exactly the same for both queries except the
> relevant variable/array names...
two things i would recommend before disecting your code.
1. write readable queries.
GOOD:
$sql = "
SELECT
name
, age
, height
, etc
FROM user
WHERE
name = '$name'
AND height = '5'";
2. always put single quotes around array keys. $array['key']
hth,
chris.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php