i have a variable that is comprised of two ints (minutes and seconds)

$final_toi = "$total_toi_tminutes:$total_toi_tseconds";

where $total_toi_tminutes would equal say 100 and $total_toi_tseconds would equal say 2.... the $final_toi then gets displayed as "100:2"... if i echo the $final_toi is displays the proper "100:2"

my problem comes when i try to pass this $final_toi variable into a table.... im passing it to a table row that has the type VARCHAR, but i get the following 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 ':2, 33:58, 65:52, 0:12, 2, 3, 11, 1, 100)' at line 4"

so its failing at the colon in the $final_toi variable.... VARCHAR accepts colons, so i dont know why this is not going through.... does anybody have any help for me?

    I figured out my problem, i was not putting single quotes around the variable name for entering into the varchar

      Write a Reply...