[PHP-DB] DB Connect with SCALA script
I am looking at a project right now that is supposed to connect a local access chanel server (not server 2K only Win2K proprietary Scala server) to a MySQL database. I have called the company and they say it's possible although they have never deployed it with MySQL only MSSQL. I have a website that uses php/mysql and would like to take some data from that MySQL db and display some of these fields onto this local access server - embedded within this SCALA code. I have scoured the Internet and am ready to surrender - I find nothing. The closest thing that I have seen is a remote possibility to connect to the DB using VB Script - which I am clueless on. Has anyone out there ever even heard of SCALA - second, has anyone successfully integrated MySQL into SCALA? NOTE: This DB connect is only for display not for insert or update functions - I just want to query and display the results. thanks, Doug -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] MySQL query problems...
I am getting errors for the following queries. This query seems to work fine in phpMyAdmin. $query2 = SELECT AllMid_Data.CPU_Hostname FROM AllMid_Data, accounts WHERE AllMid_Data.CPU_IN_SVC = \Y\ AND AllMid_Data.CPU_DNS = \sbcld.sbc.com\ AND accounts.sbcuid = $sbcuid AND accounts.system = AllMid_Data.CPU_Hostname AND accounts.ctime IS NULL ORDER BY CPU_Hostname ASC; $results2 = mysql_query($query2, $Prod) or die(mysql_error()); $system2 = mysql_fetch_assoc($results2); $query3 = SELECT AllMid_Data.CPU_Hostname FROM AllMid_Data, acct_db WHERE AllMid_Data.CPU_IN_SVC = \Y\ AND AllMid_Data.CPU_DNS = \sbcld.sbc.com\ AND acct_db.key1 LIKE \$sbcuid%\ AND acct_db.key1 LIKE \%\.AllMid_Data.CPU_Hostname ORDER BY CPU_Hostname ASC; $results3 = mysql_query($query3, $Prod) or die(mysql_error()); $system3 = mysql_fetch_assoc($results3); I am assuming that I have an issue with query3. Thanks in advance. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] MySQL query problems...
um, the errors might be helpful bastien From: NIPP, SCOTT V (SBCSI) [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] MySQL query problems... Date: Wed, 23 Mar 2005 17:18:44 -0600 I am getting errors for the following queries. This query seems to work fine in phpMyAdmin. $query2 = SELECT AllMid_Data.CPU_Hostname FROM AllMid_Data, accounts WHERE AllMid_Data.CPU_IN_SVC = \Y\ AND AllMid_Data.CPU_DNS = \sbcld.sbc.com\ AND accounts.sbcuid = $sbcuid AND accounts.system = AllMid_Data.CPU_Hostname AND accounts.ctime IS NULL ORDER BY CPU_Hostname ASC; $results2 = mysql_query($query2, $Prod) or die(mysql_error()); $system2 = mysql_fetch_assoc($results2); $query3 = SELECT AllMid_Data.CPU_Hostname FROM AllMid_Data, acct_db WHERE AllMid_Data.CPU_IN_SVC = \Y\ AND AllMid_Data.CPU_DNS = \sbcld.sbc.com\ AND acct_db.key1 LIKE \$sbcuid%\ AND acct_db.key1 LIKE \%\.AllMid_Data.CPU_Hostname ORDER BY CPU_Hostname ASC; $results3 = mysql_query($query3, $Prod) or die(mysql_error()); $system3 = mysql_fetch_assoc($results3); I am assuming that I have an issue with query3. Thanks in advance. Scott Nipp Phone: (214) 858-1289 E-mail: [EMAIL PROTECTED] Web: http:\\ldsa.sbcld.sbc.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] dbase and Debian
Ricardo Markiewicz wrote: Unfortunately, I can't convert the dbf files to SQL tables, so, i need dbase support in PHP :( connect via ODBC, perhaps? then ADOdb or PEAR it? -- Leo G. Divinagracia III [EMAIL PROTECTED] z -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] dbase and Debian
Leo G. Divinagracia III wrote: Ricardo Markiewicz wrote: Unfortunately, I can't convert the dbf files to SQL tables, so, i need dbase support in PHP :( connect via ODBC, perhaps? then ADOdb or PEAR it? you can do that. why not try with an class from phpclasses.com. I use dbf to mysql or symilar to export dbf data base to mysql or any RDBM. Regards, Luis Morales -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php