Re: [PHP-DB] Re: [PHP] Mulitpart form posts and mysql blobs

messy I want to be able to get the BINARY data from mySQL and send it via cURL directly. TIA - Original Message - From: "John W. Holmes" <[EMAIL PROTECTED]> To: "John Ryan" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent:

[PHP-DB] Mulitpart form posts and mysql blobs

How are files encoded when theyre sent in mulitpart forms??? Is it the same as blob fields in mySQL databased when you use the LOAD_FILE() command?? If not, is it easy to convert from one to the other?? At the moment, Im taking the blob from mySQL and writing it to a file and then uploading that f

[PHP-DB] SQL File Insert???

Ive a file on my server with SQL instructions to create a table and insert stuff. How do I get this to be run on the database? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] database design question

ive a table called 'lyrics' which is the main content on my site, song lyrics. im thinking of introducing rate this lyric and all that kind of stuff into the site. would it be better, from a design point of view, to create a second table for lyrics ratings and hits or just add a 'ratings' and 'hits

[PHP-DB] mysql, finding the last record

is there any quick way of selecting the 'last' row in a mysql table?? i could write some messy code but id prefer an elegant solution. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: MYSQL Table Dump

should have read the manual first, mysqldump "John Ryan" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Is there any way *from the command line* to get a dump of a mysql table and > have it saved to a local file, instead of standard output -- PHP Datab

[PHP-DB] MYSQL Table Dump

Is there any way *from the command line* to get a dump of a mysql table and have it saved to a local file, instead of standard output -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] multiple queries with PHP

You wouldnt know where to change this setting? "John W. Holmes" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > John Ryan wrote: > > > I want to SELECT * from a table and also update the hit counter by 1. So > > theres 2 different queries w

[PHP-DB] multiple queries with PHP

I want to SELECT * from a table and also update the hit counter by 1. So theres 2 different queries which I know I can easily do in PHP seperately, but I thought itd be quicker and more efficient to run them in the same query, ie seperated by a ';'. But PHP returns an error, and it works fine on t

[PHP-DB] mySQL Binaries for Linux

I downloaded what I thought was Linux mySQL binaries, and the INSTALL file said there should be a bin directory when I untar, but there isnt! Just a BUILD folder and loads of make files. Did I download the wrong one? I downloaded mysql-standard-4.0.14-pc-linux-i686.tar.gz -- PHP Database Mailing

[PHP-DB] upgrading mysql remotely

i got the mysql 4 server RPM, but I dont have RPM on my server to opne it! so i got the full tar gz files of mysql 4 but when i try to compile it, it said i dont have a c compiler. so my question is, can you get mysql linux binaries that i can just put in the old mysql foler?? -- PHP Database Ma

[PHP-DB] upgrading mySQL remotely

i need to upgrade to mysql 4 to avail of UNION, so im just downloading the 9MB RPM on dial-up, uploading it to my remote server and then can i do the installation from the telnet?? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] UNION Clause in queries

I have a UNION command in a query on a PHP page that works fine on my test apache/php/mysql server on windows at home but it returns an error when i upload it to the web. i checked both parts of the UNION in phpMyAdmin online and they both worked. so, can the UNION command be somehow disabled, and

[PHP-DB] Re: SELECT FROM 2 or more tables

mmon field, keywords, which i have searched. maybe im stupid, but i cant c where "WHERE table1.id = table2.id" would help, or sumting along that lines "John Ryan" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Is it easy?? Is it possible?? Should I ju

[PHP-DB] SELECT FROM 2 or more tables

Is it easy?? Is it possible?? Should I just run 2 different queries and output their results in the PHP script and make it look like it's all from the same table I cant grasp JOIN for the life of me -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/un

[PHP-DB] subtracting dates...

Hi, In mySQL, I store dates as -MM-DD, a standard DATE type. It stores users date of births. I need to calculate in a PHP script, the users age from this DOB. I get a PHP date in the same format as the mySQL and subtract, which returns the year rounded off. ie, it doesnt matter if your birthda

[PHP-DB] mySQL help on win xp

i installed php and apache fine on my pc, but mysql is giving problems. in winmysqladmin, you cant create a adb on the databases tab. all that lets you do is flush threads, flush processes, etc. so i had to create my database through the mysql command line. also, phpMyAdmin doesnt work, it returns