Jump to content

php/mysql query not showing all rows


cjackson111

Recommended Posts

Hello. I am pulling data, joining two MySQL tables (using php). When I use the following part in my select statement all rows are returned (which I want) even if it does not have a value for 'r_star'

 

 

SELECT..... challnge.r_star ..... FROM....

 

 

But when I use the following, only rows are returned that have values for 'r_star'

 

 

SELECT..... AVG(challnge.r_star) ..... FROM....

 

 

 

I want to find the average for the field r_star. Any ideas what I may be doing worng?

 

Thanks!

 

 

Link to comment
https://forums.phpfreaks.com/topic/277675-phpmysql-query-not-showing-all-rows/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.