php-windows Digest 10 Jan 2003 05:24:52 -0000 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 IIS problem
17735 by: Matt Babineau
17736 by: Frank
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
--- Begin Message ---
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 the server and the client. Now after moving the sources to the
server (Windows 2000 Advanced Server) and exporting the MySql database to
the server, the application fail. While debugging I got to a firm conclusion
that the sessions doesn't work well. I copied the php.ini to the system root
on the server and it still doesn't work.
Please advice me what to do in order to make the application work on the
server.
Thanks In advance,
Supra
--- End Message ---
--- Begin Message ---
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 common problem with using sessions.
___________________________________
Ryan Marrs
Web Developer
Sandler & Travis Trade Advisory Services, Inc.
248.474.7200 x 183
248.474.8500 (fax)
www.strtrade.com
-----Original Message-----
From: Supra [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 09, 2003 8:10 AM
To: [EMAIL PROTECTED]
Subject: [PHP-WIN] session problem
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 the server and the client. Now after moving the sources to the
server (Windows 2000 Advanced Server) and exporting the MySql database to
the server, the application fail. While debugging I got to a firm conclusion
that the sessions doesn't work well. I copied the php.ini to the system root
on the server and it still doesn't work.
Please advice me what to do in order to make the application work on the
server.
Thanks In advance,
Supra
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
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 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 | time | title |
> source |
> ---------------------------------------------------------------
> 128 | 1 | 2003-01-09 | 15:00:52 | some title | blabla |
> 129 | 1 | 2003-01-09 | 15:02:43 | some title 2 | blabla 2 |
> ---------------------------------------------------------------
>
> What i need is the SQL that would give me the latest created row of these
2
> (i dont mean latest as in last_id) by date and time in this case the
result
> should be the row with id = 129 because of the time.
>
> Please help...
>
> ~ Aidal
>
>
>
>
--- End Message ---
--- Begin Message ---
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, 2003 9:46 AM
Subject: [PHP-WIN] Re: get row (latest by date)
> 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 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 | time | title |
> > source |
> > ---------------------------------------------------------------
> > 128 | 1 | 2003-01-09 | 15:00:52 | some title | blabla |
> > 129 | 1 | 2003-01-09 | 15:02:43 | some title 2 | blabla 2 |
> > ---------------------------------------------------------------
> >
> > What i need is the SQL that would give me the latest created row of
these
> 2
> > (i dont mean latest as in last_id) by date and time in this case the
> result
> > should be the row with id = 129 because of the time.
> >
> > Please help...
> >
> > ~ Aidal
> >
> >
> >
> >
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--- End Message ---
--- Begin Message ---
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 you uninstall the old php.
Try that!
:)
--> -----Original Message-----
--> From: Marco Alting [mailto:[EMAIL PROTECTED]]
--> Sent: Thursday, January 09, 2003 11:29 AM
--> To: [EMAIL PROTECTED]
--> Subject: [PHP-INST] PHP 4.3.0 on Windows IIS problem
-->
-->
--> After upgrading to 4.3.0, whenever I try to view a php page
--> in my browser, I get the message "page cannot be displayed"
--> While before the upgrade it worked fine??
-->
--> Any suggestions?
-->
-->
-->
--> --
--> PHP Install Mailing List (http://www.php.net/)
--> To unsubscribe, visit: http://www.php.net/unsub.php
-->
-->
--- End Message ---
--- Begin Message ---
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
pulling my hair out with the 400 and 500 errors, I am now able to access the
php files. Unfortunately I only get "page cannot be displayed", can you
help? I did try rebooting and I did verify that php is working by running
the php.exe -i in a command prompt.
Thanks
Frank
"Matt Babineau" <[EMAIL PROTECTED]> wrote in message
001801c2b7fd$0287ac50$6710a8c0@webdevx">news:001801c2b7fd$0287ac50$6710a8c0@webdevx...
> 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 you uninstall the old php.
>
> Try that!
>
> :)
>
>
> --> -----Original Message-----
> --> From: Marco Alting [mailto:[EMAIL PROTECTED]]
> --> Sent: Thursday, January 09, 2003 11:29 AM
> --> To: [EMAIL PROTECTED]
> --> Subject: [PHP-INST] PHP 4.3.0 on Windows IIS problem
> -->
> -->
> --> After upgrading to 4.3.0, whenever I try to view a php page
> --> in my browser, I get the message "page cannot be displayed"
> --> While before the upgrade it worked fine??
> -->
> --> Any suggestions?
> -->
> -->
> -->
> --> --
> --> PHP Install Mailing List (http://www.php.net/)
> --> To unsubscribe, visit: http://www.php.net/unsub.php
> -->
> -->
>
--- End Message ---
