dadamssg

how does facebook achieve their 'real time' effect? For instance...it shows 4 New Posts or your notifications as soon as they happen without having to refresh the page. I want to implement this on my website for personal messages and other things. I just have NO idea where to even start

yup

blogentry would be the name of the column that holds all your entries...not sure what it could be called...your medium blob data type's name. and then set it equal to whatever your updated blog is...for example First blog... My dog at my homework yesterday. Updated blog... My dog at my homework a week ago. So say if your column that holds the blog entries is called 'entries' it would be something like UPDATE tablename SET entries = 'My dog at my homework a week ago.' where blogentry = '345' and 'tablename' would obviously be whatever your database table is called

haha...you're right..thanks

!= <---like that? i know thats how you do it in php..not so sure for sql

well you have to update that database table cell with sql. somethin like UPDATE tablename SET blogentry = 'youreditedblogentry' where blogentry = '345' '345' would be the blog entry id number that it has in the database.

yeah....there is a way but you have to know how to access your database. Database username, password, then have to write some php to get out and put it back in...or if you have phpMyAdmin for the site you could access it that way

i have events stored and they all have categories attached to them...how do i turn this query into the same thing, but NOT including the category 'Surrounding'? SELECT * FROM `test` WHERE end >= NOW() ORDER BY start ASC the column is named Category and i want to pull up all categories EXCEPT the 'Surrounding' category...i'm just unsure how to do this...thanks!

definition of alot?

hey all, im finishing up my website and now thinking about my ad options. I'm targeting the college town that i attend. So all my content will be relevant to the area. i really know little about getting the best results(relevant) from adsense. but i've also thought about just going after local businesses. i think i could learn a lot from working with other businesses. i just really don't know what to charge the businesses and i'm unsure about how much my site will earn from adsense being that i haven't advertised or launched the site yet. any have some advice? any and all will be much appreciated! thanks!

could you explain that? i don't understand the start_tm and end_tm part and how would output the variables?

cause im pulling up and displaying all the events...so i want to put a symbol or something next to the events that are occurring today

hey guys, thanks for the advice...but i don't think thats gonna gonna do what i want it to do...cause say its 3:20pm right now, but if i have an event that starts at 4:00pm today and ends at 5:30pm today it won't work....thanks for lookin at it again $now = time(); if(strtotime($row['start']) <= $now and strtotime($row['end']) > $now) { echo "Its today!!!!!"; }

im trying to do is find out if the event im querying is happening today. i had this $now = time() if(strtotime($row['start']) > $now and strtotime($row['end'] < $now)) { echo "Its today!!!!!"; } but its wrong, not only because of the syntax but that deals with time...the event can start a month ago if it ends today or later..or it can start today and end today or end in a month....i just want to find out if any part of it is happening the current date...thanks

all im trying to do is make a link open a new window that is like 500px by 500px or something close. heres my javascript function now function open_win() { window.open("http://www.mysite.com/beta/disclaimer.php"); } and then this is the html <a href='disclaimer.php' onClick="open_win()">disclaimer</a> im not sure if i need to take the a href='disclaimer.php' part out and i don't know how to set the height and width of the window...help would be MUCH appreciated. thanks!

i would say i know php pretty well but have no idea where to start when it comes to allowing users to upload a profile picture. Does anyone know a good tutorial or anything that shows how to store pictures and manipulate them to be portrayed a certain size? thanks

you're a genious...it worked! i was stressin about that

hey thanks...should that work in phpMyAdmin? i just tried it and i'm getting an error SQL query: Documentation SELECT * FROM Replies WHERE eventid IN ( SELECT * FROM test WHERE END < NOW( ) ) LIMIT 0 , 30 MySQL said: Documentation #1241 - Operand should contain 1 column(s)

?

sweet thanks

is there a function to make everything in a string lowercase?

wrap the header in a header div and then margin: 0 auto; to center it all

basically im trying to implement rounded corners that have a transparent background so my question is can i float a div with the transparent corner left and then float one right and then have a middle div that will stretch until it hits the edges of of the floated divs? cause i want to add a wrapper div to all of this and then set the width of the wrapper so i can control the width and it stretch and look fine. i want the outside of the corners to be transparent so they show the background image of the body so i cant set the background-color of the wrapper div or any div that the corners are in because then the transparent would be the color of the div and not the image....anyways hope that makes since and THANKS

im trying to implement a fixed background but the content is reallly jumpy when i scroll in firefox but seems fine in ie. its a big image 1500x1000px .png file thats 65.44kb. is that just the way firefox is or is there anything i can do?

if i've md5'd my users passwords, whats the best way or good ways to design a 'forgot your password' script? i haven't made them into a secret word in or anything, all i have is their username, password, and email as far as the info they have given me. anyways....having some options would be great!