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

Reply via email to