First off, if you're new to PHP/MySQL programming, don't apply, please. This job pays $10-$15, depending on quality of work. It should be a VERY simple job, as my existing coding only needs to be modified to use left/join functions between two tables.
id bigint(20) NOT NULL auto_increment,
cat varchar(255) NOT NULL default '',
info varchar(255) NOT NULL default '',
"info" contains the following data (there's actually more, but this is just an example):
pick varchar(255) NOT NULL default '',
Data inserted to this table would be (but not limited to):
My current MySQL query displays this information in a_survcats, ordered alphabetically. I need the results to display by the # of picks with the highest count, followed by the next highest # of picks, alphabetically if two items have the same number of picks...
So it'd be as follows:
Google Search - 5 picks
AOL Search - 3 picks
Yahoo Search - 3 picks
MSN Search - 1 pick.
The current query I'm using is as follows:
$result=mysql_query("SELECT id,cat,info FROM a_survcats $WHERE ORDER BY cat,info");
$tp=mysql_fetch_row(mysql_query("select count(id) from a_survpicks WHERE
$start and $fin are already defined as timestamps (for search capabilities).
I know this can be done via the join functionality, I just don't know how to do this. For someone that's savvy with PHP/MySQL, this should only take about 5-10 minutes to do. First person to post a solution will be paid $10-$15 via PayPal.
Need this fairly quick, and it WILL be tested to ensure that it works before payment.
Thanks for any help that you can provide.
Douglas Hazard - Certifiable Sports Junkie and Sports Community Enthusiast
Host of Two Cents Radio - Follow @TwoCentsRadio on Twitter (@BearlyDoug on Twitter)