I'm trying to read a text file into a blob field in a database with the
following code:
$cvfile="xxxx.txt";
$exist = file_exists($cvfile);
echo "File exists $exist<BR>";
$result1=mysql_query("select * from $TA");
$rows=mysql_num_rows($result1);
echo "$rows<BR>";
$result=mysql_query("update $TA set P1description = load_file($cvfile)") or
die (mysql_error());
Output shows File exists 1 (which I assume menas True) and the table is
being read because $rows equals 2.
P1
Then I get the "You have an error in your SQL syntax near '(xxxx.txt)' at
line 1" error
Any help?
Regards
Mick Lloyd
[EMAIL PROTECTED]
Tel: +44 (0)1684 560224
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
