Re: [PHP-DB] Dynamic pull down menus with PHP/Mysql

2004-10-07 Thread GH
For a project in college that I had once did using ColdFusion and MSAccess (please dont kill me :)) I had the simular situation What I did was when the First Drop Down was changed... it had an onChange action or something of that nature (do not have my exact code infront of me) that went to a

Re: [PHP-DB] Re: Passing url parameters

2004-10-07 Thread Bastien Koert
yes, serialize the array. then unserialize it on the other side. look it up in the manual bastien From: Gary Hotko <[EMAIL PROTECTED]> Reply-To: Gary Hotko <[EMAIL PROTECTED]> To: Amit Arora <[EMAIL PROTECTED]> CC: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Re: Passing url parameters Date: Fri, 8 O

Re: [PHP-DB] Re: Passing url parameters

2004-10-07 Thread Gary Hotko
Got a question can one send a full array to another page with out having out put each value stored in it manually? On Sun, 03 Oct 2004 05:54:54 +0530, Amit Arora <[EMAIL PROTECTED]> wrote: > You can set this to anything you want. > > http://www.url.com?new_field=value > > And you can get the va

RE: [PHP-DB] Importing Excel and Access data to MySQL

2004-10-07 Thread Zareef Ahmed
-Original Message- From: Matthew Perry [mailto:[EMAIL PROTECTED] Sent: Friday, October 08, 2004 8:16 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Importing Excel and Access data to MySQL Simple question, How does one import excel and access data to MySQL? -- Matthew Perry Please search f

[PHP-DB] Importing Excel and Access data to MySQL

2004-10-07 Thread Matthew Perry
Simple question, How does one import excel and access data to MySQL? -- Matthew Perry -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Recursively determine parent records?

2004-10-07 Thread point of no return
Chris Gregors wrote: not to nit-pick: 1. I only do 1 sql query 2. Gijs Van Tulder uses recursion, while I use while loops. Similar effect. 3. Gijs Van Tulder function only prints out the path as a series of strings. I give it back in an array. Actually, if you have more than one parent, you do more

Re: [PHP-DB] Obfuscator

2004-10-07 Thread Andrew Kreps
On Thu, 07 Oct 2004 09:10:16 -0400, Bastien Koert <[EMAIL PROTECTED]> wrote: > Whats the point? Security thru obfuscation is not security at all. If you > deem your site/data that sensitive, upgrade to ssl , lock the db down tight > and pray that the sys admins at your host are on top of exploits a

[PHP-DB] mssql.dll vs. sybase_ct

2004-10-07 Thread VEGH Karoly
Hi, We are trying to move some php webapplications from windows to linux. One of them is one with necessery db-connection to an MSSQL server. The application migration isn't running too smooth, since: If I udnerstand it correctly, there is the native-mssql connector for PHP under windows, the

Re: [PHP-DB] Loading large volumes of data

2004-10-07 Thread Andrew Kreps
On Thu, 7 Oct 2004 09:05:55 +0200, Evan Morris <[EMAIL PROTECTED]> wrote: > I have a text file containing strings. The text file is pretty massive, > about 895 MB. I need to load the words in the text file into the database in > such a way that there is a single occurrence of each word in the table

RE: [PHP-DB] Rand()

2004-10-07 Thread Ed Lazor
Hrm. Dunno then. I just manually tested it in MySQL and both approaches worked. Are you able to test directly in MySQL? Might have to go to the mysql list for this. -Ed > -Original Message- > > Yeah, I had tried that earlier but it doesn't work. It does generate > a new value for t

[PHP-DB] Re: php_mysql.dll (5.0.2) and libmysql.dll (4.0.20a) incompatibilities

2004-10-07 Thread Glenn Puckett
I just went through this myself. PHP v5x comes with the correct libmysql.dll. Copy that to System32 and it will work. I haven't used it enough yet to know if it causes problems with MySQL, but PHP now works. Steve Olney wrote: Hi, I have an incompatibility problem when trying to use PHP 5.0.2

Re: [PHP-DB] Rand()

2004-10-07 Thread blackwater dev
Yeah, I had tried that earlier but it doesn't work. It does generate a new value for temp each time but they are still in the same order as the first one always has a lower temp value On Thu, 7 Oct 2004 06:40:23 -0700, Ed Lazor <[EMAIL PROTECTED]> wrote: > > > select id, fname, lname, RAND

RE: [PHP-DB] Recursively determine parent records?

2004-10-07 Thread Chris Gregors
not to nit-pick: 1. I only do 1 sql query 2. Gijs Van Tulder uses recursion, while I use while loops. Similar effect. 3. Gijs Van Tulder function only prints out the path as a series of strings. I give it back in an array. -Original Message- From: point of no return [mailto:[EMAIL PROTECT

RE: [PHP-DB] Rand()

2004-10-07 Thread Ed Lazor
select id, fname, lname, RAND() as temp from clients where featured=1 order by temp > -Original Message- > I have the following query: > > Select id, fname, lname from clients where featured=1 order by RAND() > > At any time, there should only be three clients where featured =1. > Prob

[PHP-DB] Rand()

2004-10-07 Thread blackwater dev
I have the following query: Select id, fname, lname from clients where featured=1 order by RAND() At any time, there should only be three clients where featured =1. Problem is I have run this query several times yet it always returns them in the same order. Not sure it makes a difference but th

RE: [PHP-DB] Obfuscator

2004-10-07 Thread Bastien Koert
Whats the point? Security thru obfuscation is not security at all. If you deem your site/data that sensitive, upgrade to ssl , lock the db down tight and pray that the sys admins at your host are on top of exploits and hacks to keep the server safe. Bastien From: Stuart Felenstein <[EMAIL PROTE

[PHP-DB] Obfuscator

2004-10-07 Thread Stuart Felenstein
I have been planning, when the time is right (site is ready for real time) , to add obfuscation to pages. Wondering what others are doing in this area. Is this a typical thing that better sites use ? I see some commercial PHP obfuscators out there, anyone have recommendations ? Thank you , Stuar

[PHP-DB] Storing large file in longblob field

2004-10-07 Thread pt2002
Hi I need to store two large files, about 4MB each file in a table. The files are already in the server, no need to upload them. The problem is the max_allowed_packet limit (1MB) and I can't change this. It's a shared host. I've tried to read 512KB chunks and update the table wih CONCAT function b

Re: [PHP-DB] Recursively determine parent records?

2004-10-07 Thread point of no return
http://www.sitepoint.com/print/hierarchical-data-database has a guide on how to do the same thing but in a single SQL query, without looping at all. It is very interesting reading and requires a slight restructuring of how the records are stored to pull off but with the wonderful result in bein

Re: [PHP-DB] Loading large volumes of data

2004-10-07 Thread Evan Morris
I feel a bit stupid now. Indexing the table works super fast by comparison. No idea what made me think the overhead on updating the index was going to outweigh the benefits. Anyway, thanks for the advice. - Original Message - From: "graeme" <[EMAIL PROTECTED]> To: "Evan Morris" <[EMAIL PRO

Re: [PHP-DB] Loading large volumes of data

2004-10-07 Thread graeme
I'd think you want to index the table. Since you are doing a search on an un-index table for each word, that overhead will be more than creating an entry in an index table. Entering an index entry will require the routine to determine where the entry should be but it will be looking for that in

[PHP-DB] Loading large volumes of data

2004-10-07 Thread Evan Morris
This is more a process question that is not specific to PHP, but maybe someone can help me. I have a text file containing strings. The text file is pretty massive, about 895 MB. I need to load the words in the text file into the database in such a way that there is a single occurrence of each word