[PHP] CSV speed

2008-03-10 Thread Danny Brow
I have about 10 csv files I need to open to access data. It takes a lot of time to search each file for the values I need. Would it be best to just dump all the cvs files to an SQL db and then just grab what I need from there? I'm starting to think it would make a lot of sense. What do you guys

Re: [PHP] CSV speed

2008-03-10 Thread Danny Brow
On Mon, 2008-03-10 at 22:36 -0400, Wolf wrote: Danny Brow wrote: I have about 10 csv files I need to open to access data. It takes a lot of time to search each file for the values I need. Would it be best to just dump all the cvs files to an SQL db and then just grab what I need from

Re: [PHP] GPS Locator

2008-03-04 Thread Danny Brow
Wintec makes a nice unit. http://www.wintec.com.tw/en/home.php But you are screwed if the system is in doors. I doubt you would get a GPS signal inside a building. Dan On Tue, 2008-03-04 at 10:18 -0600, Jay Blanchard wrote: Howdy group! I know that this is not a PHP question (but it will

[PHP] DESC order results

2008-01-13 Thread Danny Brow
Just wondering if anyone could tell me how reliable the DESC order option is going to be when I am parsing thousands of records where they are multiple ChartNo's for the same clientNo. Or is there a better way to grab the most recent ChartNo. $link = mysql_connect('localhost', 'myuser',

Re: [PHP] DESC order results

2008-01-13 Thread Danny Brow
Thanks for the answer, didn't think of asking this in a MySQL forum, sorry. Dan On Sun, 2008-01-13 at 20:28 +0100, Jochem Maas wrote: Danny Brow schreef: Just wondering if anyone could tell me how reliable the DESC order option is going to be when I am parsing thousands of records where

[PHP] fgetcsv

2008-01-09 Thread Danny Brow
Hi Everyone, I'm trying to compare a value to the first field in a csv fILE (example of the data below). Using while takes too long and I can't figure out how to compare just one row at a time. I've tried some variations of the following. //Common for all trials $demoID = fopen(newDemoID.csv,

Re: [PHP] fgetcsv

2008-01-09 Thread Danny Brow
, Chris wrote: Danny Brow wrote: Hi Everyone, I'm trying to compare a value to the first field in a csv fILE (example of the data below). Using while takes too long and I can't figure out how to compare just one row at a time. I've tried some variations of the following. So are you

RE: [PHP] fgetcsv

2008-01-09 Thread Danny Brow
Um, I've read the manual. On Wed, 2008-01-09 at 20:11 -0500, Bastien Koert wrote: http://ca.php.net/manual/en/function.fgetcsv.php _ Discover new ways to stay in touch with Windows Live! Visit the City @ Live today!

Re: [PHP] fgetcsv

2008-01-09 Thread Danny Brow
the fgetcsv inside the while loop to get past the first row... :-) On Wed, January 9, 2008 6:09 pm, Danny Brow wrote: I need to compare the first field of each row. But this idea is shot to hell, i've been running one of the examples on the file and it's been about an hour+ already... 6500

[PHP] CSV date issue

2007-01-11 Thread Danny Brow
Hi, It's been a while since I've used php and I'm trying to organize some data by date. The problem I'm having is that when the data changes from say 2006 to 2005 the first few rows of 2005 data goes into my 2006 data and the date for 2006 is lost. My code for separating dates is below with some

Re: [PHP] CSV date issue - Solved

2007-01-11 Thread Danny Brow
Seems my problem was a data issue and I needed to compensate for missing dates. thanks, Dan On Thu, January 11, 2007 2:31 pm, Danny Brow wrote: Hi, It's been a while since I've used php and I'm trying to organize some data by date. The problem I'm having is that when the data changes from

Re: [PHP] test

2005-06-08 Thread Danny Brow
On Tue, 2005-06-07 at 14:46 +0200, Hans J.J. Prins wrote: test Failed. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] linux php editor

2005-06-06 Thread Danny Brow
On Mon, 2005-06-06 at 18:09 -0800, Clive Zagno wrote: the truth is Ive been developing on windows, because of some .net developments. Ive been starting most new projects as web applications and using php/mysql. On windows I used ultredit, then I found a product called phpedit, which I

RE: [PHP] dynamic drop down

2005-06-04 Thread Danny Brow
down is selected? Thanks, Dan. -Original Message- From: Danny Brow [mailto:[EMAIL PROTECTED] Sent: 01 June 2005 07:08 To: PHP-Users Subject: Re: [PHP] dynamic drop down On Tue, 2005-05-31 at 22:08 -0700, Richard Lynch wrote: On Tue, May 31, 2005 8:48 pm, Danny Brow said

Re: [PHP] Delay?

2005-06-02 Thread Danny Brow
On Thu, 2005-06-02 at 15:32 -0400, GamblerZG wrote: Sebastian wrote: yea.. takes hours... sometimes 6+ or more. i dont post that much to the list for this reason.. if it stays like this i'll just unsubscribe.. its pointless... this is suppose to be E-mail, not post office mail. I

Re: [PHP] Mailing list delays

2005-06-02 Thread Danny Brow
On Thu, 2005-06-02 at 17:15 -0700, Rasmus Lerdorf wrote: We found a problem caused by a recent disk failure that wiped out a named pipe qmail needed. I am hoping the mailing list delays should be fixed now. -Rasmus test signature.asc Description: This is a digitally signed message part

Re: [PHP] dynamic drop down

2005-06-01 Thread Danny Brow
On Tue, 2005-05-31 at 22:08 -0700, Richard Lynch wrote: On Tue, May 31, 2005 8:48 pm, Danny Brow said: Could someone point me to an example with code for dynamic drop downs in PHP? I would like to be able to have drop downs like Select Country and another drop down show the states/provinces

[PHP] test

2005-05-31 Thread Danny Brow
signature.asc Description: This is a digitally signed message part

[PHP] test

2005-05-31 Thread Danny Brow
If this gets to the list it's just a test. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] dynamic drop down

2005-05-31 Thread Danny Brow
Could someone point me to an example with code for dynamic drop downs in PHP? I would like to be able to have drop downs like Select Country and another drop down show the states/provinces based on the selected country. Thanks, Dan. signature.asc Description: This is a digitally signed message

Re: [PHP] PHP Applications?

2005-05-17 Thread Danny Brow
On Tue, 2005-05-17 at 15:34 -0400, Brent Baisley wrote: Zend sells a compiler to speed up your PHP code. Since it's compiled, it also does not contain the source code in readable form. You should visit the Zend website. Any free ones? -- PHP General Mailing List (http://www.php.net/) To

[PHP] Starting a big project

2005-05-01 Thread Danny Brow
I'm about to start writing a big web app (mostly in PHP). But I'm not sure if I should layout the DB first then write the app, or should I just start writing the app and add stuff to the DB as I need it. How do you guys go about it? Thanks, Dan. -- PHP General Mailing List (http://www.php.net/)

Re: [PHP] Starting a big project

2005-05-01 Thread Danny Brow
. Just figuring out what is better, DB layout - Write App, or Write app DB at the same time. Mike sent a real good answer, exactly what I was looking for. Thanks for you reply, I'm going to read up on propel even though I will probably not use it for this project. Thanks, Dan On 5/1/05, Danny Brow

Re: [PHP] Best Server OS

2005-03-28 Thread Danny Brow
On Mon, 2005-03-28 at 15:19 -0500, Phil Neeb wrote: I'm lookin for some opinions on this one ... What do you think the best OS is for running a server with PHP and MySQL? If you're going to say Linux, please, which Linux OS, there are so many. Slackware. Dan. -- PHP General Mailing

RE: [PHP] Best Server OS

2005-03-28 Thread Danny Brow
On Mon, 2005-03-28 at 15:58 -0500, Mike wrote: I personally like OpenBSD - though many of the BSDs are similar at many tasks and only have notable differences in a few areas (and it's those areas you should look to find which works best for you). I wonder who will get bored and stir up the

Re: [PHP] Best Server OS

2005-03-28 Thread Danny Brow
On Mon, 2005-03-28 at 23:28 +0200, M. Sokolewicz wrote: Danny Brow wrote: On Mon, 2005-03-28 at 15:58 -0500, Mike wrote: I personally like OpenBSD - though many of the BSDs are similar at many tasks and only have notable differences in a few areas (and it's those areas you should look

[PHP] Postgresql PHP

2005-03-22 Thread Danny Brow
Any recommendations on books for postgresql PHP usage. Thanks, Dan. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Update db with $_POST

2005-03-16 Thread Danny Brow
On Wed, 2005-03-16 at 16:50 +1000, Ligaya Turmelle wrote: assuming you are using PEAR DB - $result = $db-query(UPDATE items SET (item_name, item_desc, item_price, extraprice) VALUES (?,?,?,?) WHERE item_id = 3, array($_POST['title'], $_POST['description'], $_POST['price'],

[PHP] RE: Update db with $_POST

2005-03-15 Thread Danny Brow
Thanks for looking, I figured it out, after RTFM for db, I found that I needed to do field=? instead of using VALUES (). Example: $db-query('UPDATE items SET item_name=?, item_desc=?, item_price=?, extraprice=? WHERE item_id = 3', array($_POST['title'], $_POST['description'],

[PHP] Update db with $_POST

2005-03-15 Thread Danny Brow
I'm trying to update some form data with this db update query and it's not working, I'm not getting an error either. $db-query(UPDATE items SET item_name = $_POST[title], item_desc = $_POST[description], item_price = $_POST[price], extraprice = $_POST[extraprice] WHERE item_id = 3); I've

Re: [PHP] Re: Update db with $_POST

2005-03-15 Thread Danny Brow
On Tue, 2005-03-15 at 18:45 -0500, Jason Barnett wrote: Danny Brow wrote: Thanks for looking, I figured it out, after RTFM for db, I found that I needed to do field=? instead of using VALUES (). Example: $db-query('UPDATE items SET item_name=?, item_desc=?, item_price

Re: [PHP] List gone quiet?

2005-02-25 Thread Danny Brow
On Fri, 2005-02-25 at 11:13 +, Lester Caine wrote: Nothing on list over night? It's a PHP fast :) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] For HomeSite users...

2005-01-20 Thread Danny Brow
.org don't work but www.phpeclipse.de does. Dan. On Fri, 2005-01-21 at 12:06 +1100, [EMAIL PROTECTED] wrote: I havent used Homesite in years, I am now an Eclipse advocate :) www.phpeclipse.org :) OMG! This is quite possibly the coolest thing I've found in a while, and it

Re: [PHP] php editor

2005-01-13 Thread Danny Brow
On Thu, 2005-01-13 at 18:02 +0200, William Stokes wrote: Hello, I'm quite new with writing php code. I was considering of using some kind of php editor program to help with the syntax. Know any goog ones? Thanks -Will I like Komodo. Dan. -- PHP General Mailing List

RE: [PHP] can I compile php source OT

2004-12-21 Thread Danny Brow
Wow I just wasted 10 minutes of my day reading half these post. This is one long thread. And man is it hard to follow. Dan. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] ISP snippet

2004-12-10 Thread Danny Brow
On Thu, 2004-12-09 at 18:17 -0600, Brad Ciszewski wrote: i need help to figure out the isp of a user. can anyone help me with this? http://www.arin.net/whois/ It will give you the owner of the IP address, i.e. Bell, AOL, etc. Whats the reason you need the uses ISP? -Brad

[PHP] Confused - $GLOBALS

2004-12-09 Thread Danny Brow
Below is a snip of a program I am writing, I am a little new to php. Any how, I can't for the life me figure out why one of my functions cannot grab the item_pics1 variable. I have tried passing the variable to the function, tried using $GLOBALS['item_pic1']. So I guess my question is, does PHP in

Re: [PHP] Unsubscribing Junk Emails From the List: requests@firstustrading.com

2004-12-09 Thread Danny Brow
I'm getting it too. On Thu, 2004-12-09 at 09:49 -0800, Justin Palmer wrote: Hi, Every time I send a response to the list I get a auto-reply from: [EMAIL PROTECTED] Is there someone that I could email that can delete this user from the list? Thanks for any information. Regards,

Re: [PHP] Confused - $GLOBALS

2004-12-09 Thread Danny Brow
On Thu, 2004-12-09 at 13:41 -0500, John Nichel wrote: Danny Brow wrote: Below is a snip of a program I am writing, I am a little new to php. Any how, I can't for the life me figure out why one of my functions cannot grab the item_pics1 variable. I have tried passing the variable

Re: [PHP] Confused - $GLOBALS

2004-12-09 Thread Danny Brow
On Thu, 2004-12-09 at 12:40 -0800, Richard Lynch wrote: My best guess from skimming your code is that you need: global $_POST; should I put this at the top of my code with the rest of my variables? in the function that uses $_POST. Or is $_POST always global anyway? No. I always

Re: [PHP] Confused - $GLOBALS

2004-12-09 Thread Danny Brow
On Thu, 2004-12-09 at 15:39 -0500, Roger Spears wrote: Danny Brow wrote: On Thu, 2004-12-09 at 13:41 -0500, John Nichel wrote: Danny Brow wrote: Below is a snip of a program I am writing, I am a little new to php. Any how, I can't for the life me figure out why one of my functions

Re: [PHP] Confused - $GLOBALS

2004-12-09 Thread Danny Brow
On Thu, 2004-12-09 at 12:40 -0800, Richard Lynch wrote: My best guess from skimming your code is that you need: global $_POST; in the function that uses $_POST. Or is $_POST always global anyway? I always forget, because they changed it around on POST/GLOBALS/etc at some point, but

Re: [PHP] Confused - $GLOBALS

2004-12-09 Thread Danny Brow
On Fri, 2004-12-10 at 05:52 +0800, Jason Wong wrote: On Friday 10 December 2004 04:52, Danny Brow wrote: OK, you never said what your problem was except to say everything works but the str_replace item_pics1. Did you check $GLOBALS['errors'] after calling this function? No but I'm doing

[PHP] Creating a directory

2004-11-12 Thread Danny Brow
What's the best way to create a directory with PHP, I tried using: if (array_exists('dir',$_POST)) { $dir_name = test123; shell_exec('mkdir $dir_name'); I don't want to have to declare a variable, I would like to do this all on one line. Like: shell_exec('mkdir

Re: [PHP] Creating a directory

2004-11-12 Thread Danny Brow
Thanks, I should have looked that up. 4am, time for bed. Thanks again, Dan. On Fri, 2004-11-12 at 18:01 +0900, Pluance wrote: Use mkdir in PHP Functions. See Also: http://www.php.net/manual/en/function.mkdir.php On Fri, 12 Nov 2004 03:54:52 -0500, Danny Brow [EMAIL PROTECTED] wrote

Re: [PHP] Creating a directory

2004-11-12 Thread Danny Brow
On Fri, 2004-11-12 at 17:12 +, Jason Wong wrote: On Friday 12 November 2004 08:54, Danny Brow wrote: What's the best way to create a directory with PHP, I tried using: if (array_exists('dir',$_POST)) { $dir_name = test123; I'm 99% sure you mean 'test123'. I meant $dir_name

Re: [PHP] probably stupid, but...

2004-11-12 Thread Danny Brow
On Fri, 2004-11-12 at 15:08 -0500, Robert Sossomon wrote: I have a form that sends 20 rows of data into a script, instead of having to write 20 separate add functions, I wrote this piece of code... $i=1; while ($i20) { if ($_POST[book_title_$i]' != ) // One problem maybe the quote you

RE: [PHP] probably stupid, but...

2004-11-12 Thread Danny Brow
On Fri, 2004-11-12 at 14:35 -0600, Jay Blanchard wrote: [snip] Did that and it fixed only that piece (saw it right after I sent the email out to the group). I am thinking that it is still somewhat of the iterations that are causing problems. I am waiting on the server guy to get back

Re: [PHP] PHP Accelerator

2004-11-07 Thread Danny Brow
On Sun, 2004-11-07 at 07:55 +0200, Jyry Kuukkanen wrote: On Sun, 7 Nov 2004, raditha dissanayake wrote: David wrote: I need a PHP accelerator but am not sure which one to use. I would highly prefer to not use a commercial accelerator and need one that works with PHP 5. Does

Re: [PHP] VOTE TODAY

2004-11-02 Thread Danny Brow
On Tue, 2004-11-02 at 10:50 -0700, Grant wrote: I can't wait for the replies... Here's a reply: Don't vote for Bush. - Grant I'm Canadian, please stop wasting my bandwidth. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Learning PHP5

2004-10-28 Thread Danny Brow
On Thu, 2004-10-28 at 15:03 -0700, Matthew Sims wrote: About a week ago someone was asking where are beginner can go to learn PHP5? This book was just advertised on Slashdot. Learning PHP 5 Only $20 on Amazon.com

Re: [PHP] Learning PHP5

2004-10-28 Thread Danny Brow
On Thu, 2004-10-28 at 20:20 -0500, Greg Donald wrote: On Thu, 28 Oct 2004 19:12:12 -0400, Michael Lauzon [EMAIL PROTECTED] wrote: Unfortunately the PHP.net are not really for beginners, you have to have some programming knowledge to get started using their tutorials...this is just my