Syntax question.

[Gibberish]

I am getting an error in my statement and I cannot figure out why.

Here is my select statement:

$today = date('Y-m-d');
$arrCompanies =  func_query(SELECT companies.company_name, company_dates.day FROM companies, company_dates WHERE companies.companyid IN (SELECT DISTINCT companyid FROM company_dates WHERE date >= $today)); 

Here is my error:

INVALID SQL: 1064 : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT DISTINCT companyid FROM company_dates WHERE date >
SQL QUERY FAILURE: SELECT DISTINCT company_name, xcart_company_dates.day FROM xcart_companies, xcart_company_dates WHERE xcart_companies.companyid IN (SELECT DISTINCT companyid FROM company_dates WHERE date >= 2005-06-12) 

Now if I query the IN part seperatly

$arrTemp = func_query(SELECT DISTINCT companyid FROM company_dates WHERE date >= $today)); 

It returns:

Array ( [0] => Array ( [companyid] => 1 ) [1] => Array ( [companyid] => 9 ) ) 

I am assuming I am writing the IN part wrong. What I want to happen is for the first query to select those fields WHERE the companyid of that row is IN the array or select statement in the ()'s.

So if I hard coded it would look like:

$today = date('Y-m-d');
$arrCompanies =  func_query(SELECT companies.company_name, company_dates.day FROM companies, company_dates WHERE companies.companyid IN (1,9)); 

Any ideas on how to get this result?

If I type out the select statment is would be something like:

SELECT company_name and date value FROM companies, company_date tables WHERE companyid value is in the result of (Select distinct companyid FROM company_dates WHERE date field is greater than or equal to today's date)

[r937]

source of error: use of a feature not supported by your version of mysql

solution: upgrade, or rewrite the query

my advice: write two queries in a row

[Gibberish]

The problem ended up being I forgot my select statement was producing a multi dimensional array.

Solution was to take the temp array and strip it to a single row array then check that against the companyid in the second array

$today = date('Y-m-d');
# select all companyid's with dats greater then today
$arrDates = func_query("SELECT DISTINCT companyid FROM company_dates WHERE date > $today ORDER by date");

# push id's into non multidimensional array
$arrCompID = array();
for($i=0; $i < count($arrDates); $i++){
    $ID = $arrDates[$i]["companyid"];
    array_push($arrCompID, $ID);
}
$imploded = implode(",", $arrCompID);

# select all company names and day names where companyID is in companyid array.
$arrCompanies =  func_query("SELECT DISTINCT company_name, day FROM companies, company_dates WHERE companies.companyid IN ($imploded) AND company_dates.companyid = companies.companyid LIMIT 5");