[PHP-DB] Re: screen resolution!

[Jan Pieper]

PHP don´t know how whats your resolution is. You need Javascript.

 screen.width, screen.height

Jan Pieper


Hi,
   
  I have written a website in PHP using MYSQL.  But I have come accross an un-common problem.  Normally when I create a website it's done on a desktop PC.  But this time for the first time I did it on laptop meaning the screen resolution is different.
   
  Is there any sort of script/code I can use to create another section of my site in a desired screen resolution without me having to do it all manually?
   
  I know of many scripts online that I can DETERMINE visitors screen resolutions and recommend the correct one but don't know one that will adjust the website to suit that visitors screen resolution.  Am aware of scripts that redirect to another web page but that requires you to write the website again to cater for that.
   
  Is there a quicker way/solution?
   
  Thanks!
   
  J




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

Re: [PHP-DB] timestamp value management

[Jan Pieper]

the timestamp of mysql is only the date without any spacers. the php timestamp 
is a unix-timestamp (seconds since 01.01.1970) so you can´t convert your 
record-value to an normally date directly. you have to use split out the year, 
the month etc. manually. (or is there a function for it? don´t know)


Jan Pieper



So, you want the maximum date of the result set? Just use SQL:

select max(datecolumn) from table where (conditions);

-Micah 



On Monday 30 January 2006 1:03 pm, xkorakidis wrote:

hi guys!
I'm trying to manage a table containing a timestamp colum
- when I insert a record, I don't fill a value in timestamp column, so
current timestamp is inserted. The inserted value is smth like
20060129213253
- when I try to show this value in a php page, I use
date($varOfTimestampColumn) or getdate(). The final result is the
highest possible date (smth like January 19 2038 I think)

How can I manage the timestamp field so as to show the correct value?
Thanks!


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