On Saturday 13 November 2004 21:31, Stuart Felenstein wrote:
> It was not apparent whatsoever. Let me show the code
> again , but I'll include the print_r returns inline
> code.
>
> <?php
> $where = array();
> $Ind[] = "";
Not sure why you're adding an empty element to $Ind?
> print_r($Ind);
> //Array ( [0] => 1 [1] => 2 [2] => 3 [3] => 4 [4] => 5
> [5] => 6 [6] => 7 [7] => 8 [8] => 9 [9] => 10 [10] =>
> 11 [11] => 12 [12] => 13 [13] => 14 [14] => 15 [15] =>
> 16 [16] => 17 [17] => 18 [18] => 19 [19] => 20 [20] =>
> 21 [21] => 22 [22] => 23 [23] => 24 [24] => 25 [25] =>
> 26 [26] => 27 [27] => 28 [28] => 35 [29] => [30] =>
> Array ( [0] => 1 [1] => 2 [2] => 3 [3] => 4 [4] => 5
> [5] => 6 [6] => 7 [7] => 8 [8] => 9 [9] => 10 [10] =>
> 11 [11] => 12 [12] => 13 [13] => 14 [14] => 15 [15] =>
> 16 [16] => 17 [17] => 18 [18] => 19 [19] => 20 [20] =>
> 21 [21] => 22 [22] => 23 [23] => 24 [24] => 25 [25] =>
> 26 [26] => 27 [27] => 28 [28] => 35 ) )
> So maybe this is weird, since it seems to print out
> twice ?
Look at it carefully, you've got a multi-dimensional array. Element [30]
contains an array (see below). Here's a tip, when using print_r(), wrap a
<pre> tag around it:
echo "<pre>"; // you may want to consider creating a
print_r($var); // function for this
echo "</pre>";
That way you can see clearly the structure of any array that you print.
> IN(1','2','3',
See that the 1 has a missing quote?
> ,'27','28','35','','Array) )
See the "Array" (also missing a single-quote), that's element [30] mentioned
above.
Summary: the missing single-quotes are the show-stopper.
When I said ...
> > was to copy and paste the
> > full query in your post so that we could see it in
... I meant post the full query that you are sending off the the DB, which in
this case is the contents of $sql:
> $result = mysql_query($sql) or die ("Query failed: "
--
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
------------------------------------------
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-general
------------------------------------------
/*
"I am ... a woman ... and ... technically a parasitic uterine growth"
-- Sean Doran the Younger [allegedly]
ll
*/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
