[Techtalk] mysql

wolf wolf at wolfrising.net
Wed Oct 8 13:02:56 EST 2003


I'm using this mysql select statement to have credits for a course 
which are in the database as
30 be divide by 10 to show up correctly as 3, it returns the number as 
3.00, would anyone
know how to get it to return the number as 3.0 and drop the second zero?

SELECT num_credits/10 FROM course WHERE c_code='$course'

Thanks : )

More information about the Techtalk mailing list