RE: moving though an array..SOLVED

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi All,

Solved my problem!

Here's the code in case anyone really cares :P

	$col = explode(",",$threadsColumn);

	$col_search = "(";
       		for ($i=0;$i<count($col);$i++) {			
               		$col_search .= $col[$i]." LIKE
'%$threadsName%'";
               			if ($i != (count($col) - 1)) {
                    			$col_search .= " OR ";
               			 }
		}

	$col_search .= ")";

Thanks again Adam for your spelling error notice!

Aaron

-----Original Message-----
From: Adam Voigt [mailto:adam@cryptocomm.com] 
Sent: June 26, 2003 10:26 AM
To: Aaron Wolski
Cc: php-db@lists.php.net
Subject: Re:  moving though an array..

One Thing:

Change $columns[] to $colums, example:

$columns = explode(',',$threadsColumn);


On Thu, 2003-06-26 at 10:23, Aaron Wolski wrote:
> Hi All,
>  
> Hopefully someone here can point me in the right direction.
>  
> I need to create a SELECT statement based on some criteria select and
> entered into a form.
>  
> Form variables:
>  
> $threadsColumn = "manufactuer,colour";
> $string = "n";
>  
> Code:
>  
>             $columns[] = explode(",",$threadsColumn);
>  
>             $test = "(";
>  
>             for ($i=0;$i<sizeof($columns);$i++) {
>  
>                         $test .= $columns[$i]." %$string%";
>  
>             }
>  
>             $test .= ")";
>  
>             echo $test;
>  
> What I am attempting to do is create a select statement that would
look
> like (based on "form variables"):
>  
> SELECT * FROM tablename WHERE (manufacturer LIKE %n% OR colour LIKE
%n%)
>  
> The information between ( and ) needs to be written in such a manner
> that it scales up or down in options.. depending on what was selected
in
> the form.
>  
> ANYONE have some thoughts?
>  
> Oh.. when I echo the above code I get this: (Array %h%)
>  
> Thanks!
>  
> Aaron 
>  
-- 
Adam Voigt (adam@cryptocomm.com)
Linux/Unix Network Administrator
The Cryptocomm Group


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux