[PHP-DB] Re: It counts everything not a specific day..
Fixed it by doing multiple querys -- JJ Harrison [EMAIL PROTECTED] Noodle Snacks [EMAIL PROTECTED] wrote in message news:20021019113342.17226.qmail;pb1.pair.com... Although my query returns the date of the day that had the highest number of records inserted. It outputs the total number of records in the table.. Can someone with more experience in SQL help me only count the number of records inserted on the day with the highest number of records? BTW the column time is a UNIX timestamp that is set upon insert. here is my query: $query = SELECT extract(year FROM time), extract(month FROM time), count(*) as monthly_views, time FROM tececo_stats group by extract(year FROM time), extract(month FROM time) order by monthly_views desc limit 1 ; -- JJ Harrison [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Free shopping cart
I need to write a shopping cart for my friend's website. I thought modifying a free one for my need would be easier. Sorry for asking question like this. But I've done the search on google and all I could find weren't free. Can anyone provide me some links? Thanks a lot. Tony S. Wu [EMAIL PROTECTED] Nope, this world ain't perfect. But at least I know it's not because of me. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Free shopping cart
On Sunday 20 October 2002 23:17, Tony S. Wu wrote: I need to write a shopping cart for my friend's website. I thought modifying a free one for my need would be easier. Sorry for asking question like this. But I've done the search on google and all I could find weren't free. Can anyone provide me some links? Try: www.zend.com freshmeat.net sourceforge.net and even: www.hotscripts.com -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* You are number 6! Who is number one? */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Free shopping cart
Thanks a lot :D Tony S. Wu [EMAIL PROTECTED] Nope, this world ain't perfect. But at least I know it's not because of me. Jason Wong at [EMAIL PROTECTED] wrote: On Sunday 20 October 2002 23:17, Tony S. Wu wrote: I need to write a shopping cart for my friend's website. I thought modifying a free one for my need would be easier. Sorry for asking question like this. But I've done the search on google and all I could find weren't free. Can anyone provide me some links? Try: www.zend.com freshmeat.net sourceforge.net and even: www.hotscripts.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Free Shopping Carts
Hi Tony ! I've had to do the search for shopping carts too,so I can relate. There are also some free carts ,as well as some interesting accessories,for lack of a better term at:a href=http://www.phpbuilder.com;/a. Click on code bank or code library (something like that),then click the search by category link. Albert Benjamin a href=http://www.successolution.com;/a -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Sorry about that !
Free shpping carts at:www.phpbuilder.com . -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Forms question..
Hi all... When I have an input form I must click on the first input field. Is there anyway to have it active when the form loads? #2 When I tab down to the next input field, is there anyway to have it highlight what is in the field (ie the default data) so that it will overwrite it? #3 How can I get the form to submit when I hit the return button? Right now I have to click on the button with my mouse. #4 How can I get a column of numbers to left justify? Thanks JIM -- Jim Hatridge Linux User #88484 -- BayerWulf Linux System # 129656 The Recycled Beowulf Project Looking for throw-away or obsolete computers and parts to recycle into a Linux super computer -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Forms question..
When I have an input form I must click on the first input field. Is there anyway to have it active when the form loads? Javascript, not PHP. Something like document.form.element.setfocus(), I think. #2 When I tab down to the next input field, is there anyway to have it highlight what is in the field (ie the default data) so that it will overwrite it? Client side...not PHP. #3 How can I get the form to submit when I hit the return button? Right now I have to click on the button with my mouse. Client side, depends on the browser, not PHP #4 How can I get a column of numbers to left justify? HTML, not PHP. Align=left ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Forms question..
1. document.formname.elementname.focus(); Example: if my form has a name of testform and the first element is fname... then in the body tag i would do this... body onload=document.testform.fname.focus(); 2. Yeah, you need to use the select() method... so document.testform.element.select(); Example: input name=example value=N/A onfocus=document.testform.example.select(); That should work...or it might have to be in a function... 3. It should do that for you with the submit button...what browser are you using? 4. use the align attributealign=left On Sun, 2002-10-20 at 12:27, James Hatridge wrote: Hi all... When I have an input form I must click on the first input field. Is there anyway to have it active when the form loads? #2 When I tab down to the next input field, is there anyway to have it highlight what is in the field (ie the default data) so that it will overwrite it? #3 How can I get the form to submit when I hit the return button? Right now I have to click on the button with my mouse. #4 How can I get a column of numbers to left justify? Thanks JIM -- Jim Hatridge Linux User #88484 -- BayerWulf Linux System # 129656 The Recycled Beowulf Project Looking for throw-away or obsolete computers and parts to recycle into a Linux super computer -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- .: B i g D o g :. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: String extraction from blobs. Extracted string to be placedinto field within another table.
Hello, On 10/19/2002 11:13 PM, Dwalker wrote: What is the most effective method of extracting from a blob specified text to be placed into another table field. If you use Metabase it allows you to create prepared queries where you can pipe data from blob returned by a select query to a blob to be updated or inserted by another query, with minimal memory usage, thus allowing to manipulate large sized blobs. Metabase is a database independent abstraction layer so it works with many supported databases: http://www.phpclasses.org/metabase -- Regards, Manuel Lemos -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] String extraction from blobs. Extracted string to be placed into field within another table.
What is the most effective method of extracting from a blob specified text to be placed into another table field. This email message and all attachments transmitted herewith are tradesecret and/or confidential information intended only for theviewing and use of addressee. If the reader of this messageis not the intended recipient, you are hereby notified that any review, use, communication, dissemination, distribution or copying of this communication is prohibited. If you have received this communication is error, please notify the sender immediately by telephone or electronic mail, and delete this message and all copies and backups thereof. Thank you for your cooperation. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
