Re: [PHP] RE: non-auto increment question

2009-03-15 Thread Jim Lucas
PJ wrote: haliphax wrote: On Fri, Mar 13, 2009 at 1:24 PM, PJ wrote: Jim Lucas wrote: PJ wrote: am resending as this was erroneously ccd to mysql. sorry! Ashley Sheridan wrote: On Thu, 2009-02-26 at 11:27 -0500, PJ wrote: Jerry Schwartz wrote: Being rather new to all this, I understood

Re: [PHP] Which hashing algorithm is best to check file duplicity?

2009-03-15 Thread Martin Zvarík
"Fastest" depends mostly on the size of the file, not the algorithm used. A 2gig file will take a while using md5 as it will using sha1. Using md5 will be slightly quicker than sha1 because generates a shorter hash so the trade-off is up to you. $ ls -lh file.gz 724M 2008-07-28 10:02 file.

Re: [PHP] Which hashing algorithm is best to check file duplicity?

2009-03-15 Thread Chris
Martin Zvarík wrote: I want to store the file's hash to the database, so I can check next time to see if that file was already uploaded (even if it was renamed). What would be the best (= fastest + small chance of collision) algorithm in this case? "Fastest" depends mostly on the size of the

Re: [PHP] Which hashing algorithm is best to check file duplicity?

2009-03-15 Thread Paul M Foster
On Sun, Mar 15, 2009 at 10:25:11PM +0100, Martin Zvarík wrote: > I want to store the file's hash to the database, so I can check next > time to see if that file was already uploaded (even if it was renamed). > > What would be the best (= fastest + small chance of collision) algorithm > in this cas

Re: [PHP] Which hashing algorithm is best to check file duplicity?

2009-03-15 Thread Jan G.B.
2009/3/15 Martin Zvarík : > I want to store the file's hash to the database, so I can check next time to > see if that file was already uploaded (even if it was renamed). > > What would be the best (= fastest + small chance of collision) algorithm in > this case? > > Is crc32 a good choice? guess n

[PHP] Which hashing algorithm is best to check file duplicity?

2009-03-15 Thread Martin Zvarík
I want to store the file's hash to the database, so I can check next time to see if that file was already uploaded (even if it was renamed). What would be the best (= fastest + small chance of collision) algorithm in this case? Is crc32 a good choice? Thank you in advance, Martin -- PHP Gen

Re: [PHP] Problem with passing and Area in a $_POST

2009-03-15 Thread Jan G.B.
2009/3/15 Jason Pruim : > Personally... I don't care who's code it is, if it was me, I'd still go > out and validate it... If someone typed something out real quick and > missed a period, it wouldn't be their fault :) > > As has been said by some big higher up's in this very mailing list... "Treat

Re: [PHP] Problem with passing and Area in a $_POST

2009-03-15 Thread Jason Pruim
Richard Kurth wrote: tedd wrote: At 8:56 AM -0700 3/15/09, Richard Kurth wrote: This is the form that is being sent as a post and the fieldorder[] is the part that is not sending properly. But it has worked for about a year in the script. It just stopped working. and I did not change anythin

Re: [PHP] Re: GeoIP?

2009-03-15 Thread Nitsan Bin-Nun
Hi Michelle, Try to use sqlite instead of any other database. It will be better I guess. Regards, Nitsan On Sun, Mar 15, 2009 at 9:08 PM, zerof wrote: > Michelle Konzack escreveu: > >> Hello Nitsan, >> >> Am 2009-03-15 15:39:26, schrieb Nitsan Bin-Nun: >> >>> Take a look at this: >>> http://ww

Re: [PHP] left join does not work, why?

2009-03-15 Thread Jan G.B.
2009/3/15 PJ : >> -Original Message- >> From: Jan G.B. [mailto:ro0ot.w...@googlemail.com] >> so this is just wrong: >> $x = " select * >> // from foo >> from bar"; >> and that query would be valid >> "SELECT this/*, that*/ from x" >> > It took ma a bit of thinking, I must say, but the answe

Re: [PHP] Problem with passing and Area in a $_POST

2009-03-15 Thread Richard Kurth
tedd wrote: At 8:56 AM -0700 3/15/09, Richard Kurth wrote: This is the form that is being sent as a post and the fieldorder[] is the part that is not sending properly. But it has worked for about a year in the script. It just stopped working. and I did not change anything in this script -s

Re: [PHP] left join does not work, why?

2009-03-15 Thread PJ
Marc Christopher Hall wrote: > Not to mention if this is written for v 5 then you need to wrap your joins > in () > > -Original Message- > From: Jan G.B. [mailto:ro0ot.w...@googlemail.com] > Sent: Sunday, March 15, 2009 9:47 AM > To: PJ > Cc: Daniel Brown; php-general@lists.php.net > Subje

[PHP] Re: GeoIP?

2009-03-15 Thread zerof
Michelle Konzack escreveu: Hello Nitsan, Am 2009-03-15 15:39:26, schrieb Nitsan Bin-Nun: Take a look at this: http://www.maxmind.com/app/geolitecountry Use indexes, I think the checkup won't take long. ... For a long time I'm using the geolitecountry without no problems. The

Re: [PHP] Problem with passing and Area in a $_POST

2009-03-15 Thread tedd
At 8:56 AM -0700 3/15/09, Richard Kurth wrote: This is the form that is being sent as a post and the fieldorder[] is the part that is not sending properly. But it has worked for about a year in the script. It just stopped working. and I did not change anything in this script -snip- code If

[PHP] Re: GeoIP?

2009-03-15 Thread Michelle Konzack
Hello Per, Am 2009-03-15 15:12:47, schrieb Per Jessen: > The easiest is to use a DNS service - this is the best one I know: > http://countries.nerd.dk/ This is cool... OK, I have imported the ISO codes list and it just works how it should. Thanks, Greetings and nice Day/Evening Michelle Kon

Re: [PHP] Problem with passing and Area in a $_POST

2009-03-15 Thread Richard Kurth
Phpster wrote: I don't think that fieldorder needs to be an array. I don't see you using it as a multiselect. Does this field occur multiple times on the form? Bastien Sent from my iPod On Mar 15, 2009, at 11:56, Richard Kurth wrote: Shawn McKenzie wrote: tedd wrote: At 6:31 PM -0700

RE: [PHP] left join does not work, why?

2009-03-15 Thread Marc Christopher Hall
Not to mention if this is written for v 5 then you need to wrap your joins in () -Original Message- From: Jan G.B. [mailto:ro0ot.w...@googlemail.com] Sent: Sunday, March 15, 2009 9:47 AM To: PJ Cc: Daniel Brown; php-general@lists.php.net Subject: Re: [PHP] left join does not work, why? 2

Re: [PHP] Problem with passing and Area in a $_POST

2009-03-15 Thread Phpster
I don't think that fieldorder needs to be an array. I don't see you using it as a multiselect. Does this field occur multiple times on the form? Bastien Sent from my iPod On Mar 15, 2009, at 11:56, Richard Kurth wrote: Shawn McKenzie wrote: tedd wrote: At 6:31 PM -0700 3/14/09, Ric

Re: [PHP] Problem with passing and Area in a $_POST

2009-03-15 Thread Richard Kurth
Shawn McKenzie wrote: tedd wrote: At 6:31 PM -0700 3/14/09, Richard Kurth wrote: I have a script that is passing a area in a $_POST and it does not pass the data. When I try to look at the data with $_POST['fieldorder'] it its empty but when I look at it with $_REQUEST['fieldorder'] the

Re: [PHP] Problem with passing and Area in a $_POST

2009-03-15 Thread Richard Kurth
tedd wrote: At 6:31 PM -0700 3/14/09, Richard Kurth wrote: I have a script that is passing a area in a $_POST and it does not pass the data. When I try to look at the data with $_POST['fieldorder'] it its empty but when I look at it with $_REQUEST['fieldorder'] the data is there. This seams very

Re: [PHP] Problem with passing and Area in a $_POST

2009-03-15 Thread Shawn McKenzie
tedd wrote: > At 6:31 PM -0700 3/14/09, Richard Kurth wrote: >> I have a script that is passing a area in a $_POST and it does not pass >> the data. When I try to look at the data with $_POST['fieldorder'] it >> its empty but when I look at it with $_REQUEST['fieldorder'] the data is >> there. This

[PHP] Re: GeoIP?

2009-03-15 Thread Michelle Konzack
Hello Nitsan, Am 2009-03-15 15:39:26, schrieb Nitsan Bin-Nun: > Take a look at this: > http://www.maxmind.com/app/geolitecountry > > Use indexes, I think the checkup won't take long. I have it installed (php5-geoip, 1.0.3-1) , but it is realy slow OK, now I have greped for DE and the database i

Re: [PHP] GeoIP?

2009-03-15 Thread Per Jessen
Michelle Konzack wrote: > Hello, > > I am in creation of a WaveLAN service in Germany and my HTML-Form > is > DoS'ed be idiots outside of Germany. Can someone tell me how to > prevent peoples, filling out the form without being in Germany? > > Note: I do not want to load the whole GeoIP Dat

Re: [PHP] left join does not work, why?

2009-03-15 Thread Jan G.B.
2009/3/15 PJ : > Daniel Brown wrote: >> On Sat, Mar 14, 2009 at 19:51, PJ wrote: >> >>> $sql1 = "SELECT b.id, b.title, b.sub_title, b.descr, b.comment, >>> b.bk_cover, b.copyright, b.ISBN, b.language, b.sellers, c.publisher, <--- >>> CONCAT_WS(' ', first_name, last_name) AS Author >>> FROM book AS

Re: [PHP] GeoIP?

2009-03-15 Thread Nitsan Bin-Nun
Take a look at this: http://www.maxmind.com/app/geolitecountry Use indexes, I think the checkup won't take long. HTH, Nitsan On Sun, Mar 15, 2009 at 3:06 PM, tedd wrote: > At 1:52 PM +0100 3/15/09, Michelle Konzack wrote: > >> Hello, >> >> I am in creation of a WaveLAN service in Germany and

Re: [PHP] left join does not work, why?

2009-03-15 Thread 9el
--- Use FreeOpenSourceSoftwares, Stop piracy, Let the developers live. Get a Free CD of Ubuntu mailed to your door without any cost. Visit : www.ubuntu.com -- On

Re: [PHP] GeoIP?

2009-03-15 Thread tedd
At 1:52 PM +0100 3/15/09, Michelle Konzack wrote: Hello, I am in creation of a WaveLAN service in Germany and my HTML-Form is DoS'ed be idiots outside of Germany. Can someone tell me how to prevent peoples, filling out the form without being in Germany? Note: I do not want to load the whol

Re: [PHP] left join does not work, why?

2009-03-15 Thread PJ
Daniel Brown wrote: > On Sat, Mar 14, 2009 at 19:51, PJ wrote: > >> $sql1 = "SELECT b.id, b.title, b.sub_title, b.descr, b.comment, >> b.bk_cover, b.copyright, b.ISBN, b.language, b.sellers, c.publisher, <--- >> CONCAT_WS(' ', first_name, last_name) AS Author >> FROM book AS b >> LEFT JOIN book

Re: [PHP] Problem with passing and Area in a $_POST

2009-03-15 Thread tedd
At 6:31 PM -0700 3/14/09, Richard Kurth wrote: I have a script that is passing a area in a $_POST and it does not pass the data. When I try to look at the data with $_POST['fieldorder'] it its empty but when I look at it with $_REQUEST['fieldorder'] the data is there. This seams very strange to m

[PHP] Re: GeoIP?

2009-03-15 Thread Michelle Konzack
Forgotten one thing: Am 2009-03-15 13:52:52, schrieb Michelle Konzack: > Hello, > > I am in creation of a WaveLAN service in Germany and my HTML-Form is > DoS'ed be idiots outside of Germany. Can someone tell me how to prevent > peoples, filling out the form without being in Germany? > > No

[PHP] GeoIP?

2009-03-15 Thread Michelle Konzack
Hello, I am in creation of a WaveLAN service in Germany and my HTML-Form is DoS'ed be idiots outside of Germany. Can someone tell me how to prevent peoples, filling out the form without being in Germany? Note: I do not want to load the whole GeoIP Database in my scripts. Or is there a Free

[PHP] how can genrate different URLs but showing same html page

2009-03-15 Thread rahulb
Hi, I am developing forum website as my final year project. I am having problem in generating different URLs but keeping the same page.. Scenario: I am showing threads for different languages in different page, but since format of data is same for threads of all the languages, so what i planned w