Insert query

darkness

I'm getting a parse error on this line

$query = "INSERT INTO hwkset ( year, subject, Staff, date, hwkset ) values( "$year[$1]", "$subject[$i]", "$staff[$i]", "$date[$i]", "$hwkset[$i]" )";

if i take the speak marks out i get an error saying
Parse error: parse error, expecting T_STRING' orT_VARIABLE' or `T_NUM_STRING' in /home/darkness/public_html/school/admin/login.php on line 19

what am i missing

Anon

I'm pretty new to this, but have you tried to replace the " in your query with ' ? I can imagine that the " could split your string...

HTH
Lorenz

darkness

That comes up with an error

Parse error: parse error, expecting T_STRING' orT_VARIABLE' or `T_NUM_STRING' in /home/darkness/public_html/school/admin/login.php on line 19

Anon

Try this:

$query = "INSERT INTO hwkset ( year, subject, Staff, date, hwkset ) values('" . $year[$1] . "', '" . $subject[$i] . "', '" . $staff[$i] . "', '" . $date[$i] . "', '" . $hwkset[$i]. "' )";

HTH
Lorenz

[deleted]

You can ofcourse not have double-quotes inside double quotes.

Nor is it a good idea to put arrays inside quotes.

darkness

is there a way to put all the arrays in or will i have to instead of naming them as arrays name them all differently which will add a lot of code?

yendor

Darkness,

Your first value "$year[$1]" that't a 1(one) in there it should be an i(EYE) PHP won't let use numbers to name variables $1 is not valid therefore you get a parse error.

Darkness wrote:

I'm getting a parse error on this line

$query = "INSERT INTO hwkset ( year, subject, Staff, date, hwkset ) values( HERE----->"$year[$1]"<-------should be $i not $1 , "$subject[$i]", "$staff[$i]", "$date[$i]", "$hwkset[$i]" )";

if i take the speak marks out i get an error saying
Parse error: parse error, expecting T_STRING' orT_VARIABLE' or `T_NUM_STRING' in /home/darkness/public_html/school/admin/login.php on line 19

what am i missing

yendor

I almost forgot, Lorenz was also right you must have single quotes inside you double quotes. Try this

$query = "INSERT INTO hwkset (year,subject, Staff,date,hwkset) values ('$year[$i]','$subject[$i]','$staff[$i]','$date[$i]','$hwkset[$i]')";

Rodney

darkness

yeah, that works great.
Thanx!!!