array query print help

[Anon]

I am having trouble trying to print an array string, the array string will be used in an insert mysql statement, the string looks like this:

'ACID BLACK BGL 150%','ACID BLACK',107,'1233',17.95,'Black','Acid'

I am trying to print it to make sure I am pulling the string out correctly, the code to pull it out is:

$file = "file/" . $fileupload_name;
$myfile = file($file);
echo $myfile(0); *this is line 65**
die("testing");

the problem is that I am getting this error on the page:

Fatal error: Function names must be strings in do_upload.php on line 65

I realise this is probably due to the ' in the string, can anyone help me with this?

moonie 😉

[Anon]

$myfile is an array, so the correct syntax would be $myfile[0].

[Anon]

maxjp wrote:

$myfile is an array, so the correct syntax would be $myfile[0].

Thanks, been writing too many functions lately and not working with arrays enough, lol.

moonie 😉

[Anon]

This was the solution I worked out:

<?
// Drop Table
$db = mysql_connect("localhost", "name", "password") or die("Couldn't Connect.");

mysql_select_db("tablename",$db) or die("Couldn't Select.");

                         $query = "DROP TABLE classicdye";
                         mysql_query($query);

// Create Table
$query2 =
"CREATE TABLE tablename (
id int(4) DEFAULT '0' NOT NULL auto_increment,
name text,
color text,
ci int(5),
quantity text,
price float(10,2),
srchcolor text,
type text,
PRIMARY KEY (id),
UNIQUE id (id)
);";
mysql_query($query2);

// open file
$file = "file/" . $fileupload_name;
$myfile = file($file);
$tmp1 = "INSERT INTO classicdye (name,color,ci,quantity,price,srchcolor,type) VALUES (";
$tmp3 = ");";

$count = count($myfile);
$loop = 0;

while($loop < $count){
$tmp2 = $tmp1 . $myfile[$loop] . $tmp3;
//echo $tmp2;

mysql_query($tmp2) or die("error");
$loop ++;
}
echo "Database Updated";
?>

Thanks for the help.
moonie 😉