Combining 2 textareas into one SQL BLOB

[Coranthil]

I am creating a form for a web page.... part of the form will contain 2 TEXTAREAS. One is a "parts list" the other is a "quantity list". I want to combine the data from these as an SQL Blob, but I need to know how to combine them.

List 1 List 2 Combined
a 1 a:1
b 2 b:2
c 1 c:1

and so forth.

[Coranthil]

ok, I can combine the lists..

$list1 .= '/n';
$list2 .= '/n'; // makes sure the last line is included

$a1 = array();
$a2 = array();
$r = array();

foreach ($as1 as $a1)
{
$as1 = explode('\n', $list1)
}

foreach ($as2 as $a2)
{
$as2 = explode('\n', $list2)
}

foreach ($rs as $r)
{
$rs = $a1 . ':' . $a1;
}

$passval = explode('\n',$r);

I tried to return $passval as a blob, and MySQLdoesn't like that at all.. the script completely compiles, but reutrns an error when I pass the query to the database.

I know it is an error with the blob, as the rest of the script is cut and paste and edited from a similar scriupt that did not use blobs.

How can I pass a blob function to SQL? I know FrontBase has the fbsql_create_blob() function. does MySQL have a similar function? I looed at the manual and couldn't find anything.

[Coranthil]

Writes a big, bright Red N for NEWBIE on his forhead.. L*

Blobs are for BINARY data.....

hehe sorry to waste the time of the 11 ppl who actually looked at this post. 😃 😃 😃