Thanks Ian,
This was a big help. Also makes me happy to be writing CF the majority of my
time, although PHP does have a couple of cool features.
Cheers,
Duane Boudreau
Director of Web Technologies
Ektron, Inc.
> -----Original Message-----
> From: Ian Potts [mailto:[EMAIL PROTECTED]]
> Sent: Monday, November 27, 2000 10:06 PM
> To: CF-Community
> Subject: Re: PHP Coders
>
>
> I'm pretty new to PHP, however I started w/access (odbc) until I got mySQL
> up an running. Here is how I grab/deal with the results:
>
> 1. Connect to your odbc datasource.
> 2. Run the SQL.
> 3. Loop Through The Results.
>
> Sample Code:
>
> # $db is an pointer (reference), leave user/pw null if your DB
> doesn't have
> them.
> $db = odbc_connect("datasource", "user", "password");
>
> # Run The SQL
> $myrecs = odbc_exec($db, "SELECT * FROM mytable");
>
> # Loop Through Results
> while ( odbc_fetch_row($myrecs) ) {
> echo odbc_result($myrecs, "mycolumn") . "<br>";
> }
>
> Hope this helps, if not let me know or check out the manual page:
>
> http://www.php.net/manual/function.odbc-fetch-row.php
>
> Ian
>
> ----- Original Message -----
> From: "Duane Boudreau" <[EMAIL PROTECTED]>
> To: "CF-Community" <[EMAIL PROTECTED]>
> Sent: Monday, November 27, 2000 10:47 AM
> Subject: PHP Coders
>
>
> > Any PHP coders out there? Can any of you point me at a sample of how to
> > retrieve a query from an ODBC datasource using PHP.
> >
> > TIA,
> > Duane Boudreau
> > Director of Web Technologies
> > Ektron, Inc.
> >
> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> > Structure your ColdFusion code with Fusebox. Get the official book at
> http://www.fusionauthority.com/bkinfo.cfm
> >
> > Archives: http://www.mail-archive.com/[email protected]/
> > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
> >
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Structure your ColdFusion code with Fusebox. Get the official
> book at http://www.fusionauthority.com/bkinfo.cfm
>
> Archives: http://www.mail-archive.com/[email protected]/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
