[PHP-DB] Re: Rookie question - Setup

2001-05-20 Thread Graham Reeves
Hi all I come out of a client/server environment and am wanting to learn Web-programming - Specifically PHP. I am using Windows Me, Apache as my web server, Interbase as my Database and php-4.0.3pl1-installer.exe. My question: Are there any installation guides for this type of set-up? (I have

Re: [PHP-DB] Filling a dropbox on form

2001-05-20 Thread Alan Hale
Alan Hale wrote: > http://www.devshed.com/Server_Side/MySQL/JS_Arrays/ > > I found it difficult to understand what was going on because the code > example is embedded in the rest of a complex page layout. I also think there > are errors in the code, which I've only partly sorted out (I'm a Javasc

Re: [PHP-DB] Deleting specific records from MySQL tables

2001-05-20 Thread Paul Burney
on 5/20/01 11:50 AM, Matthew Tyler at [EMAIL PROTECTED] wrote: > I'm having difficulty getting certain records in MySQL tables to delete. I > have this bit of code: > > mysql_db_query("phpads", "DELETE FROM adviews WHERE > bannerID=$banresult[bannerID]"); I don't think that PHP will be able to

RE: [PHP-DB] Deleting specific records from MySQL tables

2001-05-20 Thread Craig Vincent
Try putting the variable into single quotes mysql_db_query("phpads", "DELETE FROM adviews WHERE bannerID='$banresult[bannerID]'"); That should resolve the problem. Sincerely, Craig Vincent -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For addi

[PHP-DB] Deleting specific records from MySQL tables

2001-05-20 Thread Matthew Tyler
I'm having difficulty getting certain records in MySQL tables to delete. I have this bit of code: mysql_db_query("phpads", "DELETE FROM adviews WHERE bannerID=$banresult[bannerID]"); What I'm doing here is trying to get the records from table adviews with a bannerID entry of "$banresult[bannerID

Re: [PHP-DB] connecting to database..?

2001-05-20 Thread Jesse Scott
Make sure that your php.ini and your my.cnf both agree on where the socket file is going to be put. And if you make any changes, be sure to restart both PHP/Apache and MySQL. You might also check the logs and make sure that MySQL is actually launching, it might be encountering an error and q

Re: [PHP-DB] connecting to database..?

2001-05-20 Thread rice
I have the same problem as you when using apache1.3.19, php4.0.5 and mysql3.23.38 and get the same warning message. I've spent many time to compile the system again but failed. So I forgive to use the newest version and use apache1.3.17, php4.0.4 and mysql3.23.38. It works now! Hope someone can h

Re: [PHP-DB] connecting to database..?

2001-05-20 Thread Terry Romine
I have a strange situation-- I have a php page that submits form data to MySql database and sends an email confirmation on completion. It works fine, but there were several people at one site that although the emails indicate the data was submitted successfully, the data never showed up in the

[PHP-DB] connecting to database..?

2001-05-20 Thread Derick Dorner
I receive the error when trying to connect to MySQL database: Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) in /usr/home/cupid/www/sql.php on line 13 The code I use to connect is: $link = mysql_connect ("localhost", "username", "pas

Re: [PHP-DB] Filling a dropbox on form

2001-05-20 Thread Alan Hale
Howard Picken wrote: > Running Freebsd, Apache, MySQL and Php4. > > Does any one know of way to fill a dropbox that > reduces the list of items as you type in more > info. I've looked at some scripts but not yet found something entirely satisfactory. Andrew King's script at www.webreference.com

[PHP-DB] Interbase problem

2001-05-20 Thread alpopescu
Hi, Let me help with this problem, please. Have anyone any idea why the first statement works and the second not ? 1. $dbh=ibase_connect($host, $user, $pass) or die("Connection error"); $result=ibase_query("select * from tablename"); ... ibase_close(); 2. $dbh=ibase_connect($host, $user, $p