Re: [PHP-WIN] Re: get row (latest by date)

2003-01-09 Thread Aidal
Yes, somone replied directly to me with this idea "ODER BY date DESC, time DESC", and this seems to work just fine. Thanks :) "Joseph W. Goff" <[EMAIL PROTECTED]> wrote in message 001601c2b7f6$342d0a40$bdcaa8c0@jg42000">news:001601c2b7f6$342d0a40$bdcaa8c0@jg42000... > Actually, mysql does not sup

php-windows Digest 10 Jan 2003 05:24:52 -0000 Issue 1527

2003-01-09 Thread php-windows-digest-help
php-windows Digest 10 Jan 2003 05:24:52 - Issue 1527 Topics (messages 17731 through 17736): session problem 17731 by: Supra 17732 by: Ryan Marrs Re: get row (latest by date) 17733 by: Radovan Radic 17734 by: Joseph W. Goff Re: [PHP-INST] PHP 4.3.0 on Windows

[PHP-WIN] Re: [PHP-INST] PHP 4.3.0 on Windows IIS problem

2003-01-09 Thread Frank
Matt, Here's another problem I hope you can solve. Like Marco I just recently installed PHP 4.3.0, however I never had PHP before so this is a fresh install. I'm running Win NT4 workstation and Apache 2.0.43 and in my http.conf I am using the load Module php4apache2.dll. After a few hours of pul

[PHP-WIN] RE: [PHP-INST] PHP 4.3.0 on Windows IIS problem

2003-01-09 Thread Matt Babineau
I did this exact same thing the other day. I just removed the entire PHP folder (where php.exe resides), removed all the references to php from my system, and don't forget the php.ini in the windows folder. The just unzipped php 4.3.0 and did the standard setup and it worked. Also reboot after yo

Re: [PHP-WIN] Re: get row (latest by date)

2003-01-09 Thread Joseph W. Goff
Actually, mysql does not support sub-selects. You can do this however with something like this: select * from your_table order by date_column desc, time_column desc limit 1 - Original Message - From: "Radovan Radic" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 09, 20

[PHP-WIN] Re: get row (latest by date)

2003-01-09 Thread Radovan Radic
select * from table where date=(select max(date) from table) and time=(select max(time) from table) HTH, Radovan "Aidal" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi NG. > > I know this is probably very simple, but I've had no luck making it work :( > > I

RE: [PHP-WIN] session problem

2003-01-09 Thread Ryan Marrs
First, I'd check the session.save_path specified in the php.ini file and make sure that directory exists. By default, /tmp does not exist on windows, so I would change that to c:\inetpub\sessions and create the directory, although you can use any directory you wish. That seems to be the most comm

[PHP-WIN] session problem

2003-01-09 Thread Supra
Hi, I got serious problem I need to solve a.s.a.p. Well, I've developed a database application with PHP and MySql, I used sessions. While developing I used my own computer as a web server - Windows 2000 Pro, IIS 5, PHP 4.2.3 via ISAPI. And all my code was tested successfully while my computer is t

php-windows Digest 9 Jan 2003 13:05:59 -0000 Issue 1526

2003-01-09 Thread php-windows-digest-help
php-windows Digest 9 Jan 2003 13:05:59 - Issue 1526 Topics (messages 17721 through 17730): Re: [newbie] What does this mean? 17721 by: paradiddles Newbie :: Class instance alive between pages?? 17722 by: Palli 17723 by: Luis Ferro 17726 by: Palli New install

[PHP-WIN] get row (latest by date)

2003-01-09 Thread Aidal
Hi NG. I know this is probably very simple, but I've had no luck making it work :( I want 1 single row out of a table, that row must be the latest by date and time. The table looks like this (example MySQL): ___ id | type_id | date |