Re: [PHP] A MySQL Question

2008-12-08 Thread Yeti
Who says the big bang is past? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] A MySQL Question

2008-12-08 Thread Robert Cummings
On Tue, 2008-12-09 at 17:40 +1300, German Geek wrote: > On Tue, Dec 9, 2008 at 3:51 PM, Micah Gersten <[EMAIL PROTECTED]> wrote: > > > German Geek wrote: > > > On Tue, Dec 9, 2008 at 2:46 PM, Micah Gersten <[EMAIL PROTECTED] > > > > wrote: > > > > > > Robert Cummings

Re: [PHP] A MySQL Question

2008-12-08 Thread German Geek
On Tue, Dec 9, 2008 at 3:51 PM, Micah Gersten <[EMAIL PROTECTED]> wrote: > German Geek wrote: > > On Tue, Dec 9, 2008 at 2:46 PM, Micah Gersten <[EMAIL PROTECTED] > > > wrote: > > > > Robert Cummings wrote: > > > On Tue, 2008-12-09 at 00:16 +, Nathan Rixham wr

Re: [PHP] A MySQL Question

2008-12-08 Thread Nathan Rixham
Micah Gersten wrote: Robert Cummings wrote: On Mon, 2008-12-08 at 19:46 -0600, Micah Gersten wrote: Robert Cummings wrote: On Tue, 2008-12-09 at 00:16 +, Nathan Rixham wrote: Ashley Sheridan wrote: On Mon, 2008-12-08 at 23:23 +, [EMAIL PROTECTED] wrote

Re: [PHP] A MySQL Question

2008-12-08 Thread Micah Gersten
German Geek wrote: > On Tue, Dec 9, 2008 at 2:46 PM, Micah Gersten <[EMAIL PROTECTED] > > wrote: > > Robert Cummings wrote: > > On Tue, 2008-12-09 at 00:16 +, Nathan Rixham wrote: > > > >> Ashley Sheridan wrote: > >> > >>> On Mon, 2008-12-08 at

Re: [PHP] A MySQL Question

2008-12-08 Thread Micah Gersten
Robert Cummings wrote: > On Mon, 2008-12-08 at 19:46 -0600, Micah Gersten wrote: > >> Robert Cummings wrote: >> >>> On Tue, 2008-12-09 at 00:16 +, Nathan Rixham wrote: >>> >>> Ashley Sheridan wrote: > On Mon, 2008-12-08 at 23:23 +, [EMAIL P

Re: [PHP] A MySQL Question

2008-12-08 Thread Robert Cummings
On Mon, 2008-12-08 at 19:46 -0600, Micah Gersten wrote: > Robert Cummings wrote: > > On Tue, 2008-12-09 at 00:16 +, Nathan Rixham wrote: > > > >> Ashley Sheridan wrote: > >> > >>> On Mon, 2008-12-08 at 23:23 +, [EMAIL PROTECTED] wrote: > >>> > Presumable, the EXISTS sub-

Re: [PHP] A MySQL Question

2008-12-08 Thread German Geek
On Tue, Dec 9, 2008 at 2:46 PM, Micah Gersten <[EMAIL PROTECTED]> wrote: > Robert Cummings wrote: > > On Tue, 2008-12-09 at 00:16 +, Nathan Rixham wrote: > > > >> Ashley Sheridan wrote: > >> > >>> On Mon, 2008-12-08 at 23:23 +, [EMAIL PROTECTED] wrote: > >>> > Presumable, the EXISTS s

Re: [PHP] A MySQL Question

2008-12-08 Thread Micah Gersten
Robert Cummings wrote: > On Tue, 2008-12-09 at 00:16 +, Nathan Rixham wrote: > >> Ashley Sheridan wrote: >> >>> On Mon, 2008-12-08 at 23:23 +, [EMAIL PROTECTED] wrote: >>> Presumable, the EXISTS sub-query can be optimized sometimes to just stop processing the sub-q

Re: [PHP] A MySQL Question

2008-12-08 Thread Robert Cummings
On Tue, 2008-12-09 at 00:16 +, Nathan Rixham wrote: > Ashley Sheridan wrote: > > On Mon, 2008-12-08 at 23:23 +, [EMAIL PROTECTED] wrote: > >> Presumable, the EXISTS sub-query can be optimized sometimes to just stop > >> processing the sub-query and kick things back out to the outer query.

Re: [PHP] A MySQL Question

2008-12-08 Thread Nathan Rixham
Ashley Sheridan wrote: On Mon, 2008-12-08 at 23:23 +, [EMAIL PROTECTED] wrote: Presumable, the EXISTS sub-query can be optimized sometimes to just stop processing the sub-query and kick things back out to the outer query. IN has to process them all and find them all. Don't forget the

[PHP] PHP 5.2.8 Released

2008-12-08 Thread Ilia Alshanetsky
The PHP development team would like to announce the immediate availability of PHP 5.2.8. This release addresses a regression introduced by 5.2.7 in regard to the magic_quotes functionality, that was broken by an incorrect fix to the filter extension. All users who have upgraded to 5.2.7 are

Re: [PHP] Request to bash/jump/screw my code

2008-12-08 Thread ceo
> * Your output isn't cleaned up when coming from the database. You need > to put a few stripslashes() instances in there. Actually, if you think you have to use stripslashes, then, in fact, you've used addslashes and/or Magic Quotes TWICE, and your db has BAD DATA in it. Fix the data int

Re: [PHP] A MySQL Question

2008-12-08 Thread Ashley Sheridan
On Mon, 2008-12-08 at 23:23 +, [EMAIL PROTECTED] wrote: > Presumable, the EXISTS sub-query can be optimized sometimes to just stop > processing the sub-query and kick things back out to the outer query. > > > > IN has to process them all and find them all. > > > Don't forget the special

Re: [PHP] A MySQL Question

2008-12-08 Thread ceo
Presumable, the EXISTS sub-query can be optimized sometimes to just stop processing the sub-query and kick things back out to the outer query. IN has to process them all and find them all. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Accounting component in PHP

2008-12-08 Thread German Geek
You can do raw SQL queries with ORM as well, at least in symfony ;). An ORM makes other, rather trivial queries a whole lot easier though and a framework like symfony makes development of generic requirements a lot faster and cleaner. On Tue, Dec 9, 2008 at 4:07 AM, altern <[EMAIL PROTECTED]> wrot

Re: [PHP] Request to bash/jump/screw my code

2008-12-08 Thread Ryan S
> Any advise is also most welcome. 'Advise' is a verb. 'Advice' is a noun. No charge. LOL! Thanks! Got caught by the grammar and typo police but no ticket! Must be my lucky day! Cheers! R -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.ne

Re: [PHP] Request to bash/jump/screw my code

2008-12-08 Thread Daniel Brown
On Mon, Dec 8, 2008 at 1:05 PM, Rick Pasotto <[EMAIL PROTECTED]> wrote: > > http://ezee.se/funnies/show_funny.php?id=p88&sec=1 has: > > Posted by: \' OR id != \' On: 2008-12-08 13:24:59 > \' OR id != \' That was me, testing for SQL injection. -- http://www.parasane.net/ [EMAIL PRO

Re: [PHP] Request to bash/jump/screw my code

2008-12-08 Thread Rick Pasotto
On Mon, Dec 08, 2008 at 09:01:56AM -0800, Ryan S wrote: > Hello everyone, > > Recently I worked on a rather decent sized project and it just went > live yesterday. > > We cannot really afford a security specialist so would appreciate it > if you could hit our site with whatever you want to (just

Re: [PHP] Request to bash/jump/screw my code

2008-12-08 Thread Rick Pasotto
On Mon, Dec 08, 2008 at 09:01:56AM -0800, Ryan S wrote: > > Any advise is also most welcome. 'Advise' is a verb. 'Advice' is a noun. No charge. -- "I didn't understand this at first, but YOUR CONVINCING USE OF CAPITAL LETTERS HAS MADE IT ALL CLEAR TO ME." -- J. Nairn Rick Pasotto[EMA

Re: [PHP] Request to bash/jump/screw my code

2008-12-08 Thread Daniel Brown
On Mon, Dec 8, 2008 at 12:01 PM, Ryan S <[EMAIL PROTECTED]> wrote: > > We cannot really afford a security specialist so would appreciate it if you > could hit our site with whatever you want to (just dont take us offline with > something like a DDOS please) and tell us if you find any problems.

[PHP] Request to bash/jump/screw my code

2008-12-08 Thread Ryan S
Hello everyone, Recently I worked on a rather decent sized project and it just went live yesterday. We cannot really afford a security specialist so would appreciate it if you could hit our site with whatever you want to (just dont take us offline with something like a DDOS please) and tell us

Re: [PHP] A MySQL Question

2008-12-08 Thread Robert Cummings
On Mon, 2008-12-08 at 10:19 -0500, Andrew Ballard wrote: > On Sun, Dec 7, 2008 at 12:38 PM, Robert Cummings <[EMAIL PROTECTED]> wrote: > > On Sun, 2008-12-07 at 11:01 -0500, Eric Butera wrote: > >> Sounds like someone thinks they're pretty clever. I'll never > >> understand why interviewers want t

[PHP] Guidance on enhancing functionality

2008-12-08 Thread Stephen
I want to enhance my web site’s display of photographs. I currently have a Gallery menu selection and that leads to a PHP script that, based on parameters will 1) Display all categories of photos 2) Display the thumbnails of a selected category 3) Display a selected picture I have a table (My

Re: [PHP] A MySQL Question

2008-12-08 Thread Andrew Ballard
On Sun, Dec 7, 2008 at 12:38 PM, Robert Cummings <[EMAIL PROTECTED]> wrote: > On Sun, 2008-12-07 at 11:01 -0500, Eric Butera wrote: >> Sounds like someone thinks they're pretty clever. I'll never >> understand why interviewers want to ask really odd edge case questions >> instead of ones that real

[PHP] Accounting component in PHP

2008-12-08 Thread altern
Hello, guys. Could please someone recommend me component wiritten in PHP which makes financial calculations with predefined logic? I have DB with sales information in several tables and I need to implement business logic that includes many rules of charging, different interest rates and so on. I n

Re: [PHP] MSSQL_CONNECT problem

2008-12-08 Thread Bastien Koert
On Mon, Dec 8, 2008 at 9:45 AM, Dan Shirah <[EMAIL PROTECTED]> wrote: > > > > Can't seem to connect with MSSQL_CONNECT. The function IS available. I'm > > in a Windows environment, connecting to a SQL 2000 instance. My code: > > > > mssql_connect('INTRA_SQL,1433', 'uname', 'password'); > > mssql_s

RE: [PHP] MSSQL_CONNECT problem

2008-12-08 Thread David Stoltz
Hi Dan, Yes, I have: extension=php_mssql.dll uncommented I am using dll version "2000.80.194.0" which seems to be recommended for connection problems like this... And yes - this web server talks to the SQL server on other pages using ASPit seems to just be a PHP connection problem. S

Re: [PHP] MSSQL_CONNECT problem

2008-12-08 Thread Dan Shirah
> > Can't seem to connect with MSSQL_CONNECT. The function IS available. I'm > in a Windows environment, connecting to a SQL 2000 instance. My code: > > mssql_connect('INTRA_SQL,1433', 'uname', 'password'); > mssql_select_db('database'); > > I've tried leaving the port out, tried using server IP ad

[PHP] MSSQL_CONNECT problem

2008-12-08 Thread David Stoltz
Folks, Can't seem to connect with MSSQL_CONNECT. The function IS available. I'm in a Windows environment, connecting to a SQL 2000 instance. My code: mssql_connect('INTRA_SQL,1433', 'uname', 'password'); mssql_select_db('database'); I've tried leaving the port out, tried using server IP address,

[PHP] Re: [PHP-DEV] Re: PHP 5.3.0alpha3

2008-12-08 Thread Pierre Joye
hi! On Mon, Dec 8, 2008 at 12:50 PM, Rodrigo Saboya <[EMAIL PROTECTED]> wrote: > All links at http://windows.php.net/qa/ are 404. Fixed, the files were there but a change I made in the scripts was setting the wrong directory. Thanks for the head up! Cheers, -- Pierre http://blog.thepimp.net |

Re: [PHP] Include directive..

2008-12-08 Thread German Geek
On Tue, Dec 9, 2008 at 12:47 AM, dele454 <[EMAIL PROTECTED]> wrote: > > Hi, > > I am modifying the apache config file on my domain to include the path to > the Zend Framework on a specified location outside the public folder. > > So in my http.conf file i simply include the path to where the inclu

Re: [PHP] Include directive..

2008-12-08 Thread Jochem Maas
dele454 schreef: > Hi, > > I am modifying the apache config file on my domain to include the path to > the Zend Framework on a specified location outside the public folder. > > So in my http.conf file i simply include the path to where the includes file > is to customise the virtual host: > > [C

Re: [PHP] Include directive..

2008-12-08 Thread Jason Pruim
On Dec 8, 2008, at 6:47 AM, dele454 wrote: Hi, I am modifying the apache config file on my domain to include the path to the Zend Framework on a specified location outside the public folder. So in my http.conf file i simply include the path to where the includes file is to customise th

[PHP] Re: PHP 5.3.0alpha3

2008-12-08 Thread Rodrigo Saboya
Lukas Kahwe Smith wrote: Hello! Johannes has packaged PHP 5.3.0alpha3, which you can find here: http://downloads.php.net/johannes/ Windows binaries thanks to Pierre, which are available here: http://windows.php.net/qa/ Please test it carefully, and report any bugs in the bug system, but only

[PHP] Include directive..

2008-12-08 Thread dele454
Hi, I am modifying the apache config file on my domain to include the path to the Zend Framework on a specified location outside the public folder. So in my http.conf file i simply include the path to where the includes file is to customise the virtual host: [CODE] # To customize this VirtualH

RE: [PHP] Downloading file from local network machine

2008-12-08 Thread Mayer, Jonathan
Cheers Ash et al... got it working now using fileread(), based on the example on php.net. I have it in a separate download.php file which takes a variety of inputs and spews out a file download. Many thanks all. -Original Message- From: Ashley Sheridan [mailto:[EMAIL PROTECTED] Sent: 05

Re: [PHP] Refresh (F5) adds another SQL record.

2008-12-08 Thread Bhupendra Patel
If the user hits the back button and then the forward, it sometimes resubmits the form. This is why i initiated the session and ended it at the end of the data processing page. If they happen to press forward, or back, it will still not initiate the form unless they have actually visitied and submi

Re: [PHP] Poll of sorts: Javascript Form validation or PHP

2008-12-08 Thread Per Jessen
tedd wrote: > The php routine also passed [EMAIL PROTECTED], which is real -- but > it's interesting that most email (if not all) programs cannot show > the domain name correctly, which is [EMAIL PROTECTED] I have yet to find an > email program that can show IDNS correctly. Tedd, I've got a disti

Re: [PHP] Poll of sorts: Javascript Form validation or PHP

2008-12-08 Thread Per Jessen
tedd wrote: > At 5:10 PM +0100 12/7/08, Per Jessen wrote: >> You cannot have 8bit characters to the left of the @ in the email >> address. > > > I'm not sure that's correct. I am sure. In fact, the entire email header must not contain any 8-bit characters. I.e. it _can_, but it is a violat