Re: [PHP-DB] Variable search help still needed - sorry :-(
Hi there,
I made some of the changes you said below, and when I check the query I get
this:
The query is SELECT distinct description, email, url, country, category,
type, rating from search6 WHERE description LIKE '%word%'AND category =
'Automotive' AND country = 'Austria' AND type = 'Car Rental' ORDER BY
description
so to me it doesn't appear to be putting the array item in there, or am I
wrong? I am confused, thanks for your help.
Regards
Chris
On Saturday 19 January 2002 13:11, Chris Payne wrote:
Hi there,
I know this is probably a REALLY simple problem, but I can't get this to
work. I need to get it to cycle through each word and do a search, I
used
this as sent from Beau Lebens (Thank you) but I can't get it to work.
It
works on 1 word querie but if I enter more than 1 it says can't execute
query, please help and tell me what i'm doing wrong :-)
Anytime you're putting a query to a db and you're not getting the results
expected you should echo the query to see what you're actually sending to
the
db. You could also copy and paste the query into the mysql-client to see
what
pops out.
$words = explode( , $test);
// create connection
$connection = mysql_connect(Localhost,!!!,!!!) or die(Couldn't
make
a connection.);
// select database
$db = mysql_select_db(tas, $connection)
or die(Couldn't select database.);
$sql = SELECT distinct description, email, url, country, category,
type,
rating from search6 WHERE ; foreach ($words as $word) {
$sql .= description LIKE '%word%';
You should probably be using:
$sql .= description LIKE '%word%' OR ; # note the spaces
}
After the foreach loop you need to remove the trailing OR . That is you
need to remove the last 3 characters from $sql.
$sql .= AND category = '$category' AND country = '$country' AND type =
'$type' ORDER BY description;
This would be a good place to:
echo(The query is $sqlbr);
$sql = mysql_query($sql,$connection)
or die(Couldn't execute query.);
hth
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
Why must you tell me all your secrets when it's hard enough to love
you knowing nothing?
-- Lloyd Cole and the Commotions
*/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Variable search help still needed - sorry :-(
On Sat, 19 Jan 2002, Chris Payne wrote: Hi there, I made some of the changes you said below, and when I check the query I get this: The query is SELECT distinct description, email, url, country, category, type, rating from search6 WHERE description LIKE '%word%'AND category = 'Automotive' AND country = 'Austria' AND type = 'Car Rental' ORDER BY description so to me it doesn't appear to be putting the array item in there, or am I wrong? I am confused, thanks for your help. You should probably be using: $sql .= description LIKE '%word%' OR ; # note the spaces Missed this error the first time round. It should be: $sql .= description LIKE '%$word%' OR ; # note the $!! hth -- Jason Wong -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Variable search help still needed - sorry :-(
Hi there,
I know this is probably a REALLY simple problem, but I can't get this to work. I need
to get it to cycle through each word and do a search, I used this as sent from Beau
Lebens (Thank you) but I can't get it to work. It works on 1 word querie but if I
enter more than 1 it says can't execute query, please help and tell me what i'm doing
wrong :-)
Thank you so much.
Regards
Chris
www.planetoxygene.com
-
$words = explode( , $test);
// create connection
$connection = mysql_connect(Localhost,!!!,!!!) or die(Couldn't make a
connection.);
// select database
$db = mysql_select_db(tas, $connection)
or die(Couldn't select database.);
$sql = SELECT distinct description, email, url, country, category, type, rating from
search6 WHERE ;
foreach ($words as $word) {
$sql .= description LIKE '%word%';
}
$sql .= AND category = '$category' AND country = '$country' AND type = '$type' ORDER
BY description;
$sql = mysql_query($sql,$connection)
or die(Couldn't execute query.);
Re: [PHP-DB] Variable search help still needed - sorry :-(
On Saturday 19 January 2002 13:11, Chris Payne wrote:
Hi there,
I know this is probably a REALLY simple problem, but I can't get this to
work. I need to get it to cycle through each word and do a search, I used
this as sent from Beau Lebens (Thank you) but I can't get it to work. It
works on 1 word querie but if I enter more than 1 it says can't execute
query, please help and tell me what i'm doing wrong :-)
Anytime you're putting a query to a db and you're not getting the results
expected you should echo the query to see what you're actually sending to the
db. You could also copy and paste the query into the mysql-client to see what
pops out.
$words = explode( , $test);
// create connection
$connection = mysql_connect(Localhost,!!!,!!!) or die(Couldn't make
a connection.);
// select database
$db = mysql_select_db(tas, $connection)
or die(Couldn't select database.);
$sql = SELECT distinct description, email, url, country, category, type,
rating from search6 WHERE ; foreach ($words as $word) {
$sql .= description LIKE '%word%';
You should probably be using:
$sql .= description LIKE '%word%' OR ; # note the spaces
}
After the foreach loop you need to remove the trailing OR . That is you
need to remove the last 3 characters from $sql.
$sql .= AND category = '$category' AND country = '$country' AND type =
'$type' ORDER BY description;
This would be a good place to:
echo(The query is $sqlbr);
$sql = mysql_query($sql,$connection)
or die(Couldn't execute query.);
hth
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
/*
Why must you tell me all your secrets when it's hard enough to love
you knowing nothing?
-- Lloyd Cole and the Commotions
*/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
