PHP - Moved: Repeat Region - Help Needed

This topic has been moved to PHP Applications.

http://www.phpfreaks.com/forums/index.php?topic=331158.0

This topic has been moved to Third Party PHP Scripts.

http://www.phpfreaks.com/forums/index.php?topic=355529.0

This topic has been moved to CSS Help.

http://www.phpfreaks.com/forums/index.php?topic=320868.0

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=319419.0

Not too familiar with sessions but I was curious to get others' input on this situation. I want to have users visit my site and be confronted with selecting their region, which will filter out the content they see.

What type of sessions lifetime should I be working with here? I was thinking of keeping the session registered for as long as they stay on the site and maybe an hour afterwards just incase they visit again.

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=318486.0

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=333523.0

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=318572.0

I am using Dreamweaver CS4 to build a website. On my contact page, I made a form with spry validation. I used a tutvid tutorial to learn a simple form handler script (I'm a complete newb at PHP) and everything works great. The only problem I'm having is, in my Dreamweaver template, I have an editable region that has the form. When  the user clicks to submit the form, a new html page opens up that looks nothing like my website.
What I'm trying to accomplish is having the form disappear and be replaced in the same editable region with my "thank you" message. This way, the user just submits, the form disappears, and they get a thank you message on the same page, in the same place where the form was.

Here is the form code:

Code: [Select]
<form id="frmContact" name="frmContact" method="post" action="contact_form.php">
     <fieldset><legend>Submit a question or comment...</legend>
     
       <p>
         <label for="name">Name:</label>
         <span id="spryName">
         <input type="text" name="name" id="name" />
         <span class="textfieldRequiredMsg">Name is required.</span><span class="textfieldMinCharsMsg">Must have at least 3 characters.</span><span class="textfieldMaxCharsMsg">Must not exceed 20 characters.</span></span></p>
       <p>
         <label for="email">Email:</label>
         <span id="spryPassword">
         <input type="text" name="email" id="email" tabindex="10" />
         <span class="textfieldRequiredMsg">Email address is required.</span><span class="textfieldInvalidFormatMsg">Not a valid email address.</span><span class="textfieldMinCharsMsg">Not a valid email address.</span><span class="textfieldMaxCharsMsg">Not a valid email address.</span></span></p>
       <p>
         <label id="message" for="question">Please tell us how we can help you:</label><br />
         <span id="spryText">
         <textarea name="question" id="question" cols="45" rows="5" tabindex="20"></textarea><br />
         <span class="textareaRequiredMsg">A question or comment is required.</span><span class="textareaMinCharsMsg">Must have 16 characters minimum</span><span class="textareaMaxCharsMsg">Must not exceed 500 characters.</span></span></p>
       <p>
         <input type="submit" name="submit" id="submit" value="Submit" tabindex="30" />
       </p>
     </fieldset>
     </form>

Here is the PHP script:

<?php

/* Subject and Email variables */

$emailSubject = 'Contact Form Response';
$webMaster = 'centerline.computers@gmail.com';

/* Gather Data variables */

$nameField = $_POST['name'];
$emailField = $_POST['email'];
$questionField = $_POST['question'];

$body = <<<EOD
<br><hr><br>
Name: $nameField <br>
Email: $emailField <br>
Message: $questionField <br>
EOD;

$headers = "From: $emailField\r\n";
$headers .= "Content-type: text/html\r\n";
$success = mail($webMaster, $emailSubject, $body, $headers);


/* Results rendered as HTML */


$theResults = <<<EOD
<html><body>
<h2>Thank you for submitting.</h2>
<p>We will get back to you as soon as possible.</p>

</body>
</html>
EOD;
echo "$theResults";

?>

Thanks for any help you might have for me!

Basically, I am creating a list of all the regions in the world, and I want it to display the countries that are inside each region. I am saving the data in a table that is composed of 2 columns, region name and country name. I have to do it this way, because there are some countries that fall into several regions.

The link is here http://128.123.242.201/countries.php. As you can see it is repeating regions (as it should) but I don't know how to combine all the countries in each region together, and only display each geographical region once.
Code: [Select]
<!DOCTYPE html>
<?php require "connect.php";?>
<html>
<head>
  <link href="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8/themes/base/jquery-ui.css" rel="stylesheet" type="text/css"/>
  <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.5/jquery.min.js"></script>
  <script src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8/jquery-ui.min.js"></script>
 
  <script>
  $(document).ready(function() {
    $("#accordion").accordion();
  });
  </script>
</head>
<body style="font-size:75%;">


<?php

if(isset($_POST['submit'])) {


  $region = $_POST['region'];
  $country = $_POST['country'];
    
$query= "INSERT INTO regions (region,country) VALUES ('$region','$country')";

$result = mysql_query($query);

   if(!$result) {
        $confirmMsg = "There was a problem updating the record.";
    }
    elseif(mysql_affected_rows()==0) {
        $confirmMsg = "There was no record to update.";
    }
    else {
        $confirmMsg = "The record was successfully updated.";
    }


echo $confirmMsg; 
}

?>






<h3>
S<br />Add information:
<form method="post" action =""><br />

Country: <input type = "text" name="country" />
Region: <input type = "text" name="region" />
<br />
<input type = "submit" value = "submit" name="submit" />
</form>
</h3>

<div id="accordion">

<?php


//Delcare variable $info
$region = $country = NULL;
$query = "SELECT * FROM regions";
$result = (mysql_query($query)); 


while  ($row=mysql_fetch_assoc($result))
{
$region  = "{$row['region']}"; 
$country = "{$row['country']}";


$deleteimg = "http://www.veryicon.com/icon/png/System/Float/Delete.png";

$delete = "<a href=\"delete.php?region=".$region."&country=".$country."\"onclick=\"";
$delete .= "return confirm('Are you sure you want to delete?')\">";
$delete .= "<img src=".$deleteimg." height=\"20\"/></a>";


$accord = "<h3><a href=\"#\">$region</a></h3>";
$accord .= "<div>";
$accord .= "<p>";


$accord .= $delete.$country;

$accord .= "</p>";
$accord .= "</div>";



echo $accord;

}

?>


</div>


</body>
</html>

hi, is there a way to tell php to do a process again?
example:

Code: [Select]
$draft_number=rand(1, 15);

if($draft_number == 5){
START OVER AT TOP
} else {
$sql1 = "UPDATE names SET draft = '$draft_number' WHERE id = '$uid'";
$result1 = mysql_query($sql1) or die('Error, Check you fields and try again.');
}

I have this code which checks for the word "Big Ben" and if it's not there it outputs some html. I want t be able to make another statement to also check for the word "London Tower" and if it's not there then to check for the word "Canary Wharf",

So far I've only managed one statement without the code breaking, how do I add the others in as well.

<?php $astacker=get_post_meta($post->ID, 'thesite', true); if ( $astacker == [b]'Big Ben'[/b]) { ?>
<?php include(TEMPLATEPATH."/feedsgrabstack.php");?>
<?php }else { ?>
<div id="splitter"><div class="clear">
<a href="<?php echo get_post_meta($post->ID, "linktosource", true);?>">Click Here To View Answers</a> <span style="float:right;"><a href="#related">See Related Questions</a></div></div>
<?php } ?>

Hello, I need help in making my script loop indefinitely. Any ideas?

Hi Everyone, could anyone tell me why this only shows one record.
There is at least four that will match the query.

case 'jayzquotes';
 echo '<table border="0" cellspacing="0" cellpadding="2"><tr><td><h1>Jay-Z Quotes</h1></td></tr></table><br>';

 
 echo '<table width="600" border="0" cellspacing="0" cellpadding="2">';
  
  $result = mysql_query("SELECT * FROM quotes WHERE artist LIKE 'J%' and approved = 'y'")
or die(mysql_error()); 

$count = mysql_num_rows ($result );
while($row=mysql_fetch_array($result)){

  
$resultb = mysql_query("SELECT * FROM comments WHERE quoteid=".$row['quoteid']."")
or die(mysql_error()); 
while($link=mysql_fetch_array($resultb)){

$date = $row[date];
$user = $row[user];
$email = $row[email];
$artist = $row[artist];
$song = $row[song];
$quote = stripslashes($row[quote]);
$quoteid = $row[quoteid];
$votes = $row[votes];

 
echo '
<tr>
  <td width="424"><strong>Date Submitted:</strong><span class="red"> '.$date.'</span></td>
  <td width="156" align="right"><strong>Total Votes</strong> (<span class="red">'.$votes.'</span>)</td>
  </tr>
<tr>
  <td colspan="2"><strong>Quote submitted by:</strong><span class="red"> '.$user.' </span>- <span class="red"><a href="mailto:'.$email.'">'.$email.'</a> </span></td>
  </tr>
<tr>
  <td colspan="2"><strong>Artist:</strong> <span class="red">'.$artist.' </span></td>
  </tr>
<tr>
  <td colspan="2"><strong>Song name:</strong> <span class="red">'.$song.' </span></td>
  </tr>
<tr>
  <td colspan="2"><strong>Quote:</strong><hr></td>
  </tr>
<tr>
    <td colspan="2">'.$quote.'</td>
    </tr>
<tr>
  <td colspan="2"><table width="100%" border="0" cellspacing="0" cellpadding="5" class="quotefooter">
    <tr>
      <td><strong>(<span class="dark">'.$countb.'</span>) Comments: View / Edit Comments</strong></td>
      <td align="center"><strong><a href="index.php?action=editquote&quoteid='.$quoteid.'" target="_self">Edit Quote</a></strong></td>
      <td align="center"><strong><a href="index.php?action=deletequote&quoteid='.$quoteid.'">Delete Quote</a></strong></td>
        </tr>
      </table><br><hr></td>
  </tr>
';
  }
}
echo '</table>';
echo '<strong>Total Results</strong><span class="red"> '.$count.'</span>';

break;