Re: MySql runs on windows ME

I have 2 OS's. One is Linux and the other is WinME. MySql runs fine on BOTH systems (it is running just fine on Win ME right now). -w - Original Message - From: "Doug V" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, September 09, 2001 2:24 PM Subject: windows ME > Will

Re: MySql runs on windows ME

I have 2 OS's. One is Linux and the other is WinME. MySql runs fine on BOTH systems (it is running just fine on Win ME right now). -w - Original Message - From: "Doug V" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, September 09, 2001 2:24 PM Subject: windows ME > Will

Re: Data Entry Forms for MySql

Hello I often use an html editor to create forms, use PHP4 as a cgi and enter the data directly into MySql. This does not necessitate Microsoft, and has worked very well for me. -warren - Original Message - From: "Stephen Reynolds" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Mo

Re: MySQL too slow....

Hello! A lot of people use PHP4 or PERL or C++ and connect *directly using the script. PHP4 has MySql functions built right in for convenience. In PHP for example, just do this: MYSQL_CONNECT("localhost","yourID","yourPassword"); mysql_select_db("yourDB"); $maxi=mysql_query("select fieldname1,

Re: events that i can trigger on intervals.

Hi! Could this work, I wonder? Have a timestamp field that gets set whenever a person books a room. Then when people look at a room, if the current date is more than a certain amount of time after the timestamp showing, it is EXPIRED. This would be easy to code in PHP. Cheers! -Warren ---

Re: Configuring PHP for MySQL

Wrong. As the MySQL Development Team suggested, this is a quesiton for PHP people. THe message "Header files not found at .. " has nothing to do with MySQL. This is a header that is being generated (HTML HEADERS). Therefore, at the TOP of a (PHP) script file you are saying something lik

storage and retrieval of blobs

Hi! I'm new too, but here are some things I've picked up from others on the List kind enough to advise: Regarding blobs, putting even large amounts of material into them is the same as using any other data type. Some considerations: http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:10632 http://li

Re: mysql hosting?

Gary Huntress, who sometimes posts on this List, runs such a free system. It is found in his signature line, as follows: SNIP == FreeSQL.org offering free database hosting to developers Visit http://www.freesql.org SNIP == - Original Message - From:

mySql on PhatLinux

Hi All! Has anyone got mySql running on PhatLinux? As I understand it, Phat is designed to run on a Windows partition - intel machine. If so, which binaries are used? (or which src file)I was thinking of trying the following distribution: Linux (Intel libc6 systems) [pc-linux-gnu-

re: JAPANESE QUESTION: My Inept Translation Attempt

I'll try to translate this as best I can. The sender can likely understand the response in English, so fire away. If you send them English he'll probably try (and probably can use) English. If anyone on the list can do a better job of translating this, please feel free to correct me! Keep in

decoding binary audio in MySql database

Does anyone have some code or very specific pointers as to how I might take an audio file stored in Blob format and write the file to disk? Thanks! -Warren - Before posting, please check: http://www.mysql.com/manual.php (

pulling audio out of a blob and playing it

Hi! I store image files in a MySql table, and can upload, store and retrieve these binary files without problems. I also store some audio files (they happen to be in .wav format). I'm having difficulty dragging these audio files out in a way that IE and Netscape can recognize. This doesn't

creating a new column whose values mirror the row order

Hi! Futher to a question I had asked, I think that my final problem in this application still has to do with presentation of some records in MySql. Rene and Marcus fruitfully suggested using the html refresh option in frames as a mechanism for presenting records every so many seconds, and at the

building a timer for controlled display of records

Hi! Has anyone a nice example of a timer that will run on a Win OS? It is to be a timed display in which a record is retrieved from a MySql database table and after 15 seconds the next record comes up for display. Since the application has to be responsive to user input during the "show" of r

"text stored as binary" question posted earlier

Hi all! Regarding my earler question about storing text as binary - I found no problem storing the text as mediumtext or longtext, and then dragging it out with a normal "mysql_query ".This solves my problem. However, if anyone has other ideas I'd love to hear them! Thanks very much! -W

Is storing a whack of text in a binary format ok?

Hi, I can store and retrieve binary data in the form of image or sound files. However, I wanted to store up to say, 10,000 bytes of textual data. Since varchar has a 255 byte ceiling I thought that mediumblob might be nice for this. I can store the stuff as mediumblob without difficulty. Howe

IGNORE previous temporary table problem posting

Hi All! I just posted a note about having problems creating temporary tables. However, I JUST realized (and empirically verified) that my problem of not being able to create temporary tables is that I didn't use an ID with the CREATE permission enabled. I am a bonehead. Thanks again! Cheers!

temporary tables via command line vs. php interface

Hi All! I am using MySQL 3.23.29a-gamma server and interfacing with PHP4. Using the following frommysql -u Some_ID -p Some_Password , all works out just fine: ===SNIP=== use mydatabase; CREATE TEMPORARY TABLE GACK1 select * from questions SORT ; ===SNIP=== I can then "se

having problems getting a distinct listing

Hi! I have a tests database that has questions (one table is "questions" and a field in this table is "uid" and another field is "question") there is also a Testerator table in my tests database, which organizes questions by section and keeps track of test number (as field "Quid") SO I would lik

modification of my last question

Hi! I just realised that the question I posed moments ago was not explained fully and therefore sounds even more silly than it perhaps is. My need is to have a number of fields that can be expanded and fit the form of field[i] where "i" can be expanded as desired. So I would like to know how to

RDBMS question on coding "expanding series-like fields"

Hi! I have a Test Questions database. Right now I have a hard-coded limit of 200 questions in it; I actually made a table with field names like Quest1, Quest2. . . Quest200. However, I know that I am not using the power of MySql in setting it up this way. This is more an example of my own ig

silly question but I'm stumped

Hi All! I have a need to make a LONG insert command. Does anyone have an example of something like this: $result1=MYSQL_QUERY("INSERT INTO test(dataA,dataB) VALUES ('$dataA','$dataB')"); but SPREAD over more than one line?I can't seem to get the quotes and backslashes right for some unknow

generic question re. image blobs in dbs

Hi! There is a consensus that blobs containing image files like .jpgs, .gifs, etc. might better be stored just as links in the database, with the actual files in a directory pointed to by the database links. Forgive my ignorance, but can someone explain a few of the more obvious reasons why t

2 character sets at the same time

Hi! I would like to be able to use BOTH Japanese characters and English in mySQL. I am wondering if this is possible. I know that one can use the Japanese charset, and of course one can set the English charset, but I require BOTH Japanese and English. . . Is there any way to do this? Thanks