Re: Inserting images (not the location of the images)
You can easily upload images using just your web browser - an FTP program is not needed. You'll need a form with it's encoding set to multipart/form-data, e.g. form name=formAddTitle method=post action=save_details.php enctype=multipart/form-data ... input type=file name=imgCover ... input type=submit name=cmdSaveTitle value=Save Music Title ... /form and then within your receiving script you'll need something similar to: $image_filename = $HTTP_POST_FILES[imgCover][name]; move_uploaded_file($HTTP_POST_FILES[imgCover][tmp_name], my/save/location/ . $image_filename); That's all there is to it. Assuming you're using PHP that is :) FYI: I haven't done it myself but I think you can save images into MySQL using a BLOB field. Neil Emma Grant wrote: ** This Message Was Virus Checked With : SAVI 3.58 May 2002 Last Updated 14th June 2002 ** Hi All, First of all I want to thank you all for all the help that you have given me throughout the last week. I have learnt a great deal, and through your help and the resources on the interenet I have successfully been able to create and connect to a database through MySQL on Linux. Create a user for that database. Inserted and updated values on the command line, and I have learnt to insert, update and view the data from the database through web form using CGI. (Thanks to those who taught me how to check for errors in my scripts) Just to think, I didn’t even know how to access MySQL last Thursday ☺ But as you expected, here comes my question; I need to be able to insert images into the database through a FILE FIELD on a web form. I have already tried this through a simple form that I created, but it only inserts the actual location (eg C:Documents and SettingsAdministratorDesktoppersonal.jpg) of the file that I am browsing for on my computer. Is there some sort of syntax that I have to use that converts the image to binary as it gets “inserted” into the database, and then can be read by any program (ie, web browsers) as an image when I select it again from the database through a SELECT query? Why would I do this you ask? (read on if you are interested) ☺ I know that many of you are about to tell me to store the images on my server, and reference the location from my database field. As I have read many times throughout my research. But I want the ability for the user to choose the images they want in a database from the form field. I don’t want them to have to use a FTP program to upload images, and then insert the image location. I want it to be a one-stop form. That is part of my project. So if anyone can help, that would be great. Emma - 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 -- Work: [EMAIL PROTECTED] Home: [EMAIL PROTECTED] Web: www.curvedvision.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: no subject
select name, birthday from ??? order by name; Along those lines anyway. Chuck \PUP\ Payne wrote: * This Message Was Virus Checked With : SAVI 3.54 Feb 2002 Last Updated 25th March 2002 * Ok, I know I am going to get yell about this but how can I do an SQL and only show to fields from a table. For example I only like to see the names and birthday? Or will as so all fields for a given table. Chuck Payne - 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 -- Email: [EMAIL PROTECTED] [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
Re: about installing mysql on windows 98
Yeah no problem. I believe you will need to run the following: mysqld-nt --standalone HTH Neil Rajesh Chabria wrote: dear sir, please help me out to install the mysql windows version.the problem is i have only windows 98 as stand alone.i donot have windows NT SERVER. so can mysql be installed on windows 98 as stand alone without the help of a server.please mail back. - 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 *** This message was virus checked with: SAVI 3.54 Feb 2002 last updated 26th February 2002 *** -- Email: [EMAIL PROTECTED] [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
Table file extensions
Hi there, I am using MySQL v3.23.40 on Windows NT. When creating various MyISAM tables the files saved are of the form *.frm *.MYD and *.MYI. So far so good. When I copy these files over to a Linux box though some of the *.MYD and *.MYI extensions appear as lowercase *.myd and *.myi This causes MySQL on Linux to complain as it looking for the uppercase versions of the files. Does anyone know how I can get around this, or even better, why the case appears to change? Any help would be greatly appreciated. Neil Email: [EMAIL PROTECTED] [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
Re: Existing file cannot be found
This problem appears to be similar to one I have when I create MySQL databases on my Windows machine and then transfer them at a later date to RedHat. MySQL looks for tables with the extensions MYD and MYI but they sometimes get converted to lowercase and thus MySQL complains (Linux is case-sesitive remember). Not sure what you can do to stop this happening but if you find a 'cure' could you let me know. Cheers, Neil Mikhail V.Soloviev wrote: Hello, sometimes my mysqld tells me that it cannot open the file table.MYD. So script doensn't work, although the file exists in the mysql/database/ folder. When I overwrite this file with backuped one, problem disappears, and then appears again in several days. What's the matter? p.s. Mysql 3.23.48 on RH 7.2, default config except wait_timeout=60 Best regards, Mikhail Soloviev - 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 *** This message was virus checked with: SAVI 3.53 Jan 2002 last updated 30th January 2002 *** -- Email: [EMAIL PROTECTED] [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
Re: Network drive for datadir
Thanks for doing the test Miguel - yes my drive is mapped correctly. Does not want to work though :( Miguel Angel Solorzano wrote: At 16:00 04/02/2002 +, Neil Freeman wrote: Hi! I did the test in my small network and works. The only care I did is to mapped the network drive, assign a letter (in my case F). Please take a look if effectively you had mapped the drive X (trying to access the X drive with an DOS prompt). Regards, Miguel Hi, Ideally I wish to keep all of my database files on a network drive (X:\). Using WinMySQLAdmin.exe I have created a my.ini file which resides in my WINNT directory. my.ini contents... [mysqld] basedir=C:/mysql #bind-address=127.0.0.1 datadir=X:/Shared/MyData/data #language=C:/mysql/share/your language directory #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M [WinMySQLadmin] Server=C:/mysql/bin/mysqld-nt.exe user=guest password=guest Upon starting the MySQL service though I receive the error message Could not start the Mysql service on \\DELL02. Error 1067: The process terminated unexpectedly. I have copied the databases to a local drive (D:\) and altered the my.ini file and all works well. Does anyone know why I cannot use MySQL to access databases on a networked drive??? Neil Email: [EMAIL PROTECTED] [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 -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.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 *** This message was virus checked with: SAVI 3.53 Jan 2002 last updated 30th January 2002 *** -- Email: [EMAIL PROTECTED] [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
Re: Network drive for datadir
That's a bit of a pain :) Any idea if this will be supported at some point? Cheers, Neil Victoria Reznichenko wrote: Neil, Monday, February 04, 2002, 6:00:18 PM, you wrote: NF Hi, NF Ideally I wish to keep all of my database files on a network drive NF (X:\). Using WinMySQLAdmin.exe I have created a my.ini file which NF resides in my WINNT directory. NF my.ini contents... NF [mysqld] NF basedir=C:/mysql NF #bind-address=127.0.0.1 NF datadir=X:/Shared/MyData/data NF #language=C:/mysql/share/your language directory NF #slow query log#= NF #tmpdir#= NF #port=3306 NF #set-variable=key_buffer=16M NF [WinMySQLadmin] NF Server=C:/mysql/bin/mysqld-nt.exe NF user=guest NF password=guest NF Upon starting the MySQL service though I receive the error message NF Could not start the Mysql service on \\DELL02. Error 1067: The process NF terminated unexpectedly. I have copied the databases to a local drive NF (D:\) and altered the my.ini file and all works well. NF Does anyone know why I cannot use MySQL to access databases on a NF networked drive??? MySQL doesnt support loading files from Windows/samba shares. NF Neil -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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 *** This message was virus checked with: SAVI 3.53 Jan 2002 last updated 30th January 2002 *** -- Email: [EMAIL PROTECTED] [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