doctor_james

Yes, I have.. I want to count the records of the busiest day But I really have no Idea how to do it .

It worked , thanks alot. But there's still one question left. How can I get the hits for the busiest day according to the table I introdiced above . Thank You all .

$query="SELECT DISTINCT(ip) FROM stats WHERE YEAR('date')='2008'"; $h=mysql_query($query); $hits=mysql_num_rows($h);

Thanks for the replies .. I used your method but It returns no result.

I've created a table to save my website visits , the fields are id,Ip,date,page,broswer . By each visit , a Record are added to the table so each day can have several records. Now I wanted to get this Information out of these Information: 1) Hits for the busiest day . 2) Hits for this week. 3) Hits for this month. 4) Hits for this year. How can I do it ? Is this possible with the information I've collected ? Thanks in advance .

Hi, as you all know commenting forms in websites is a target for hackers . What can I do to make it as secure as possible ? any advice would be appreciated

Hi, How can I get the last records of 10 different RSS files and print them in a page ?

Hi, I'm trying to generate an excel file out of a mysql table . I've used Spreadsheet_Excel_Writer class and some other codes I've found on internet . But there's a problem with character set . The data looks confusing and characters are so strange . Has anyone had this problem ? thanks.

Thank for the reply ; Quick and informative . Thanks again.

1 - Is there any database PHP cannot work with ? If so , what are they ? 2 - Is it possible to connect to a database on a Local Machine from a remote Host? Thanks in advance .

Hi , I've created a four-level menu . but there's a problem with closing sub menus . When I'm moving the cursor to the next level (for example from the third level to the fourth level) I don't want the prent menus (second and third level) to be closed and when I move from the fourth level to the second , I want the third menu to be closed also . But now when I move to next level the previous ones disappear and When I move from the fourth level to the second , the third one is still visible and I need to move mouse over and out of it to close it .

Hi, I have a button and I want it do open a box next to itself on mousemove or mouseover events. But since the position of this button is dynamic , I don't know to set top and left values . any ideas ..? thanks in advance.

I have a dynamic menu and it has sub menus n each sub menu can have sub menus and so on ... But since it's a dynamic menu (created with PHP) I don't know how to position the sub menus block as you know it must be placed in a DIV with position set to "absolute" . I mean this menu can be placed in everywhere n i dont know how to get left and top .

Hi . How can I get those records which are older less than a month ? thanks in advance.

Hi. I got a problem with Imagettfbbox : Call to an undefined function . my php version is 5.2.5 and GD is installed . I read that freetype is to be installed either . How can I check if it is installed or not? how can I use it ? thanks in advance.