RE: [PHP-DB] SESSION

2002-12-23 Thread John W. Holmes
> After collecting the input data from a FORM via an array (name=kgkeys) > the next function starts: > session_start(); > $_SESSION['g_numprimarykeys'] = $_POST['numprimarykeys']; //This always > works ok first time through > $_SESSION['g_kgkeys'] = $_POST['kgkeys']; //This always works ok first >

[PHP-DB] SESSION

2002-12-23 Thread Kevin Gordon
After collecting the input data from a FORM via an array (name=kgkeys) the next function starts: $val) //This works ok when the above stores 'g_kgkeys' properly. { $pkey[$key] = $val; } In php.ini: registe

RE: [PHP-DB] mysql database not 'taking' changes

2002-12-23 Thread Mark
--- Jody Cleveland <[EMAIL PROTECTED]> wrote: > > Sorry. Stupid technospeak on my part. > > No problem, much ignorance on my part. > > > When you connect to the database, you tell it to use a particular > > username and password. When these new tables were created, did > you > > change the permi

RE: [PHP-DB] mysql database not 'taking' changes

2002-12-23 Thread Jody Cleveland
> Sorry. Stupid technospeak on my part. No problem, much ignorance on my part. > When you connect to the database, you tell it to use a particular > username and password. When these new tables were created, did you > change the permissions in the mysql table for the user, or does that > account

RE: [PHP-DB] mysql database not 'taking' changes

2002-12-23 Thread Mark
Sorry. Stupid technospeak on my part. When you connect to the database, you tell it to use a particular username and password. When these new tables were created, did you change the permissions in the mysql table for the user, or does that account have access to all the tables/databases? Basically

RE: [PHP-DB] mysql database not 'taking' changes

2002-12-23 Thread Jody Cleveland
> Does the user that the script runs as have full CRUD access to the > new tables? Have you set any restrictions on what that user can do to > the table(s)? Boy, do I feel lost... How would I check that? Thanks! Jody -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: ht

Re: [PHP-DB] mysql database not 'taking' changes

2002-12-23 Thread Mark
Does the user that the script runs as have full CRUD access to the new tables? Have you set any restrictions on what that user can do to the table(s)? --- Jody Cleveland <[EMAIL PROTECTED]> wrote: > Hello, > > I'm using a product called Squirrelmail for my web based email. In > it, it > uses a da

[PHP-DB] mysql database not 'taking' changes

2002-12-23 Thread Jody Cleveland
Hello, I'm using a product called Squirrelmail for my web based email. In it, it uses a database for user preferences and address books. (I posted to that list, and it was suggested to check here) I created the database squirrel. I created two tables, one called addresses and one called prefs. For

Re: [PHP-DB] Checking if number is in bottom three?

2002-12-23 Thread Doug Thompson
Generally, you want to use the LIMIT function. SELECT num FROM myfile ORDER BY num LIMIT 3; However, if the values may be repeated (e.g., 1,1,1,2,4,4,5), the query above will return 1,1,1. If you are interested in the three lowest values and not just smallest entries, add DISTINCT SELECT DISTINC

Re: [PHP-DB] Checking if number is in bottom three?

2002-12-23 Thread Leif K-Brooks
Thanks, but what I want to do is check if a number is in the first 3, not return the first three. If returning the first three and seeing if any of them matches is the only way, I'll do that, but it doesn't seem that great for the server. SELPH,JASON (HP-Richardson,ex1) wrote: select myfield

[PHP-DB] Checking if number is in bottom three?

2002-12-23 Thread Leif K-Brooks
I need a way to check if a number is in the bottom three of a column in my database. For example, if I had a list of number in my table like this: 1 5 8 12 60 1 10001 I might need to know if 5 was in the bottom three, which it would be. But if I checked 60, it wouldn't be. I could check the

RE: [PHP-DB] Questions regarding primary keys, updates, and autoincrement

2002-12-23 Thread Bernain, Fernando G.
Michael, why do you need to link de manufacturer table with de product table? I think that you have to clarify the design of your db and your business rules first... for instance, if you have to reuse the IDs (the barcode and de manufa cturer ID), then you will create new tables in order to preserv

[PHP-DB] Connect Time with Interbase

2002-12-23 Thread Andreas Steibl
Is it possible to minimize the time which PHP needs to connect to the Interbase server ? The problem is that for every page which need the Database, it needs about 1-2 seconds for connecting to the interbase (i use allready pconnect) But everytime the script ends, the connection is closed to the DB