problem connecting to database

[Diesel73]

ok this is what I'm using

<?
  if (!$fname || !$lname || !$address || !$city)
{
  echo "You have not entered all the required information.<br>"
          ."Please go back and try again.";
  exit;
}

$db_addr = "localhost";
$db_user_= "username";
$db_pass_=_"password";
$db_name_=_"mride";
$db_table_=_"customers";

$connect_ =_ mysql_connect ($db_addr ,$db_user ,$db_pass ); 

if_(!( $connect ))_{ 
____echo_ "There was a problem." ;
____exit(); 
}

if_(!( mysql_select_db ($db_name )))_{ 
____echo_ "There was a problem." ;
____exit(); 
}

if_( mysql_query ("insert_into_$db_table_values_('$fname', '$lname','$address'.'$city')" ))_{ 
____ $message_ =_ "Information Entered" ;
}
else_{ 
____ $message_ =_ "There was a problem." ;
}
?>

I'm somewhat new to this so forgive the newbie questions. I obviously change the username & password to the actual information. What do I enter as "localhost"?

Whenever I try to run this I get
"Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING in /usr/local/plesk/apache/vhosts/milwaukeeride.com/httpdocs/insert_values.php on line 37"

Thanks for any help on this.
Derrick

[seby]

did you code that, or did someone else?
that is awful coding ..

is this the entire script? where's the form?

[Diesel73]

Well thanks for the confidence boost!

As I stated I'm new to this, I have been reading for a while and tried to put something together and it does not work. I have tried messing around with this for a while and all I'm looking for is some guidance as to the error of my ways!

Any help would be greatly appreciated.

[Diesel73]

Ok here is the form. This is just a few excerpts from the actual form as I'm just trying to get everything going. Once I do then I will add all the other fields. That is another reason it might not make sense.

<form name="insert" method="post" action="insert_values.php">
<div align="center"><br>
<table width="600" border="0" cellspacing="0" cellpadding="0">
<tr class="milwaukee">
<td width="215"><div align="right">First Name:</div></td>
<td width="385"><input name="fname" type="text" id="fname"></td>
</tr>
<tr class="milwaukee">
<td><div align="right">Last Name:</div></td>
<td><input name="lname" type="text" id="lname"></td>
</tr>
<tr class="milwaukee">
<td><div align="right">Address:</div></td>
<td><input name="address" type="text" id="address"></td>
</tr>
<tr class="milwaukee">
<td><div align="right">City:</div></td>
<td><input name="city" type="text" id="city"></td>
</tr>
<tr class="milwaukee">
<td colspan="2"><div align="center">
<input type="submit" name="Submit" value="Submit">
</div></td>
</tr>
</table>
</div>
</form>[/URL]

[seby]

well, here is a start, try the code below.. you have to change column1,column2,column3,column4 to the mysql columns you are inserting $fname,$lname,$address,$city into..

<?php

  if (!$fname || !$lname || !$address || !$city) 
{ 
  echo "You have not entered all the required information. <br /> Please go back and try again."; 
  exit; 
} 

$db_addr = "localhost"; 
$db_user = "username"; 
$db_pass = "password"; 
$db_name = "mride"; 
$db_table = "customers"; 

mysql_connect($db_addr,$db_user,$db_pass) or die ('cannot connect to database');
mysql_select_db($db_name) or die ('cannot select database');

 $results = mysql_query("INSERT INTO $db_table (column1,column2,column3,column4) VALUES ('$fname','$lname','$address','$city')"); 

if($results)
{
	 echo "Information Entered"; 
} 
else
{  

	echo "There was a problem."; 
} 

?> 

[Diesel73]

Thanks seby, I'll give this a try and thanks for giving me a direction to follow.