a lil more help

[aaronbosco]

so I have a form on form.php
im trying to post $company, $address, $phone, $contact in my $table_name
php--------------
<?php
$fontO = '<font face="Verdanna,Helvetica" color="#00ee99" size="4">';
$fontC = '</font>';
echo '<TABLE width="550" align="center" border="0">';
echo '<TR><TD><IMG SRC="images/list.jpg" WIDTH="550" HEIGHT="61" BORDER=0 ALT=""></TD>';
echo '</TR></TABLE><TABLE width="550" align="center" bgcolor="E1E1E1">';
echo '<FORM METHOD=GET ACTION="complete.php">';
echo '<tr><td align="left">Company Name</td><td align="center"><INPUT TYPE="text" NAME="company"></td></tr>';
echo '<tr><td align="left">Address</td><td align="center"><INPUT TYPE="text" NAME="address"></td></tr>';
echo '<tr><td align="left">Phone #</td><td align="center"><INPUT TYPE="text" NAME="phone" ></td></tr>';
echo '<tr><td align="left">Contacts</td><td align="center"><INPUT TYPE="text" NAME="contact"></td></tr>';
echo '</font><tr><td align="left"><INPUT TYPE="submit" value="Add Info"></td>';
echo '<td align="left"><INPUT TYPE="reset" value="Refresh"></td></tr>';
echo '</FORM></TD></TR></TABLE>';
?>

I can view the variables in complete.php but they wont post in my database
PHP------------------
<?php
$company = $HTTP_GET_VARS['company'];
$address = $HTTP_GET_VARS['address'];
$phone = $HTTP_GET_VARS['phone'];
$contact = $HTTP_GET_VARS['contact'];
$db_host = "localhost";
$db_base = "youngcanadian_com";
$table_name = "business_directory";
$db_user = "user";
$db_pass = "pass";
mysql_connect($db_host, $db_user, $db_pass)
or die("Could not connect: " . mysql_error());
mysql_select_db('business_directory');
mysql_query ("INSERT INTO business_directory (company, address, phone, contact) VALUES ('$company', '$address', '$phone', '$contact')");
print "successful entry";
mysql_close();
?>
do I have to prenounce the variables differently
is this wrong?
please help

[sarahk]

I'd like you to check what you get here

mysql_query ("INSERT INTO business_directory (company, address, phone, contact) VALUES ('$company', '$address', '$phone', '$contact')");

// when it's rewritten as:
$sql = "INSERT INTO business_directory (company, address, phone, contact) VALUES ('$company', '$address', '$phone', '$contact')";
echo "<br>$sql<br>";
mysql_query($sql);

does the query which is output look right?
do you need to addslashes()?
can you copy and paste into phpMyAdmin and run it ok?

[aaronbosco]

it writs this in html
and when I do a query in myphpadmin it works like a charm
but not yet through my form.php page yet

INSERT INTO business_directory (company, address, phone, contact) VALUES ('fdsaasdf', 'asdffdsa', 'asdffdsa', 'asdffdsa')

[sarahk]

I'd put some debugging in along the way to see if you are accessing your database AT ALL.

can you select and output from the database?