text area variable not sent to database

jkatcher

I am trying to send the data from a textarea as one variable to my database, but it isn't transferring. Can you help?

What are your favorite venues in and around Seattle to play (Top 5)?
<textarea name="favVenue" rows="4" cols="30"
class="input" wrap="physical">
</textarea>

The name of my column in the database is "favVenue". Do I need to do something else?

Thanks!

LordShryku

You're gonna have to show us more than that. How are you processing the info? What field type is favVenue in the database?

jkatcher

sorry!

the i set favVenue as varchar in the db, should I change that to text?

here's my processform.php:

<?php
include ('misc.inc');
include ('head.asp');

$name = $HTTP_POST_VARS['name'];

/ connect to server(mysql) with pconnect for persistent
connection, not to close then reconnect /
mysql_pconnect("$host","$user","$password")
or die ("Couldn't connect to the server.");

/ connect to db (seattlebands) /
mysql_select_db("seattlebands")
or die ("Couldn't connect to the database.");

/ add row to table 'bands' and insert input values /
$query = "INSERT INTO bands (
name,
members,
memberName,
genre,
wherePlayed,
whoWithLoc,
whoWithNat,
label,
labelName,
manager,
managerName,
whenFormed,
wouldPay,
favVenue,
favBooker,
siteLink,
origin,
sold,
disco,
favPromoCo,
howMuch,
favPlay,
draw)

VALUES (
'$name',
'$members',
'$memberName',
'$genre',
'$wherePlayed',
'$whoWithLoc',
'$whoWithNat',
'$label',
'$labelName',
'$manager',
'$managerName',
'$whenFormed',
'$wouldPay',
'$favVenue',
'$favBooker',
'$siteLink',
'$origin',
'$sold',
'$disco',
'$favPromoCo',
'$howMuch',
'$favPlay',
'$draw')";

$result = mysql_query($query)

or die (mysql_error());

echo "
Name:$name 
How many members:$members 
Member names:$memberName 
Genre:$genre 
Where you've played:$wherePlayed 
Who with loc.$whoWithLoc 
Who with nat.$whoWithNat 
Are you on a label?$label 
What's the label name?$labelName 
Do you have a manager?$manager 
What is the manager name?$managerName 
When did you form?$whenFormed 
Do you want to work w/ a promoter?$wouldPay 
What your favorite venues?$favVenue 
Who is your fav. promoter?$favBooker 
Link to site:$siteLink 
Where did you form?$origin 
Records sold:$sold 
Discography:$disco 
Fav Promotions Co.:$favPromoCo 
How much would you pay for promotion?$howMuch 
Where is your fav venue to play?$favPlay 
How many can you draw?$draw";

</body>
</head>
</html>

i haven't gotten to the formatting of the echo statement yet, but it'll do for now...