Re: Ramdom tip...

[Ryan Everhart]

If you are using SQL server you can write a query like this


SELECT Tip_ID, Tip
FROM TipTable
ORDER BY NEWID()

The key is the ORDER BY NewID()

On 5/2/05, Javier Flores <[EMAIL PROTECTED]> wrote:
> 
> 
>  
> 
> I would like to RAMDOM a tip on my home page… do you have any code to do
> this?
> 
>  
> 
> I have and ID and the TIP on the table… 
> 
>  
> 
> Thanks,
> 
>  
> 
> Javier
NŠh²Û?צj)m¢X¬µ×ðqû ¢¸¢éì¹»®&Þ†Ûiÿü0Á×ðqû ¢¸?~Šæ1é›zµ'²æìr¸›yÇæN‹.nÇ+‰·¡¶Úÿ
0uü~è(®ߢ¹ŒzfÞ­ ŠËkjب?Çæ