Scott:
On Tue, Jul 02, 2002 at 10:05:31AM -0400, Scott Fletcher wrote:
> I tried this script and it showed all of the data correctly, so how do I
> make the define variable to work correctly?
>
> > define(CUSTOMER_ID,0);
> > define(CUSTOMER_NAME,1);
> > define(STATE,6);
> >
> > // blah blah blah
> >
> > if (odbc_fetch_row($result))
> > {
> > odbc_fetch_into($result,$user_detail,1);
> > {
> > echo $user_detail[STATE];
> > }
> > }
Why not make life simpler via odbc_fetch_array()? The names of the fields
become the names of the array's keys. Drop the defines() and
odbc_fetch_row() and just do this:
while ( $user_detail = odbc_fetch_array($result) ) {
echo $user_detail['State'];
}
--Dan
--
PHP classes that make web design easier
SQL Solution | Layout Solution | Form Solution
sqlsolution.info | layoutsolution.info | formsolution.info
T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y
4015 7 Av #4AJ, Brooklyn NY v: 718-854-0335 f: 718-854-0409
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
