Results 1 to 8 of 8

Thread: PHP

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User milla's Avatar
    Join Date: Apr:2006
    Location: Dobrich
    Posts: 4

    Question PHP

    .
    :

    . . .. :. :

    PHP 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"); 
    , 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:59

    WHERE date BETWEEN '$From_data_report' AND '$To_data_report'



  2. #2
    White awesomeness z0ne's Avatar
    Join Date: Feb:2002
    Location: o
    Posts: 13,331

  3. #3
    Registered User milla's Avatar
    Join Date: Apr:2006
    Location: Dobrich
    Posts: 4

    Thumbs up

    Quote Originally Posted by z0ne
    z0ne,

  4. #4
    Registered User milla's Avatar
    Join Date: Apr:2006
    Location: Dobrich
    Posts: 4

    Exclamation

    Quote Originally Posted by vbTheKing
    --?! . 02.11.2005 23:59 - , 02.11.2005 0:00 23:59 ??
    ..!
    01.12.2005 00:00 02.12.2005 23:59 ( ) 02.11.2005
    ( )


  5. #5
    Pesho's Avatar
    Join Date: Nov:2001
    Location: Sofia
    Posts: 5,169
    -, , (.. ), .

    -, , .. : - .

  6. #6
    Registered User milla's Avatar
    Join Date: Apr:2006
    Location: Dobrich
    Posts: 4

  7. #7
    Undead user Oldman's Avatar
    Join Date: Oct:2003
    Location: outside
    Posts: 432
    Quote Originally Posted by Pesho
    -, , (.. ), .

    -, , .. : - .
    . varchar . , - .
    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.
    .

  8. #8
    ! vbTheKing's Avatar
    Join Date: Sep:2003
    Location:
    Posts: 4,138

    Cool

    Quote Originally Posted by milla
    ..!
    01.12.2005 00:00 02.12.2005 23:59 ( ) 02.11.2005
    ( )

    ... , , quote-.
    ''? * *
    - !
    ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |