$ blank when rest post...?

[Kudose]

I have a script that you enter data into, then is displays what you entered and says is this correct, then you submit it, well everything submits fine, and dandy, except the $location fields stays blank, but it isnt on the check page. Do you know why this would happen?

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')") or die(mysql_error());

			 echo"
			 	<td height='475' width='100%' valign='center'> <strong><font size='2' face='Tahoma'>
			Event added! Thank you, $username</font></strong></td>";

No parse errors or anything, is just inserts everything right, and in the right posistions, it just fails to post $location.

Any ideas as to why? Thanks!

[sarahk]

have you
checked that $location has a value
echo'd out the insert statement to see what it holds
* pasted in the insert statement manually to see if there is any feedback?

I suspect that $location doesn't have a value - after all if it isn't on the "check page" how is it supposed to have a value?

[milind24]

just change the variable name $location to other name and test it or try to echo query to see all values getting properly with insert into values ?

[Kudose]

I ran a test query, it shows up on the check page, then I ran the query print out, and everything printed fine, except $location prints as 0 instead of the text. It is set as VARCHAR(24) Not Null and when I change it to TEXT, it does the same thing.

[Kudose]

It is an issue of getting the $location that posted on the checkpage to the DB. For some reason no matter what I do, it doesnt work 🙁