Re: PHPExcel

Shawn McKenzie wrote:

On 7/3/08, Dan Shirah <mrsquash2@gmail.com> wrote:

GOT IT!!! I changed my code to the following: $sql = "SELECT * FROM brev_pending_summary_detail WHERE name = '$name_code'"; if (!empty($case_age)) { $sql.=" AND case_age_group = '$case_age'"; } if (!empty($case_cat)) { $sql.=" AND case_category = '$case_cat'"; } if (!empty($case_status)) { $sql.=" AND case_status = '$case_status'"; } // Start our query of the database $query = ifx_query($sql, $connect_id);

Also, why are you fetching a row here? Then in your loop you will have missed the first one.

$row = ifx_fetch_row($query); $results = array();

It looks like he was following the example on the ifx_fetch_row() manual page. If you look at the arguments and examples, you will see that same type of concept. Problem is he didn't follow it in the for loop. Check my other email for the example that I submitted that he should try. -- Jim Lucas "Some men are born to greatness, some achieve greatness, and some have greatness thrust upon them." Twelfth Night, Act II, Scene V by William Shakespeare