PHP beginner: How to "Order by" that query?
I have a rather (I think) easy problem to solve but being a PHP newbie, I can't seem to get the answer...
The query below, print a cloud of tags on my page. I'd like to add "ORDER BY TagID ASC" to this query so that the tags appeared according to their ID #, but I have no idea, where to put it (I didn't write that query, obviously).
<?php
$tags = $data->select ( "Tag", "*" , NULL , 0 , 500 ) ;
if ( ! empty ( $tags ) )
foreach ( $tags as $tag ) :
$counts = $data->count_record ( "Website_Tag" , array ( "TagID" => $tag["TagID"] ) ) ;
if ( $counts > 20 )
$font_size = $counts ;
else
$font_size = 11 ;
?>
<a style="font-size: <开发者_如何学Go?php echo $font_size ?>px;" href="<?php echo base_url."coupons/".get_sef_url ( $tag["TagID"] , "Tag" ) ?>/"><?php echo $tag["TagName"] ?></a>
<?php
endforeach ;
?>
Any help will be strongly appreciated? Thanks!
You could try sort()
<?php
$tags = $data->select ( "Tag", "*" , NULL , 0 , 500 ) ;
if ( ! empty ( $tags ) )
sort($tags); // sort here
foreach ( $tags as $tag ) :
$counts = $data->count_record ( "Website_Tag" , array ( "TagID" => $tag["TagID"] ) ) ;
if ( $counts > 20 )
$font_size = $counts ;
else
$font_size = 11 ;
?>
<a style="font-size: <?php echo $font_size ?>px;" href="<?php echo base_url."coupons/".get_sef_url ( $tag["TagID"] , "Tag" ) ?>/"><?php echo $tag["TagName"] ?></a>
<?php
endforeach ;
?>
精彩评论