parse error

tmann

I'm getting a parse error on the line with the first echo statement below (I posted all the scripts as text files at:

http://www.unc.edu/~tmann/php ):

if ($record_added == 0) {
echo "Error, table not updated";
exit;
} else {

insert ok

echo "Table updated!";

}

Do you know why I'm getting that parse error? Does it have somethign to do with me not accessing all of my variables correctly in light of register_globals being turned off?

Thanks!
Tommy

jerdo

If register_globals is off in your php.ini file you will need to access variables that are sent with a form using $GET[variable_name] or $POST[variable_name]

tmann

Right, I think I've done that for all the vars that were sent over in the form (with the exception of "submit" because I don't use that in the php script). Do I need to access vars in inlude files in any special way or can I just refer them as $variable? I can still create new variables within in the php file as $variable right?

Any ideas on that parse error? I see problem at all on the line that the error message points to (or for that matter, on any line in the script).

Thanks!
Tommy

rinjani

Try this It hink it's because you are doing your connection inside of the mysql_query()

Since you have already established a connection in your dbconnect script use:

$result = mysql_query($sql);
$record_added = mysql_affected_rows($result);

echo "Records added: $record_added";

to make sure there's some output.

If you no longer have the connection at this point do another pconnect NOT a mysql_query connect (sorry didn't go through all your code).

HTH

dannys

You're missing the ending " for your $sql assignment (line 38 I think)

jdesilva

just out of curiosity what is the meaning of

if ($record_added == 0)

the manual states:

mysql_affected_rows()

If the last query failed, this function will return -1.

tmann

Originally posted by jdesilva
just out of curiosity what is the meaning of
if ($record_added == 0)
the manual states:

[/B]

That's a good question...I actually had it the other way until someone suggested I try adding that line to fix things. But you're right, it is -1 and not 0. I should just rework that whole if statement. Thanks for pointing that out!!
Tommy

tmann

Originally posted by dannys
You're missing the ending " for your $sql assignment (line 38 I think)

You're right! How dumb to miss something like that -- thanks! Would using a debugger catch these types of things? These types of things seem to happen to me a lot. I check, check, and re-check, but it seems like I ALWAYS miss something trivial that makes the whole thing go bad.

Thanks again!
Tommy