Search results for query: *

I'm trying to lookup some totals by state in these 3 tables. We have a league table, which contains the state column, then we have a team table which has a reference back to league, then we have a member table which references back to the team table. I'm trying to figure out how to get totals on...

I'm trying to pull statistics from 2 tables. Here's what happens: An affiliate sends out emails to 10 (or so) people. One of those people sends out an email to 5 people. One of those 5 sends out a video to 2 people. I need to track the total resulted from the original 10 sent out, which should...

My query returns with this error: Unknown column 'u.user_id' in 'on clause' Here's the query: SELECT u.user_id AS id, a.affiliate_id AS a_id, u.phone, u.city, u.state, u.email, a.company, a.username, a.contact, a.address, a.zip, a.subscribed...

I'm trying to output a grid view of year/month data from a table using this query: SELECT COUNT(`id`) AS `total`, DATE_FORMAT(`report_date`,'%Y-%m') AS `group_date`, DATE_FORMAT(`report_date`,'%Y') AS `report_year`, DATE_FORMAT(`report_date`,'%m') AS `report_month`...

I've setup a query for Pagination, however now I'm seeing that some of these records have duplicate information. I want to only group these records by a few of the columns, but also want other information along with the records. I'm used to MySQL and the Limit 0,50 feature. So, my query (page 3...

I'm trying to setup a class that will allow a file to be included on the page. It goes something like: <?php class myClass { ... ... ... function includeFile(){ if(file_exists($this->include_file)){ include($this->include_file); } else {...