Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    Regular Coder
    Join Date
    Sep 2010
    Posts
    119
    Thanks
    6
    Thanked 0 Times in 0 Posts

    php where clause problem grater than time value

    hi i have small issue

    $etime='15:00:00;

    $sqlstr4 ="SELECT * FROM Barcode_FP WHERE date_barcode='$production_Date' AND Barcode_Time > '$etime' ";

    $result4 = mysql_query($sqlstr4);
    $record4 = mysql_fetch_array( $result4 );

    i have something like this but i`m not getting time 15:01:00

    plz help me to solve this problem

  • #2
    Master Coder mlseim's Avatar
    Join Date
    Jun 2003
    Location
    Cottage Grove, Minnesota
    Posts
    9,369
    Thanks
    8
    Thanked 1,075 Times in 1,066 Posts
    Describe how this column is set-up in your database table: Barcode_Time

    What variable type did you give it (when you created it), and give an example of what a typical value looks like. Display a time in the morning (AM) and afternoon (PM).

  • #3
    God Emperor Fou-Lu's Avatar
    Join Date
    Sep 2002
    Location
    Saskatoon, Saskatchewan
    Posts
    16,978
    Thanks
    4
    Thanked 2,659 Times in 2,628 Posts
    In particular, execute: SHOW CREATE TABLE Barcode_FP and post that.
    PHP Code:
    header('HTTP/1.1 420 Enhance Your Calm'); 


  •  

    Posting Permissions

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