Hi:
As I am using PHP with mySQL, I downloaded the mySQL ODBC with
mysql.com's website and installed just now. I am using under Windows
machine / operating system. But even though I have installed the odbc I
can't progress with the Database interface. It give me Error like this:
Fatal error: Call to unsupported or undefined function mysql_connect()
in c:\windows\system\inetsrv/karthick/testdb.php3
on line 2
I have written script for this, which I have attached with this
mail <testdb.php3>. It doesn't works properly. I have installed mySQL
ODBC in Windows platform (which I downloaded from mysql.com !). I have
setup the mySQL odbc as it follows:
host: localhost
user: root
password: <nothing, blank>
port: 3306
That's all.
Do I need to start some separate service for starting this kind of
ODBC Connectivity. If yes, somebody can help me ?.
Thanx in advance. Bye for now !.
--
Best Regards,
TV Karthick Kumar
Aspire Systems, India
karthick@stripped
Attachment: [text/html]
Attachment: [text/html]
<?php
$dbh = mysql_connect("localhost:3306", "root", "");
mysql_select_db("test");
$query = "select * from test";
$result = mysql_query($query, $dbh);
$fields = mysql_num_fields($result);
while ($row=mysql_fetch_array($result)) {
for ($i=0; $i<$fields; $i++) {
$name=mysql_field_name($result, $i);
echo "$name = $row[$name]<BR>\n";
}
echo "<br><br>\n";
}
<?
