[PHP-DB] Re: Excel to MySQL

2005-01-24 Thread David Robley
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

RE: [PHP-DB] last record

2005-01-24 Thread Peter Lovatt
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: [email protected] > Subject: [PHP-DB] last record >

Re: [PHP-DB] last record

2005-01-24 Thread neil
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 co

Re: [PHP-DB] last record

2005-01-24 Thread John Holmes
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

[PHP-DB] last record

2005-01-24 Thread neil
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

[PHP-DB] Excel to MySQL

2005-01-24 Thread Novice Learner
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 --

Re: [PHP-DB] help query is so slow

2005-01-24 Thread Samar
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

[PHP-DB] Bad Search Results from Query

2005-01-24 Thread Larry Sandwick
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 da

Re: [PHP-DB] Out of the Office

2005-01-24 Thread Jochem Maas
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 aut

[PHP-DB] help query is so slow

2005-01-24 Thread ron
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 th

Re: [PHP-DB] Auto Responses?

2005-01-24 Thread Jochem Maas
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

RE: [PHP-DB] Out of the Office

2005-01-24 Thread Hutchins, Richard
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

[PHP-DB] Out of the Office

2005-01-24 Thread mosypian
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

Re: [PHP-DB] Auto Responses?

2005-01-24 Thread Martin Norland
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. O

Re: [PHP-DB] Auto Responses?

2005-01-24 Thread Jochem Maas
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 ha

Re: [PHP-DB] Auto Responses?

2005-01-24 Thread Nigel Jones
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 (b