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
