Help with php enquiry form

ace2721

Hi Guys

I am still new to the php world so forgive me if this is easy, I have a fully functioning contact form which I need a little help with. At the moment it customers fill an enquiry form in which goes to an mysql data base, sends me an email and then autorespondes to there enquiry. what I need it to do is send directly to the branches email. So what I thought about doing is create a table called pit_locations with id, name, branch and email.

this is query I have in serted

$sql = mysql_query("SELECT Email FROM pit_locations WHERE Location ='$postcode' LIMIT 1");
$info = mysql_fetch_array($sql);

but I keep getting this error

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

here is the script the error is in red on line 167 I would be very grateful for any help

<?php

// Connect to database
$hostname = "0.0.0.0";
$username = "test";
$password = "test";
$dbname = "test";
$usertable = "test";
$f_name = $REQUEST['f_name'];
$postcode = $REQUEST['postcode'];
$tel = $REQUEST['tel'];
$mobile = $REQUEST['mobile'];
$email = $REQUEST['email'];
$course = $REQUEST['course'];
$go = "1";

mysql_connect($hostname, $username, $password) or DIE("Unable to connect to MySQL server $hostname");

$selected = mysql_select_db($dbname) or DIE("Could not select requested db $dbname");

$errmsg = ''; // error message
$f_name = ''; // sender's name
$postcode = ''; // sender's name
$tel = ''; // message tel
$mobile = ''; // message tel
$email = ''; // sender's email addres
$course = ''; // the message itself

if(isset($POST['send']))
{
$f_name = $POST['f_name'];
$postcode = $POST['postcode'];
$tel = $POST['tel'];
$mobile = $POST['mobile'];
$email = $POST['email'];
$course = $_POST['course'];

if(trim($f_name) == '')
{
$errmsg = 'Please enter your name';
}
else if(trim($postcode) == '')
{
$errmsg = 'Please enter your postcode';
}
else if(trim($tel) == '')
{
$errmsg = 'Please enter Your Telephone Number:';
}
else if(trim($mobile) == '')
{
$errmsg = 'Please enter your mobile';
}

else if(trim($email) == '')
{
$errmsg = 'Please enter your email address';
}
else if(!isEmail($email))
{
$errmsg = 'Your email address is not valid';
}
else if(trim($course) == '')
{
$errmsg = 'Please enter the course your interested in';
}

if($errmsg == '')
{
if(get_magic_quotes_gpc())
{
$tel = stripslashes($tel);
$message = stripslashes($message);
}

  $query = "INSERT INTO pitman (id, f_name, postcode, tel, mobile, email, course, pdate) VALUES ('', '$f_name', '$postcode', '$tel', '$mobile', '$email' , '$course', NOW())";

  $result = mysql_query($query) or DIE("Could not Execute Query on table $usertable");



  // the email will be sent here
  $to      = "email";

  $user_message .= "Name: $f_name \r\n";
    $user_message .= "postcode: $postcode \r\n";
    $user_message .= "tel: $tel \r\n";
    $user_message .= "mobile: $mobile \r\n";
    $user_message .= "email: $email \r\n";
    $user_message .= "course: $course \r\n";
    $headers = "- company \r\n";
    $headers .= "Reply-To: $email";

$sql = mysql_query("SELECT Email FROM pit_locations WHERE Location ='$postcode' LIMIT 1");
$info = mysql_fetch_array($sql);

  mail('email','Company',$user_message,$headers);

  $autoreply="Thank you for your enquiry, $f_name.

\n\n$user_message\n\nThis is an automated reply.";
$subject="Thank you for Enquiring $name!

mail($email, $subject, $autoreply);
?>
<div align="center" class="boldenquire">Thank you for your enquiry and we look forward to helping you. </div>
<?php
}
}

mysql_close();

if(!isset($_POST['send']) || $errmsg != '')
{
?>

scrupul0us

you need to execute the query statement

ace2721

Hi scrupul0us

thanks for your reply sorry can you be more specific, what statement do I use to execute the command as I have very little experience with php

sorry to be difficult

djjjozsi

please indent you code,
and use php bb tags if you share php codes for us please. The table field names are case sensitive.

$sql = mysql_query("SELECT Email FROM pit_locations WHERE Location ='$postcode' LIMIT 1") or die(mysql_error());

in your code change the DIE into die .

ace2721

Hi djjjozsi

thanks for you help I get this error now Unknown column 'Location' in 'where clause'

i have check the spelling of the field names etc they are fine

I can't see what it could be

djjjozsi

Lets check the correct field name (location) for Email table.

Send us a table structure dump from phpmyadmin..

ace2721

djjjozsi

sorry it was my fault, locations was wrong in the table sorry dude, the only thing now it sends as normal but doesn't send to the email address in the table

i don't get any error messages

these are the fields I have in pit_locations

id, name, Location, Email, tel

djjjozsi

before you run a query, use a die function ,and print the query.

test in phpmyadmin, and if its ok run it.

see your code, the parameters in email() , print the message body and the variables which are important to know they are alive before you send the email.

jjozsi.

ace2721

Hi djjjozsi

sorry I am a complete novice so I really don't want to waste your time, I dont really no how to do a lot in php as I am really only just on the basics.

I went into phpmyadmin and run the query which the query returns nothing as the $postcode is coming from the form so thats ok i think

i added this to the query

$sql = mysql_query("SELECT Email FROM pit_locations WHERE Location ='$postcode' LIMIT 1") or

$result = mysql_query($query) or die('Query failed: ' . mysql_error());

sorry if I am being a dick but I am network engineer trying to sort out a programming problem

djjjozsi

Let me tell you some bacic troubleshooting technique:

Create a mysql query in a separate string!

$sql = "SELECT Email FROM pit_locations WHERE Location ='$postcode' LIMIT 1";

NEW line is coming!

Now print this sql query, to able to test in phpmyadmin using the values from your form:

print "Test this query in phpmyadmin: $sql";

Now run this query in your php program using the very basic error check:.

$result = mysql_query($sql) ;
if($result==false)
die("Error with the query: " .$sql . "  ,  mysql error is:".mysql_error() );

do not use the "or die" while you don't know where and how you could use it!

sorry if I am being a dick but I am network engineer trying to sort out a programming problem

No need to say that.

Hello jjozsi.

ace2721

Hi djjjozsi

thanks so much for all your help so far its really strange as I have done everything you have said and its all been fine, no error messages at all

it still sends the enquiry to me ok but its not sending the email to the relevant branch when they click submit

could I be missing something very small here or is there an easier way

thanks again

djjjozsi

you mean brunch of email, but i did not see emails.

well. Where you get the email addresses ? the limit 1 in your mysql will select only one row from your Email table.

If you select more then one row, you can get the email addresses using a while cycle:

<?php
$result = mysql_query( "$sql_query" );

echo "The message will be send to:";

if ( mysql_num_rows( $result ) > 0 )
{
		while ( $one_row = mysql_fetch_assoc( $result ) )
		{
				echo $one_row["Email"] . ";";
				/* Lets use the email function inside this cycle/loop  */
		} 
} 
else
		print "No result<br />";

?>

ace2721

Hi djjjozsi

I think I need to explain this better, as you can see they fill a form, the form asks for:

Your Name

Nearest centre

Tel

Mobile

Email

Course of interest

these details just go into a table called pitman, it sends me the email enquiry then sends them a little message

what I wanted to do is create a new table pit_locations that has the name email and branch, so when they click on submit it goes straight to them. instead of coming to me and me having to forward it on

the website is all html and not database driven if that makes any difference