RE: [PHP-DB] HEAP table

2003-07-09 Thread Terry Riley
Thanks, Daevid I'll probably use something with session variables. However, what I wish is that there was some kind of application-wide variables, as can be set in ColdFusion, that could track this. I cannot find any means to create such variables in PHP. Anyone got any ideas on those

Re: RE: [PHP-DB] HEAP table

2003-07-09 Thread Terry Riley
Brandy - that's two messages in this thread from you with no content! Terry --Original Message- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] HEAP table

2003-07-09 Thread Terry Riley
Good idea, Ben. I'll remember that when I can afford to have hosting on a non-shared server :-) , but can't use it at the moment. Cheers Terry --Original Message- You could have a php file set variables or an array called $GLOBAL[some_global_variable], go into the php.ini

Re: RE: [PHP-DB] HEAP table

2003-07-09 Thread Terry Riley
Just remembered - this is the guy ([EMAIL PROTECTED]) that was so abominably rude a couple of weeks back. He's obviously found another way of shooting blanks! --Original Message- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] PHP, MySQL and Flash

2003-07-09 Thread Rankin, Randy
Does anyone know of any articles on integrating PHP, MySQL and Flash to perform a drag and drop routine for updating a db? Specifically, I have a client who is _INSISTING_ that I integrate a drag and drop feature into his railcar storage application. He wants to be able to view two railcar

[PHP-DB] Auto inc in MySQL

2003-07-09 Thread Tristan . Pretty
I know I'll get flamed for askign such a simple question, but here goes... I have a MySQL DB and wanna increment a field 'id_number' by one each time, to avoid creating duplicates... I've done it before, but can't remember how... Any ideas? Tris...

RE: [PHP-DB] Auto inc in MySQL

2003-07-09 Thread Rich Hutchins
Tristan, It is a simple question and the answer be found very easily in the MySQL manual. All you need to do is to create a column in your table of type AUTO_INCREMENT. Then, when you insert a row into the table, you simply insert NULL as the value for the auto-incremented column and it will be

Re: [PHP-DB] Auto inc in MySQL

2003-07-09 Thread dpgirago
Tris, make the the field, id_number, an auto_increment field. [EMAIL PROTECTED] on 07/09/2003 07:44:34 AM To: [EMAIL PROTECTED] cc:(bcc: David P. Giragosian/MDACC) Subject: [PHP-DB] Auto inc in MySQL I know I'll get flamed for askign such a simple question, but here goes...

Re: [PHP-DB] Delete constraint

2003-07-09 Thread Norma Ramirez - TECNOSOFT
Thank´s a lot Pascal, it works just fine and all those links have very useful information. =) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] PHP, MySQL and Flash

2003-07-09 Thread Rich Hutchins
Randy, There ARE javascript solutions for this and a few can be found here: http://www.webreference.com/programming/javascript/dragdropie/ http://www.walterzorn.com/dragdrop/dragdrop_e.htm http://www.webreference.com/dhtml/column7/ (particularly good) What you'll find is that JS does not

[PHP-DB] OCIPLogon

2003-07-09 Thread Sapporo
Hi, I'm trying to avoid excessive database connections within my app. From the docs, I figured that the following code would insert 2 rows of data into table Dummy, since the connection would be reused and the transactions aren't isolated by using OCINLogon() (error handling left out for

Fwd: [PHP-DB] PHP, MySQL and Flash

2003-07-09 Thread . ma
hi! flash offers some great actionscript-functions to work with php (or any other serversided language) over http there is an object called LoadVars - i do not exactly know how to handle it within flash, but it can access php-scripts over http and send some post or get variables to it. in

RE: [PHP-DB] OCIPLogon

2003-07-09 Thread RENAULT, François
the first OCIexecute($statement, OCI_DEFAULT); has not been commited so when you reconnect , your cursor is closed and rollbacked with the 2nd PLogon -Message d'origine- De : Sapporo [mailto:[EMAIL PROTECTED] Envoyé : mercredi 9 juillet 2003 16:03 À : [EMAIL PROTECTED] Objet :

RE: [PHP-DB] Weird Segfaults with Oracle, PHP, Apache2

2003-07-09 Thread Harris, Jeff
-Original Message- From: Thies C. Arntzen [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 09, 2003 5:33 AM To: Harris, Jeff Cc: '[EMAIL PROTECTED]' Subject: Re: [PHP-DB] Weird Segfaults with Oracle, PHP, Apache2 On Tue, Jul 08, 2003 at 05:51:47PM -0500, Harris, Jeff wrote: We're

Re: [PHP-DB] Auto inc in MySQL

2003-07-09 Thread Leif K-Brooks
Stan Lemon wrote: Also, I believe in addition to AUTO_INCREMENT it has to be UNIQUE as well. Please correct me if I am wrong. No, just INDEX. UNIQUE will work fine, but I reccomend making it PRIMARY. -- The above message is encrypted with double rot13 encoding. Any unauthorized attempt to

[PHP-DB] Re: OCIPLogon

2003-07-09 Thread Pete Morganic
$conn = OCIPLogon(scott, tiger, testdb); $statement = OCIparse($conn, INSERT INTO Dummy VALUES ('A')); OCIexecute($statement, OCI_DEFAULT); $statement = OCIparse($conn, INSERT INTO Dummy VALUES ('B')); OCIexecute($statement, OCI_DEFAULT); $statement = OCIparse($conn, INSERT INTO Dummy

[PHP-DB] mysql_fetch_array issues.

2003-07-09 Thread Greg Hetrick
I am getting the following error when attempting to pull data out of a mysql DB Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/pffl/public_html/pffl/webpage/html/dataentry.php on line 125 I can take this same code to a different web server and it is

Re: [PHP-DB] mysql_fetch_array issues.

2003-07-09 Thread jeffrey_n_Dyke
Do you have an 'or die(mysql_error())' statement following your mysql_query($result) line. 99% of the time, this error means your query failed. if it works on another serverare the fields the same, the dbname, the tablename? hth jeff

Re: [PHP-DB] mysql_fetch_array issues.

2003-07-09 Thread Terry Riley
As far as I know, that error means that the query that was supposed to produce $result did not run because of errors in the SQL (or the database). Suggest you check your query in myPHPAdmin or MySQLfront or whatever to be sure that it has no errors. Terry --Original Message-

Re: [PHP-DB] mysql_fetch_array issues.

2003-07-09 Thread Greg Hetrick
I do not have the die statment -- the DB is the same except the name and I have double checked that I just did a back up of the previous db and moved it to the new server. I have done some more digging, my query appears to work, but I almost appears that I have a problem with selecting the

Re: [PHP-DB] mysql_fetch_array issues.

2003-07-09 Thread Greg Hetrick
Query is correct appears to be a problem connecting to the db -- I can comment out the mysql_select line and I get no change. Terry Riley [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] As far as I know, that error means that the query that was supposed to produce $result did not run

RE: [PHP-DB] mysql_fetch_array issues.

2003-07-09 Thread Gary . Every
Do you have select permissions on that DB/table? If you have GRANT permissions, try GRANS SELECT, INSERT, UPDATE, DELETE ON db.tablename to 'youruser'@'your.ip.address' IDENTIFIED BY 'yourpassword'; your.ip.address can be substituted with localhost if you're on the same box. Gary Every Sr.

Re: [PHP-DB] mysql_fetch_array issues.

2003-07-09 Thread Greg Hetrick
Yup, I have all permissions -- it appears that I can access mysql but not the database itself. Gary Every [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] . Do you have select permissions on that DB/table? If you have GRANT permissions, try GRANS SELECT, INSERT, UPDATE, DELETE ON

[PHP-DB] mssql_bind problems

2003-07-09 Thread Chris Wright
I am running PHP 4.3.2 and MS-SQL 2000. I am trying to run some sample code to make sure all works well. The code below works fine. It simply inserts a record into a table. This is done in the stored procedure code on the SQL server. Code that works: $myServer = 192.168.200.28; $myUser = sa;

Re: [PHP-DB] mysql_fetch_array issues.

2003-07-09 Thread Kieu D. Trang
this error only means that your msql_query($result) was correct, but did not have any result... meaning, there was nothing to select, there for there is nothing to fetch... hence you can not do a msql_fetch_array() on an empty result set. KD On Wed, 9 Jul 2003, Greg Hetrick wrote: Yup, I