[Resolved] simple query question

NoBullMan

Hi,
I have a query in my php file that when run outside of PHP works fine and returns the result (MySQL) but from within the php file it does not produce any result.

  

$query = "SELECT SUM(Qty) AS opt_count FROM OrderDetails INNER JOIN Orders 
ON Orders.TrackingNumber = OrderDetails.TrackingNumber
WHERE OrderDetails.OptionNumber = '$option_number' AND Orders.BuilderID = '$builderid'
GROUP BY OptionNumber";

The above works fine when I test it with PHPMyAdmin (after replacing the variable names with values, of course). It gives me a 1x1 table with the heading "opt_count" and a value of 11.
But:

  $res = mysql_query($query);
  $num_rows = mysql_num_rows($res);
//$n = mysql_result($res, 0, 'opt_count');
  $row = mysql_fetch_array($res);
  $n = $row['opt_count'];

results in:
n=
num_rows=0

Thanx.

tsinka

Hi,

how does the query look like when you print it:

  echo $query;
  $res = mysql_query($query); 
  $num_rows = mysql_num_rows($res); 
//$n = mysql_result($res, 0, 'opt_count'); 
  $row = mysql_fetch_array($res); 
  $n = $row['opt_count'];

If the values come from a form you might need to use e.g. $POST['variable'] instead of $variable (or $GET if the method of the form is set to GET).

Thomas

NoBullMan

Hi,
the values do come from a form and I use $_POST['xxxx'] to get the values. I used error_log() function to print out the values and they are posted correctly. I put the query in error_log(), with the variables substituted by correct values, copied the query and used phpMyAdmin to do a query and it works fine, no errors, and gives me the result I am looking for. But the same query, execusted from withing PHP file produces no result.

One thing though:
if $res = mysql_query($query) does not return anything, then
$num_rows = mysql_num_rows($res) would usually produce an error message, something like $res is not a valid SQL something. This does not happen so I am assuming the query is valid.

Thanks for your help.

tsinka

Ok,

so it must be something else ... please post the script attached to your post.

Thomas

NoBullMan

Sorry to have taken your time for a problem that was a result of a dumb mistake.
I tested my query on live DB, using phpMyAdmin and that's why I got the results. However, the php file I was using to test was using a test database that did not have all the data.

I apologize for this non-problem.