RE: [PHP-DB] PHP/MS Access Help
| From: | Eduardo Jordan G. | Date: | Thu, 25 May 2000 13:58:34 +0000 |
| Subject: | RE: [PHP-DB] PHP/MS Access Help | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-89@lists.php.net to get a copy of this message | ||
I can't find those functions on php documentation.
You should first check documentation.
You can use one of this functions to query a db
"odbc_do synonym for odbc_exec()
odbc_exec Prepare and execute a SQL statement
odbc_execute execute a prepared statement"
Eduardo Jordán G.
ejordan@accessinter.net
-----Original Message-----
From: Tim Hulen [SMTP:thulen@yahoo.com]
Sent: Thursday, May 25, 2000 8:28 AM
To: php-db@lists.php.net
Subject: [PHP-DB] PHP/MS Access Help
This script creates an error. Fatal error: Call to
unsupported or undefined function odbc_select_db().
Is the select_db not available? I'm using PHP3 and MS
Access. I looked through PHP documentation and I
can't find odbc_select_db. Here the rest of my code.
<html>
<body>
<?php
$db = odbc_connect("dive","","");
odbc_select_db("mydb",$db);
$result = odbc_query("SELECT * FROM tblDiveData",$db);
echo "<table border=1>\n";
echo "<tr><td>Dive Number</td>Dive<td></tr>\n";
while ($myrow = odbc_fetch_row($result))
{
printf("<tr><td>%s %s</td><td>%s</td></tr>\n",
$myrow[1], $myrow[2], $myrow[3]);
}
echo "</table>\n";
?>
</body>
</html>
If anyone can find a problem or fix please let me
know.
Tim
=====
"Hokey religions and ancient weapons can never compare to a
good blaster at your side, Kid."
May all your bubbles be external.
__________________________________________________
Do You Yahoo!?
Kick off your party with Yahoo! Invites.
http://invites.yahoo.com/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
For additional commands, e-mail: php-db-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net