PHP - Way To Insert +7 Into A Field?

Hello
I though this code would work
Code: [Select]
mysql_query("UPDATE cart SET totprice = quantity * price WHERE ID='{$id}'")or die(mysql_error());because this is working fine
Code: [Select]
mysql_query("UPDATE products SET rating = rating + 1 WHERE ID='{$id}'")or die(mysql_error());
Anything wrong with it, or how should i do it?

For instance if i set the following 2x variables;

"$varOne = $_GET[first_name]"
"$varTwo = $_GET[last_name]"
"$varThree = $_GET[userid]"

how do i insert them both together into a DB field for example:

$full = $varOne,$varTwo,$varThree (without the , )

this would then be echo as : joebloggs66985

i have the INSERT in there atm but i wanted to insert first name and last name together with there userid to generate a sort of username possibility.

sorry if i didnt explain correcly

Hi guys

I have the code below and have 4 text fields, the issue is i'd like to prevent insert query if textfield is empty, do u know how?




if (isset($_POST['register']) && $_POST['register'])
    {

$reference = rand(11111111,99999999);

$name1 = addslashes(strip_tags($_POST['name1']));
$name2 = addslashes(strip_tags($_POST['name2']));
$name3 = addslashes(strip_tags($_POST['name3']));
$name4 = addslashes(strip_tags($_POST['name4']));

$addname4=mysql_query("INSERT INTO nearest (stref, name) VALUES('$reference','$name4')");
$addname3=mysql_query("INSERT INTO nearest (stref, name) VALUES('$reference','$name3')");
$addname2=mysql_query("INSERT INTO nearest (stref, name) VALUES('$reference','$name2')");
$addname1=mysql_query("INSERT INTO nearest (stref, name) VALUES('$reference','$name1')");

}




thanks

Hi I am very new to PHP & Mysql. I am trying to insert values into two tables at the same time. One table will insert a single row and the other table will insert multiple records based on user insertion. Everything is working well, but in my second table, 1st Table ID simply insert one time and rest of the values are inserting from 2nd table itself. Now I want to insert the first table's ID Field value (auto-incrementing) to a specific column in the second table (only all last inserted rows).   Ripon.   Below is my Code:

<?php



$con = mysql_connect("localhost","root","aaa");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }


mysql_select_db("ccc", $con);


$PI_No = $_POST['PI_No'];
$PO_No = $_POST['PO_No'];


$qry = "INSERT INTO wm_order_entry (
Order_No,
PI_No,
PO_No) 


VALUES(
NULL,
  '$PI_No',
 '$PO_No')";
$result = @mysql_query($qry);




$val1=$_POST['Size'];
$val2=$_POST['Style'];
$val3=$_POST['Colour'];
$val4=$_POST['Season_Code'];
$val5=$_POST['Dept'];
$val6=$_POST['Sub_Item'];
$val7=$_POST['Item_Desc'];
$val8=$_POST['UPC'];
$val9=$_POST['Qty'];
$N = count($val1);
for($i=0; $i < $N; $i++)
{


$profile_query = "INSERT INTO order_entry(Size,
Style,
Colour,
Season_Code,
Dept,
Sub_Item,
Item_Desc,
UPC,
Qty,
Order_No
) VALUES( '$val1[$i]','$val2[$i]','$val3[$i]','$val4[$i]','$val5[$i]','$val6[$i]','$val7[$i]','$val8[$i]','$val9[$i]',LAST_INSERT_ID())";
$t_query=mysql_query($profile_query);
}
header("location: WMView.php");
mysql_close($con);
?>

Output is attached.

This is my first real jump into PHP, I created a small script a few years ago but have not touched it since (or any other programming for that matter), so I'm not sure how to start this.

I need a script that I can run once a day through cron and take the date from one table/filed and insert it into a different table/field, converting the human readable date to a Unix date.

Table Name: Ads
Field: endtime_value (human readable date)

to

Table Name: Node
Field: auto_expire (Converted to Unix time)

Both use a field named "nid" as the key field, so the fields should match each nid field from one table to the next.  Following a tutorial I have been able to insert into a field certain data, but I don't know how to do it so the nid's match and how to convert the human readable date to Unix time.  Thanks in advance!.

Hi:
I'm going crazy trying to do the following:
I'm making a job registration process where the user registers on one php page to the website, must acknowlege and email receipt using an activate php page, then is directed to upload their C.V. (resume) based on the email address they enter in the active page output. I then run an upload page to store the resume in teh MySQL db based on the users email address in the same record.

If I isolate the process of the user registering to the db, it works perfectly.
If I isolate the file upload process into the db, it works perfect.
I simply cannot upload teh file to the existing record based on teh email form field matching the user_email field in the db.
With the processes together, teh user is activated, but teh file is not uploaded.

Maybe I've simply been at this too long today, but am compeled to get through it by end day.
If anyone can help sugest a better way or help me fix this, I will soo greatly appreciate it.

My code is as follows for the 2 pages.

---------activate.php-------
<?php
session_start();
include ('reg_dbc.php');
if (!isset($_GET['usr']) && !isset($_GET['code']) )
{
$msg = "ERROR: The code does not match..";
exit();
}
$rsCode = mysql_query("SELECT activation_code from subscribers where user_email='$_GET[usr]'") or die(mysql_error());
list($acode) = mysql_fetch_array($rsCode);
if ($_GET['code'] == $acode)
{
mysql_query("update subscribers set user_activated=1 where user_email='$_GET[usr]'") or die(mysql_error());
echo "<h3><center>Thank You! This is step 2 of 3. </h3>Your email is confirmed. Please upload your C.V. now to complete step 3.</center>";
} else
{ echo "ERROR: Incorrect activation code... not valid"; }

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
<title>Job application activation</title>
</head>
<body>
<center>
<br/><br/><br/>
<p align="center">
        <form name="form1" method="post" action="upload.php" style="padding:5px;">
        <p>Re-enter you Email : <input name="email" type="text" id="email"/></p></form>
          <form enctype="multipart/form-data" action="upload.php" method="POST">
          <input type="hidden" name="MAX_FILE_SIZE" value="4000000">
          Upload your C.V.: <input name="userfile" type="file" id="userfile">
          <input name="upload" type="submit" id="upload" value="Upload your C.V."/></form>
</p>
</center>
</body>

</html>
--------upload.php----------
<?php
session_start();
if (!isset($_GET['usr']) && !isset($_GET['code']) )
{
$msg = "ERROR: The code does not match..";
exit();
}
if(isset($_POST['upload']) && $_FILES['userfile']['size'] > 0)
{
$fileName = $_FILES['userfile']['name'];
$tmpName  = $_FILES['userfile']['tmp_name'];
$fileSize = $_FILES['userfile']['size'];
$fileType = $_FILES['userfile']['type'];
$email = $_POST['email']['user_email'];

$fp      = fopen($tmpName, 'r');
$content = fread($fp, filesize($tmpName));
$content = addslashes($content);
fclose($fp);

if(!get_magic_quotes_gpc())
{
    $fileName = addslashes($fileName);
}

include 'reg_dbc.php';

$query = "UPDATE subscribers WHERE $email = user_email (name, size, type, content ) ". "VALUES ('$fileName', '$fileSize', '$fileType', '$content')";

mysql_query($query) or die('Error, query failed');
mysql_close($dbname);
}
?>
<center>
<br/>
<br/>
<br/>
<br/>
Thank you for uploading your <?php echo "$fileName"; ?> file, completing your registration, and providing us your C.V. for this position.
<br/>
<br/>
<br/>
We will contact you if your canditature qualifies.
</center>

Can anyone tell me why this is not INSERTing? My array data is coming out just fine.. I've tried everything I can think of and cannot get anything to insert.. Ahhhh!

<?php
  $query = "SELECT RegionID, City FROM geo_cities WHERE RegionID='135'";
  $results = mysqli_query($cxn, $query);
  $row_cnt = mysqli_num_rows($results);
  echo $row_cnt . " Total Records in Query.<br /><br />";
  if (mysqli_num_rows($results)) {
      while ($row = mysqli_fetch_array($results)) {
          $insert_city_query = "INSERT INTO all_illinois SET state_id=$row[RegionID], city_name=$row[City] WHERE id = null" or mysqli_error();
          $insert = mysqli_query($cxn, $insert_city_query);
          if (!$insert) {
              echo "INSERT is NOT working!";
              exit();
          }
          
          echo $row['City'] . "<br />";
          
          echo "<pre>";
          echo print_r($row);
          echo "</pre>";
      }
      //while ($rows = mysqli_fetch_array($results))
      
      } //if (mysqli_num_rows($results))
      
      else {
          echo "No results to get!";
      }
?>

Here is my all_illinois INSERT table structu

CREATE TABLE IF NOT EXISTS `all_illinois` (
  `state_id` varchar(255) NOT NULL,
  `city_name` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Here is my source table geo_cities structu

CREATE TABLE IF NOT EXISTS `1` (
  `CityId` varchar(255) NOT NULL,
  `CountryID` varchar(255) NOT NULL,
  `RegionID` varchar(255) NOT NULL,
  `City` varchar(255) NOT NULL,
  `Latitude` varchar(255) NOT NULL,
  `Longitude` varchar(255) NOT NULL,
  `TimeZone` varchar(255) NOT NULL,
  `DmaId` varchar(255) NOT NULL,
  `Code` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

I'm missing something here. I have a form, and when the submit is pressed, the relevant post data inserts into table one, then I want the last insert id to insert along with other form data into a second table. The first table's still inserting fine, but I can't get that second one to do anything. It leapfrogs over the query and doesn't give an error. EDIT: I forgot to add an error: I get: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'usage, why VALUES ('14', '', '123', '','1234', '', '')' at line 1

query:INSERT INTO tbl_donar (donar_fname, donar_name, donar_address, donar_address2, donar_city, donar_state, donar_zip, donar_email, donar_phone, donar_fax, donar_company) VALUES ('test 14', 'asdfa', 'asdf', 'adf','asdf', '', '', '', '123', '', '')


Code: [Select]
if (empty($errors)) {

require_once ('dbconnectionfile.php');

$query = "INSERT INTO tbl_donar (donar_fname, donar_name, donar_address, donar_address2, donar_city, donar_state, donar_zip, donar_email, donar_phone, donar_fax, donar_company)
 VALUES ('$description12', '$sn', '$description4', '$cne','$description5', '$description6', '$description7', '$description8',
'$description9', '$description10', '$description11')";

$result = @mysql_query ($query);


if ($result) {

$who_donated=mysql_insert_id();

$query2 = "INSERT INTO tbl_donation (donor_id, donor_expyear, donor_cvv, donor_cardtype, donor_authorization, amount, usage, why)
 VALUES ('$who_donated', '$donate2', '$donate3', '$donate4','$donate5', '$donate6', '$donate7')";
$result2 = @mysql_query ($query2);

if ($result2) {echo "Info was added to both tables! yay!";}

echo "table one filled. Table two was not.";
echo $who_donated;

//header ("Location: http://www.twigzy.com/add_plant.php?var1=$plant_id");

exit();
} else {
echo 'system error. No donation added';

(Another quite newbie...)
I have already an online booking form. The Form works fine now and I would like to add on one more issue, but the code ignores what I want to check. I have 4 fields: arrival, departure, no. of persons and comments to check.

Scenario 1:

All field mentioned above are emtpty: Workes fine and message appears: "You have not provided any booking details".

Scenario 2:

If arrival (date_start) and departure (date_end) is entered, there should be at least an entry either in the field "comment", or in the field "pax". If not, there should be a message: "You have not provided sufficient booking details".

INSTEAD: The booking request is sent, which should not be the case.

The code is currently:

      # all fields empty : arrival, departure, pax and comments - error

if(empty($data_start) && empty($data_end) && empty($pax)&& empty($comment)){
    exit("You have not specified any booking details to submit to us.
    <br>Please use your browser to go back to the form.
    <br>If you experience problems with this Form, please e-mail us");
    exit;
}
      #If arrival  and departure date is entered, there should be at least an entry

either in the field "comment", or in the field "pax".
      
if(!isset($data_start) && !isset($data_end) && empty($pax) && empty($comment)){
    exit("You have not provided sufficient booking details.
    <br>Please use your browser to go back to the form.
    <br>If you experience problems with this Form, please e-mail us");
    exit;
}

The form can be tested at http://www.phuket-beachvillas.com/contact-own/contact-it.php

Can someone please check and tell me what's wrong with the code ? Thanks to anyone for any hint.

Code: [Select]
$new_array2=array_diff($my_array,$itemIds);

$updatedb = mysql_query("UPDATE content_type_ads SET field_expire_value = '666' WHERE $new_array2 = field_item_id_value");
"$new_array2" has only 12 digit numbers for each item in the array, and I want to match them to the "field_item_id_value" field in the table, updating the "field_expire_value" field for the record where they match.  I know I am close because the UPDATE code works before I add the WHERE statement (it of course adds '666' to EVERY field, but for a noobie it's a start!).

Hi,
I'm developing an app using flash AS2 as the front end via PHP and a mySQL database at the backend on my server.

what i'm looking to do is update/insert into a table called 'cards' and at the same time update/insert into another table called 'jingle'. There is a field called 'cardID' in jingle that should be the same as the ID number created in 'cards' thus creating a link between entries in the different tables that can be called up as i choose.

hope i've been clear i just wouldn't know where to start any help would be appreciated.

MySQL client version: 5.0.91
PHPmyAdmin Version information: 3.2.4


thanks in advance

How should it look if I want to make a query where a field value should be lower than another field?

Code: [Select]
....WHERE total_points<max_points");

Hello, I'm having a bit of a problem here, all help to this issues would be much appreciated

I am trying to use text boxes to insert numbers into the database based on what is inputed.
If I have a string, like this for example:
$variable = 09385493;

And I want to insert it into the database like this:
mysql_query("INSERT INTO integers(number)
VALUES ('$variable')");

When checking the integers table in my database, looking at the number field, the $variable that was inserted is outputted as
9385493

Notice the number zero was taken out of the front of the number. If the number is double 0's (009385493), both of those zero's would disappear, too.

Thanks

Hey guys,

I am a webmaster for my church and I am fairly new to PHP. What am trying to is when a visitor goes to our radio ministry page and clicks a button which the message number is displayed in the read only textbox, it will go to my request CD page and auto populate the message number in that text field form the readonly text field from the previous page. I will show my code for both pages for you to review.



This is the Radio page (where I want to take the message number value from)
Code: [Select]
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
    <head>
    <meta http-equiv="Content-Type" content="Living Word Community Church radio ministry" />
    <meta name="keywords" content="reformed radio fort worth, reformed radio dallas, biblical radio fort worth, biblical radio dfw"  />
    <title>In Light of Scripture-Radio Ministry</title>
    <link href="_css/Main.css" rel="stylesheet" type="text/css" />
    <script src="SpryAssets/SpryMenuBar.js" type="text/javascript"></script>

    <link href="SpryAssets/SpryMenuBarHorizontal.css" rel="stylesheet" type="text/css" />
    </head>

    <body>

    <div class="container">
    <div class="header"><a href="index.php"><img src="_images/LWCCWeb.jpg" alt="Insert Logo Here" name="Insert_logo" width="960" height="200" id="Insert_logo" style="background: #D8BF78; display:block;" /></a>
       <?php include("_includes/header.php"); ?>
    <div class="sidebar1">
        <p></p>
         <table width="150" border="0" cellpadding="10" align="left">
      <tr>
        <td><a href="directions.php"><img src="_images/ChurchBox.png" width="150" height="125" alt="Directions" /></a></td>
      </tr>
      <tr>
        <td><img src="_images/Service Times.png" width="150" height="778" alt="Service Times" /></td>
      </tr>
    </table>

        <!-- end .sidebar1 --></div>
     
    <div class="content">
       <div id="radio"></div>
        <table width="600" border="0" cellpadding="10">
      <tr>
        <td><img src="_images/ILOS.png" width="600" height="111" alt="In Light of Scripture" /></td>
        </tr>
         <tr>
             <td style=" padding-top:25px"><p><font size="5"><b>In Light of Scripture</b> has been locally broadcast for more
             than 25 years.<br />
              This Sunday morning radio program features the expositional teaching of Pastor Stan McGehee Jr.
             </font><p/></td>
          </tr>
       
        </table>
       
        <div id="mediagraph"><a href="http://kdkr.org" target="_blank"><img src="_images/kdkr.jpg" width="300" height="200" alt="Braodcast on KDKR 91.3 Sunday   
           Mornings at 7:30" /></a></div>
           
            <br  /><br  />
            <font size="2"><p align="center"><b>The sermon featured this week on "In Light of Scipture" is</b></p></font>
            <font size="2"><p align="center" style="color:#711726"><b><i>Peace Despite Tribulation</i></b></p></font>
            <div id="messagenumber" align="center">
            <form action="" method="get" name="messagenumber">
            <input name="" type="text" value="JR-843" size="6" readonly="readonly" />
            <input name="GetMessage" type="button" value="Get Message" />
            </form>
            </div>
        <!-- end .content --></div></div>
      <div class="sidebar2">
        <table width="150" border="0" cellpadding="16" align="left">
          <tr>
            <td><a href="reformation.php"><img src="_images/MenuBox1.png" width="150" height="125" alt="What Do We Mean by Reformed?" /></a></td>
          </tr>
          <tr>
            <td><a href="ServiceTimesAndCal.php"><img src="_images/MenuBox2.png" width="150" height="125" alt="Worship Service Schedule and Calendar" /></a></td>
          </tr>
          <tr>
            <td><a href="radio.php"><img src="_images/MenuBox3.png" width="150" height="125" alt="In Light of Scripture Radio Ministry" /></a></td>
          </tr>
          <tr>
            <td><a href="cable.php"><img src="_images/MenuBox4.png" width="150" height="125" alt="Living Word Today Cable Program" /></a></td>
          </tr>
          <tr>
            <td><a href="Sermons.php"><img src="_images/MenuBox5.png" width="150" height="125" alt="Listen to Sermons Online" /></a></td>
          </tr>
           <tr>
              <td><a href="http://www.lwcchurch.org/blog/" target="_blank"><img src="_images/MenuBox6.png" width=
               "150" height="125" alt="Read our reformed blog" /></a></td>
          </tr>
        </table>
       
        <!-- end .sidebar2 --></div>
        <?php include("_includes/footer.php"); ?>
      <!-- end .container --></div>
      <script type="text/javascript">
    var MenuBar1 = new Spry.Widget.MenuBar("MenuBar1", {imgDown:"SpryAssets/SpryMenuBarDownHover.gif", imgRight:"SpryAssets/SpryMenuBarRightHover.gif"});
    var MenuBar2 = new Spry.Widget.MenuBar("MenuBar2", {imgDown:"SpryAssets/SpryMenuBarDownHover.gif", imgRight:"SpryAssets/SpryMenuBarRightHover.gif"});
    </script>
    </body>
    </html>

This is for the CD request form. I want it to populate the Message# text field

    Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
    <head>
    <meta http-equiv="Content-Type" content="Order Living Word Community Church sermons and teachings on CD" />
    <meta name="keywords" content="Stan McGehee cd, Reformed teachings on cd, Biblical teachings on cd, LWCC cds"  />
    <title>Order CD's Online</title>
    <link href="_css/Main.css" rel="stylesheet" type="text/css" />
    <link href="js/jquery.datepick.css" rel="stylesheet" type="text/css" />
    <script src="SpryAssets/SpryMenuBar.js" type="text/javascript"></script>
    <script src="SpryAssets/SpryValidationTextField.js" type="text/javascript"></script>
    <link href="SpryAssets/SpryMenuBarHorizontal.css" rel="stylesheet" type="text/css" />
    <script type="text/javascript" src="jquery/jquery-1.5.js"></script>
    <script type="text/javascript" src="js/jquery.datepick.js"></script>
    <script src="SpryAssets/SpryValidationSelect.js" type="text/javascript"></script>
    <script src="SpryAssets/SpryValidationRadio.js" type="text/javascript"></script>
    <link href="SpryAssets/SpryValidationTextField.css" rel="stylesheet" type="text/css" />
    <script type="text/javascript">
       $(function() {
       $('#popupDatepicker').datepick();
       $('#inlineDatepicker').datepick({onSelect: showDate});
    });

    function showDate(date) {
       
    }

       </script>



    <link href="SpryAssets/SpryValidationSelect.css" rel="stylesheet" type="text/css" />
    <link href="SpryAssets/SpryValidationRadio.css" rel="stylesheet" type="text/css" />
    </head>

    <body>

    <div class="container">
    <div class="header"><a href="index.php"><img src="_images/LWCCWeb2.png" alt="Insert Logo Here" name="Insert_logo" width="960" height="200" id="Insert_logo" style="background: #D8BF78; display:block;" /></a>
       <?php include("_includes/header.php"); ?>
       
    <div class="sidebar1">
        <p></p>
         <table width="150" border="0" cellpadding="10" align="left">
      <tr>
        <td><a href="directions.php"><img src="_images/ChurchBox.png" width="150" height="125" alt="Directions" /></a></td>
      </tr>
      <tr>
        <td><img src="_images/Service Times.png" width="150" height="890" alt="Service Times" /></td>
      </tr>
    </table>

        <!-- end .sidebar1 --></div>
     
    <div class="content">
       &nbsp;
       <h2 style="padding-left:50px"> Order messages on CD from LWCC</h2>
       <div id"form">
       
        <form action="FormToEmail2.php" method="post">

       


        <table width="550" border="0" cellpadding="10">
         <tr>
           <td><table width="550" border="0" cellpadding="10">
      <tr>
        <td width="190">First Name:</td>
        <td width="314"><span id="spryfirstname">
        <input name="firstname" type="text" id="firstname" maxlength="20" />
        <span class="textfieldMaxCharsMsg">Too many letters</span><span class="textfieldRequiredMsg">Enter first name </span></span></td>
      </tr>
      <tr>
        <td>Last Name:</td>
        <td><span id="sprylastname">
        <input name="lastname" type="text" id="lastname" maxlength="20" />
        <span class="textfieldRequiredMsg">Enter last name</span><span class="textfieldMaxCharsMsg">Too many letters</span></span></td>
      </tr>
      <tr>
       <td>Email<font size="2"> (So we can confirm if needed)</font>:</td>
        <td><span id="spryemail">
        <input name="email" type="text" id="email" maxlength="50" />
        <span class="textfieldRequiredMsg">Enter Email</span><span class="textfieldInvalidFormatMsg">Must be Email.</span><span class="textfieldMaxCharsMsg">Email too long</span></span></td>
      </tr>
      <tr>
       <td>Street:</td>
        <td><span id="sprystreet"><span id="sprystreet">
        <input name="street" type="text" id="street" maxlength="50" />
        <span class="textfieldRequiredMsg">Enter Street Address</span><span class="textfieldMaxCharsMsg">Exceeded maximum number of characters.</span></span></td>
      </tr>
      <tr>
       <td>City:</td>
        <td><span id="sprycity"><span id="sprytextfield5">
        <input name="City" type="text" id="city" maxlength="50" />
        <span class="textfieldRequiredMsg">Enter your city</span><span class="textfieldMaxCharsMsg">Exceeded maximum number of characters.</span></span><span class="textfieldRequiredMsg">Enter Email</span><span class="textfieldInvalidFormatMsg">Must be Email.</span><span class="textfieldMaxCharsMsg">Email too lon</span></span></td>
      </tr>
       <tr>
       <td>Apartment number:</td>
        <td><span id="aptnum">
        <input name="Apt number" type="text" id="aptnum" maxlength="6" width="80px" />
        <span class="textfieldRequiredMsg">Enter Email</span><span class="textfieldInvalidFormatMsg">Must be Email.</span><span class="textfieldMaxCharsMsg">Email too long</span></span></td>
      </tr>
      <tr>
       <td>State:</td>
        <td><span id="spryselect1">
          <select name="statelist">
            <option value="null"></option>
            <option value="Alabama">AL</option>
            <option value="Alaska">AK</option>
            <option value="Arkansas">AR</option>
            <option value="Arizona">AZ</option>
            <option value="California">CA</option>
            <option value="Colorado">CO</option>
            <option value="Connecticut">CT</option>
            <option value="Deleware">DE</option>
            <option value="District of Columbia">DC</option>
            <option value="Florida">FL</option>
            <option value="Georgia">GA</option>
            <option value="Hawaii">HI</option>
            <option value="Idaho">ID</option>
            <option value="Iowa">IA</option>
            <option value="Illinois">IL</option>
            <option value="Indiana">IN</option>
            <option value="Kansas">KS</option>
            <option value="Kentucky">KY</option>
            <option value="Louisiana">LA</option>
            <option value="Massachusetts">MA</option>
            <option value="Maryland">MD</option>
            <option value="Maine">ME</option>
            <option value="Michigan">MI</option>
            <option value="Minnesota">MN</option>
            <option value="Missouri">MO</option>
            <option value="Mississippi">MS</option>
            <option value="Montana">MT</option>
            <option value="Nebraska">NE</option>
            <option value="New Hampshire">NH</option>
            <option value="New Jersey">NJ</option>
            <option value="New Mexico">NM</option>
            <option value="Nevada">NV</option>
            <option value="New York">NY</option>
            <option value="North Carolina">NC</option>
            <option value="North Dakota">ND</option>
            <option value="Ohio">OH</option>
            <option value="Oklahoma">OK</option>
            <option value="Oregon">OR</option>
            <option value="Pennslyvania">PA</option>
            <option value="Rhode Island">RI</option>
            <option value="South Carolina">SC</option>
            <option value="Tennessee">TN</option>
            <option value="Texas">TX</option>
            <option value="Utah">UT</option>
            <option value="Vermont">VT</option>
            <option value="Virginia">VA</option>
            <option value="Washington">WA</option>
            <option value="Wisconsin">WI</option>
            <option value="West Virginia">WV</option>
            <option value="Wyoming">WY</option>
          </select>
          <span class="selectRequiredMsg">Please select state</span></span></td>
      </tr>
      <tr>
       <td>Zip Code:</td>
        <td><span id="spryzip"><span id="sprytextfield6">
        <input name="Zip Code" type="text" id="zip" maxlength="50" />
        <span class="textfieldRequiredMsg">Enter Zip Code</span><span class="textfieldInvalidFormatMsg">Zip Code is 5 numbers.</span></span><span class="textfieldRequiredMsg">Enter Email</span><span class="textfieldInvalidFormatMsg">Must be Email.</span><span class="textfieldMaxCharsMsg">Email too lo</span></span></td>
      </tr>
      <tr>
        <td>Which Pastor or Teacher?</td>
        <td>
          <div id="spryradio1">
            <table width="250">
              <tr>
                <td><label>
                  <input type="radio" name="Speaker" value="Pastor Stan McGehee" id="radiogroup_4" />
                  Pastor Stan McGehee Sr</label></td>
              </tr>
              <tr>
                <td><label>
                  <input type="radio" name="Speaker" value="Pastor Stan McGehee Jr" id="radiogroup_5" />
                  Pastor Stan McGehee Jr</label></td>
              </tr>
              <tr>
                <td><label>
                  <input type="radio" name="Speaker" value="Pastor Jack McFarland" id="radiogroup_6" />
                  Pastor Jack McFarland</label></td>
              </tr>
              <tr>
                <td><label>
                  <input type="radio" name="Speaker" value="Steve Bader" id="radiogroup_7" />
                  Steve Bader</label></td>
              </tr>
            </table>
            <span class="radioRequiredMsg">Please select speaker</span></div></td>
      </tr>
      <tr>
      <td>Where did you hear message?</td>
      <td>
         <div id="spryradio2">
           <table width="200">
             <tr>
               <td><label>
                 <input type="radio" name="How did you hear?" value="At LWCC" id="RadioGroup1_0" />
                 At our church</label></td>
             </tr>
             <tr>
               <td><label>
                 <input type="radio" name="How did you hear?" value="On the Radio" id="RadioGroup1_1" />
                 On the Radio</label></td>
             </tr>
             <tr>
               <td><label>
                 <input type="radio" name="How did you hear?" value="On Cable" id="RadioGroup1_2" />
                 On Cable</label></td>
             </tr>
           </table>
           <span class="radioRequiredMsg">Please make a selection</span></div></td>
      </tr>
      <tr>
       <td>What service?</td>
        <td><div id="spryradio3">
          <table width="248">
            <tr>
              <td width="240"><label>
                <input type="radio" name="When did you hear message?" value="Sunday AM" id="When did you hear message?_0" />
                Sunday AM</label></td>
            </tr>
            <tr>
              <td><label>
                <input type="radio" name="When did you hear message?" value="Sunday PM" id="When did you hear message?_1" />
                Sunday PM</label></td>
            </tr>
            <tr>
              <td><label>
                <input type="radio" name="When did you hear message?" value="Wednesday PM" id="When did you hear message?_2" />
                Wednesday PM</label></td>
            </tr>
            <tr>
              <td><label>
                <input type="radio" name="When did you hear message?" value="Adult Sunday School" id="When did you hear message?_3" />
                Adult Sunday School</label></td>
            </tr>
          </table>
          <span class="radioRequiredMsg">Please make a selection.</span></div></td>
        </tr>
      <tr>
        <td>Message Number <font size="2">(If known)</font>: </td>
        <td><input name="Message#" type="text" id="messagenumber" maxlength="50" /></td>
      </tr>
            </table>

    </td>
           </tr>
         <tr>
           <td><table width="550" border="0" cellpadding="10">
               <h3 style="padding-left:135px">Please pick date of message</h3>
                <div id="selectdate" align="center"><input id="inlineDatepicker" name="When Did You Hear?" type="text" /></div>
             
               

                <script type="text/javascript">

             var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
    document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
    </script>
    <script type="text/javascript">
    var pageTracker = _gat._getTracker("UA-4715900-1");
    pageTracker._initData();
    pageTracker._trackPageview();

    </script></table></td>

     
      <tr>
        <td style="padding-left:250px"><input name="submit" value="Submit" type="submit" />&nbsp;&nbsp;<input name="clearBtn" type="reset" /></td>
       
      </tr>
    </table>
    </td>
           </tr>
         </table>
       

        </form></div>
      <!-- end .content --></div></div>
      <div class="sidebar2">
        <table width="150" border="0" cellpadding="25" align="left">
          <tr>
            <td><a href="reformation.php"><img src="_images/MenuBox1.png" width="150" height="125" alt="What Do We Mean by Reformed?" /></a></td>
          </tr>
          <tr>
            <td><a href="ServiceTimesAndCal.php"><img src="_images/MenuBox2.png" width="150" height="125" alt="Worship Service Schedule and Calendar" /></a></td>
          </tr>
          <tr>
            <td><a href="radio.php"><img src="_images/MenuBox3.png" width="150" height="125" alt="In Light of Scripture Radio Ministry" /></a></td>
          </tr>
          <tr>
            <td><a href="cable.php"><img src="_images/MenuBox4.png" width="150" height="125" alt="Living Word Today Cable Program" /></a></td>
          </tr>
          <tr>
            <td><a href="Sermons.php"><img src="_images/MenuBox5.png" width="150" height="125" alt="Listen to Sermons Online" /></a></td>
          </tr>
           <tr>
              <td><a href="http://lwcchurch.blogspot.com" target="_blank"><img src="_images/MenuBox6.png" width="150" height="125" alt="Read our reformed blog" /></a></td>
          </tr>
        </table>
       
        <!-- end .sidebar2 --></div>
       <?php include("_includes/footer.php"); ?>
      <!-- end .container --></div>
    <script type="text/javascript">
    var MenuBar1 = new Spry.Widget.MenuBar("MenuBar1", {imgDown:"SpryAssets/SpryMenuBarDownHover.gif", imgRight:"SpryAssets/SpryMenuBarRightHover.gif"});
    var MenuBar2 = new Spry.Widget.MenuBar("MenuBar2", {imgDown:"SpryAssets/SpryMenuBarDownHover.gif", imgRight:"SpryAssets/SpryMenuBarRightHover.gif"});
    var sprytextfield1 = new Spry.Widget.ValidationTextField("spryfirstname", "none", {validateOn:["blur"], maxChars:20});
    var sprytextfield2 = new Spry.Widget.ValidationTextField("sprylastname", "none", {maxChars:20, validateOn:["blur"]});
    var sprytextfield3 = new Spry.Widget.ValidationTextField("spryemail", "email", {maxChars:50, validateOn:["blur"]});
    var sprytextfield4 = new Spry.Widget.ValidationTextField("sprystreet", "none", {validateOn:["blur"], maxChars:50});
    var sprytextfield5 = new Spry.Widget.ValidationTextField("sprytextfield5", "none", {maxChars:50, validateOn:["blur"]});
    var spryselect1 = new Spry.Widget.ValidationSelect("spryselect1", {validateOn:["blur"]});
    var sprytextfield6 = new Spry.Widget.ValidationTextField("sprytextfield6", "zip_code", {validateOn:["blur"]});
    var spryradio1 = new Spry.Widget.ValidationRadio("spryradio1");
    var spryradio2 = new Spry.Widget.ValidationRadio("spryradio2");
    var sprytextfield7 = new Spry.Widget.ValidationTextField("sprymessagenumber", "none", {isRequired:false});
    var spryradio3 = new Spry.Widget.ValidationRadio("spryradio3");
    </script>
    </body>
    </html>