MySQL install file problems

[sford999]

Hi,

I have an installer file which works up to a point.

It installs everything into the database except for one thing.

It doesnt insert the [b]$name[name][/b] variables into the db, it just skips them and Im baffled why its doing that.

Can anyone post a solution as to why its doing that please.

This is a sample query:

mysql_query("INSERT INTO t_backup (id, name, plate, category, description) VALUES ('128', 'error_subject', '$settings[error_sub]', '12', '')");

Thanks in Advance.

[thorpe]

these values need to be surrounded by {}. you should also surround array keys with quotes.

mysql_query("INSERT INTO t_backup (id, name, plate, category, description) VALUES ('128', 'error_subject', '{$settings['error_sub']}', '12', '')");

[sford999]

thorpe wrote:

these values need to be surrounded by {}. you should also surround array keys with quotes.

mysql_query("INSERT INTO t_backup (id, name, plate, category, description) VALUES ('128', 'error_subject', '{$settings['error_sub']}', '12', '')");

Still doesn`t work, its still skipping the array keys

[sford999]

I`ve fixed it.

Just needed to change each $settings[error_sub] to \$settings[error_sub]