Saving data from dropdown

Hello,

I have taken addForm.php and added some dropdown menus to it. The options for the dropdowns are being successfully pulled from the database using some other code I have found on the forum here:

https://www.interactivetools.com/iforum/Products_C2/CMS_Builder_F35/gforum.cgi?post=67011

<?php
// This form requires: CMSB v2.04 Build 1
require_once "../cmsAdmin/lib/viewer_functions.php";
$tableName = 'listings';
$recordNum = null; // you must set either $recordNum or $preSaveTempId to null
$preSaveTempId = @$_REQUEST['preSaveTempId'] ? $_REQUEST['preSaveTempId'] : uniqid('x');
$errorsAndAlerts = '';

// get field options for Currency
$fieldname = 'currency';
$selectedValue = '';
$valuesAndLabels = getListOptions($tableName, $fieldname);
$optionsCurrency = getSelectOptions($selectedValue, array_keys($valuesAndLabels), array_values($valuesAndLabels));

// get field options for Condition
$fieldname = 'condition';
$selectedValue = '';
$valuesAndLabels = getListOptions($tableName, $fieldname);
$optionsCondition = getSelectOptions($selectedValue, array_keys($valuesAndLabels), array_values($valuesAndLabels));

However, I keep receiving this error message when I submit the form:

MySQL Error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'condition = 'Good'' at line 7

I can get the form to save all the other fields but as soon as I try and save the options from the "condition" field I receive the error message.

Here is the code I am using to save the data to the database:

$query = "INSERT INTO `{$TABLE_PREFIX}$tableName` SET
createdDate = NOW(),
createdByUserNum = '" .intval( @$CURRENT_USER['num'] ). "',
updatedDate = NOW(),
updatedByUserNum = '" .intval( @$CURRENT_USER['num'] ). "',
product = '" .mysql_escape( $_REQUEST['product'] ). "',
condition = '" .mysql_escape( @$_REQUEST['condition'] ) ."'";


Can someone please explain what the problem is here?

Thank you,
Greg