fakierock

Below is the error message I'm getting: PHP Notice: Undefined variable: query in /var/www/vhosts/apphosts.co.uk/httpdocs/v2/project_php/track.php on line 61 line 61 - mysql_query($query); Thanks

Hi guys, I have a CMS system which I've spent the last week fixing. It's built in PHP, and now I'm stuck on the most simplest of tasks. I can't figure out why I am receiving an "undefined variable" error within this block of code. Any help would be greatly appreciated. function track_app($app_id, $lang_code, $str, $instance) { $lang_id = get_lang_id($lang_code); if ($instance > 0) { if ($str == 'LOAD_APP' || $str == 'APP_LOADED') { $query = "INSERT INTO `tracking` ( `APPLICATION_ID`, `LANG_ID`, `INFO`, INSTANCE_ID ) VALUES ( $app_id, $lang_id, '$str', $instance )"; } mysql_query("INSERT INTO `tracking_backup` ( `APPLICATION_ID`, `LANG_ID`, `INFO`, INSTANCE_ID ) VALUES ( $app_id, $lang_id, '$str', $instance )"); mysql_query("UPDATE `instances` SET ACTIVE = 1 WHERE INSTANCE_ID = $instance"); } else { $query = "INSERT INTO `tracking` ( `APPLICATION_ID`, `LANG_ID`, `INFO` ) VALUES ( $app_id, $lang_id, '$str' )"; } mysql_query($query); }

Hi guys, I have built a HTML email newsletter which consists of images, headers, text etc, but I need to make these elements editable so that if I want to change the current images or text I can do it within the HTML page itself rather then building 20 different email templates. I want to be able to change the images and text throughout the template without using a database. I also need to send the email from the page itself. I'm really only looking for advice on how I could go about doing this in PHP. I have the time and willingness to learn. Any advice, help or links to helpful tutorials or articles would be greatly appreciated, as I really want to learn how to do this myself, I just need to be sent in the right direction in knowing how I can even get started. Thanks