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

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 = \$other\ WHERE

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 message.

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 the

[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

[PHP-DB] need help guys

i have this select name=category option value='Arts'Antiques Arts/option then i pass this to next page: script c=document.forms[0].category.options[document.forms[0].category.selectedIndex].text location.href=additems.php?category=+c /script in url it shows like this:

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 select name=category option value='Arts'Antiques

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 preserve

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 update

[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:

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

Chad, Try something like this: - ? $qry = SELECT category_id, category_name from tblCategories; $result = mysql_query($query); ? form method=POST name=criteria action=my_postpage.php select name=categories

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:

[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

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: ? mysql_connect(localhost,$user,$pass); mysql_select_db($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