I have created an insert loop to increment fieldname by count. $x will define the loop number so I wish to display 'track_name' as ' track_name1', 'track_name2' etc on each cycle of the loop. Trying to parse the $x to the track_name always seems to return a parse error. If anyone can shed some light on how to achieve this I would be grateful.
$insertSQL = sprintf("INSERT INTO metal_tracks (disco_id, track_name, comments) VALUES (%s, %s, %s)", GetSQLValueString($_POST['disco_id'], "int"), GetSQLValueString($_POST['track_name'], "text"), GetSQLValueString($_POST['comment'], "text"));
Thanks in advance for any suggestions.