Add value to a variable without forming it before

[Marcel1993]

Hey,

 

$upgrade_next_sql = "SELECT * FROM todo_upgrades WHERE profile_id = ".$profile_id." AND level = ".$profile_data['level_'.$show.'']+1." AND type = '$show'";

 

doesn't work because there is "+1". How can I add this value to the variable without forming a extra variable before?

[trq]

That will work fine. Do you see what is expected when you echo $upgrade_next_sql ?

 

Also, you have some extra crap within your array index (it won't effect it, it's just not needed). $profile_data['level_'.$show]

[gergy008]

Also because you are using double quotes theres no need to append the string to insert a variable. You have:

 

"...file_id = ".$profile_id." AND le..."

 

You can made it:

 

"...file_id = $profile_id AND le..." and it will work, However '...file_id = $profile_id AND le...' would not as it's single quotes.

[sasa]

add space after +1

change +1. to +1 .