Simple: Date Stamp mySQL and PHP
Hi all, Ive got a timestamp in a database column and basically I was wondering if there was any function in PHP to parse the date into something more readable from 20020123143547 23 Jan 2002 14:35 something like $date1= datetoreadable($date); Thanks Shannon __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: [PHP-DB] any good web hosting with php and mysql support?
Ive got numerous accounts with www.palmversa.com and I have to say they are very reliable and extremely cheap. Hope this helps Shannon -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Help! Languages and Characters....
I have a mysql table (MySAM), a field in there is set to unique, however the field does not seem to recognise the difference between certain ascii characters, for example it things that multimedia and multimèdia are the same (I hope it is shown correctly) but basically it dos not recognise characters like an e with an acute accent to be different from a normal e Anyone know how I can fix this? Thanks Shannon __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help! Languages and Characters....
The problem is that I dont want it case sensitive, but I do want it to distinguish special characters, any more ideas? Thanks Shannon --- Michael Brunson [EMAIL PROTECTED] wrote: On Fri, 21 Dec 2001 11:07:27 -0800 (PST), Shannon Kendrick [EMAIL PROTECTED] wrote: | I have a mysql table (MySAM), a field in there is set | to unique, however the field does not seem to | recognise the difference between certain ascii | characters, for example it things that | | multimedia and multimèdia are the same (I hope it is | shown correctly) but basically it dos not recognise | characters like an e with an acute accent to be | different from a normal e | | Anyone know how I can fix this? Set the field type as BINARY, that will make it case sensitive. Thanks, Michael -- Michael Brunson 504.473.6643 [EMAIL PROTECTED] ICQ: 83163789 ? Special Projects Programming Manager ? --- Intercosmos Media Group, Inc. --- www.intercosmos.comwww.directnic.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Table Locking...
Does anyone know of a way to lock at the row level instead of table level using MySQL 3.23.46 Thanks Shannon __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Table Locking...
Whats the drawback of using InnoDB instead of MySAM tables? --- Carl Troein [EMAIL PROTECTED] wrote: Shannon Kendrick writes: Does anyone know of a way to lock at the row level instead of table level using MySQL 3.23.46 Yep, use InnoDB instead of MyISAM tables. //C - person of few words. But surprisingly seldom. -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Table Locking...
Whats the drawback of using InnoDB instead of MySAM tables? --- Carl Troein [EMAIL PROTECTED] wrote: Shannon Kendrick writes: Does anyone know of a way to lock at the row level instead of table level using MySQL 3.23.46 Yep, use InnoDB instead of MyISAM tables. //C - person of few words. But surprisingly seldom. -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: letter 'O' with umlaut not equivalent to regular 'O'?
Try setting the column to binary, that what worked for me. Shannon --- awk [EMAIL PROTECTED] wrote: Description: Somehow the letter 'O' is not equivalent to the letter 'Ö' (O with umlaut), in string matching. How-To-Repeat: I tried the following query in MySQL: SELECT 'e'='ë', 'o'='ö'; (ie, select 'e' = e-with-umlaut, 'o' = o-with-umlaut) And the result: +-+-+ | 'e'='ë' | 'o'='ö' | +-+-+ | 1 | 0 | +-+-+ I believe both results should be '1' with Latin-1? I tried it on Linux (MySQL 3.23.46) and FreeBSD (3.23.42) with the same results. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Glitch?
Hi all, Ive recently been made aware of a glitch in MySQL regarding locked at the table level (instead of row) when a record is being updated. Is this still a problem in Version 3.23.46? Has it been fixed in 4.0.0? And if so, when is a stable version of 4.0 likely to be released? Many thanks, Shannon __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php