Okay, I decided to try the COUNT method since all I really wanted to get in
the first place was how many rows would be returned for a specific query.
So, I have the below:
<?php
if (!$connect_id = ifx_connect("$database@$host", $user, $pass)) { // THE
ACTUAL CONNECTION
echo "Unable to connect to Informix Database\n"; // DISPLAY IF
CONNECTION FAILS
exit();
}
$query = "SELECT COUNT(*) FROM brev_pending_summary_detail";
$count_query = ifx_query ($query, $connect_id);
$rowcount = ifx_fetch_row($count_query);
$rows = $rowcount[0];
echo $rows;
?>
I'm not getting any errors, but no number/data displays for $rows when it
should be telling me there is over 100,000 records.
Any ideas why it isn't returning a number value for $rowcount[0]/$rows?
On 6/10/08, Daniel Brown <parasane@xxxxxxxxx> wrote:
>
> On Tue, Jun 10, 2008 at 12:42 PM, Jim Lucas <lists@xxxxxxxxx> wrote:
> > Jim Lucas wrote:
> >
> > I should slow down also and make sure all is well with my messages before
> > sending.
> >
> > $query = 'SELECT COUNT(*) FROM brev_pending_summary_detail '; // BASIC
> QUERY
>
> Yeah.... that and quit stealing the code I submitted earlier. ;-P
>
> --
> </Daniel P. Brown>
> Dedicated Servers - Intel 2.4GHz w/2TB bandwidth/mo. starting at just
> $59.99/mo. with no contract!
> Dedicated servers, VPS, and hosting from $2.50/mo.
>
