doctor_james
Members-
Posts
40 -
Joined
-
Last visited
Never
Everything posted by doctor_james
-
how can I get these results out of my table ?
doctor_james replied to doctor_james's topic in MySQL Help
Yes, I have.. I want to count the records of the busiest day But I really have no Idea how to do it . -
how can I get these results out of my table ?
doctor_james replied to doctor_james's topic in MySQL Help
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 . -
how can I get these results out of my table ?
doctor_james replied to doctor_james's topic in MySQL Help
$query="SELECT DISTINCT(ip) FROM stats WHERE YEAR('date')='2008'"; $h=mysql_query($query); $hits=mysql_num_rows($h); -
how can I get these results out of my table ?
doctor_james replied to doctor_james's topic in MySQL Help
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 ?
-
[SOLVED] Two questions about PHP and Databases
doctor_james replied to doctor_james's topic in PHP Coding Help
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.
-
Hi . how can I shorten a decimal fraction , for example : 1.2392399417447694 to this : 1.23923999 . thanks in advance .
-
Hi guys . I have a form without a submit button but I dont want it to be submitted when "ENTER" is pressed . How can I do that ? It's submitted when I press enter ... thanks in advance .
-
How can I find out it's set in php.ini . and yes it's shared .
-
Thanks for your replies . I tried your code but it fails to send . even that simple mail() function doesn't send anything .
-
even mail(address,subject,body) doesn't work !
-
hi , what's wrong with this code . it doesn't work ! <?php $address="AnEmailAddress"; $headers = "From: info@pgtt.ir\r\n"; $headers .= "MIME-Version: 1.0\r\n"; $boundary = uniqid("HTMLDEMO"); $headers .= "Content-Type: multipart/alternative "."; boundary = $boundary\r\n\r\n"; $headers .= "This is a MIME encoded message.\r\n\r\n"; $headers .= "--$boundary\r\n" ."Content-Type: text/plain; charset=utf-8\r\n"."Content-Transfer-Encoding: base64\r\n\r\n"; $headers .= chunk_split(base64_encode("This is the plain text version!")); $headers .= "--$boundary\r\n" ."Content-Type: text/html; charset=ISO-8859-1\r\n"."Content-Transfer-Encoding: base64\r\n\r\n"; $headers .= chunk_split(base64_encode("This the <b>HTML</b> version!")); mail($address, "An HTML Message", "", $headers); ?>
-
how to move scrollbar to top automatically?
-
Hi , how can I change the "type" property of a password element on the fly? I tried this : document.forms[0].elementName.type="....." but I get an error , I think "type" property just returns the type of an element . thanks in advance .
-
Hi guys . suppose I have three tables as folllowing : 1- entries (id,title,entry) -> table of articles . 2- users (id,user_id,entry_id) -> entries users have read . 3- users (id,user) -> list of users . now I want users just to see those entries they haven't read , how can I do that ? thanks in advance .