Results 1 to 8 of 8
Thread: PHP
Hybrid View
-
16th April 2006 19:37 #1
PHP
.
:
. . .. :. :
, 01.12.2005 00:00 02.12.2005 23:59 01.12.2005 00:00 02.12.2005 23:59 02.11.2005 00:00 23:59PHP Code:$From_data_report = "$From_Date_day.$From_Date_month.$From_Date_year 00:00";
$To_data_report = "$To_Date_day.$To_Date_month.$To_Date_year 23:59";
if ($Company == "") {$By_Company = "AND Company!='$Company'";} else {$By_Company = "AND Company='$Company'";}
$ViewNotes = mysql_query("SELECT * FROM notes WHERE date BETWEEN '$From_data_report' AND '$To_data_report' $By_Company ORDER BY Note_ID");
WHERE date BETWEEN '$From_data_report' AND '$To_data_report'
-
16th April 2006 21:23 #2
-
16th April 2006 22:29 #3
-
17th April 2006 00:35 #4
..!
Originally Posted by vbTheKing
01.12.2005 00:00 02.12.2005 23:59 ( ) 02.11.2005
( )
-
17th April 2006 01:04 #5
-
17th April 2006 01:19 #6
-
17th April 2006 09:21 #7. varchar . , - .
Originally Posted by Pesho
date,datetime,timestamp .. . ( ).
:
Code:"Select * from notes where STR_TO_DATE(date,'%d.%m.%Y %T') BETWEEN STR_TO_DATE('".$From_data_report."','%d.%m.%Y %T')AND STR_TO_DATE('".$To_data_report."','%d.%m.%Y %T')"Last edited by Oldman; 17th April 2006 at 09:37.
.
-
17th April 2006 01:43 #8
... , , quote-.
Originally Posted by milla
''? * *
- !
...




Reply With Quote
. 02.11.2005 23:59 - , 02.11.2005 0:00 23:59 ?? 

Lenovo ThinkPad 15 IdeaPad 15
5th May 2023, 22:16 in