[PHP-DB] PHP and Oracle

Hi, How would I install PHP with Oracle support if Oracle is on another machine, not in the web server machine? Thanks, Lester - Lester June Cabrera Chief Web Programmer I-Quest Corporation Tel: (632) 867 8460 local 32 Fax: (63 2) 867 8077

[PHP-DB] Updating multiple forms

How do I update data into multiple forms? Thanks in advance.. Shahmat

Re: [PHP-DB] Updating multiple forms

Hi, What do you mean by updating data into multiple forms? Do you mean displaying data in multiple HTML forms? Lester At 04:53 PM 4/18/01 +0800, Shahmat Dahlan wrote: How do I update data into multiple forms? Thanks in advance.. Shahmat -- PHP Database Mailing List (http://www.php.net/)

Re: [PHP-DB] Updating multiple forms

Apologies... Lemme rephrase my question, How do I update data into multiple tables in MySQL? Shahmat Lester June Cabrera wrote: Hi, What do you mean by updating data into multiple forms? Do you mean displaying data in multiple HTML forms? Lester At 04:53 PM 4/18/01 +0800, Shahmat

Re: [PHP-DB] Updating multiple forms

Yes, this is only applicable if I only have one table. What if I need to update multiple tables? Lester June Cabrera wrote: I guess you need to use the UPDATE command UPDATE tablename SET column1 = 'some value' WHEREcolumn2 = 'another value'; Did I get what you mean? Lester At 05:02

Re: [PHP-DB] Updating multiple forms

On 18 Apr 2001, at 17:27, Shahmat Dahlan wrote: Yes, this is only applicable if I only have one table. What if I need to update multiple tables? Shamat, it seems we need some more info to understand your needs. What precisely are you trying to do?

Re: [PHP-DB] Updating multiple forms

Off the top of my head, and it's 3am local so take this with a grain of salt, but I think that this will work... Update Table1, Table2 SET Table1.column1 = 'blah', Table2.column1='foo' WHERE Table1.ID = x AND Table2.ID = y 'Luck -Szii - Original Message - From: Lester June Cabrera

[PHP-DB] Convertin Asp to Php

Hi I got to convert a asp site white database conections to a mysql but I hav to convert it to Php with conections to Mysql my question is if there is a simple way to do this or if the pages has to be rewriten (for an example a converter program) and is there a correspondence to ADO between

RE: [PHP-DB] Convertin Asp to Php

Hi Tobbe, I haven't used it and I am only a beginner at this stuff, but there is a product called Code Charge www.codecharge.com. It is available for download for a trial period. It may be useful. I don't know of any other possibility, other than re-writing the logic. Although from using PHP and

[PHP-DB] Concurrent update to database (PostgreSQL or MySQL) ??

Hi, How can I avoid two or more users to update the same record at the same time ? Ideally, I would like to lock the record when a user open it for modification. So if another user try to open the same record he'll be warned or get record values as read only. Is this possible and how to do it

[PHP-DB] building database advise

I have a database project, historic building materials... I've designed 4 Tables like this (there are more fields which I didn't listed here): table products - primary key(productid) - product description ... table category - primary key(categoryid) - category description table subcategory -

Re: [PHP-DB] MySQL Question

On Tue, Apr 17, 2001 at 05:52:53PM -0400, Peter J. Krawetzky wrote: How do you move the database files to another location in MySQL? I am running Redhat 7.1 with MySQL version 3.23.33. You ask the appropriate list @ [EMAIL PROTECTED] Of course by the time you do so, you have already

Re: [PHP-DB] Concurrent update to database (PostgreSQL or MySQL) ??

This is a database, not a PHP question. Different databases have different locking/buffering schemes. So which are you using, and what do the documents say about locking? Do they lock records or pages? Generally you never attempt to lock a record until you are ready to write to it. In

Re: [PHP-DB] Concurrent update to database (PostgreSQL or MySQL) ??

On 18 Apr 2001, at 13:47, Nicolas Guilhot wrote: Don't want to start another religion war, but... Hi, How can I avoid two or more users to update the same record at the same time ? Ideally, I would like to lock the record when a user open it for modification. So if another user try to

RE: [PHP-DB] Updating multiple forms

Basically you write multiple query statements. Like so: $query_updatetable1 = "UPDATE table1 SET fieldname WHERE fieldname = x"; $result_updatetable1 = mysql_query($query_updatetable1); $query_updatetable2 = "UPDATE table2 SET fieldname WHERE fieldname = y"; $result_updatetable2 =

Re: [PHP-DB] PHP and Oracle

At 03:43 PM 4/18/01 +0800, Lester June Cabrera wrote: How would I install PHP with Oracle support if Oracle is on another machine, not in the web server machine? 1. Install the Oracle Net8 client on your web server... 2. Configure the Oracle Net8 client on your web server... 3.

RE: [PHP-DB] Best non-tackified grip enhancer for golfers+

BDY.RTF -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] hide passing value

I want to hide the values being passed between forms like password. For that i tried GET and POST but wouldn't work. Any other Ideas. -Regards -- The secret of the universe is @*!'^#+ NO CARRIER ___ _ _ _ |_|_||_||_||\/||_|| \ _|| || || \| || ||_/ -- PHP Database Mailing List

Re: [PHP-DB] HTTP1.0/404 Not found

I want to know now to avoid displaying HTTP/1.0 404 Not found page. Despite the fact that i want say that everyone to go to index.php page on any non existing URL. pls tell me where to do the exact and how?. Add index.php to your httpd.conf think it's called directoryindex.. it says

Re: [PHP-DB] HTTP1.0/404 Not found

on 4/18/01 10:41 AM, Sharmad Naik at [EMAIL PROTECTED] wrote: I want to know now to avoid displaying HTTP/1.0 404 Not found page. Despite the fact that i want say that everyone to go to index.php page on any non existing URL. pls tell me where to do the exact and how?. Pls help me Sorry,

Re: [PHP-DB] hide passing value

Ok fair play - What about using sessions then: ?php session_start(); session_register('password') ? simply place the code between the ?php and ? at the top of each page you wish the password to be available on. Hope that helps... Russ

Re: [PHP-DB] Concurrent update to database (PostgreSQL or MySQL) ??

As others have mentioned, this is a tricky thing to do. What others haven't mentioned is a way to do it. Let's say you just showed the update form to two users. It contains the fields that they are allowed to update and the values in those fields had been retreived from the database. Both

[PHP-DB] PHPNuke 4 error. Got any clues?

Ok.. I recently uploaded all the files, followed the readme exactly, set permissions, uploaded the mySQL file, created the database, and all necessary steps to my FreeBSD server. When I goto the admin.php, I get this error: "Fatal error: Call to undefined function: translate() in

RE: [PHP-DB] PHPNuke 4 error. Got any clues?

Hi Brian, I've not worked with PHPNuke, but translate() is not a PHP native function (I don't believe...) so find where it's being defined in the PHPNuke distro and ensure that that file is being included/required in admin.php or before. HTH Best regards, Andrew

Re: [PHP-DB] PHPNuke 4 error. Got any clues?

At 03:55 PM 4/18/2001 -0400, Brian Tegtmeier wrote: If you have any suggestions, It would be greatly appreciated. thanks! :) First, do not use PHPNuke. It has a shaky codebase which would require a complete rewrite to fix up. I have used it personally and regret it as it is a total pain to

[PHP-DB] Web based adminisration

Are there any other web based administration tools for mysql written in php besides phpMyAdmin?Links? Mike P [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list

RE: [PHP-DB] Web based adminisration

I've written a Content Publishing Tool for my site. http://www.sohh.com Steven -Original Message- From: Mike [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 1:48 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Web based adminisration Are there any other web based administration

[PHP-DB] How to redirect a user to main page once I capture his info in a form?

Hi all, I have a simple form where I capture the information from users. Once the information is captured, I'd like to send the users the the main page. I already tried the header command but I get an error like this: Warning: Cannot add header information - headers already sent by

Re: [PHP-DB] How to redirect a user to main page once I capture his info in a form?

At 02:03 PM 4/18/2001 -0700, Hector M Banda wrote: Warning: Cannot add header information - headers already sent by (output started at page.php:42) in page.php on line 45 What's at line 42 of page.php? Cheers -

AW: [PHP-DB] Concurrent update to database (PostgreSQL or MySQL) ??

Another way is to keep another unique value inside the table to be updated and remember it. When needed, I add a second unique column to the table (in my case a char(64)) which is filled with the current timestamp and some md5 checksum. I select this value before the update, pass it along with

Re: [PHP-DB] How to redirect a user to main page once I capture his info in a form?

header("location: http://www.need-info.com"); - Original Message - From: "Ron Brogden" [EMAIL PROTECTED] To: "Hector M Banda" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, April 18, 2001 2:08 PM Subject: Re: [PHP-DB] How to redirect a user to main page once I capture his info in

Re: [PHP-DB] How to redirect a user to main page once I capturehisinfo in a form?

Try using just HTML htmlheadtitleLogging in.../title meta http-equiv="refresh" content="0;URL=display.php?action=home"/head body/body/html Hope this helps, Morgan Tocker. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands,

Re: [PHP-DB] How to redirect a user to main page once I capture his info in a form?

Hi, you have output in line 42. any html stuff. You have to send haeder information before any output. If you capture the info via a form you can make a seperate capturing script (not $PHP_SELF) to enter the info into a DB and at the end of this -after successfully inserting the data- redirect

[PHP-DB] inserting a timestamp

hey all, I am having a hell of a time getting a timestamp to insert correctly. it keeps coming up 00 here's what i have $date_avail = mktime (0,0,0,$month,$day,$year); $avail = date("F j, Y", $date_avail); echo "Date Available: $avail"; this works fine and displays the

Re: [PHP-DB] inserting a timestamp

Olinux, From the Mysql Manual As a string with no delimiters in either 'MMDDHHMMSS' or 'YYMMDDHHMMSS' format, provided that the string makes sense as a date. For example, '19970523091528' and '970523091528' are interpreted as '1997-05-23 09:15:28', but '971122129015' is illegal (it has a

[PHP-DB] Error Msg: Wrong data type when performing extract()

$sqlstmt ="SELECT stock_in.id, equip.equip_type, "; $sqlstmt.="equip.brand, equip.model, "; $sqlstmt.="vendor.name, stock_in.po_no, "; $sqlstmt.="stock_in.vendor_sales_no, stock_in.cust_po_no, "; $sqlstmt.="stock_in.serial, stock_in.warranty, stock_in.date_received, "; $sqlstmt.="stock_in.remark,

[PHP-DB] MySql won't connect

I know that the pages that I am using worked. I created them, then had to reload my OS. I saved everything before erasing the HD. I have restored the files but now I get a warning message that says MySQL Connection Failed: Can't connect to local MySQL server through socket The mysql.sock

Re: [PHP-DB] MySQL transactions?

a common question. This might help http://www.mysql.com/documentation/mysql/bychapter/manual_Compatibility.html #Missing_Transactions -- Regards, Gary "SuperID" Huntress === FreeSQL.org offering free database hosting to developers Visit

Fw: [PHP-DB] MySql won't connect

Your direct e-mail has problems too. - Original Message - From: "Dan Anderson" [EMAIL PROTECTED] To: "johndmiller" [EMAIL PROTECTED] Sent: Wednesday, April 18, 2001 11:36 PM Subject: Re: [PHP-DB] MySql won't connect Not a php expert by any means, but I get this when I use the "wrong"

Re: [PHP-DB] Error Msg: Wrong data type when performing extract()

In article [EMAIL PROTECTED], [EMAIL PROTECTED] ("Shahmat Dahlan") wrote: $result=mysql_query($sqlstmt); # print $result; $row=mysql_fetch_array($result) extract($row); If I do the above, I get the results below: Warning: Wrong datatype in call to extract() in

Re: [PHP-DB] MySQL transactions?

The newest MySQL code has transactions via their implementation of Sleepcat's BDB tables. If you use BDB tables instead of MyISAM you can do transactions. Check the syntax on CREATE TABLE for details on how to create BDB tables. 'Luck -Szii - Original Message - From: Gary Huntress