Re: Re: Help: Database Search

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 */