How to retrieve Float data from MYSQL within PHP

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • jameelahmed
    New Member
    • Apr 2007
    • 4
    #1

    How to retrieve Float data from MYSQL within PHP

    I m writing following query in PHP or MYSQL but couldn’t get result

    Select * from table where field=4.8
    Tags: None
    • ScarletPimpernal
      New Member
      • Mar 2007
      • 39
      #2
      Hi,

      May be this will help,
      Try this query

      SELECT * FROM table WHERE FORMAT(field,1) =4.8;

      Thanks,
      Scarlet


      Originally posted by jameelahmed
      I m writing following query in PHP or MYSQL but couldn’t get result

      Select * from table where field=4.8

        Comment

        • jameelahmed
          New Member
          • Apr 2007
          • 4
          #3
          thank u v much ScarletPimperna l
          you solved my problem
          thanks again

            Comment

            Previous template Next
            Working...