Re: [PHP-DB] Creating an array of mySQL results with PHP

With the help of Court Shrock, who answered by original request for help, I have managed to create an array of form data that can be fed to a mySQL UPDATE query. In case anyone else needs to do this, here's the solution I reached. The existing data is read from the database and placed in cells t

Re: [PHP-DB] Creating an array of mySQL results with PHP

On Thursday 14 March 2002 16:20, John Hughes wrote: > $sql = "UPDATE parent_log > SET > classroom = \"$classroom\", > homework = \"$homework\", > library = \"$library\", > fieldtrip = \"$fieldtrip\", > pta = \"$pta\", > mast = \"$mast\", > meetings = \"$meetings\", > other = \"

Re: [PHP-DB] date problem

Rehab, > i have an input field in a form that accept date called $date and in databse i made it of type $date so its defualt is -00-00 > > the problem is when i say: > if($date!="-00-00") > {do something} > > he doesn't understand $date!="-00-00" Please copy-paste the actual error m

Re: [PHP-DB] PLEASE HELP !!!!!!!

Manual reference: http://www.php.net/manual/en/function.mysql-connect.php resource mysql_connect ( [string server [, string username [, string password [, bool new_link) Seeing it is not a web page you're connecting to, try removing the "http://";. "localhost" has particular meaning within

[PHP-DB] installing php-interbase support

Hi, I would like to solve this problem on my apache-php instalation Fatal error: Call to undefined function: ibase_connect() in /home/pcash/public_html/includes/conexioninterbase.inc on line 7 To solve first i have try to do [root@www download]# rpm -i php-interbase-3.0.16-2bc.i386.rpm error:

[PHP-DB] need help guys

Rehab M.Shouman - Express yourself with a super cool email address from BigMailBox.com. Hundreds of ch

[PHP-DB] need help guys

i have this Antiques & Arts then i pass this to next page:

RE: [PHP-DB] need help guys

you can't pass a literal "&" in a url - it makes it think that it's the next variable. -Original Message- From: its me [mailto:[EMAIL PROTECTED]] Sent: 14 March 2002 11:21 To: [EMAIL PROTECTED] Subject: [PHP-DB] need help guys i have this Antiques & Arts then i pass this to next page:

RE: [PHP-DB] need help guys

Can you send us the full script?? Why can't you just do a submit??? The problem is the ampersand (&) in the middle. This is a place marker which marks the start of the next variable in the query string. If you absolutely *HAVE* to submit the data this way, you'll need to convert it to the escape

RE: [PHP-DB] need help guys

hi Rehab Because your submitted text on the url contains an '&' anthing after this character will be parsed as a new variable. Instead of location.href="additems.php?category="+c try location.href="additems.php?category="+escape(c) this will encode the '&' aswell as spaces to pre

Re: [PHP-DB] Avoiding the update of a timestamp in MySQL

Hi, thanx I try that. andy PS: yes I did, but did not try it yet. Thanx "Dl Neil" <[EMAIL PROTECTED]> schrieb im Newsbeitrag 0c8601c1cae2$d26b6dc0$c200a8c0@jrbrown">news:0c8601c1cae2$d26b6dc0$c200a8c0@jrbrown... > Hi Andy, > > > I have a timestamp in my table to store a date. Now I have to u

[PHP-DB] creating a drop down menu from mysql categories

Hello everyone, I am a little new to the list. I have been reading a lot of the posts but have not submitted yet. But I ran into a problem I was hoping I might get e little help or at least get a point in the right direction. I have a table called tblCategories with field category_ID

[PHP-DB] HELP ! SELECT QUERY WITH OCI8

I was successful in compiling php with the options --with-oracle and --with-oci8. but when I tried to make a SELECT query to the database I got the following error message: OCIDebug: oci_do_connect: id=1 OCIDebug: oci_parse "select login, password from users" id=2 conn=1 Warning: OCIStmtEx

RE: [PHP-DB] creating a drop down menu from mysql categories

Chad, Try something like this: - $category_array[category_name]"; } ?> - Rand

RE: [PHP-DB] date problem

if( strcmp($date,"-00-00") ) { do something} -Original Message- From: its me [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 12:16 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] date problem i have an input field in a form that accept date called $date and in databse i made it

[PHP-DB] INSERT IMG in Database

Hi, I have a windows 2000 Database Server with IBM DB2 V7.2 FP5 I have a linux web server with Apache/PHP I installed IBM DB2 IMAGE Extender and enable my database for it. Now I'm uploading a file to the server and I want to copy this file in the database. I'm using the following script: $u

[PHP-DB] DB Class pointer as var in another class

We've been considering the following implementation of a class pointer within another class. Our goal here is to minimize the number of database connections per function call. It seems to work just fine, but I wanted to post this up for comments. PHP 4.1.1 doesn't seem to have a problem with it

Re: [PHP-DB] creating a drop down menu from mysql categories

Thanks everyone for the help, I know with other lists, sometimes when you finally get you problem to work you post your answer. Anyway, just in case anyone was wondering, here is what I ended up doing: category $category_array[1]"; }

RE: [PHP-DB] DB Class pointer as var in another class

Hi Gary, I didn't understand what you were actually trying to do here.. You stated that "Our goal here is to minimize the number of database connections per function call." but seems like you are connecting to the database in the constructor? So each instance will automatically connect to the DB??

Re: [PHP-DB] DB Class pointer as var in another class

I'll have to re-think extending the class with our database class. In the past they may not have worked well. Admittedly, our classes were written poorly. But, now that we're massively redesigning, that may work very well. Thanks for getting my brain-juices flowing again. Gary "Gurhan Ozen"