Query assistance

[g-force2k2]

i don't see the difference in codes just the double slashes you could use triple or quadruple it wouldn't make a difference...

at least to my knowledge...

g-force2k2

[Dark_Wizard]

Today at 05:29 PM g-force2k2 said this in Post #11
i don't see the difference in codes just the double slashes you could use triple or quadruple it wouldn't make a difference...

at least to my knowledge...

g-force2k2

You still need to keep the escape for the value and the name in the database...

[g-force2k2]

no you don't because they aren't variables until they pass on the HTTP submit...

regards,
g-force2k2

[Sylvus]

Fixed. I re-ran the query. This ran cleanly.

UPDATE setting SET optioncode='<select name=\"setting[$setting[allowmultiregs]]\">
<option value=\"0\" ".iif($setting[value]==0,"selected","").">NO - Dont allow multiples</option>
<option value=\"1\" ".iif($setting[value]==1,"selected","").">YES - allow multiples</option>
<option value=\"2\" ".iif($setting[value]==2,"selected","").">YES - but track multiples</option>
</select>' WHERE varname='allowmultiregs'

Yet I'm still getting this error under the spot it should be displayed in the CP.

Parse error: parse error, expecting `','' or `';'' in /mnt/web/guide/skullport/forum/admin/options.php(72) : eval()'d code on line 1

I've tried to put a ; at the end of

</select>;'

or

</select>';

or at the end of

varname='allowmultiregs';

or even

varname='allowmultiregs;'

All of these run with success yet still generate a parse error.

I even tried this, based on a hack made by Drak and the query runs OK but it still generates a parse error.

I'm stumped

Syl...

[g-force2k2]

try updating the optioncode='' and see if it still generates a parse error...

if so it has something to do with an eval function have you done any other modifications or edited any templates?

regards,
g-force2k2

[Sylvus]

Ack! I had left my post reply open for over an hour and didn't see all the posts above mine. I'm going to read those and go through the steps you suggested and see what I can come up with before I reply to your question above.

I just ran:

UPDATE setting SET optioncode='<select name=\"setting[\$setting[allowmultiregs]]\">
<option value=\"0\" \".iif(\$setting[value]==0,\"selected\",\"\").\">NO - Dont allow multiples</option>
<option value=\"1\" \".iif(\$setting[value]==1,\"selected\",\"\").\">YES - allow multiples</option>
<option value=\"2\" \".iif(\$setting[value]==2,\"selected\",\"\").\">YES - but track multiples</option></select>' WHERE varname='allowmultiregs';

This was the result:

Query added to database: ... Success!
Viewing changes in CP: Parse error: parse error, expecting `','' or `';'

So on to Dark_Wizards suggestion of running:

UPDATE setting SET optioncode='<select name=\\"setting[\$setting[allowmultiregs]]\\">
<option value=\\"0\\" \".iif(\$setting[value]==0,\"selected\",\"\").\">NO - Dont allow multiples</option>
<option value=\\"1\\" \".iif(\$setting[value]==1,\"selected\",\"\").\">YES - allow multiples</option>
<option value=\\"2\\" \".iif(\$setting[value]==2,\"selected\",\"\").\">YES - but track multiples</option></select>' WHERE varname='allowmultiregs';

Query added to database: ... Success!
Viewing changes in CP: WORKED!

Sorry about the post above where I state "
Fixed. I re-ran the query. This ran cleanly." as that was a post I left replying to for over an hour.

This issue is resolved but now my question is, could one of you make me understand why Dark_Wizards suggestion worked and the others did not?

Syl...

[Dark_Wizard]

Let g-force2k2 explain it as he said what I did wouldn't make a difference.

[Sylvus]

Oh come on! Don't be like that

The two of you took the time to help me out and I'm thankful for that. It's not going to help me learn how things work if you say stuff like that Mr. Wizard!

I'm sure G-Force2k2 didn't mean anything personal by his comment but rather, going on what he has learned from being here.

Well, I hope someone explains it.

Thanks again, both of you, right or wrong, it was a great lesson in syntax.

Syl...

[g-force2k2]

Today at 10:06 PM Dark_Wizard said this in Post #17
Let g-force2k2 explain it as he said what I did wouldn't make a difference.

wtf is up with the attitude?

you have a problem then act your age not like some two year old whinning that he was right...

i said "to my knowledge" so i learned something new like wtf is your problem with that?

i helped and you helped you don't like me helping then fine, can't help that im still learning... do a favor and get a life instead of starting fights because im just trying to help and you acting like an ass only shows how immature you are.

And don't say you aren't trying to prove that you're better because in another thread i was helping someone and you stepped in and just felt like showing that you're some kind of special person... well i hope you feel special for trying to act all bad online...

take Syl's advice we both learned something... if you want to be an ass and keep on targeting me then i won't waste my time helping others... get a life...

g-force2k2

[Dark_Wizard]

I don't have an attitude, sorry if it was taken that way I was only trying to make a point and actually forgot to add the wink smilie as I originally intended. This had nothing to do with anything other than letting people learn why this works and why that doesn't. I struggled over this many months ago and couldn't understand why until I asked over at sitepointforums.