RE: Case sensitivity
You have two choices, you can use a binary datatype for the field, or force a binary comparison using the BINARY operator. http://www.mysql.com/doc/en/Case_Sensitivity_Operators.html http://www.mysql.com/doc/en/Column_types.html query, sql Mike -Original Message- From: asp52 [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 9:06 AM To: [EMAIL PROTECTED] Subject: Case sensitivity Hi, I have been searching tables based on search values which turn up tobe fine, however the results dont reflect case sensitivity. what i mean, if i run following query select field1 from table1 where name='text1'; this works fine but returns the same result set with text1 values of 'USER' or 'user'. i need to run the query which should run case sensitive. ie USER is different from user Thanks in advance who can throw some ligth Adamji - 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 - 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: Case sensitivity
You can specify a varchar field as binary, for instance: field1 varchar(50) binary query, sql Mike -Original Message- From: asp52 [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 9:50 AM To: Mike Grabski; [EMAIL PROTECTED] Subject: Re: Case sensitivity Thanks, Just worked it out with binary statement in my query. all fine. Would it be wise to use binary type table? didnt try that as i wanted a flexible table of type varchar to perserve space. what would be its impact? cheers. Adamji From: Mike Grabski [EMAIL PROTECTED] To: 'asp52' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, December 19, 2002 2:29 PM Subject: RE: Case sensitivity You have two choices, you can use a binary datatype for the field, or force a binary comparison using the BINARY operator. http://www.mysql.com/doc/en/Case_Sensitivity_Operators.html http://www.mysql.com/doc/en/Column_types.html query, sql Mike -Original Message- From: asp52 [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 9:06 AM To: [EMAIL PROTECTED] Subject: Case sensitivity Hi, I have been searching tables based on search values which turn up tobe fine, however the results dont reflect case sensitivity. what i mean, if i run following query select field1 from table1 where name='text1'; this works fine but returns the same result set with text1 values of 'USER' or 'user'. i need to run the query which should run case sensitive. ie USER is different from user Thanks in advance who can throw some ligth Adamji - 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 - 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: Parser seems to have problems with '-' (dash).
I believe I ran into this problem before, and I'm pretty sure that a back tick will work. NOTE: a backtick is not the same thing as a single quote Using the backtick will also help you handle (and hopefully rename) tables and so forth that accidentally or unknowingly use a reserved keyword. using mysql-front, it had a bad tendancy to enclose table names with backticks, and so table creation would be allowed, but when i tried to access the table from the command line i got all sorts of errors, and using the backticks again worked. So try the back tick (`table-with-dash`) and see if that works. Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 10:52 AM To: [EMAIL PROTECTED] Subject: Parser seems to have problems with '-' (dash). Hello I have hade several problems with the character '-' (dash, minus, or whatever you wan't to call it) the parser seems to regardles of quoting be seen as an substraction operator. Does anybody recognice this, have I just missed the part where the characters allowed in names and passwords is specified. antispam device: sql, query, queries, smallint Merry Christmas/Happy Hannuka/Happy holidays A Happy New Year -- ers - Anders Nygård - 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 - 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: Using MS Access as front end to mysql database
Depending on your OS, you might be able to implement security through the network layer via IPSec. I run mySQL between two Windows2k servers, with the mySQL server requiring the web server (in this case, a remote client to the mySQL server) to establish an IPSec tunnel in order to connect. It works very well. However, this perhaps is only a good solution where the servers/workstations involved are static and well defined. mysql query Mike Grabski -Original Message- From: Fernando Grijalba [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 10:17 AM To: MySQL Help Subject: RE: Using MS Access as front end to mysql database Just be careful because the connection can be looked at and if there is sensitive data going through someone who wants to can get their hands on it. The data travelling from the server to the client is not encripted and as far as I know there are not any hosts that will offer MySQL with the SSL support as it is not 100% working yet. Just something to think about. JFernando ** sql ** -Original Message- From: Michael She [mailto:[EMAIL PROTECTED]] Sent: December 14, 2002 16:33 To: JamesD Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Using MS Access as front end to mysql database Yup, agreed. MySQLODBC works over TCP/IP fine. I'm currently tunneling through a Linksys router to a database I have at home. If your provider is unwilling to compromise, it maybe time to look for another host. There are plenty of MySQL and MS SQL hosts who allow TCP/IP connections. At 11:56 AM 12/14/2002 -0800, JamesD wrote: they can do it. they just dont want to. firewall rules can be established to allow connects to the mysql port from only the ip's assoc with your remote offices, etc etc the answer is you can do what you want. You just need a business partner who can service his customer properly. mysqlODBC can do what you want. where mysql is located is irrelevant, in the grand sense. you just point to an ip and a port. etc etc James Danforth -Original Message- From: Donna Flanders [mailto:[EMAIL PROTECTED]] Sent: Friday, December 13, 2002 6:59 AM To: [EMAIL PROTECTED] Subject: Using MS Access as front end to mysql database We have been informed by our web hosting site that we cannot connect remotely to our mysql database using any kind of connection other than a script from a web page or phpMyAdmin. It is our intent to have our data stored in a mysql database on the web and use MS Access as the front end to the database. Our reasons are - we have an existing Access database with a small number of users at different locations that need to be entering data, running reports and queries. We also have a large number of agencies that would hit the database. It was our intent to migrate the data tables to mysql and leave MS Access as the front end. When we asked our web host about this, they responded this way: Due to security concerns you would not be able to connect to our mysql server thru an external terminal directly as a mysql client. You would be able to use mysql services only thru Web sevices i.e either thru php scripts or thru phpmyadmin in Control panel--Advanced Menu--Sql Databases _ My questions are - Is this true of all web hosts or just the one we are using? Our current hosting plan is a shared hosting plan. Do we have to have a dedicated database server to do this? Knowing that we want to keep MS Access as the front end, are there other options we have not explored? - 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 - 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 -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage : http://www.binaryio.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 - 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
RE: MySQL4 on Linux with Intel Hyperthreading CPUs?
If the OS can use hyperthreading, fortunately, benchmarks are showing that there's no preformance hits because of overhead created trying to keep resource contention down. This is good! So if your system _can_ support hyperthreading, leaving it on won't hurt, if it doesn't improve your system's performance. If the OS doesn't support hyperthreading, then it just won't use it, obviously, so it's not an issue. But as far as MySQL's usage and performance in particular with hyperthreading procs, I don't have any experience :/ Mike -Original Message- From: John Dell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 11, 2002 6:15 PM To: [EMAIL PROTECTED] Subject: MySQL4 on Linux with Intel Hyperthreading CPUs? Hi, I have a new dedicated mysql 4.0.5 server running redhat 8.0 that we are testing. The new server is a dual Intel Xeon 2.4GHZ with hyperthreading enabled, so Linux thinks there are 4 cpu's rather than the 2 real CPU's. Anybody have any experience with this and whether it can cause any problems with MySQL or Linux? Any performance reasons to enable/disable hyperthreading? Thanks! John Dell [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 - 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: Serwer Hardware p4 or pIII ?
I saw some discussion on this topic last night, and forgot to put in my .02: Whomever said that memory and hard disk hardware should be the focal point in a new mySQL DB server, and not processors, I very much disagree with. While I agree that ample and fast memory, in addition to an efficient, reliable, and speedy storage system, is vital, neither of those mean squat if you don't have a high speed bus and powerful CPU to do the computations. You can have gigs and gigs of RAM and the fastest SCSI RAID array, for all I care, if it's still on a tiny 100MHZ FSB (like _original_ P3s), you still have a huge bottleneck looming on your horizon. I've been an AMD user for quite some time, and I really think AMD can kick some butt, but I think the statement that P4 FPU performance is poor is not entirely correct. the 2.53GHz P4 is right on par, if not better, than all but the highest (2600+) AMD XP chips. The 2.8 certainly edges them out, and the 3.06 GHz's performance is ASTONISHING. This is based on multiple benchmarks I've either seen or done, so I'm not just talking whitepapers (and keep in mind, I've been a big AMD fan for a couple years now). I refused to be impressed by the performance of Intel's processors, but this made my head spin. As far as cash goes, yes the 3.06 is VERY expensive (around $700 right now), but the other tiers below it are getting ever more reasonable. It comes down to cash flow, I think. P3's strong points is that they are tried and true, powerful, reliable, but inexpensive. P4's fast memory bandwidth, and the upper echelon of P4s are just impressive, but expensive. AMD's are cheap and pack a good punch. I won't go into Xeon, MP, and other multi-proc stuff, that's a slightly different ballgame. I very much agree with mixing and matching different types of boxes based on their strongpoints. Mike -Original Message- From: Robert Adkins [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 9:22 AM To: andy thomas; [EMAIL PROTECTED]; Helmut Apfelholz Cc: [EMAIL PROTECTED] Subject: RE: Serwer Hardware p4 or pIII ? I am running a few AMD based servers in our offices here and have no issues with them. The big question is, What kind of operations are you most likely to see with your servers? If the servers will be doing some heavy floating point operations stay away from the Intel P4. (Unless recent versions have been fixed.) The Pentium 4 has a TERRIBLE FPU. If you need high FPU and MUST stick with Intel, then by all means look for Pentium III CPUs or look from some Pentium Xeon CPUs. If you aren't brand specific, take a look at AMD. They perform admirably for FPU options. For instance, there is one workstation application that we have for developing CNC Mill cutter path that simply tears things up when it is run on an AMD chip. Our old system would take nearly an hour to generate the same cutter path that is generated in less then 30 seconds on the AMD Chip. (Athlon 2000+ XP) In the tests performed by our vendor, a similar speed Pentium 4 takes quite a bit longer to generate the same cutter path. Something close to 5 minutes longer. Of course, that's all FPU doing the work there. The one thing that the P4 has over the AMD Athlon XP and P3 CPUs is raw memory bandwidth. It can easily outpace both of those other processors for VERY specific operations, like video editing and other HIGH Memory bandwidth hungry applications. Depending upon what you are building, you might want to utilize more then one CPU type across several boxes to be able to utilize the strengths of each processor design. Good luck! Regards, Robert Adkins II IT Manager/Buyer Impel Industries, Inc. Ph. 586-254-5800 Fx. 586-254-5804 -Original Message- From: andy thomas [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 1:33 PM To: [EMAIL PROTECTED]; Helmut Apfelholz; Robert Adkins Cc: [EMAIL PROTECTED] Subject: Re: Serwer Hardware p4 or pIII ? On Wed, 4 Dec 2002, Helmut Apfelholz wrote: Hi, I am assembling mysql only server. I am planning 2Gb RAM, 4 x 15k SCSI disks. However I cannot decide if I should get 2 p4 processors or 2 tuallatin pIII. I could not find any mysql specif?c benchmarks, that would show which processors I should use. I will be running linux on the server. Could anyone share his/hers experience with me ? I have often wondered about that myself so I would be interested in other people's views. I currently run a number of servers with dual 1GHz P3's. Andy - 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: mysql breaking through a firewall
Opening TCP port 3306 for inbound requests on your firewall should be adequate. Mike Grabski -Original Message- From: Grant Cooper [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 2:05 PM To: [EMAIL PROTECTED] Subject: mysql breaking through a firewall I am trying to break through my admins firewall on 1531. But my admin was thinking it needs more than one port like Microsoft MySQL. Are there special requirements for port assignments? If this doesn't work I have to use M. MySQL. :( Thanks in advance. G. Cooper - 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 - 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: .NET and mysql
There are a couple managed .Net providers for mySQL. One that I use is eInfo Designs' dbProvider. They have a couple different versions available, the personal is free. It works very well and is designed to work within Microsoft's .Net framework for data objects. www.einfodesigns.com I'd be interested in knowing of any other free providers if anyone else has other suggestions! Mike -Original Message- From: Natale Babbo [mailto:[EMAIL PROTECTED]] Sent: Friday, November 22, 2002 12:06 PM To: [EMAIL PROTECTED] Subject: .NET and mysql Hello All, Is it possible to connect to a MySQL database using .NET without ODBC? ... and if yes then please give me a sample connection string and tell me what provider/driver to use! Thanks a lot! __ Per te Blu American Express è gratis! http://it.yahoo.com/mail_it/foot/?http://www.americanexpress.it/land_yahoo - 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 - 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: MySQL as a desktop DB
Oh fiddle sticks! I just noticed mySQL-Front has been discontinued. I love that program :( Oh well, I'll check out this SQLyog. Thanks for the tip. Mike -Original Message- From: Insanely Great [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 1:58 AM To: MySQL List Subject: Re: MySQL as a desktop DB I think MySQL will be more faster in Desktop environment and if you are adverse to using the text based interface to MySQL then you can try out some GUI avaiable in the market. The best I know are MySQL-Front and SQLyog but since MySQL-Front has been discontinued you can try SQLyog at http://www.webyog.com/sqlyog Insane - Original Message - From: Adam Parker [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 3:11 AM Subject: MySQL as a desktop DB I currently use MS Access as a single-user desktop database. The database is getting quite large. The largest table has 300,000 rows. I am considering upgrading the database. How suitable is MySQL as a single-user desktop database? How does it compare to Access when it is used like this? Obviously MySQL would have advantages if I intended to use it as a server database with concurrent users. But is it faster than Access in the single-user environment, when dealing with large databases? Thanks for any help. - 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 - 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 - 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: using a php page to reboot linux
Although this is the wrong forum for this question, you certainly can. PHP has functions available to execute programs or command lines. http://www.php.net/manual/en/ref.exec.php Mike -Original Message- From: Harpreet Kaur [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 3:38 PM To: [EMAIL PROTECTED] Subject: using a php page to reboot linux Hi mysql list members, Is it possible to reboot the linux server through a PHP page. Like a client clicking on a button in a php page and that would result in rebooting the linux server. Can this be done?? Pls help, Regards, Harpreet Kaur _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.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 - 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: newbie PHP/mySQL query
You should pass the data to be imported into Flash through urlencode(). Flash needs the data to be urlencoded in order for it to be able to read it, particularly if the inputted data contains HTML, text with spaces, symbols, etc. Mike -Original Message- From: Phil Clandillon [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 25, 2002 11:22 AM To: [EMAIL PROTECTED] Subject: newbie PHP/mySQL query Hi everyone, I'm using a very simple PHP script with mySQL to load a news feed (url encoded) into flash. I've got it working but I would like the records to come out in the opposite order, with the newest one first. This is the script: ?php $db = mysql_connect(localhost, root, pass); mysql_select_db(sanchoDiary,$db); $sql=SELECT * FROM news; $result=mysql_query($sql,$db); $num = mysql_num_rows($result); $cur = 1; echo num=$numnewsFeed=; while ($num = $cur) { $row = mysql_fetch_array($result); $newsposter = $row[newsposter]; $newsitem = $row[newsitem]; $link = $row[link]; $datetime = $row[datetime]; echo font color=\#FF\b$newsposter/b/fontfont color=\#663366\br-br$newsitem br/fontfont color=\#FF00FF\uba href=\$link\ target=\_blank\$link/a/b/u/fontbr-- ---brfont size=\-1\ color=\#66\$datetime/fontbrbr; $cur++; } echo newsLoaded=1dummy=1; ? Can anyone help me to sort this out? cheers Phil Clandillon -- Graphic and Interactive Design -- work: http://www.clandillon.com play: http://www.mrming.co.uk - 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 - 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: newbie PHP/mySQL query
Agh... I apologize to all. Did not read the question asked correctly. As far as order is concerned, you need to add ORDER BY field sort order, DESC for descending, ASC for ascending if you have a date field, this would probably be the best to use. And example might be SELECT field1, field2, field3 FROM news ORDER BY date DESC Again, my apologies. Mike -Original Message- From: Phil Clandillon [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 25, 2002 11:22 AM To: [EMAIL PROTECTED] Subject: newbie PHP/mySQL query Hi everyone, I'm using a very simple PHP script with mySQL to load a news feed (url encoded) into flash. I've got it working but I would like the records to come out in the opposite order, with the newest one first. This is the script: ?php $db = mysql_connect(localhost, root, pass); mysql_select_db(sanchoDiary,$db); $sql=SELECT * FROM news; $result=mysql_query($sql,$db); $num = mysql_num_rows($result); $cur = 1; echo num=$numnewsFeed=; while ($num = $cur) { $row = mysql_fetch_array($result); $newsposter = $row[newsposter]; $newsitem = $row[newsitem]; $link = $row[link]; $datetime = $row[datetime]; echo font color=\#FF\b$newsposter/b/fontfont color=\#663366\br-br$newsitem br/fontfont color=\#FF00FF\uba href=\$link\ target=\_blank\$link/a/b/u/fontbr-- ---brfont size=\-1\ color=\#66\$datetime/fontbrbr; $cur++; } echo newsLoaded=1dummy=1; ? Can anyone help me to sort this out? cheers Phil Clandillon -- Graphic and Interactive Design -- work: http://www.clandillon.com play: http://www.mrming.co.uk - 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 - 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
Which would be a faster query:
I am building a forum as part of a site, and the forum is broken into three tables, a forum table, a thread table, and a post table. All tables have indexes for common SELECT statements, to increase speed. Example- A user posts a new thread: One method would be 3 queries to insert/update (insert into post, insert into thread, update forum) and 1 simpler query to read (SELECT forum info and stats), and in another method, 2 queries to insert/update (insert into thread, insert into post) and one slightly more complex query to read, using a query similar to this: SELECT COUNT(*) AS totalreplies, postid, threadid, userid, username, posteddate FROM post GROUP BY posteddate ORDER BY posteddate DESC At smaller volumes the query times are all very similar and not very substantial. I'm curious as to what the fastest method would be, at higher volumes. Thanks in advance for any thoughts, ideas or info. Mike Grabski - 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: Char vs Varchar field types
also, note that char is changed to varchar in some cases, such as when there is a text field in the table. -Original Message- From: Jon Haworth [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 10:40 AM To: 'Luke van Blerk'; [EMAIL PROTECTED] Subject: RE: Char vs Varchar field types Hi Luke, When is it appropriate to use Char instead of Varchar and vice versa? Use CHAR for when you know in advance how many characters are going to be in that field. A good example is for MD5 hashes: they are always 32 characters long, so you can use CHAR(32). Use VARCHAR for when you don't know - names, addresses, etc. Cheers Jon mysql aol / - 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 - 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: Access - Mysql conversion
I too am researching how to do this. I've found plenty of products that will do this, of course, I'd rather do it myself. here's some links i've found: http://www.convert-in.com/acc2sqlp.htm http://ultradev.buzzinet.co.uk/mysql/tutorials/converting_data/index.asp http://www.winmysql.com/ i hope that helps at all. If you find anything useful, would you be able to pass the word along? Thanks. Mike -Original Message- From: Joel Wickard [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 3:43 PM To: [EMAIL PROTECTED] Subject: Access - Mysql conversion I'm looking for a program, standalone, or web-based, to convert a current access database to mysql. any hints? - 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 - 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: ID in table
I believe auto_increment uses the last highest value inserted into the record. So if your first insert is 1000, it will count up from 1000 there on after. Correct me if wrong. Mike -Original Message- From: Jure Grom [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 17, 2002 3:56 PM To: MySQL - List Subject: ID in table Is there any way to start Ids in table from some number for exampl 1 with function auto_increment and not from 1? tnx jure - 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 - 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: Coldfusion?
Interesting story. We run Windows 200 servers, and we axed MSSQL and CF/ASP. i would (and do) run php even on a windows box. i guess the only problem it brings is no stored procedures, and people freak out if they don't have that enterprise interface. oh well. mySQL runs better even on a win32 platform (IMHO). -Original Message- From: Nally, Tyler G. [mailto:[EMAIL PROTECTED]] Sent: Friday, January 11, 2002 2:52 PM To: [EMAIL PROTECTED] Subject: RE: Coldfusion? -Original Message- From: Andy Ingham [mailto:[EMAIL PROTECTED]] We've been running Cold Fusion with MySQL on the Solaris platform for almost two years now and have had such terrible problems with Cold Fusion errors that we have begun the process of migrating to PHP. Our average load has been about 30,000 .cfm pages (linked to MySQL backend) served per week, which I don't consider to be too heavy a load to expect the system to handle successfully. Unfortunately, our log files are riddled with fatal Cold Fusion errors and subsequent restarts. It got so bad that we had to institute a cron job to check for the happiness of the CF processes every 3 minutes and restart them if there was a problem. Oh boy... I'll confirm that as well. I previously worked at Macmillan Computer Publishing (www.mcp.com) when I wrote The Personal Bookshelf and migrated that application from cgi-bin/perl and dbm arrays to Cold Fusion/Oracle all on Solaris. It was CF version 4. And it was really bad. In a development environment where there is limited access, and the machine load is relatively low, it's no problem. Yet, the webstats were saying we had approximately 8,000 users using the Personal Bookshelf at any one time, so it was going to be put under a heavy load once it is in production. Such happened and CF really really choked. The machine suffered under a really high *load*. Typically above 90%. The sysadmins joked that the machine was working so hard it was glowing in the corner. We optimized the code over the course of a couple of weeks scruitinizing the CF markup for more efficient ways to do things in order to get it down to a load. We got the load down to between 60-70% as I remember, which was still too high. Not only was the machine at an unusually high load, but the CF server would die periodically between every 10-45minutes. The sysadmins eventually wrote a script to check the health of the CF server instance that'd run every 3 minutes to determine whether or not it should restart CF automtically. It was a really bad situation. We talked with Allaire and they couldn't believe the problems we had with CF on Solaris. At the time, Allaire said that we had the largest *nix based CF application on the www with a Sun Ultra with 4 GB of RAM tied to a pretty heavy amount of disk space, etc. We provided them with database schema's, data, and our code ... and let them try it out. They did. And they confirmed everything we had said...even in their environment. They said the design of the database and the coding of the pages didn't contribute to the poor performance of the CF engine. Ultimately, they said they couldn't help us because the thing in CF that was causing all of the problems (they said) was a simulated windows registry that CF requires in order to operate. They said that we were also suffering from a lot of errors where CF would loose database connections and not keep threads alive like they would in a non-*nix environment without a heavy load. They had no answers for us at all. They suggested that it be monitored constantly so that the application stays running as much as possible. When I heard about the simulated registry for *nix servers built into CF, I nearly hit the roof! I couldn't hardly believe it. That was a couple of years ago, and CF has went from 4 -- 4.5 -- 5. Under a windows environment, it's probably pretty good. Under *nix (Solaris in my experience) it really left much to be desired. I'd avoid it and stick with php on Solaris any day. Tyler Nally -- __ _Tyler Nally / /__ _(_)___ _ _ [EMAIL PROTECTED] / / _ \/ __ `/ / __ \/ __ \ / __ \/ ___/ __ `/ 317-860-3016 / / __/ /_/ / / /_/ / / / // /_/ / / / /_/ / American Legion Website /_/\___/\__, /_/\/_/ /_(_)/_/ \__, /http://www.legion.org // // - 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual)
RE: I must be mental but.
There shouldn't be a space after -p password, also don't forget to put the user in there, unless you are using the default user (usually root, although i've noticed on win32 it seems to be 'ODBC') ex: if your password is test, the command would be mysqladmin -u user -ptest newpassword By all means, correct me if i'm wrong. It's happened before ;) Mike -Original Message- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 12, 2001 9:22 AM To: [EMAIL PROTECTED] Subject: RE: I must be mental but. I compiled without problem mysql on Redhat linux 7.1 I have just started the sever using nohup /usr/local/mysql/libexec/mysqld This started fine without problem. as I am used to using Oracle and new to mysql I decided to do an mysql_install_db which prompted me saying remember to change password using mysqladmin -p password `password` I did this and it asked me for a password ?? what is the password and how do I change it. This command to me suggests that -p password enters the password password and the `password` is the new password ??? can someone explain ?? Thanks, Matt. - 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 - 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: Pictures in mysql
as someone suggested, if you have ASP, you can get an upload module. if you have php 4, you already have full capability to upload images, either using FTP, or if your server will let you copy from the temporary directories, for instance: page 1 has a form that allows you to select an image on your harddrive, in a variable called fileupload. the form target has a script similar to this: if(!$fileupload = none) { copy($fileupload,[target]); unlink($fileupload); } at the same time, you can simply insert [target] reference into your mySQL database. the above will only work, of course, if you have the correct permissions on the server's temp folder. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 24, 2001 8:10 AM To: [EMAIL PROTECTED] Subject: Pictures in mysql Hello friends. I am a newbie in mysql and web programming. Can someone please tell me where I can find some info on putting pictures into mysql fields and also how I can use a web interface to add the pictures to the database. Thanks Denis - 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 - 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