some weird problem

mistercash60000

well this is my weird problem,

I have executed this query in phpmyadmin to test my query and see if it works
query:

SELECT month(Dateadd)as Month,year(dateadd)as Year, count(*) as NumberFROM tblmovies where OwnerID=1 group by month(Dateadd),year(Dateadd) order by year(Dateadd),month(Dateadd);

This works I get this result:
Month Year Number

2 2003 6
3 2003 140
4 2003 65
5 2003 34
6 2003 27
7 2003 3
8 2003 18
9 2003 25
10 2003 40
11 2003 7
12 2003 14

well when I do this in php trough a webpage and use the same query
I don't get the second line of my result don't get 3 2003 140
Does anybody know why there is a difference in it?

Is that because some variabel isn't big enough or something

my result in webpage is:
2 2003 6 the second line is missing:3 2003 140
4 2003 65
5 2003 34
6 2003 27
7 2003 3
8 2003 18
9 2003 25
10 2003 40
11 2003 7
12 2003 14

Any help would be appreciated

pete_bisby

If you're sure that the SQL query is working correctly, then the problem must be with your PHP code.

Post a copy of what you have.

mistercash60000

I have found the problem,

I had also an second query on my php page, there I counted the max that was shown this way I could figure out how width my graph needed to be drawn.

Now It works now I have to found another way to determine the max.

Didn't knew that you aren't allowed to run 2queries on one page with functions

pete_bisby

You should be able to run quite a few queries at the same time - I've had 4 queries running, usually as loops.

As long as the variables relating to the groups of records are not the same, you should be fine. For example:

$qry = "SELECT MAX(), MIN() ..... ";
$res = mysql_query($qry, $db);
for ($i=0; $i < mysql_num_rows($res); $i++) {
  $row = mysql_fetch_array($res);
  $qryA = "SELECT MAX(), MIN() ...... ";
  $resA = mysql_query($qryA, $db);
  for ($j=0; $j < mysql_num_rows($resA); $j++) {
    $rowA = mysql_fetch_array($resA);
    $qryB = "SELECT MAX, MIN() ..... ";
    $resB = mysql_query($qryB, $db);
    for ($k=0; $k < mysql_num_rows($resB); $k++) {
      $rowB = mysql_fetch_array($resB);
      ....
      ....
    }
  }
}

Assuming that the queries for $qryA, $qryB and $qryC are correct, they can be kept separate because the variable names are different, and are quite happy for all of the queries to run at the same time.