variable posting as blank or 0

[Kudose]

Ok, I have this script below everything works except it is posting blank into the DB at $location

<tr> 
                  <td>City, State</td>
                  <td><input name="location" type="text" id="location" size="24" maxlength="32" style="background-color: transparent"></td>
                </tr>

this is the part of the form that holds $location, no need in posting the long script just for you to see this part 🙂

Next it the MySQL portion, and for some reason it is posting a blank in the location part 🙁

<? 
	   if($username=='' || $password=='' || $eventname=='' || $promotedby=='' || $venue=='' || $location='' || $date=='' || $doorfee=='' || $rooms=='' || $infoline=='' || $lineup=='' || $username==''){
	       echo "           

          <td height='475' width='100%' valign='center'> <strong><font size='2' face='Tahoma'>You 
            left required feilds blank. Please go back and fix this. <a href='addevent.php'>&lt;- 
            Back</a></font></strong></td>";
       } else {

   include('dbinfo.inc.php');
$query=mysql_query("SELECT * FROM users WHERE username='$username' AND password='$password'");
$rows = mysql_num_rows($query);
if($rows != "1"){
	   echo"
	   			<td height='475' width='100%' valign='center'> <strong><font size='2' face='Tahoma'>
				Your username and/or password is not valid. Please go back and fix this.
				 <a href='addevent.php'>&lt;- Back</a></font></strong></td>";

	} else {


			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>";					  

             }}
			 ?>	 


Thank you so much in advance!

[sijis]

hmm..
that code seems that it would work. I didn't notice any typos in 'location'. I'm sure you aren't getting parsing errors.
try $_POST['location'] inside the sql-query. see if that picks up the value.

the other thing i can think of is id might? cause a problem. other than that i can't think of anything else.
<input type=text id=location ....>

oh, idea... could it be that your field 'location' in the mysql db is smaller than the text you are inputting? or the format isn't correct.
the field type for 'location' could be a number, but you're trying to insert text or vice versa.....

[Kudose]

Location is set as TEXT in the DB...

Everything posts but this one variable. It is odd.

[Kudose]

Even when I change it to VARCHAR(18) is still posts blank

[Kudose]

Anyone got any ideas?

[sijis]

honestly the only thing i can think of is maybe there is a spelling error. could it be that the db has the field misspelled like Location, locatoin, etc.

did you also try the $_POST['location']; ?

im out of ideas right now.. if i think of something else, i'll let you know.

[cgraz]

The spelling error makes sense, but I think mysql_error() would print out an error if that was the case. Also, if all the other variables are being inserted, then register globals are on and you shouldn't need to use $_POST

All your variables are coming from the same form? Can you post the code to your entire form? What I would do is change this

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());

To this:

$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')";
print $query . "<br>";
$result = mysql_query($query) or die(mysql_error());

What does that print?

Cgraz

[Kudose]

It prints out all of the variables correctly, 0 is in place of $location. I have the DB set up on VARCHAR(24) NOT NULL location is spelled correctly on every script. I know this becuase it posts correctly when I go to:

http://kcnites.ionichost.com/events.php

And it shows up properly on my check page, it just is posting a blank into the DB. This is getting aggitating.

[Kudose]

INSERT INTO events (eventname, promotedby, venue, location, date, doorfee, presale, ticketsavail, rooms, maxcap, infoline, website, lineup, username) VALUES ('Event Name', 'Promoted By', 'Venue', '0', '02.26.2003', '50', '', '50', '50', '50', '50', '50', 'More colors coming soon. I am testing right now. If you select a color, then you must end that color with end color before using another one.', 'Kudose')

is the exact print out cgraz

[cgraz]

can you copy and paste what my code above prints? If you tried that and the query looks right, then the problem most likely lies somewhere in your database.

Cgraz

[Kudose]

Done

[cgraz]

what's your db structure? What field is location currently? you mentioned earlier you had changed it? (is location also supposed to be a 0?)

Cgraz

[Kudose]

$presale I entered value of 50 also but if left a blank in the DB unline $location which posts a 0

[Kudose]

Name Type Can be null
eventname varchar(30) No

promotedby varchar(30) No

venue varchar(30) No

location varchar(24) No

date varchar(20) No

doorfee varchar(18) 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

[Kudose]

It is really odd. If you go here:

http://kcnites.ionichost.com/addevent.php

enter username testacct and pass testacct

Enter all of the info, it will take you to a check page, wich has all of the variables, and then you submit, but it leaves out $location.

[cgraz]

Well on your 2nd page where the person previews what they wrote, the value of location is there as I entered it (in the hidden input fields). The problem lies when it reaches eventadd.php

Are you sure you don't have any other variables called location on that page that may be overwriting this? What if on the preview page, you change your form tag to look like this:

<form action="eventadd.php?location=<?=$location?>" method="post">

Then try posting. When you post, look at the url on eventadd.php and see if you see the value for location in the url. Should work.

Cgraz

[Kudose]

Cgraz, this is what the URL says after changing it to what you said:

http://kcnites.ionichost.com/eventadd.php?location=Kansas%20City,%20KS

But it is still leaving $location as a 0 in the DB

[Kudose]

I added $HTTP_GET_VARS['location']; to the query page, and now it posts to the DB.

[Kudose]

Thank you for your help. It is much appreciated.