Re: [PHP] searching date

2003-08-15 Thread Jonatan Pugliese. 
"select * from 'news' where 'date' between '$date_begin' and '$date_last'";

i hope this code is ok?

my english is very poor !


- Original Message - 
From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 14, 2003 5:36 PM
Subject: [PHP] searching date


> Hi ,
> 
> The  user  have to choose 2 date ($date_begin & $date_last) and i want
> to  know  howcan  i  make  to find field in mysql where field included
> between ($date_begin & $date_last)
> 
> "SELECT  *  FROM  `news`  WHERE  `date`  included  in  ($date_begin  &
> $date_last)"
> 
> -- 
> Best salutations,
>  Admin mailto:[EMAIL PROTECTED]
> http://clubafricain.partout.org
> 
> Post-Joint : .
> 
> 
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] PHP.ini file and register_globals

2003-08-15 Thread Jonatan Pugliese. 
never reboot !!
is not necessary !
- Original Message - 
From: "Ben C." <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 15, 2003 2:14 PM
Subject: [PHP] PHP.ini file and register_globals


> I have a quick simple question.  I am using PHP 4.2.3 on Linux.  I am
trying to turn register_globals from off to on.  Is all that I need to do
change it from off to on in the php.ini file?  Do you I need to reboot to
have the changes go into effect?  Sorry for a simple question but I am new
at configuring PHP.  Thanks for the help.
>
>
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] PHP.ini file and register_globals

2003-08-15 Thread Jonatan Pugliese. 
yes you must to restart your webserver !!
type  /etc/init.d/httpd restart

- Original Message - 
From: "Jay Blanchard" <[EMAIL PROTECTED]>
To: "Jonatan Pugliese." <[EMAIL PROTECTED]>; "Ben C."
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, August 15, 2003 2:18 PM
Subject: RE: [PHP] PHP.ini file and register_globals


> [snip]
> never reboot !!
> is not necessary !
> [/snip]
>
> But you might want to restart your web server.
>
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] String parsing help

2003-08-20 Thread Jonatan Pugliese. 
$vector=split( " ", $string, );


$City=$vector[0];
$State=$vector[1];
$Zip=$vector[2]:

- Original Message - 
From: "Matt Matijevich" <[EMAIL PROTECTED]>
To: "<" <[EMAIL PROTECTED]>
Sent: Wednesday, August 20, 2003 5:11 PM
Subject: [PHP] String parsing help


> I have have a string that I need to split into 3 different variables:
> City,State, and Zip.  Here is a couple examples of the strings I need to
> parse:
> 
> ANCHORAGE  AK  99507-6420
> JUNEAU  AK  99801
> NORTH LITTLE ROCK  AR  72118-5227
> 
> Does anyone have an idea how I could slit this into the appropriate
> variables, maybe some kind of regular expression?  I cant use the space
> character to split the data because some of the city names have spaces
> in them.
> 
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] String parsing help

2003-08-21 Thread Jonatan Pugliese. 
it's true my example is bad
I no evaluate the last line

sorry !!!


- Original Message - 
From: "CPT John W. Holmes" <[EMAIL PROTECTED]>
To: "Jonatan Pugliese." <[EMAIL PROTECTED]>; "Matt Matijevich"
<[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, August 20, 2003 5:44 PM
Subject: Re: [PHP] String parsing help


> From: "Jonatan Pugliese." <[EMAIL PROTECTED]>
> > From: "Matt Matijevich" <[EMAIL PROTECTED]>
> > > I have have a string that I need to split into 3 different variables:
> > > City,State, and Zip.  Here is a couple examples of the strings I need
to
> > > parse:
> > >
> > > ANCHORAGE  AK  99507-6420
> > > JUNEAU  AK  99801
> > > NORTH LITTLE ROCK  AR  72118-5227
> > >
> > > Does anyone have an idea how I could slit this into the appropriate
> > > variables, maybe some kind of regular expression?  I cant use the
space
> > > character to split the data because some of the city names have spaces
> > > in them.
> >
> > $vector=split( " ", $string, );
> >
> >
> > $City=$vector[0];
> > $State=$vector[1];
> > $Zip=$vector[2]:
>
> Umm, no. then you'll have $City = "North", $State = "Little" and $Zip =
> "Rock" with the last example.
>
> The following works:
>
> 
> $str = "NORTH LITTLE ROCK  AR  72118-5227
> JUNEAU  AK  99801
> ANCHORAGE  AK  99507-6420
> NORTH CARO  MI  48732
> ";
>
>
preg_match_all('/^(.*)([a-z]{2})\s+([0-9]{5}(-[0-9]{4})?)/im',$str,$matches)
> ;
>
> $count = count($matches[1]);
>
> echo $count . ' addresses found:';
>
> for($x=0;$x<$count;$x++)
> {
> $city = trim($matches[1][$x]);
> $state = trim($matches[2][$x]);
> $zip = trim($matches[3][$x]);
> echo "City: $city, State: $state, ZIP: $zip";
> }
>
> ?>
>
> ---John Holmes...
>
>
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Mailing List Weirdness

2003-08-21 Thread Jonatan Pugliese. 
yes
me too
- Original Message - 
From: "Van Andel, Robbert" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 21, 2003 1:35 PM
Subject: [PHP] Mailing List Weirdness


> The last two posts I sent to this mailing list produced a flurry of emails
> from various locations including majordomo stating it couldnt' understand
> the command I just sent it, a reply from a e-commerce site stating my
order
> has been received, and others.  Anyone else running into this?
>
> Robbert van Andel
>
>
>


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Mailing List Weirdness

2003-08-21 Thread Jonatan Pugliese. 
but I never send an unsuscribed mail !



- Original Message - 
From: "Dan Van Derveer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 21, 2003 2:19 PM
Subject: RE: [PHP] Mailing List Weirdness


> Most mailing lists(I don't know about this one because I have yet to
> unsubscribe) require confirmation of the unsub too. I was thinking maybe
us
> users can attempt to remove these other mailing lists for ourselves.
>
> Dan
>
> -Original Message-
> From: Van Andel, Robbert [mailto:[EMAIL PROTECTED]
> Sent: Thursday, August 21, 2003 12:45 PM
> To: [EMAIL PROTECTED]
> Subject: RE: [PHP] Mailing List Weirdness
>
> Is there no confirmation anymore when subscribing to the list??  I seem to
> recall that once I added my email I got several emails from this mailing
> list asking me to confirm the subscription.  These returned emails are a
> pain in the a** if you ask me, or even if you don't :D
>
> Robbert van Andel
>
>
>
> -Original Message-
> From: Jonatan Pugliese. [mailto:[EMAIL PROTECTED]
> Sent: Thursday, August 21, 2003 9:38 AM
> To: Van Andel, Robbert; [EMAIL PROTECTED]
> Subject: Re: [PHP] Mailing List Weirdness
>
>
> yes
> me too
> - Original Message - 
> From: "Van Andel, Robbert" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, August 21, 2003 1:35 PM
> Subject: [PHP] Mailing List Weirdness
>
>
> > The last two posts I sent to this mailing list produced a flurry of
emails
> > from various locations including majordomo stating it couldnt'
understand
> > the command I just sent it, a reply from a e-commerce site stating my
> order
> > has been received, and others.  Anyone else running into this?
> >
> > Robbert van Andel
> >
> >
> >
>
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] ignore - test

2003-08-21 Thread Jonatan Pugliese. 
test !!
- Original Message - 
From: "Chris W. Parker" <[EMAIL PROTECTED]>
To: "Curt Zirzow" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, August 21, 2003 5:07 PM
Subject: RE: [PHP] Mailing List Weirdness


> Curt Zirzow 
> on Thursday, August 21, 2003 1:09 PM said:
> 
> > The issue has been resolved, I am currently getting these
> > autoresponders off the list.
> 
> Hurray!
> 
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] sql faq

2003-09-24 Thread Jonatan Pugliese. 
select MaeSocio.* from MaeSocio
LEFT JOIN MaeSeguro ON MaeSocio.NroSocio=MaeSeguro.NroSocio
where MaeSeguro.NroSocio is null

MaeSeguro.NroSocio is not null

count(*) MaeSocio = 354000
count(*) MaeSeguro=108000

how i can retype this query?





Jonatan Pugliese
Area Sistemas
ACA - Automovil club Argentino
4808-4676 / 4663
www.aca.org.ar  

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php