Re: [PHP-DB] Auto Responses?
Problems guys... Emails don't actually "come" from [EMAIL PROTECTED] they are sent to [EMAIL PROTECTED] and then sent like it was an email from the sender to x subscriber... Really you should be suggesting that the subjects be used in the event/filter things. Autoresponders DO have their uses (business people, as long as they aren't using their business account for lists) to ones that are, sign up for a free hotmail/yahoo/gmail/* webmail account and get php list stuff sent there instead (there are many people on this list with free gmail invites if you still need them). That or ask your network admin/postmaster/yourself (if your that lucky) to setup another account for you On Mon, 24 Jan 2005 15:33:57 +0800, Jason Wong <[EMAIL PROTECTED]> wrote: > On Monday 24 January 2005 02:13, Samar wrote: > > On Mon, 24 Jan 2005 01:56:03 +0800, Jason Wong <[EMAIL PROTECTED]> wrote: > > > More specifically, smart autoresponders will not respond to mailing > > > lists, bounces, etc. > > > > If they are some kind of extensions or plug-ins to email clients, I > > guess you could put up some more info on them to enlighten all of us > > and these "out of office" and "on vacation to Hawai" people. :) > > This is getting way off topic. I don't use any autoresponders on my mail > client so I can't give any advice there (but I'm sure google can). I only use > autoresponders on my mailserver. These look at the headers of the incoming > mail to determine whether an autoresponse is appropriate. The autoresponders > will also limit the number of autoresponses so that if eg your friend sends > you 100 mails, they will not be told 100 times that you're having a whale of > a time in Hawaii, it will only frustrate them and foment envy :). > > So if your autoresponder doesn't have at least those 2 features, complain > loudly, or find a better one (or a better mail client). > > -- > Jason Wong -> Gremlins Associates -> www.gremlins.biz > Open Source Software Systems Integrators > * Web Design & Hosting * Internet & Intranet Applications Development * > -- > Search the list archives before you post > http://marc.theaimsgroup.com/?l=php-db > -- > New Year Resolution: Ignore top posted posts > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > My 1 cent (50% OSS Discount) -- N Jones -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Auto Responses?
Nigel Jones wrote: Problems guys... Emails don't actually "come" from [EMAIL PROTECTED] they are sent to [EMAIL PROTECTED] and then sent like it was an email from the sender to x subscriber... Really you should be suggesting that the subjects be used in the event/filter things. Autoresponders DO have their uses (business people, as long as they aren't using their business account for lists) to ones that are, sign up for a free hotmail/yahoo/gmail/* webmail account and get php list stuff sent there instead (there are many people on this list with free gmail invites if you still need them). That or ask your network I don't use autoresponders - If I ever go away, I either: a, take a laptop and check for urgent stuff. b, send important clients/colleagues an email saying when I'll be back - which takes roughly the same time as setting up the autoresponder and has the added bonus that you don't have to remember to turn off the auto-responder when you get back ;-) having said that I'd love a gmail invite - I wanna dig into their madhatter javascript used in the clientside interface and learn a few tricks. so if anyone has a spare ...? admin/postmaster/yourself (if your that lucky) to setup another account for you ... This is getting way off topic. I don't use any autoresponders on my mail client so I can't give any advice there (but I'm sure google can). I only use autoresponders on my mailserver. These look at the headers of the incoming mail to determine whether an autoresponse is appropriate. The autoresponders will also limit the number of autoresponses so that if eg your friend sends you 100 mails, they will not be told 100 times that you're having a whale of a time in Hawaii, it will only frustrate them and foment envy :). BTW: Jason what server side autoresponder are you using? ... rgds, Jochem -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Auto Responses?
Jochem Maas wrote: Nigel Jones wrote: Problems guys... Emails don't actually "come" from [EMAIL PROTECTED] they are sent to [EMAIL PROTECTED] and then sent like it was an email from the sender to x subscriber... Really you should be suggesting that the subjects be used in the event/filter things. On that note - why is it that vacation autoreplies get through to this list, but if you dare to speak the dreaded o f f - t o p i c or [ O - T ] keywords your mail doesn't get through? I don't use autoresponders - If I ever go away, I either: a, take a laptop and check for urgent stuff. b, send important clients/colleagues an email saying when I'll be back - which takes roughly the same time as setting up the autoresponder and has the added bonus that you don't have to remember to turn off the auto-responder when you get back ;-) Assuming you have this luxury. A bigger question is, how often are 'we' (e.g. techies) in positions where we're away for so long, and so immediately available to clients - but those clients don't know our schedule? If I'm so 'in bed' with a client that they expect instantaneous turnaround, I would just warn them directly - maybe my experiences are unique. I just don't "service" a lot of people at a time - I would think anyone who does either keeps communication open or has others servicing them also. having said that I'd love a gmail invite - I wanna dig into their madhatter javascript used in the clientside interface and learn a few tricks. so if anyone has a spare ...? Done. Cheers, -- - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Out of the Office
I will be out of the office Monday, January 24th, through Friday, January 28th, with NO access to email. For urgent matters please contact Jared Fine at 585-419-7888 [EMAIL PROTECTED] Marie Osypian Director, Internet Development Savingforcollege.com, LLC Ph: 585.419.7885 Fx: 585.419.7820 http://www.savingforcollege.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Out of the Office
Agh! You have GOT to be friggin' kidding me! These autoresponders and the whole discussion of how they work or don't work are just cluttering up this list. Please just everybody do everybody else a favor and _think_ before you use/configure your autoresponder and take the whole other discussion (while I'm sure it has merit) off list. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, January 24, 2005 9:40 AM To: php-db@lists.php.net Subject: [PHP-DB] Out of the Office I will be out of the office Monday, January 24th, through Friday, January 28th, with NO access to email. For urgent matters please contact Jared Fine at 585-419-7888 [EMAIL PROTECTED] Marie Osypian Director, Internet Development Savingforcollege.com, LLC Ph: 585.419.7885 Fx: 585.419.7820 http://www.savingforcollege.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Auto Responses?
Martin Norland wrote: Jochem Maas wrote: Nigel Jones wrote: Problems guys... Emails don't actually "come" from [EMAIL PROTECTED] they are sent to [EMAIL PROTECTED] and then sent like it was an email from the sender to x subscriber... Really you should be suggesting that the subjects be used in the event/filter things. On that note - why is it that vacation autoreplies get through to this list, but if you dare to speak the dreaded o f f - t o p i c or [ O - T ] keywords your mail doesn't get through? its a mad world. :-) I don't use autoresponders - If I ever go away, I either: a, take a laptop and check for urgent stuff. b, send important clients/colleagues an email saying when I'll be back - which takes roughly the same time as setting up the autoresponder and has the added bonus that you don't have to remember to turn off the auto-responder when you get back ;-) Assuming you have this luxury. A bigger question is, how often are 'we' (e.g. techies) in positions where we're away for so long, and so immediately available to clients - but those clients don't know our schedule? If I'm so 'in bed' with a client that they expect instantaneous turnaround, I would just warn them directly - maybe my experiences are unique. I just don't "service" a lot of people at a time - I would think anyone who does either keeps communication open or has others servicing them also. good point, I indeed have the luxury of having a limited no. of (relatively important) clients, this makes things easy. having said that I'd love a gmail invite - I wanna dig into their madhatter javascript used in the clientside interface and learn a few tricks. so if anyone has a spare ...? Martin delivered the goods! many thanks to him, and anyone else who would have sent one (if Martin hadn't gotten there first :-) ) rgds, Jochem Done. Cheers, -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] help query is so slow
Hi All,
What seems to be the problem why my query to mysql is so slow.
I'm using it for accounting, wherein I need to get the start time they login
and the time they logout then compute it.
to get the start time I did select * from table where blah blah and blah blah
and blah;
to retrieve the data I used while ($row = mysql_fetch_assoc($start_time)) {
within that whle loop I then again did another query select * from table blah
and blah and blah to get the end time.I did it inside the while loop because
i need some data(3 columns) from my first query that acts as the primary key.
I think that querying again to get the end time while I'm still inside the
while loop is the cause why it's to slow to display on the php page.
I'd like to get it out from the while loop but I can't ecause I need data
from the first query, hope someone would understand this question. Thank You
-- --
iTouch Communications, Inc.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Out of the Office
Hutchins, Richard wrote: Agh! You have GOT to be friggin' kidding me! chill. These autoresponders and the whole discussion of how they work or don't work are just cluttering up this list. true. Please just everybody do everybody else a favor and _think_ before you use/configure your autoresponder and take the whole other discussion (while one of those is definitely not going to happen in the near future :-) I'm sure it has merit) off list. who is it that is supposed to admin this list? the person responsible doesn't seem to have the time (and/or the problems are not critical enough to warrant attention). is there anybody on this list capable of doing the admin? would they have some time to do it? and if so is there any possibility of giving such person karma to do some clean up etc? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Bad Search Results from Query
I am trying to search through a Field that has the following data in it,
basically state abbreviation with zip code data.
The NOTES field is setup as a varchar(75)
Record 1 Al GA CA
Record 2 FL AL upper
Record 3 all others in CA
Record 4 CA zip 123456, 456789
The data is passed in a variable from a submit scripts as $terr , let say we
are searching for anybody with AL Alabama in there territory. The 3
queries I have tried all return more then I need or nothing at all.
Is there a way search a Field that will return only records 1 and record 2
or make the search case sensitive for states and return only records 1 and
2?
I am currently using the first query listed. If I use the second query the $
is treated as an expression and not the true variable being passed in from a
submit form.
$sql = ("select last_name, first_name, phone, email, csr, line, picture,
notes, id from address where notes like '%$terr%' " );
$sql = ("select last_name, first_name, phone, email, csr, line, picture,
notes, id from address where notes REGEXP BINARY '[$terr]' " );
$sql = ("select last_name, first_name, phone, email, csr, line, picture,
notes, id from address where MATCH(notes) AGAINST ('\"$terr\"') " );
Any help would be appreciated.
DB = MySql version 3.23.47
Code = PHP 4.2.0
OS = RedHat
Larry Sandwick
Sarreid, Ltd.
Network/System Administrator
phone: (252) 291-1414 x223
fax : (252) 237-1592
_
I am using the free version of SPAMfighter for private users.
It has removed 6574 spam emails to date.
Paying users do not have this message in their emails.
Try SPAMfighter for free
now!
Re: [PHP-DB] help query is so slow
Hello Ron,
I guess it would really help all of us helping you in giving any real
help if you post some code here. :)
Regards,
Samar M.
= Warning: Dates in Calendar are closer than they appear.
On Mon, 24 Jan 2005 23:18:33 +0800, ron <[EMAIL PROTECTED]> wrote:
>
> Hi All,
>
> What seems to be the problem why my query to mysql is so slow.
>
> I'm using it for accounting, wherein I need to get the start time they login
> and the time they logout then compute it.
>
> to get the start time I did select * from table where blah blah and blah blah
> and blah;
>
> to retrieve the data I used while ($row = mysql_fetch_assoc($start_time)) {
>
> within that whle loop I then again did another query select * from table blah
> and blah and blah to get the end time.I did it inside the while loop because
> i need some data(3 columns) from my first query that acts as the primary key.
>
> I think that querying again to get the end time while I'm still inside the
> while loop is the cause why it's to slow to display on the php page.
>
> I'd like to get it out from the while loop but I can't ecause I need data
> from the first query, hope someone would understand this question. Thank You
>
> -- --
> iTouch Communications, Inc.
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Excel to MySQL
Hello, I have an Excel worksheet with a database in it. I would like to move this data to the database on the server that would work with my .php files. Is there a way? I apologize if I posted this question on the wrong list. Thank you, Masud Hasnain - Do you Yahoo!? Yahoo! Mail - Find what you need with new enhanced search. Learn more.
[PHP-DB] last record
Apart from the obvious of reversing the sort order in a select statement and then picking off the first record eg. select * from blah where somefield like '%something%' order by someotherfield desc limit 0,1 is there any way in php rather than sql to pick the last record in a record set? Thanks Neil -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] last record
neil wrote: Apart from the obvious of reversing the sort order in a select statement and then picking off the first record eg. select * from blah where somefield like '%something%' order by someotherfield desc limit 0,1 is there any way in php rather than sql to pick the last record in a record set? Unless you're trying to recreate mysql_insert_id(), then the way you have written is the way to do it. I suppose you could use mysql_result(), but that'd be pretty inefficient. -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals – www.phparch.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] last record
Thanks Peter
The reason I was wanting to do it in php was because the sql query is quite
complex and variable depending on the input from a form.
When the result page is presented I want to provide a link to the last
record at the top of the page.
After connecting and selecting the table I am constructing the query
I then want pick off the last record
and then get all the records
the rather cludgy way I am doing it is this:
First run
$result = mysql_query($sqlstr." desc limit 0,1");
$row = mysql_fetch_assoc($result);
Second run
$result = mysql_query($sqlstr);
while ($row = mysql_fetch_assoc($result)) {
This is fine while there is only one order by appended to the query but if
there is none or more than one it doesn't work so well
Thanks
Neil
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] last record
hi using mysql as you describe is probably the most elegant and efficient way to do it is there a reason for asking php to do it? Peter > -Original Message- > From: neil [mailto:[EMAIL PROTECTED] > Sent: 25 January 2005 03:12 > To: php-db@lists.php.net > Subject: [PHP-DB] last record > > > Apart from the obvious of reversing the sort order in a select > statement and > then picking off the first record > > eg. select * from blah where somefield like '%something%' order by > someotherfield desc limit 0,1 > > is there any way in php rather than sql to pick the last record > in a record > set? > > Thanks > > Neil > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Excel to MySQL
On Tuesday 25 January 2005 08:07, Novice Learner wrote: > Hello, > > I have an Excel worksheet with a database in it. I would like to move this > data to the database on the server that would work with my .php files. > > Is there a way? > > I apologize if I posted this question on the wrong list. > > Thank you, One option might be to export the Excel data as csv, then use whatever option your database provides to import the csv data. -- David Robley Nostalgia isn't what it used to be. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
