| 
 Posted by Marcel on 11/17/05 21:35 
"Kannan" <Kannanmca@gmail.com> schreef in bericht  
news:1132247221.901388.154680@f14g2000cwb.googlegroups.com... 
> Hi 
> 
> I have to display the output of a stored proc in MS SQL server in a 
> browser using php. 
> 
> The numbers are stripped of their trailing zeros. 
> 
> There may be multiple colums which may come from the stored proc 
> 
> Like 
> 
> Colum1 column2 column3            XXX                  XXX 
> ---------   -----------    ------------            ---- 
> ------ 
> date      varchar   decimal(10,2)    float                  real 
> 
> I cannot use sprintf or number format as i dont know what the coulmn 
> type is going to be. All I need to do is just print whatever the stored 
> procedure is returning without stripping any zeros. 
> 
> I am a beginner in php so i am not aware of how to do this. 
> 
> Kindly help me . 
> 
 
$a = 0000012; 
 
$result = intval($a); 
 
echo $result; // prints 12 
 
Marcel
 
  
Navigation:
[Reply to this message] 
 |