Hello,
This is a reply to an e-mail that you wrote on Mon, 14 Jul 2003 at 18:48,
lines prefixed by '>' were originally written by you.
> I'm trying to split up a file and dump it into a mySQL database BLOB.
> Wherever I run the query:
> mysql_query("INSERT INTO table (field) VALUES ('{$buffer}')");
> Nothing ever shows up in the table whethere field is a text or a
> blob
> and whether I dump in text or binary. Oddly enough when I run the
> query
> I get no error, and can print it and run it through a mySQL terminal,
> and it works.
Change your line of code to something like this:
mysql_query("INSERT INTO table (field) VALUES ('{$buffer}')") or
die(mysql_error());
to find out what is going wrong.
Has the data in $buffer been escaped, reay to go straight into the
query? if not add the line:
$buffer = mysql_escape_string($buffer);
beofre the one that you mentioned above.
HTH
David.
--
phpmachine :: The quick and easy to use service providing you with
professionally developed PHP scripts :: http://www.phpmachine.com/
Professional Web Development by David Nicholson
http://www.djnicholson.com/
QuizSender.com - How well do your friends actually know you?
http://www.quizsender.com/
(developed entirely in PHP)
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
