doddsey_65

I have a class which pulls settings from the database. These settings are needed for the application to be run. Currently it queries the database on each page load and adds the information to a static variable. What I'm after is a way to store this information in the variable so it can be accessed on each page without having to query the database. Memcache is an option but it can be disabled in my application so I am after another if possible. Thanks

i had a feeling that was coming after i posted that

can you change my username to a bright blue one?

anyone have any ideas?(shameful bump)

am i on the right lines with this: $query = $link->query("SELECT * FROM ".TBL_PREFIX."posts GROUP BY FROM_UNIXTIME(p_time_posted) "); $row = $query->fetchAll();

i realise now that this was a bad way to save times but i never intended to use them this way so i didnt think it mattered. Thanks for the advice

unix timestamp

i need to sort my database results by the day they were added to the database. There is a column with the timestamp of when they were inserted but how do i group them by the day they were inserted so i can display them as such: Mon 14th: 5 records Tues 15th: 11 records etc.

I have a section on my website where the url points to www.example.com/some_page#some_element #some_element is used by javascript to load the element in question into the parent element. However i need pagination done on this loaded element. How should i go about it? would it work? obv i cant use www.example.com/some_page#some_element/page/2. Any tips or advice?

you suggest a button in the admin section that will delete all attachments that arent being used?

I need to make an attachment system for my forum but i have a big issue. When a user adds an attachment they are added to the server there and then(the way i want it to be so i can have progress bars and such). Then when a user submits their post the content and attachmnet names are added to the database. Simple. But what happens when a user decides not to continue with the post? The attachments have already been added to the server but they arent being used. One thing i can think of is to run a query which checks which attachments are on the server and cross references them with the names in the database. If they are on the server but not in the database then delete the files. However that seems to be quite an intensive way of doing things and adds yet another query to each page load. Any advice or ideas on this?

I have an array with a list of timezones and their offsets but the names of the timezones(which i got off my OS's clock) dont match the timezone names in php. Heres my array: $tz = array( "0" => "Select A Timezone", "-12" => "(GMT - 12:00) International Date Line West", "-11" => "(GMT - 11:00) Midway Island, Samoa", "-10" => "(GMT - 10:00) Hawaii", "-9" => "(GMT - 09:00) Alaska", "-8" => "(GMT - 08:00) Pacific Time US, Canada, Baja", "-7" => "(GMT - 07:00) Mountain Time US", "-6" => "(GMT - 06:00) Central America, Mexico City", "-5" => "(GMT - 05:00) Eastern Time US, Bogota, Lima, Quito", "-4:30" => "(GMT - 04:30) Caracas", "-4" => "(GMT - 04:00) Atlantic Time Canada, La Paz, Santiago", "-3:30" => "(GMT - 03:30) Newfoundland", "-3" => "(GMT - 03:00) Brazil, Buenos Aires, Fortaleza, Greenland", "-2" => "(GMT - 02:00) Mid-Atlantic", "-1" => "(GMT - 01:00) Azores, Cape Verde Island", "0" => "(GMT) Western Europe Time, Casablanca, Lisbon, London", "+1" => "(GMT + 01:00) Brussles, Copenhagen, Madrid, Paris, Vienna", "+2" => "(GMT + 02:00) Kaliningrad, South Africa, Cairo", "+3" => "(GMT + 03:00) Baghdad, Riyadh, Moscow, St. Petersberg", "+3:30" => "(GMT + 03:30) Tehran", "+4" => "(GMT + 04:00) Abu Dhabi, Muscat, Yerevan, Baku, Tbilisi", "+4:30" => "(GMT + 04:30) Kabul", "+5" => "(GMT + 05:00) Ekateringberg, Islamabad, Karachi, Tashkent", "+5:30" => "(GMT + 05:30) Mumbai, Kolkata, Chennai, New Delhi", "+5:45" => "(GMT + 05:45) Kathmandu", "+6" => "(GMT + 06:00) Almaty, Dhaka, Colombo", "+6:30" => "(GMT + 06:30) Yangon, Cocos Islands", "+8" => "(GMT + 08:00) Beijing, Perth, Singapore, hong Kong", "+9" => "(GMT + 09:00) Tokyo, Seoul, Osaka, Sapporo, Yakutsk", "+9:30" => "(GMT + 09:30) Adelaide, Darwin", "+10" => "(GMT + 10:00) Eastern Australia, Guam, Vladivostok", "+11" => "(GMT + 11:00) Magadan, Solomon Islands, New Caledonia", "+12" => "(GMT + 12:00) Auckland, Wellington, Fiji, Kamchatka", );

im setting up timezones so every user will be able to have the times displayed in their timezone. however when they register their timezone is sent to the database as an integer value: eg/ -3. meaning -3 hours from GMT. but to set the timezone in php i am using: date_default_timezone_set(); i have the list of available timezones but they just display the names and not the hour difference. Is there any where to get such a list or should i be doing things differently?