I don't know what var you aretalking about, but all the vars you
here are only one word long.

If you mean $THECONTENT, then you should have written
THECONTENT=$*

You whould have seen this if you had echo'd the variables in question
before trying to insert them.

[EMAIL PROTECTED] wrote:

> only the first word of the files being read into the var gets inserted into
> the table
> 
> #!/bin/sh
> pushcontent()
> {
> SECTIONID=4
> THETITLE=$1
> THECONTENT=$2
> THECOUNTER=1
> mysql -u root -D nuke <<EOF
> INSERT INTO seccont(artid,secid,title,content,counter)
> VALUES
> ('max(artid)','$SECTIONID','$THETITLE',"$THECONTENT",'$THECOUNTER');
> EOF
> }
> x=`ls /usr/local/apache/htdocs/rpts/rvd`
> for a in $x
> do
> y=`cat /usr/local/apache/htdocs/rpts/rvd/$a`
> pushcontent $a $y
> done
> 
> 
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail 
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-- 
Gerald L. Clark
[EMAIL PROTECTED]


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to