[PHP-DB] Add and Subtract

2002-02-22 Thread Jennifer Downey
Hi All, Would someone please help me with the following code? I am trying to make this work like if I have 15 gold pieces and I deposit 5 it will subtract 5 from the gold pieces I have and deposit the 5 into my account showing that I now have 10 gold pieces I can deposit and 5 in the bank. I wo

[PHP-DB] Re: Associating table id...

2002-02-22 Thread Pete Lacey
You have set the value of the id input element to the literal string 'id'. What you really want to do is set the id element to the primary key of the row in question. To use your coding style: ... $id = sprintf(mysql_result($result,$count,"pk_field")); echo "remove\n"; ... Pete Jas wrote: >

[PHP-DB] Re: PHP and big production database apps ?

2002-02-22 Thread Pete Lacey
You most certainly can write enterprise scale applications in PHP/PostgreSQL. The web is littered with resources to make your life easier. For me, PHPLIB (on sourceforge) has really saved my life. It's getting a little long in the tooth and the docs are, erm, spotty. But it is definitely w

Re: [PHP-DB] Displaying data as while recieving form mysql server

2002-02-22 Thread William Fong
I've noticed in the past that some webbrowsers will start to display before it's finished. I remember a few years back that some version of Netscape did it because our "web design" class made some HORRIBLE code which usually didn't end/complete properly, but would still show up. Also, on those o

Re: [PHP-DB] Array HELL!!!!

2002-02-22 Thread jas
I have made the changes you suggested which if you ask me have been the most informative answers I have recieved thus far. I did run into a slight snag on line 21 which is this on my confirmation page "" and the parse error is as follows... Parse error: parse error, expecting `STRING' or `NUM_STR

Re: [PHP-DB] Displaying data as while recieving form mysql server

2002-02-22 Thread Roel Mulder
Hi Lee, You can't. A has to be closed before a browser can render it and present it to you. So, the webserver may well be trowing echo("".$row[$i]."\n"); to the browser, the browser will wait for the . You might try cutting the one big table into smaller tables, each complete table will be

Re: [PHP-DB] Array HELL!!!!

2002-02-22 Thread biorn
Ok, you have almost got it. I have made little remarks further down in your code which should just about do it for you. jas <[EMAIL PROTECTED]> said: > I don't know what it is but I am having a hell of a time trying to get some > results of a query setup into an array or variable (too much of

[PHP-DB] Displaying data as while recieving form mysql server

2002-02-22 Thread Lee Leahu
Hello. After I run my mysql query and get the results, then I do a look to put the data into table rows that go to a webbrowser. How can i set it up so that the user see's the table rows as their writen, not after the script is all done. Lee [EMAIL PROTECTED] -- PHP Database Mailing List (h

Re: [PHP-DB] Array HELL!!!!

2002-02-22 Thread jas
Well ok now that I know it isn't an array I am having problems with, how exactly am I supposed to create a variable (that can be passed to another page) from a selected set of records? Thanks again for the politeness, Jas "Spyproductions Support Team" <[EMAIL PROTECTED]> wrote in message [EMAIL PR

RE: [PHP-DB] Array HELL!!!!

2002-02-22 Thread SpyProductions Support Team
That's not Array Hell, this is Array Hell: $Hell = array("satan","fire","brimstone"); -Mike > -Original Message- > From: jas [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 22, 2002 4:37 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Array HELL > > > I don't know what it is bu

[PHP-DB] Array HELL!!!!

2002-02-22 Thread jas
I don't know what it is but I am having a hell of a time trying to get some results of a query setup into an array or variable (too much of a newbie to know which) that can be passed to a confirmation page before deleting the record from a table. I have given up working on this but for those of y

Re: [PHP-DB] mysql connect, while and close big problem

2002-02-22 Thread William Fong
http://www.php.net/manual/en/function.mysql-pconnect.php http://www.php.net/manual/en/function.mysql-connect.php I am not sure if there are any performance difference between the two. I've read in MySQL's manual that non-persistent can max out the server, thus, recommending using persistent conn

[PHP-DB] re: Parse Error

2002-02-22 Thread Lawrence
I'm sure by now this has already been answered, but just in case it hasn't been, you've got an extra ')' at the end of this line: r_num\""); I hate to post this again but I have looked in a couple of php and mysql books but cannot seem to figure this one out. I am getting a parse error whe

Re: [PHP-DB] Re: Associating table id...

2002-02-22 Thread biorn
All you need to do is assign the variable (let's call it $id) the id for that record set from the database. Then pass this variable to the next page for the delete. You may want to search for the mysql_fetch_array function on php.net. This would be used to grab the record set from the datab

[PHP-DB] Re: Associating table id...

2002-02-22 Thread jas
I sincerely wish someone could give me some insight as to what I am doing wrong here. I have been scouring php.net for any website that has a good tutorial or article on how to pass the variables from page to page while assigning a variable a whole record set from a database. If anyone has run i

Re: [PHP-DB] mysql connect, while and close big problem

2002-02-22 Thread Killer Angel Clark
non-persistent. I would also like to ask the difference between persistent and non-persistene connection? "Ray Hunter" <[EMAIL PROTECTED]> ¼¶¼g©ó¶l¥ó [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > What type of connections are you making persistent or non-persistent? > > Ray Hunter > Firmware Engi

[PHP-DB] Re: Errors Deleting...

2002-02-22 Thread Lerp
Hi there :) When using checkboxes you'll have to name them as an array... > value=\"".$myrow[id]."\">remove I'm pretty sure it would be like: remove Hope this points you right direction ;) Cheers, Joe:) "Jas" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...

[PHP-DB] Associating table id...

2002-02-22 Thread jas
Ok I have been working on this function to delete an item from a mysql database and so far I have not had any success. Here is the problem I am having (after alot of headaches), I need to be able to associate a checkbox to a record or a set of records... For example, page 1 queries a database and

Re: [PHP-DB] PHP and big production database apps ?

2002-02-22 Thread William Fong
We use PHP and MySQL as helper applications (since we've implemented an ERP solution). Basically, we run everything off HTML. It works great because we have both PCs and MACs in house. Having this run through a browser keeps my development time really low. -- William Fong - [EMAIL PROTECTED]

[PHP-DB] Re: PHP and big production database apps ?

2002-02-22 Thread John Lim
For a commercial PHP library for building applications, have a look at phpLens at http://phplens.com/ This was developed by our company, and we have used it develop some pretty big applications (100 company extranet for example). There are other libraries available, some free. I like to search ho

RE: [PHP-DB] PHP and big production database apps ?

2002-02-22 Thread Hunter, Ray
You can get a complicated as you want. I am running postgres and php for our Quality assurance department that has a web based front-end portal with the postgres and mysql backend. I use the postgres database for the sensitive database (testing, cvs, test-cases, etc.) while I use mysql for the

[PHP-DB] Re: slow result

2002-02-22 Thread Lerp
Post some code up :) "Sommai Fongnamthip" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi, > When I select data from table with mysql prompt or mysql-front-end, it > display result fast. But when I put this sql into php, it used more time > to display the

[PHP-DB] more apache than php but please

2002-02-22 Thread John Fishworld
Why does this one work http://10.10.1.3/phpMyAdmin/ but this one not http://10.10.1.3/phpMyAdmin ?? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] PHP and big production database apps ?

2002-02-22 Thread Pagin
Hi all, I am absolutly new to PHP and PostgreSQL. So far I developed production database apps for managing production in production comapny(using Clipper and DBF files). Now my boss has got idea to try using PHP and PostgreSQL to create another production apps. These apps should run localy in com

[PHP-DB] R: [PHP-DB] configuring php for oracle...

2002-02-22 Thread Michele Azzolari
Hi, First of all, have you installed Oracle 8.0.5 or Oracle 8.1.* client on your web server? If you use php for Win you only need to load php_oracle.dll for Oracle 7.* and 8.0.*, or php_oci.dll for oracle > 8.1.* I use win2k with apache1.3.20,php4.0.6,Oracle 8.1.7.1.1 and I have no problem Mik

Re: Re: Re: [PHP-DB] php-mysql insert via web form problem

2002-02-22 Thread pdsec
Ok, stripSlashes did the trick. thanks all. On Fri, 22 Feb 2002 16:59:56 +0800, Jason Wong <[EMAIL PROTECTED]> wrote: >On Friday 22 February 2002 16:51, [EMAIL PROTECTED] wrote: >> Hello, >> Thanks for your reply. I am not putting the \ slashes in the query, I >> think php is. However, I am

Re: Re: [PHP-DB] php-mysql insert via web form problem

2002-02-22 Thread Jason Wong
On Friday 22 February 2002 16:51, [EMAIL PROTECTED] wrote: > Hello, > Thanks for your reply. I am not putting the \ slashes in the query, I > think php is. However, I am not sure how to remove them from the query that > is being sent to mysql. > Check out stripslashes(). -- Jason Wong -> Gre

Re: [PHP-DB] php-mysql insert via web form problem

2002-02-22 Thread Marius Ursache
in your php.ini have something about magic_quotes. read the manual. [EMAIL PROTECTED] a écrit : > Hello, > Thanks for your reply. I am not putting the \ slashes in the query, I think php >is. However, I am not sure how to remove them from the query that is being sent to >mysql. > > regards

Re: Re: [PHP-DB] php-mysql insert via web form problem

2002-02-22 Thread pdsec
Hello, Thanks for your reply. I am not putting the \ slashes in the query, I think php is. However, I am not sure how to remove them from the query that is being sent to mysql. regards ~:P On Fri, 22 Feb 2002 09:58:27 +0200, Marius Ursache <[EMAIL PROTECTED]> wrote: >i think the query you