RE: Two values for LIMIT?
Hi Antonio, I need help for prompt LIMIT with two values, the first value is the starting row, the second value end of LIMIT. I think your syntax is a little bit out... if you're passing two values, the following apply: - The first value is the starting row - The second value is the number of records to return So if you wanted to return rows 40 to 60, use LIMIT 40,20 (start at 40 and return 20 rows from there) It's all explained on the SELECT man page: http://www.mysql.com/doc/en/SELECT.html (scroll down) HTH Jon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Boolean!
Hi T., How can I set the domain of a attribute to a boolean value? OK, I'm not entirely clear with your terminology, but I think you're asking how do I define a field as a boolean... MySQL doesn't provide a boolean datatype as such, but in my experience the best way to handle it is to define a field as a smallint and use 1 for true and 0 for false. Cheers Jon - 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
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
RE: [PHP] Dumped OK, Restore NOT
Anyways, if any PHP people here are--god forbid--actually using MySQL as their database, I would GREATLY appreciate any help in this matter. I've thoroughly read the mysqldump chapter in the docs, and gone through several tutorials, but have found nothing on actually restoring a database from a dumped file--ON Windows. Have you tried something like phpMyAdmin (or something similar, like Mascon)? Cheers Jon ** 'The information included in this Email is of a confidential nature and is intended only for the addressee. If you are not the intended addressee, any disclosure, copying or distribution by you is prohibited and may be unlawful. Disclosure to any party other than the addressee, whether inadvertent or otherwise is not intended to waive privilege or confidentiality' ** - 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] Access to MYSQL via ODBC?
apart from performance issues, is it possible in PHP to read/write a MYSQL DB not directly, but via ODBC? The reason (as states in my other message MS ACCESS on Linux) is that it would make possible to test on Linux PHP code that would eventually manage (wit xero or minimal changes) an MS access on NT/IIS. While the theory behind this is sound, a quick caveat: Access' SQL is way out in left field somewhere, and you might find you need to do considerable tweaking to get the same results out of Access MySQL. You might want to consider some sort of db abstraction layer to make the transition a bit easier - it's more work up front, but the benefits are many :-) Cheers Jon ** 'The information included in this Email is of a confidential nature and is intended only for the addressee. If you are not the intended addressee, any disclosure, copying or distribution by you is prohibited and may be unlawful. Disclosure to any party other than the addressee, whether inadvertent or otherwise is not intended to waive privilege or confidentiality' ** - 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: Can only create 127 records in a table :o(
Your autoincrement column is of type TINYINT. This type is specifically designed to only hold numbers from 0 to 127. For best results, use an INTEGER - they can accept numbers up to 999 IIRC. HTH Jon -Original Message- From: Mette Møller Madsen [mailto:[EMAIL PROTECTED]] Sent: 15 June 2001 12:46 To: mysql listserver Subject: Can only create 127 records in a table :o( Hi there! When I try to insert more than 127 rows/records in a table I get this error: ERROR 1062: Duplicate entry '127' for key 1 (the key is an auto incremented primary key) Does anyone know how to store _more_ than 127 rows in a table? My guess is that I need to change to settings of my db, but I cannot find anything in the manual. (I'm running version 3.23.38 which should be a stable one.) best regards, Mette Madsen - 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 ** 'The information included in this Email is of a confidential nature and is intended only for the addressee. If you are not the intended addressee, any disclosure, copying or distribution by you is prohibited and may be unlawful. Disclosure to any party other than the addressee, whether inadvertent or otherwise is not intended to waive privilege or confidentiality' ** - 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: order by rand() question
I don't think the answer has changed since last week :-) IMHO it's not really slow and inefficient, anyway - this script: ---start--- ?php $db = mysql_connect(localhost, root, :-)); mysql_select_db(Playground, $db); mysql_query(CREATE TABLE mytable (myfield INTEGER UNSIGNED, PRIMARY KEY myfield))); for ($foo=1; $foo=1; $foo++) { $s = INSERT INTO mytable SET myfield=. $foo; mysql_query($s); } ? end produces a table with 1 rows each containing an integer. Then we do: mysql SELECT * FROM mytable ORDER BY RAND() LIMIT 5; +-+ | myfield | +-+ |9935 | |3221 | |1530 | |3889 | |2133 | +-+ 5 rows in set (0.08 sec) Right, that's *less than a tenth of a second*, and that's on a crufy old P200 that also happens to be serving our company Intranet at the same time as doing this little experiment. So what's so inefficient? I can't blink in 0.08 seconds, let alone think a query is running too slowly. Cheers Jon -Original Message- From: Matt Heaton [mailto:[EMAIL PROTECTED]] Sent: 15 June 2001 14:23 To: [EMAIL PROTECTED] Subject: order by rand() question Hi all, trying to do something and have it be as efficient as possilble. My question is if I have a table with say 10,000 rows in it, and I issue a command like this select * from table where number=1 order by rand() limit 1; If 1000 rows would match this command does mysql first find all 1000 rows and THEN randomly select 1 of those to return, OR does it just randomly start somewhere and then stop when it finds one? The first method would be really slow and inefficient, but I am afraid that is how it works? Is there anyone out there that knows FOR SURE how the order by rand() operation works? I can't find a specification out there for it. Thanks, Matt Heaton - 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 ** 'The information included in this Email is of a confidential nature and is intended only for the addressee. If you are not the intended addressee, any disclosure, copying or distribution by you is prohibited and may be unlawful. Disclosure to any party other than the addressee, whether inadvertent or otherwise is not intended to waive privilege or confidentiality' ** - 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: concated comparisons stopped working properly
And why do you think it should return 0 ? ( 1 5 ) returns 1. ( 1 3 ) returns 1. ( 1 5 3 ) should then return 1. Or am I missing something? I think probably becuse ( 5 3 ) returns 0. Depends how you read it, either as 1 is less than 5 and less than 3 or 1 is less than 5 and 5 is less than 3. Of course the real question is how does MySQL read it? :-) Cheers Jon ** 'The information included in this Email is of a confidential nature and is intended only for the addressee. If you are not the intended addressee, any disclosure, copying or distribution by you is prohibited and may be unlawful. Disclosure to any party other than the addressee, whether inadvertent or otherwise is not intended to waive privilege or confidentiality' ** - 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: re: startup Help
I take it you're running Windows? If so then PATH is an environment variable that allows you to run any command in its directories from anywhere. Example: c:\ path=c:\windows;c:\windows\command c:\ dir *.exe Volume in drive C has no label Volume Serial Number is 07D1-0502 Directory of C:\ File not found 17,223.45 MB free c:\ ipconfig Windows 98 IP configuration 1 Ethernet adapter: IP address. . . . . . . . : 10.10.10.107 In this example, ipconfig.exe is actually in c:\windows, but I can run it from c:\ because my PATH variable includes c:\windows. You can find out your current path settings by typing path at a DOS prompt, and you can add your own by modifying your autoexec.bat file. HTH Jon -Original Message- From: Martin Scherer [mailto:[EMAIL PROTECTED]] Sent: 13 June 2001 05:15 To: [EMAIL PROTECTED] Subject: re:re: startup Help Thank you, but what does exactly does that mean. An example would help. m. On Tue, 12 Jun 2001, Martin Scherer wrote: I am told that mysqladmin is not an understood command. Looks like you need to update your PATH variable. Neil - 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 ** 'The information included in this Email is of a confidential nature and is intended only for the addressee. If you are not the intended addressee, any disclosure, copying or distribution by you is prohibited and may be unlawful. Disclosure to any party other than the addressee, whether inadvertent or otherwise is not intended to waive privilege or confidentiality' ** - 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/PHP/Apache on PPC
Hi, snip What I am wanting to know is, am I best off installing MySQL/PHP/Apache on Windows98 (emulated on G4 Mac/OS 9.1) or should I hold off for an installation on a separate partition of LinuxPPC. I have tried installing on the Win98 emulator but there are loads of errors. /snip I don't know much about Macs, but I would say you're better off with a Linux than Windows, even when the Windows isn't emulated :-) snip Are there issues with MySQL/PHP/Apache on Win98 emulated? /snip There are issues with these on Win98 on a PC, so probably, yes. snip Do I need more than one computer on a network to use MySQL server or can I use the server on the same machine (TCP/IP)? /snip Nope, you can do it all on one machine - just specify 127.0.0.1 or localhost for the server name. snip I have a virtual server account with MySQL/PHP supported. Is there an easy way of setting up a test bed there on the web and interacting with it via FTP/HTTP? /snip Aha, you need PHPMyAdmin (http://sourceforge.net/projects/phpmyadmin/), it's a PHP-based admin package for MySQL - you do all the work via html forms. You just upload the whole shebang to your webserver, password-protect the directory, and off you go. Great stuff. HTH Jon ** 'The information included in this Email is of a confidential nature and is intended only for the addressee. If you are not the intended addressee, any disclosure, copying or distribution by you is prohibited and may be unlawful. Disclosure to any party other than the addressee, whether inadvertent or otherwise is not intended to waive privilege or confidentiality' ** - 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: how to setup a Newsletter?
You could do this with PHP. insert story into database; do { get subscriber email address; send email with link to story; } until no more subscribers If you have a lot of subscribers you'd be better off with a proper list manager, though. HTH Jon -Original Message- From: kaab kaoutar [mailto:[EMAIL PROTECTED]] Sent: 30 May 2001 10:29 To: [EMAIL PROTECTED] Subject: how to setup a Newsletter? Hi! I'working with php/mysql and id like to set a news letter! can u guide me through how to trigger sending an email once an article is inserted to my table in the database? i mean i want emails to be sent to all subscribers (stored in subscribers table) once an article is inserted in the articles database ! the aim is to automate it without human intervention! Thanks ** 'The information included in this Email is of a confidential nature and is intended only for the addressee. If you are not the intended addressee, any disclosure, copying or distribution by you is prohibited and may be unlawful. Disclosure to any party other than the addressee, whether inadvertent or otherwise is not intended to waive privilege or confidentiality' ** - 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: Can't login to MySQL from PHP
Hi Marco, The usual method is something along the lines of: --start-- $server = localhost; $username = your username; $password = your password; $database = your database name; $db_handler = mysql_connect($server, $username, $password) or die (mysql_error()); mysql_select_db ($database); ---end--- The die (mysql_error()) will echo the error message to the screen if the connection failed, which at least will let you know what went wrong (hopefully). You shouldn't have to enter the username and password anywhere else but here (it's generally a good idea to have the above code in a separate file, which you then include into any script that needs database connectivity). Armed with this information, you should be in a better position to sort it out, but give us a shout if it's still not happy. HTH Jon -Original Message- From: Marco Bleeker [mailto:[EMAIL PROTECTED]] Sent: 29 May 2001 16:25 To: [EMAIL PROTECTED] Subject: Can't login to MySQL from PHP Hello, I am a novice to Apache, MySQL and PHP. I have just installed these on my Win98SE machine, and want to do some off-line ('localhost') exercises before I go on the web. Apache and PHP work; I can run PHP scripts that do not access a database. But as soon as I try mysql_connect(), I get errors. I am sure it is something very basic I am missing. Perhaps it's a matter of username/password; I fooled around a bit with those, but to no effect (how are those verified? I suppose they have to be entered in 2 places?). Does anyone have a hint? Or can someone guide me through a procedure to track the problem? Which additional info do you need? ** 'The information included in this Email is of a confidential nature and is intended only for the addressee. If you are not the intended addressee, any disclosure, copying or distribution by you is prohibited and may be unlawful. Disclosure to any party other than the addressee, whether inadvertent or otherwise is not intended to waive privilege or confidentiality' ** - 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: Database accepts only 127 records
Define your tables so you're not using TINYINT as your primary key - it has a maximum size of 127. If you use INTEGER you should be fine. HTH Jon -Original Message- From: Jari Mäkelä [mailto:[EMAIL PROTECTED]] Sent: 25 May 2001 12:29 To: [EMAIL PROTECTED] Subject: Database accepts only 127 records Hi, got a problem as mysql does not allow writing but 127 entries to a database, any idea how to correct this abnormality? Jari Mäkelä - 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 ** 'The information included in this Email is of a confidential nature and isi ntended only for the addressee. If you are not the intended addressee, any disclosure, copying or distribution by you is prohibited and may be unlawful. Disclosure to any party other than the addressee, whether inadvertent or otherwise is not intended to waive privilege or confidentiality' ** - 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: another question to continue
Yes, you have to escape special characters. Not sure about accents etc, but a search on the list archives (lists.mysql.com) should turn up something, this gets discussed pretty regularly. HTH Jon -Original Message- From: Jari Mäkelä [mailto:[EMAIL PROTECTED]] Sent: 25 May 2001 13:03 To: [EMAIL PROTECTED] Subject: another question to continue hi again, am not quite sure of this as Mysql is too new thing to me but apostrophesl ike plain 'and é in text being written in has to be dealt with somehow, is the say 0'keefe solution the proper way to do that. meaning that O\'keefe works? Jari Mäkelä ** 'The information included in this Email is of a confidential nature and isi ntended only for the addressee. If you are not the intended addressee, any disclosure, copying or distribution by you is prohibited and may be unlawful. Disclosure to any party other than the addressee, whether inadvertent or otherwise is not intended to waive privilege or confidentiality' ** - 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: characters - URGENT!!
I would say it depends on what you're using to put the data into your database. PHP comes with several functions that make this sort of thing very easy (strip_tags, for example, will remove all HTML tags from a string) If you're using Perl or something else that supports regex, I think that's going to have to be the best way. HTH Jon -Original Message- From: Selvin Sakal [mailto:[EMAIL PROTECTED]] Sent: 24 May 2001 12:43 To: [EMAIL PROTECTED] Subject: characters - URGENT!! Hi, i have a mysql database, can anyone tell me any characters that cannot be entered into mysql (like !@#$%, etc). Also i have a string and i would like to remove html tags, characters (like ~!@#$%^*()_+|`-=\{}[]:?;',./ ) out of it, so basically i want the string to be just left with words. any help would be helpful, Thanks Selvin P.S. this is urgent i need this very quickly _ Get Your Private, Free E-mail from MSN Hotmail at 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 ** 'The information included in this Email is of a confidential nature and is intended only for the addressee. If you are not the intended addressee, any disclosure, copying or distribution by you is prohibited and may be unlawful. Disclosure to any party other than the addressee, whether inadvertent or otherwise is not intended to waive privilege or confidentiality' ** - 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: Basic Beginner Question
Try clicking on Execute SQL Statement and entering CREATE DATABASE MyDatabaseName (without the quotes, and replacing MyDatabaseName with whatever you like). It should be as simple as that, but if it doesn't work, you may want to check with your host that you _are_ allowed to do it - some don't let you create multiple databases, you have to stash all your tables in one big database. Cheers Jon -Original Message- From: Savin, Jill [mailto:[EMAIL PROTECTED]] Sent: 24 May 2001 17:27 To: [EMAIL PROTECTED] Subject: Basic Beginner Question I am brand new to MySQL - my web host has set up a graphical tool for me to use, to try and administer it - it's called MysqlTool, Version 0.85. It's got a database there that my host created for me. Now I want to create an additional database, but don't see any kind of button for doing that. If I go inside the database he already created, I can find a prompt that says Execute SQL Statement or Generate Create Table Script, and a New Table - would either of these links allow my to create a new database? And if so, how would I do it? thanks j ** 'The information included in this Email is of a confidential nature and is intended only for the addressee. If you are not the intended addressee, any disclosure, copying or distribution by you is prohibited and may be unlawful. Disclosure to any party other than the addressee, whether inadvertent or otherwise is not intended to waive privilege or confidentiality' ** - 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: Cold Fusion Express
Perhaps MyODBC would help you out... http://www.mysql.com/downloads/api-myodbc.html Don't know for sure but it's probably worth a look :-) HTH Jon -Original Message- From: Timothy Heald [mailto:[EMAIL PROTECTED]] Sent: 23 May 2001 13:57 To: [EMAIL PROTECTED] Subject: Cold Fusion Express Hi. I am new to this list and I am having some problems. I have set up a small personal server at my house to set up a site for family and such. I am by trade a cold fusion developer. On the server at home I have a cold fusion express application server running on a win2k box using iis as my web server. I would like to use MYSQL as my db however my odbc settings in the cold fusion administrator does not have a driver listing for it. Will one of the other drivers work or m I stuck using access at the house? Any help would be greatly appreciated. Tim Heald Application Development http://www.schoollink.net/ - 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 ** 'The information included in this Email is of a confidential nature and is intended only for the addressee. If you are not the intended addressee, any disclosure, copying or distribution by you is prohibited and may be unlawful. Disclosure to any party other than the addressee, whether inadvertent or otherwise is not intended to waive privilege or confidentiality' ** - 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: To install MySQL, where can free download Lunix?
http://www.slackware.com/ (IMHO the best distro) Other distros: http://www.suse.com/ http://www.debian.com/ http://www.mandrake.com/ http://www.redhat.com/ etc A google for download linux would have answered the question for you, BTW. HTH Jon -Original Message- From: johnd [mailto:[EMAIL PROTECTED]] Sent: 30 April 1999 18:04 To: [EMAIL PROTECTED] Subject: To install MySQL, where can free download Lunix? Hi, I would like to install MySQL. I want to setup Lunix on IBM compatible computer. Do you know where I can get free download Lunix recent version? Thank you very much. John Ding ** 'The information included in this Email is of a confidential nature and is intended only for the addressee. If you are not the intended addressee, any disclosure, copying or distribution by you is prohibited and may be unlawful. Disclosure to any party other than the addressee, whether inadvertent or otherwise is not intended to waive privilege or confidentiality' ** - 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: My script that uses mysql.
I am not sure if i should post it here but please do help my if you can. Probably one of the PHP lists would be a better place ;-) Check out http://www.php.net/support.php for a full run-down. The script is as follows: snip I basically have two questions. If i want to make a "mailto" function to "print $row["email_player"];", how do i do that? The basic command would be: mail($row["email_player"], "the subject", "the message"); However there are some setup things you need to do (give PHP the name of your mail server etc), have a look at http://www.php.net/mail for more info about this function. And question #2. Exactly what do the $row do? $row is an array holding the data that was returned from MySQL. If you have a field called "firstname" and a field called "surname", you can get the data for these fields for the current row by looking at $row["firstname"] and $row["lastname"]. The reason it's in a loop is to step through any multiple rows that were returned. Again, http://www.php.net/mysql-fetch-array has all the details you'll need, and then some. HTH Jon ** 'The information included in this Email is of a confidential nature and is intended only for the addressee. If you are not the intended addressee, any disclosure, copying or distribution by you is prohibited and may be unlawful. Disclosure to any party other than the addressee, whether inadvertent or otherwise is not intended to waive privilege or confidentiality' ** - 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 on Windows 2k
Are you in the right directory, or do you have your PATH environment variable set to point to the right directory? Running mysql from C:\windows\ is unlikely to work unless you've tweaked your settings. HTH Jon -Original Message- From: Daniel J. [mailto:[EMAIL PROTECTED]] Sent: 22 March 2001 17:20 To: [EMAIL PROTECTED] Subject: MYSQL on Windows 2k I installed mysql as a service and it starts/stops fine, but whenever I try any commands starting with 'mysql' on the prompt it says it's an unrecognized command. Please help. ** 'The information included in this Email is of a confidential nature and isi ntended only for the addressee. If you are not the intended addressee, any disclosure, copying or distribution by you is prohibited and may be unlawful. Disclosure to any party other than the addressee, whether inadvertent or otherwise is not intended to waive privilege or confidentiality' ** - 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: Connect Apache
Not sure exactly what you're after... MySQL isn't an Apache module, it's a separate program. You want MySQL to run on Apache? http://www.mysql.com/downloads/ You want Apache to run MySQL on? http://httpd.apache.org/ HTH Jon -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 09 March 2001 14:52 To: Mysql Subject: Connect Apache Hello All, Where can I find Apache module for mySQL ?? -- Best Regards, Winson Chang 3F, 2, 150 Lane, Sec. 5, Hsin I Rd., Taipei, Taiwan, R.O.C. Tel: +886-2-27225333 ext 376 Fax: +886-2-27222330 Email: [EMAIL PROTECTED] ** 'The information included in this Email is of a confidential nature and isi ntended only for the addressee. If you are not the intended addressee, any disclosure, copying or distribution by you is prohibited and may be unlawful. Disclosure to any party other than the addressee, whether inadvertent or otherwise is not intended to waive privilege or confidentiality' ** ** 'The information included in this Email is of a confidential nature and is intended only for the addressee. If you are not the intended addressee, any disclosure, copying or distribution by you is prohibited and may be unlawful. Disclosure to any party other than the addressee, whether inadvertent or otherwise is not intended to waive privilege or confidentiality' ** - 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: trying to install on RedHat 7.0 and need help
At the moment all anyone can do is point you to the manual at http://www.mysql.com/doc/I/n/Installing.html. Given how easy this is to find from www.mysql.com, we must assume you have already read it and therefore are having some sort of problem not covered by it - perhaps you could explain what is happening? Cheers Jon -Original Message- From: Charles L. Hagen [mailto:[EMAIL PROTECTED]] Sent: 04 March 2001 04:12 To: [EMAIL PROTECTED] Subject: trying to install on RedHat 7.0 and need help Importance: High I cannot seem to get this database program to work correctly. I am asking for any help I can get. I need to start this asap. Charles Hagen [EMAIL PROTECTED] ** 'The information included in this Email is of a confidential nature and is intended only for the addressee. If you are not the intended addressee, any disclosure, copying or distribution by you is prohibited and may be unlawful. Disclosure to any party other than the addressee, whether inadvertent or otherwise is not intended to waive privilege or confidentiality' ** - 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: Just Checking
ping! -Original Message- From: Quentin Bennett [mailto:[EMAIL PROTECTED]] Sent: 05 March 2001 03:04 To: MySQL (E-mail) Subject: Just Checking Hi, I someone sees this, can they respond, because I have received nothing from the list for 30 hours +. It's now 16:00 NZ Time, 03:00 GMT on Monday 5th March Thanks Quentin Bennett Transport Systems Division Infinity Solutions web http:\\www.infinity.co.nz mailto:[EMAIL PROTECTED] Phone : +64 9 358 9720 Fax : +64 9 309 4142 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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 ** 'The information included in this Email is of a confidential nature and is intended only for the addressee. If you are not the intended addressee, any disclosure, copying or distribution by you is prohibited and may be unlawful. Disclosure to any party other than the addressee, whether inadvertent or otherwise is not intended to waive privilege or confidentiality' ** - 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: Suggestion For List Management
Well, you could filter anything sent or cc'ed to [EMAIL PROTECTED] into a separate folder -Original Message- From: Jeff Gannaway [mailto:[EMAIL PROTECTED]] Sent: 22 February 2001 11:08 To: [EMAIL PROTECTED] Subject: Suggestion For List Management Here's an idea for the list memebers and list master Since a lot messages have undescriptive subjects ("Help", "Check This", "What's This?", etc...) I think it would be a good idea to set up the majordomo to add a tag to each subject line like the PHP list does. For instance Subj: Help become: Subj: [MYSQL] Help I've only been on the list for a day and a half. However I'm a memeber of 3 high-volume lists and I can tell that adopting this technique would make my life easier, and presumably other list memebers too. It definitely makes it easier to sort through your e-mails. Anyway, that's my 2 -Jeff Gannaway [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 ** 'The information included in this Email is of a confidential nature and isi ntended only for the addressee. If you are not the intended addressee, any disclosure, copying or distribution by you is prohibited and may be unlawful. Disclosure to any party other than the addressee, whether inadvertent or otherwise is not intended to waive privilege or confidentiality' ** - 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: SQL statement in PHP
PHP sees the first " of "Consultancy" as being the end of the variable $sql. To get round this, change the " to ' inside the statement (e.g. ...where Business_Type = 'Consultancy' and...) HTH Jon -Original Message- From: Matt Davis [mailto:[EMAIL PROTECTED]] Sent: 16 February 2001 12:43 To: mysql Subject: SQL statement in PHP Can anybody help with this If I put the following statement in PHP my browser tells me that there is an error on the line. //create sql statement $sql = "select Business_Name,Trading_Details where Business_Type = "Consultancy" and Bassingbourn != "0" from Main"; If I remove where Business_Type = "Consultancy" and Bassingbourn != "0" It work fine, but no variation of the above line works. Am I missing something really obvious. Please help as I am very quickly becoming bald. 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: Here you have, ;o)
Oh no, not another one -Original Message- From: Mike Hammonds [mailto:[EMAIL PROTECTED]] Sent: 12 February 2001 18:30 To: [EMAIL PROTECTED] Subject: Here you have, ;o) Hi: Check This! - 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: Downloading MySql
http://www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.32-win.zip This is the link to the Win32 binary of the latest version. To find the downloads page on the website, visit www.mysql.com and click on the "Downloads" link in the menu on the left of the screen. HTH Jon -Original Message- From: Pradeep Rangdal [mailto:[EMAIL PROTECTED]] Sent: 08 February 2001 11:27 To: [EMAIL PROTECTED] Subject: Downloading MySql Dear sir , I was browsing the whole site to down load the windows NT version of mysql but i could not get any proper guidence or the proper downloading page.. could u please guid me in downloading mysql.. Thanking you. Pradeep Rangdal Cybage Software Ltd Pune - 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: Download of MySQL
Well, it's not me, I found it with no problems. 1. Click on "Downloads" 2. Click on the first link under "MySQL database" (helpfully labelled "Stable release, recommended") 3. Select your OS. Seems sensible enough. Cheers Jon -Original Message- From: Gustav Wiberg [mailto:[EMAIL PROTECTED]] Sent: 24 January 2001 14:30 To: MYSQL List Subject: Download of MySQL Hi Is it just me who thinks it is very difficult to find the right download-location for MySQL (when you have Windows 95, or Windows 98) on the mysql.com-site? /Gustav Wiberg - 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: Sorting a date
You may find it easier to store the date as a timestamp and convert it on the fly, depending on what you're using to get the info from the database. In PHP, you'd need something like $date = mktime(0,0,0,$month,$day,$year); where $month, $day and $year hold the date you're dealing with (i.e. $month=11, $day=10, $year=1974 gives you my DoB, 10th Nov 1974, in case you want to remember it so you can buy me a present :-) Store $date in your database, and you have a standard UNIX timestamp that can be read by pretty much anything, displayed however you want, and sorted on. There are probably other ways of dealing with this that are as/more efficient, but this works for me. HTH Jon -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 23 January 2001 12:16 To: [EMAIL PROTECTED] Subject: Sorting a date Hi, I would like to sort, when displaying, an "European Date" with mysql. Anyone can give me some hints ? The date format looks so like : 01.02.2001 03.12.2000 22.11.2000 and is stored in a simple field text (first FEB 2001) Thanks GPo - 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: Sorting a date
Forgot to mention... you can check it for validity easily using this method as well: if (checkdate($frmStartMonth,$frmStartDay,$frmStartYear)) { echo "You can enter dates correctly. Well done!"; } else { echo "Please visit http://i-am-a-llama.com/explain-to-me-how-dates-work.html"; } Cheers Jon -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 23 January 2001 12:16 To: [EMAIL PROTECTED] Subject: Sorting a date Hi, I would like to sort, when displaying, an "European Date" with mysql. Anyone can give me some hints ? The date format looks so like : 01.02.2001 03.12.2000 22.11.2000 and is stored in a simple field text (first FEB 2001) Thanks GPo - 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: Memory
How about a RAM disk? I don't know of any for Linux but they must exist. Load the whole shebang into the RAM disk and then run it as normal from there instead of your HDD. You may want a cron job that periodically dumps the whole lot onto the HDD for backup purposes. HTH Jon -Original Message- From: Johan Geuze [mailto:[EMAIL PROTECTED]] Sent: 23 January 2001 12:39 To: [EMAIL PROTECTED] Subject: Memory Hello, I've got a mysql database(3.23) on a very slow disk, the database is only 50mb in size but the harddisk seems to be the real bottleneck here. The linux box where mysql is running on has 640 megabytes of ram. the database would fit into the ram with no problems. Is there an option to have your entire db in ram, (constantly updating the slower db on disk)? I know this gives dataloss if a powerout happens.. but this isn't a issue really. regards Johan Geuze - 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