Query limiting results

[timmah1]

This code limits itself to 10 results.

 

I need to pull all of the temperatures from the database, the are listed like 96.5, 97.3, 98.9 and so on.

When I run the query, it only shows 10 results.

 

Can anybody tell me why it does this?

<?php
$month = date("m");

$query = "SELECT * FROM charts WHERE username = 'admin' AND MONTH(posted) = '$month' ORDER BY DAY(posted)";
				$chart = mysql_query($query);

				while($charts = mysql_fetch_assoc($chart)){
				$temps[$charts['temp']] =  $charts['temp'];
				} 
				$temp = implode(',', $temps);
				echo $temp."<br />";
?>

 

Thanks in advance

[Philip]

What data is in the database?

 

[revraz]

There is nothing there limiting to 10 results.

 

But should

 

$temps[$charts['temp']]

 

be

 

$temps[$charts][['temp'] ?

 

Not really sure what you are trying to do there.

[timmah1]

There are 23 items in the database, but it is only echoing out 10 results

 

posted = date field

temp = varchar field

and username

[timmah1]

Not sure what you mean by this revraz

$temps[$charts][['temp'] ?

[revraz]

What are you trying to do here?

 

$temps[$charts['temp']]

 

[timmah1]

I got it fixed, I have no idea what the hell I was doing

I took this

$temps[$charts['temp']] =  $charts['temp'];

 

and changed it to this

$temps[] =  $charts['temp'];

 

and it works perfect

 

Thanks for opening my eyes revraz