Re: [PHP-DB] sql and week starting ending numbers (dates)

2002-06-01 Thread Bogdan Stancescu
SELECT FROM_DAYS(TO_DAYS(purchaseDate)-DAYOFYEAR(purchaseDate)+WEEK(purchaseDate)*7) will hopefully return the date you need. You'll have to enclose all that in a DATE_FORMAT to get a printable date tho. Last minute note: you might have to subtract 1 from the last term because I guess MySQL st

[PHP-DB] sql and week starting ending numbers (dates)

2002-06-01 Thread Adam Royle
Hello all, I am creating a finance manager in php and mysql for my own accounting purposes (and to broaden my skills in php and sql) and I have a couple of pages where I view statistics on how much I spend, etc, and what patterns are formed from my spending. I have made a couple of pages with

[PHP-DB] MySQL enum displaying values in Select

2002-06-01 Thread bob
Hello, I have a problem I can't seem to overcome. Maybe it's just something simple but for some reason I am unable to read in values from a mysql db column (enum) and display the results in an option box. I can display the values to the screen but I can't seem to get them into the option box. Th

Re: [PHP-DB] Array_rand issue...

2002-06-01 Thread Manuel
Here is how you do it: $pictures = array( 1, 2, 3, 4, 5, 6, 7, etc.) shuffle($pictures) //This will randomly rearrange them in the array. //then echo "$pictures[1] echo $pictures[2] echo $pictures[3]"; Dave Carrera <[EMAIL PROTECTED]> wrote: Hi All I have a fuctioning array of about 20

[PHP-DB] Re: Pulldown selection speeds

2002-06-01 Thread Hugh Bothwell
http://www.zend.com/zend/tut/drop-down.php or do a Google search for 'javascript chained select' "Chris Payne" <[EMAIL PROTECTED]> wrote in message 01c2092d$17a9fdb0$f7fea8c0@chris">news:01c2092d$17a9fdb0$f7fea8c0@chris... > I’m having an issue with pulldown selection speeds, > is there