[Techtalk] mysql

[wolf]

Ignore me, common sense finally kicked in : )

num_credits*.1


On Wednesday, October 8, 2003, at 01:02 PM, wolf wrote:

> Hi,
>
> 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 : )
>
> _______________________________________________
> Techtalk mailing list
> Techtalk at linuxchix.org
> http://mailman.linuxchix.org/mailman/listinfo/techtalk
>