I'm looking for some basic instruction on creating a SQL/ODBC query from a web page.

Below is sample from the ODBC/JDBC forum using PHP.

Mostly I am uncertain how to code the client location. I am also unfamiliar with how the remaining objects need to be coded(odbc_exec,odbc_fetch etc.).

What I really need is a simple primer or tutorial on connecting to FileMaker ODBC data via the web using SQL.

Can anyone help?

PHP example:

<?php

$conn = odbc_pconnect(client, user, password);

$sql = 'SELECT * FROM Companies WHERE clientnumber=10100';

$rs = odbc_exec($conn, $sql);

$row = odbc_fetch_array($rs);

print_r($row);

?>

Wrong forum. Please post either in the PHP or the ODBC / JDBC forum.

Ok. This is now in the correct forum

Edited October 12, 200619 yr by Guest
Moved from XML/XSLT