Re: [php-list] Randomly selecting records from a MySQL table

2005-04-20 Thread Hendra Susanto
you can use order by rand()... example if i want to pic a random picture from photos table: $resultrandom = mysql_query("SELECT pictures FROM photos_table ORDER BY RAND() DESC"); Regards, Hendra www.papanbuletin.com On 4/21/05, Marian Briones <[EMAIL PROTECTED]> wrote: > > > How can I rando

[php-list] NEver mind; found it!

2005-04-20 Thread Marian Briones
Oh the power of ORDER by rand() LIMIT 1 :-) Community email addresses: Post message: php-list@yahoogroups.com Subscribe:[EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list Yahoo!

[php-list] Randomly selecting records from a MySQL table

2005-04-20 Thread Marian Briones
How can I randomly select a record from an MySQL query? I'm doing a self-driven membership website where the user will have to identify the characters in graphics in order to continue registration. How can I do this? (The answers are out there) Community email addresses: Post message: p

Re: [php-list] Removing Values after session

2005-04-20 Thread James Keeline
> Im storing three values during a session in a db. When the user logs off > or when they just close the broswer, I want those values turned back to 0. > > I know how to do this if they just log out but, how would you do this if > they just close the broswer? > > Wade Storing session variabl

Re: [php-list] Removing Values after session

2005-04-20 Thread Wade
04202005 1123 GMT-6 Im not storing session data in a db. Im storing huh. I didnt think of that. Wade Patrick Bierans wrote: > > Im storing three values during a session in a db. When the user logs off > > or when they just close the broswer, I want those values turned back > to 0. > > >

Re: [php-list] Removing Values after session

2005-04-20 Thread Patrick Bierans
> Im storing three values during a session in a db. When the user logs off > or when they just close the broswer, I want those values turned back to 0. > > I know how to do this if they just log out but, how would you do this if > they just close the broswer? every time he opens a page you refres

[php-list] Removing Values after session

2005-04-20 Thread Wade
04202005 1105 GMT-6 Im storing three values during a session in a db. When the user logs off or when they just close the broswer, I want those values turned back to 0. I know how to do this if they just log out but, how would you do this if they just close the broswer? Wade [Non-text portio

[php-list] Re: = equals 3D ??

2005-04-20 Thread Keith Young
Hi Sarah, 3D does in fact mean the equals sign (=). A better way of saying it is: 0x3D is the hex representation of an equals (=) sign. Here is a hex chart for reference (3 is on the left edge, D along the top edge) http://www-atm.physics.ox.ac.uk/user/iwi/charmap.html Cheers, Keith. ---

[php-list] = equals 3D ??

2005-04-20 Thread Sarah Foxton
Hi there Im trying to match with a preg match.. The phrase I want to look for is :- pass ..(text).. 4+2=7 im using this code :- if (preg_match("/^\s*pass:.*4\+2\=7/i", $value)){ I send an email to the system... with the line :- pass: Pizza Words 4+2=7 Batman himp HOWEVER - my log repor