PHP - "nested" Mysql Select Commands

Can someone please help me with an array problem i can not figure out.

I need the array to be numbered from 1 to how ever many fields that are needed in the form and have a mysql field name and the title of the field also in the array.

1, "mysql_field_name", "Title of form field"
2, "", ""

and so on

then the form will be shown based on the array.

I have the following draft code which I am working with.

any suggestions on how i may do this array ?

Code: [Select]
<?php
$options = array(
'1'=> array('fieldtext'=>'option1', 'mysqlfield'=>'option1'),
'2'=> array('fieldtext'=>'option2', 'mysqlfield'=>'option2'),
'3'=> array('fieldtext'=>'option3', 'mysqlfield'=>'option3'),
'4'=> array('fieldtext'=>'option4', 'mysqlfield'=>'option4'),
);


// $options = array(1 => "option1", "option2", "option3", "option4");

// the line above works but i want to include the name of the mysql field as well.

$userid = 1;

?>
<div style="align: center; margin: 12px; font-family:Tahoma;">
<br><br><?php
if ($_POST['Update'] != "Update") { // check if form submitted yet, if not get data from mysql.
$res = db_query("SELECT * FROM `users` WHERE `userid` = '" . $userid . "'");
foreach($options as $key => $value) { $_POST[$key] = mysql_result($res, 0, $value); }
$ok_to_update = "no";
} elseif ($_POST['Update'] == "Update") { // check if form submitted yet, if so get POST data.
// error checking
// foreach($options as $key => $value) {
// $_POST[$i] = "";
// }
$ok_to_update = "yes";
}

if ($_POST['Update'] == "Update" && $ok_to_update == "yes") {
// $res = db_query("INSERT INTO `users` () VALUES ()"); // add user details to database.
?><p><br><br><br>Thank you for updating</p><?php
} else {
?><form name="form1" method="post" action="">
<?php foreach($options as $key => $value) {
?><p><?php echo($value); ?>:&nbsp;<input type="text" name="<?php echo($key); ?>" value="<?php echo($_POST[$key]);?>"></p>
<?php } ?>
<input name="Update" type="submit" value="Update">
</form>
<?php } ?>
</div>

thanks x a million in advance people.  ok i know no php but i feel like im really close to editing this code to how i want it.
i want one send to check the text box captcha and everything else listed there
and i want send2 to check if email1 and email2 match, and if they do, then mail email1 and/or 2.
i preferably need to also have a separate one of these for send2 also: <?php
if (isset($errors)) {

foreach ($errors as $error) {

echo("<p>$error<p>\n");

}
}
?>

heres what i have otherwise, i basically just copied two php "if ___, then do ___" above eachother.
 
<?php
if ($_POST['send']) {

$errors = array();

if ($_POST['captcha'] != $_SESSION['captchacode']) {

$errors[] = "You didn't enter the correct letters!";
}

if (empty($_POST['email']))  {

$errors[] = "Please enter an e-mail address"; 

} 
else if (!eregi("^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$", 

$_POST['email'])) 
{ 
$errors[] = 'Please enter a valid e-mail address'; 
} 

if ($_POST['email1'] != $_POST['email2']) {
$errors[] = "The two emails do not match!";
}

if (!count($errors)) {

// IMPORTANT: If you don't call this the 

// user will keep getting the SAME code!

captchaDone();
$name_field = $_POST['name']; 
$email_field = $_POST['email']; 
$message = $_POST['message'];
$phone = $_POST['phone'];
$optional = $_POST['callback'];
$cs = $_POST['cs'];
$email1 = $_POST['email1'];
$email2 = $_POST['email2'];
$body = "Name: $name_field, Email: $email_field, Phone: $phone, Location: $cs, Call Them! 

$optional, Message: $message";

mail($myaddress, 'Contact Form Submission', $body);

// Notice we can shift in and out of "HTML mode"

// to display some HTML only when the 

// user passes the test
?>
<?php
if ($_POST['send2']) {

$errors = array();

if ($_POST['captcha2'] != $_SESSION['captchacode']) {

$errors[] = "You didn't enter the correct letters!";
}

if (empty($_POST['email1']))  {

$errors[] = "Please enter an e-mail address"; 

} 
else if (!eregi("^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$", 

$_POST['email1'])) 
{ 
$errors[] = 'Please enter a valid e-mail address'; 
} 

if ($_POST['email1'] != $_POST['email2']) {
$errors[] = "The two emails do not match!";
}

if (!count($errors)) {

// IMPORTANT: If you don't call this the 

// user will keep getting the SAME code!

captchaDone();
$email1 = $_POST['email1'];
$email2 = $_POST['email2'];
$body = "$email1, $email2";

mail($myaddress, 'Contact Form Submission', $body);

// Notice we can shift in and out of "HTML mode"

// to display some HTML only when the 

// user passes the test
?>

Hi,

bit stuck on how to find and replace "<" and ">" with "&lt;" and  "&gt;". I basically have a database record that outputs to screen and I need the code in the <code> tags to be rendered to the screen. I therefore need it to go through the whole array variable from the db and change the symbols just inside the code tags. Please be aware that the code tags might happen more than once

here's an example below

Code: [Select]
<p>blah blah blah</p>
<p>blah blah blah</p>
<p>blah blah blah</p>
<code>
<h1>hello</h1>
</code>
<p>blah blah blah</p>
<p>blah blah blah</p>
<p>blah blah blah</p>
<code>
<h1>hello</h1>
</code>

the desired output would be:

<p>blah blah blah</p>
<p>blah blah blah</p>
<p>blah blah blah</p>
<code>
&lt;h1&gt;hello&lt;/h1
</code>
<p>blah blah blah</p>
<p>blah blah blah</p>
<p>blah blah blah</p>
<code>
&lt;h1&gt;hello&lt;/h1
</code>

help on this would be great

Cheers

Rob

I've searched but can't seem to find anything I can apply to this situation.  Most of the resources are dedicated to dropdown menu's from the same table. 

I have two tables 'regions' and 'cities' and I am looking to create a menu that lists all the cities within a region then moves on to do the same for the rest of the regions in that state:

State1
Region1
City1
City2
City3
Region2
City1
City2
City3
Region3
Etc

My tables:
States table: stateID, state
Regions table: regionID, region, stateID
Cities table: cityID, city, regionID

I currently have two pages- select region, then select city... I'd like to consolidate to one step after choosing a state.

I know I need a nested loop, (while?), and to count the results somehow to retrigger loop; also not sure how to handle two mySQL querries in the nested loop.  I'm having trouble wrapping my mind around it. Thank you.

Hi guys

I am a newbie with PHP and I have been trying to solve this problem for 3 days..

Ive set up a booking form on my website to be sent directly to my email once the client clicked on the send button..
The problem I am having while checking these pages on wamp is that the booking form is ok but when I click on the send button the following message error appears
"Warning: mail() [function.mail]: Failed to connect to mailserver at "localhost" port 25, verify your "SMTP" and "smtp_port" setting in php.ini or use ini_set() in C:\wamp\www\fluffy_paws\booking_form2.php on line 27"

When I check online I have this message "500 - Internal server error.
There is a problem with the resource you are looking for, and it cannot be displayed."

Are my codes wrong???

My webhosting is Blacknight.com , Im on Windows Vista, my internet is a dongle with O2 ireland

Thanks for your help!