Re: [PHP-DB] PHP query to mysql database returns emtpy data, butQuery Browser shows records

2005-01-06 Thread Bastien Koert 
Perhaps an IN query clause it what he needs...
$query example = SELECT description from cpProducts where
category IN (39, 47, 48, 172)
bastien
From: Jochem Maas [EMAIL PROTECTED]
To: graeme [EMAIL PROTECTED]
CC: Jason Walker [EMAIL PROTECTED], php-db@lists.php.net
Subject: Re: [PHP-DB] PHP query to mysql database returns emtpy data, 
butQuery Browser shows records
Date: Thu, 06 Jan 2005 14:24:29 +0100

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 he is trying to do - I doubt he wants to put 'OR's in 
the character string, besides which AFAIK you can't do something like:

SELECT description from cpProducts where category=39 OR 47 OR 48 OR 172;
(possibly the SQL above will actually return all rows because any number 
greater than zero will evaluate to true - e.g. ($x = true || 1) is always 
true regardless of the value of $x, I am assuming the same general logic 
goes for SQL or'ing)
it should be:

SELECT description from cpProducts where category=39 OR 47 OR 48 OR 172;
Jason, read on for more (possible) help (well I gave it a shot but I don't 
think it will be any help, sorry):


Jason Walker wrote:

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 .   . $hotid . ';
  echo bR . $query . br;
 echo combined package number =  . $comIB . br;
   $retval = ;
  $link = 
mysql_connect($config['host'],$config['user'],$config['pass']) or 
die(Could not connect);
  mysql_select_db('stc_store') or die(Unable to connect to 
the default database);
  $result = mysql_query($query) or die(Unable to pull 
the menu objects for main event details);
  echo mysql_affected_rows() . br;
while ($results = mysql_fetch_array($result, 
MYSQL_ASSOC)){
 extract($results);
   echo $description;
   $retval = $description;
  }
   mysql_free_result($result);
 mysql_close($link);
  return $retval;
  }

I have some extra 'echo' statements to see the progress on the web page. 
If I remove the 'where' clause within the SQL statement, I get rows. But 
when I add the 'where' portion, no records are returned.

Here is an example of what the query looks like:
$query example = SELECT description from cpProducts where category='39 47 
48 172'
I'll assume that your table has a field named 'category' - otherwise the 
statement should throw you a big error :-) BUT is it a character data field 
(i.e. does it contain text)? AND do you actually have rows where the value 
of the category field is '39 47 48 172' - in order to get rows returned 
when running your example query the value needs to match this string 
EXACTLY.

Given the fact that using mysql control center give you the desired result 
the above probably was a waste of time typing. Given that fact the only 
thing I can think of is that you have a extra space floating about (but I 
can't see it in the code your provided)

does the output of mysql_error() provide any feedback?
(what an odd problem!)

When I run the same query in MYSQL Control center or Query Browser, no 
problem. I use this function template for my SELECT statements.

Please let me know if there is something missing from the code.
Thanks.


Jason Walker
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
http://www.desktophero.com


No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.298 / Virus Database: 265.6.8 - Release Date: 1/3/2005


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

Re: [PHP-DB] PHP query to mysql database returns emtpy data, butQuery Browser shows records

2005-01-06 Thread jwalker 


No the category field is varchar(250) and uses spaces to parse each element 
within the field. 

The database is an osCommerce hybrid - not my own. The values within the 
category field go from one number to an X set of numbers, separated by spaces. 
This is making development rather difficult and painful.

---Original Message---
 From: Bastien Koert [EMAIL PROTECTED]
 Subject: Re: [PHP-DB] PHP query to mysql database returns emtpy data, 
 butQuery Browser shows records
 Sent: 06 Jan 2005 14:14:02

  Perhaps an IN query clause it what he needs...
  
  $query example = SELECT description from cpProducts where
  category IN (39, 47, 48, 172)
  
  bastien
  
  From: Jochem Maas [EMAIL PROTECTED]
  To: graeme [EMAIL PROTECTED]
  CC: Jason Walker [EMAIL PROTECTED], php-db@lists.php.net
  Subject: Re: [PHP-DB] PHP query to mysql database returns emtpy data,
  butQuery Browser shows records
  Date: Thu, 06 Jan 2005 14:24:29 +0100
  
  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 he is trying to do - I doubt he wants to put 'OR's in
  the character string, besides which AFAIK you can't do something like:
  
  SELECT description from cpProducts where category=39 OR 47 OR 48 OR 172;
  
  (possibly the SQL above will actually return all rows because any number
  greater than zero will evaluate to true - e.g. ($x = true || 1) is always
  true regardless of the value of $x, I am assuming the same general logic
  goes for SQL or'ing)
  it should be:
  
  SELECT description from cpProducts where category=39 OR 47 OR 48 OR 172;
  
  Jason, read on for more (possible) help (well I gave it a shot but I don't
  think it will be any help, sorry):
  
  
  Jason Walker wrote:
  
  
  
  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 .   . $hotid . ';
 echo bR . $query . br;
echo combined package number =  . $comIB . br;
  $retval = ;
 $link =
  mysql_connect($config['host'],$config['user'],$config['pass']) or
  die(Could not connect);
 mysql_select_db('stc_store') or die(Unable to connect to
  the default database);
 $result = mysql_query($query) or die(Unable to pull
  the menu objects for main event details);
 echo mysql_affected_rows() . br;
   while ($results = mysql_fetch_array($result,
  MYSQL_ASSOC)){
extract($results);
  echo $description;
  $retval = $description;
 }
  mysql_free_result($result);
mysql_close($link);
 return $retval;
 }
  
  I have some extra 'echo' statements to see the progress on the web page.
  If I remove the 'where' clause within the SQL statement, I get rows. But
  when I add the 'where' portion, no records are returned.
  
  Here is an example of what the query looks like:
  
  $query example = SELECT description from cpProducts where category='39 47
  48 172'
  
  I'll assume that your table has a field named 'category' - otherwise the
  statement should throw you a big error :-) BUT is it a character data field
  (i.e. does it contain text)? AND do you actually have rows where the value
  of the category field is '39 47 48 172' - in order to get rows returned
  when running your example query the value needs to match this string
  EXACTLY.
  
  Given the fact that using mysql control center give you the desired result
  the above probably was a waste of time typing. Given that fact the only
  thing I can think of is that you have a extra space floating about (but I
  can't see it in the code your provided)
  
  does the output of mysql_error() provide any feedback?
  
  (what an odd problem!)
  
  
  
  When I run the same query in MYSQL Control center or Query Browser, no
  problem. I use this function template for my SELECT statements.
  
  Please let me know if there is something missing from the code.
  
  Thanks.
  
  
  
  
  
  Jason Walker
  
  [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
  
  http://www.desktophero.com
  
  
  
  
  
  No virus found in this outgoing message.
  Checked by AVG Anti-Virus.
  Version: 7.0.298 / Virus Database: 265.6.8 - Release Date: 1/3/2005
  
  
  
  
  
  --
  PHP Database Mailing List (http://www.php.net/)
  To unsubscribe, visit: http://www.php.net

Re: [PHP-DB] PHP query to mysql database returns emtpy data, butQuery Browser shows records

2005-01-06 Thread Jochem Maas 
jwalker wrote:
No the category field is varchar(250) and uses spaces to parse each element within the field. 

The database is an osCommerce hybrid - not my own. The values within the category field go from one number to an X set of numbers, separated by spaces. This is making development rather difficult and painful.
Jason,
I thought it was something like that - sounds nasty, you poor man!
anyway can you confirm that the value in your where clause (as given in 
your example query) actually exists in the DB.

also things to try maybe:
1. test the problem on another machine
2. update php to latest release of you version (probably php4)
3. cut and paste a known value from the category field out of the DB and 
perform the query again with this value pasted into the query literally 
(rather than building the value from the various vars) to confirm the 
problem.

good luck

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