To view the terms under which this email is distributed, please go to
http://disclaimer.leedsmet.ac.uk/email.htm
On 07 January 2005 03:25, Jason Walker wrote:
Graeme - you were moving in the right direction. Since the
data in the field
is varchar(250), the only thing that changes is the
graeme wrote:
Hi,
You have:
$query example = SELECT description from cpProducts where category='39
47 48 172'
don't you want to add a logical operator such as OR, possibly AND
$query example = SELECT description from cpProducts where category='39
OR 47 OR 48 OR 172'
graeme.
whatever it is that
Sorry I was in a hurry for lunch.. I meant category='39 ' OR category
'47' etc... which of course the IN clause would address.
But if it is a character string '39 47 48 172' that is required then
double check the number of spaces that are required against those that
are produced. Maybe is is
: Thursday, January 06, 2005 7:55 PM
To: Jochem Maas
Cc: Jason Walker; php-db@lists.php.net
Subject: Re: [PHP-DB] PHP query to mysql database returns emtpy data, but
Query Browser shows records
Sorry I was in a hurry for lunch.. I meant category='39 ' OR category
'47' etc... which of course the IN clause
Here is the query:
function ReturnPackageDescriptions($pack, $cat,
$hotcat, $hotid){
$comIB =
$cat . . $pack . . $hotcat . .
$hotid;
$catLength =
strlen($comIB);
echo $catLength;
$query = SELECT
description from cpProducts where category=' . $cat . .
$pack . . $hotcat .
Hi,
You have:
$query example = SELECT description from cpProducts where category='39
47 48 172'
don't you want to add a logical operator such as OR, possibly AND
$query example = SELECT description from cpProducts where category='39
OR 47 OR 48 OR 172'
graeme.
Jason Walker wrote:
Here is