TEXT variable posting 0?

[Kudose]

This is my table:

eventname varchar(30) No

promotedby varchar(30) No

venue varchar(30) No

location text No

date varchar(20) No

doorfee varchar(8) No

presale varchar(8) Yes

ticketsavail varchar(8) Yes

rooms char(2) No

maxcap varchar(5) Yes

infoline varchar(30) No

website varchar(30) Yes

lineup text No

username varchar(24) No

copied from my GUI for my DB.

Highlighted in red is my loaction TEXT table.

And here is my code:

$query = mysql_query("INSERT INTO events (eventname, promotedby, venue, location, date, doorfee, presale, ticketsavail, rooms, maxcap, infoline, website, lineup, username)
				                      VALUES ('$eventname', '$promotedby', '$venue', '$location', '$date', '$doorfee', '$presale', '$ticketsavail', '$rooms', '$maxcap', '$infoline', '$website', '$lineup', '$username')");
				 mysql_query($query);

now I have this info being submited via form. with the variables in correct positions. Everything posets to the DB correctly and in there proper posistions. You wondering what the problem is huh. Well, when the $location variable posts to the DB, wether you input integers or text, it returns the number 0 into the DB where the text location should be. Any ideas as to why? Thank in advance. All of everyones help is SO GREATLY appreciated.

[nnichols]

I suspect it is because you have misspelt the variable name somewhere, possibly in the form that submits to this script. Try this
code which will echo the $query so you can check to see if $location is being substituted as you expect -

$query = "INSERT INTO events (eventname, promotedby, venue, 
	location, date, doorfee, 
	presale, ticketsavail, rooms, 
	maxcap, infoline, website, lineup, username)
	VALUES ('$eventname', '$promotedby', '$venue', 
	'$location', '$date', '$doorfee', 
	'$presale', '$ticketsavail', '$rooms', 
	'$maxcap', '$infoline', '$website', '$lineup', '$username')"
$result = mysql_query($query) or die ('MySQL error: ' . mysql_error() . '<br>Query: ' . $query);

// echo the query so you can see if $location is being substituted correctly
echo $query;