aeafisme23

Just wanted to let everyone know I figured it out using an IF statement if ( $dvd_quantity == 1 ) { $dvd_cost = 25.00;} elseif ( $dvd_quantity == 2 ) { $dvd_cost = 45.00;} elseif ( $dvd_quantity > 2 ) { $dvd_cost = ((15 * $dvd_quantity) + 15); } Thanks for letting me get this far so I was able to noodle it in the right direction!!!!

Thanks for the explaination Alex, makes sense. Unfortunately the page is just white and no error message so it leads me to believe I still have an error in sytnax. Litebearer, thank you for your comment as well. A switch statement may seem more logical but I came across an error as well, it gave me the default error. This is what i tried using your method you suggested: switch ($dvd_cost) { case 1: $dvd_quantity = 1; $dvd_cost = 25.00; break; case 2: $dvd_quantity = 2; $dvd_cost = 40.00; break; case 3: $dvd_quantity > 2; $dvd_cost = 15 * $dvd_quantity; break; default: echo "Sorry we experienced an error"; } a little additional code if it's needed <?php $dvds1 = $_POST["dvds1"]; $dvds2 = $_POST["dvds2"]; $dvds3 = $_POST["dvds3"]; $dvds4 = $_POST["dvds4"]; $dvd_quantity = $dvds1 + $dvds2 + $dvds3 + $dvds4; // QUANTITY if ( $dvd_quantity == "1" ) { $dvd_cost = "25.00";} elseif ( $dvd_quantity == "2" ) { $dvd_cost = "45.00";} else ( $dvd_quantity > "2" ) { $dvd_cost = 15 * $dvd_quantity; } ?>

This is the code that does not work. I want to create the last greater than in the ELSE statement but it does not work, code works up to that point by erasing the else statement and alternatively I could add 100's of elseif to satisfy a quantity and cost but that is not simplified. I know this is a logical and syntax error on my part but I am not sure how i correctly change it? Any help would be great! Thanks guys or gals! <?php if ( $dvd_quantity == "1" ) { $dvd_cost = "25.00";} elseif ( $dvd_quantity == "2" ) { $dvd_cost = "45.00";} else ( $dvd_quantity > "2" ) { $dvd_cost = "15.00*$dvd_quantity";} ?>

Thank you, you top of the include page was pretty much what was wrong, i was defining a variable in the wrong order so on default i was always going to call apple. Thanks again. mrMarcus, thank you for making me laugh

I would like to have a variable in this situation be REPLACED by $orange so that when I echo $apple below it will read the $orange variable from the include and say I am an orange. This is a very dumbed down version of what I am doing and I have 100's of pages that use the include page and each page starts out with declaring $apple=$orange or $apple=$pineapple or in a Generic way I just leave the variable as is. I hope I did not make this more confusing. Content: <?php include("includepage.php"); $apple = $orange; ?> <?php echo $apple; ?> Include Page $apple ="I am an apple"; $orange ="I am an orange";

Maybe this is a better example of what I am trying to do : $eventinfo = "'include("eventinclude.php");' <p class=\"left-align\">Hello this is text.</p>"; Of course I can not get the above to work and tried interchanging the " and the 's many times to no avail. With in the variable I want to execute an include statement along with text. UPDATE: $eventinfo = include("eventinclude.php"); I tried doing that and it is calling the include but it is executing right away and it is not fitting with in the html and where I want it to go it says 1 , just the number one. Is 1 an error code for something?

Thanks for the info on i know what are the major issues of the '" and ;'s but I do not think this is nested inside the variable so when I call the variable $eventinfo it will never execute the mysql code. Any ideas? Thanks

I have about 50 pages that all use variables to display images and text. I did a bad job at coding in the first place and the project is too big to open all 50 pages and insert each statement in when I can use the variable that is there. $eventinfo = "This is just some random text and i want to include some info from my database inside this content // the info below I am trying to contain with in the variable $eventinfo $connect = mysql_pconnect('localhost", "xxxxx", "xxxxx") or die(mysql_error()); mysql_select_db("xxxxx", $connect) or die(mysql_error()); $sql_address = mysql_query("SELECT MAX(ID) as ID, Date, Time FROM events WHERE DMA='$Station'") or die (mysql_error()); $row_count = 0; while($results = mysql_fetch_array($sql_address)) { <tr> <td><p>' .$results['Date'] . '</p></td> </tr> <tr> <td><p>' .$results['Time'] . '</p></td> </tr>'; } mysql_free_result($sql_address); mysql_close($connect); this is more content below the sql statement and with in the variable eventinfo."; I have also tried to call an include statement of the sql inside $eventinfo but it's the same result. I understand the logic of why it will not work, I am declaring a variable and then putting variables inside but when i do that the semi colons are ending the statement early. I know there are other ways to do this besides putting it inside a variable but as of right now I am banking that this can be done some how to call the sql statement with in the variable. Any ideas?

I still am trying to figure this out and have come up with a way to rig the code but it's just like an array and the fact that the information is already in the database and I can not pull it is frusturating.... <?php $cat=$_GET['cat']; $subcat=$_GET['subcat']; if ($cat == '1'){$state = "AL";} if ($cat == '2'){$state = "AK";} if ($cat == '3'){$state = "AZ";} if ($cat == '4'){$state = "AR";} if ($cat == '5'){$state = "CA";} if ($cat == '6'){$state = "CO";} if ($cat == '7'){$state = "CT";} if ($cat == '8'){$state = "DE";} if ($cat == '9'){$state = "DC";} if ($cat == '10'){$state = "FL";} echo "State is $state <br>City is $subcat<br><br>"; As you can see I can easily just call the city by $subcat, but if i do state is $cat then it returns nothing, instead i have to delcare a variable for every state above.... really weird.... Trying to use less code...alot less. Let me know if I need to provide more code. This is pulling from 2 tables with in a database, one for each drop down, category being the state and subcategory being the city....each has a auto incrementing id assigned to each city or state, hence the error i have been getting.

I think I understand what you are getting at and tried something like this echo "<form method=get name=f1 action='dd-check.php'><input type='hidden' value='$noticia2[category]'>"; ////////// Starting of first drop downlist ///////// echo "<select name='cat' onchange=\"reload(this.form)\"><option value=''>Select one</option>"; while($noticia2 = mysql_fetch_array($quer2)) { if($noticia2['cat_id']==@$cat){echo "<option selected value='$noticia2[cat_id]'>$noticia2[category]</option>"."<BR>";} else{echo "<option value='$noticia2[cat_id]'>$noticia2[category]</option>";} } echo "</select>"; and also tried putting the value hidden else where.....If this is not what you meant let me know. Also for anyone else maybe you may see something else that could help me out as well, this is crazy.....

Correct, I tried to switch out cat_id to category in the code but I am not getting it to work, I guess the coding is just not that good to manipulate ? I figured if I switched the value which is the variable that will be passed to the next page dd-check.php that it would work ..... Just cant get it to work echo "<select name='cat' onchange=\"reload(this.form)\"><option value=''>Select one</option>"; while($noticia2 = mysql_fetch_array($quer2)) { if($noticia2['cat_id']==@$cat){echo "<option selected value='$noticia2[cat_id]'>$noticia2[category]</option>"."<BR>";} // switched to if($noticia2['cat_id']==@$cat){echo "<option selected value='$noticia2[category]'>$noticia2[category]</option>"."<BR>";} else{echo "<option value='$noticia2[cat_id]'>$noticia2[category]</option>";} // switched to else{echo "<option value='$noticia2[category]'>$noticia2[category]</option>";} }

Forgot to add the link to try so you can see what I am talking about. http://thegreatestsave.org/add/dd.php

I am trying to accomplish a custom State / City drop down using a database and I am running into a small problem of pulling the wrong variable (field from the database). My end result is this State is 4 City is Jonesboro As you can see there are no states called "4", that is the cat_id assigned to the state which would be Arkansas. I tried switching around the variables a bit to try and display the state Arkansas instead of "4" but no such luck yet. Any ideas? dd.php <?php @$cat=$HTTP_GET_VARS['cat']; // Use this line or above line if register_global is off ///////// Getting the data from Mysql table for first list box////////// $quer2=mysql_query("SELECT DISTINCT category,cat_id FROM category order by category"); ///////////// End of query for first list box//////////// /////// for second drop down list we will check if category is selected else we will display all the subcategory///// if(isset($cat) and strlen($cat) > 0){ $quer=mysql_query("SELECT DISTINCT subcategory FROM subcategory where cat_id=$cat order by subcategory"); }else{$quer=mysql_query("SELECT DISTINCT subcategory FROM subcategory order by subcategory"); } ////////// end of query for second subcategory drop down list box /////////////////////////// echo "<form method=post name=f1 action='dd-check.php'>"; ////////// Starting of first drop downlist ///////// echo "<select name='cat' onchange=\"reload(this.form)\"><option value=''>Select one</option>"; while($noticia2 = mysql_fetch_array($quer2)) { if($noticia2['cat_id']==@$cat){echo "<option selected value='$noticia2[cat_id]'>$noticia2[category]</option>"."<BR>";} else{echo "<option value='$noticia2[cat_id]'>$noticia2[category]</option>";} } echo "</select>"; ////////////////// This will end the first drop down list /////////// ////////// Starting of second drop downlist ///////// echo "<select name='subcat'><option value=''>Select one</option>"; while($noticia = mysql_fetch_array($quer)) { echo "<option value='$noticia[subcategory]'>$noticia[subcategory]</option>"; } echo "</select>"; ////////////////// This will end the second drop down list /////////// //// Add your other form fields as needed here///// echo "<input type=submit value=Submit>"; echo "</form>"; ?> dd-check.php <?php $cat=$_POST['cat']; $subcat=$_POST['subcat']; echo "State is $cat <br>City is $subcat "; ?>

Your a genious PFMABISMAD, it was the mismatch () sure enough.....when copy pasting the original file (since im reusing it) i copied to the end closing )) and left them in the middle....grrr.... Thanks so much everyone, all those before taught me a few things as well so I am very appreciative for that (shortcut for echoing a value, the debugging at the top) THANK YOU ALL!

Basically i have a few types of these pages where i can just change out the field names and somewhere along the way I went astray and now the pages will not show up at all. I want to say it's as simple as a missing ; or a misspelling of syntax but for the life of me i can not find it. I will post the code but it's not fair to expect anyone to read it all since there is so much, but is there a good debugging way to find out where my problem might exist. Usually i will get t_else errors on line etc...and those are easy to diagnose, but when the page is blank...its finding a needle in the haystack. (Code below) thanks again. <html> <head> <title>Manage Coordinator Log</title> </head> <body> <?php /************************************************************************* control code for application *************************************************************************/ //submit button was pressed so call the process form function if (isset($_POST['submit'])) { process_form(); die(); }//end if //call the get_data function if (isset($_GET['id'])) { get_data(); }//endif //nothing chosen so list the dma's if ((empty($_POST))&&(empty($_GET))) { list_users(); die(); }//end if //request to add a new contact so call the show_form function if ((isset($_GET['action']))&&($_GET['action']=='add')) { show_form(); }//endif /************************************************************************* get the data for an individual contact *************************************************************************/ function get_data() { //validate the id has been passed at that it is a number if ((empty($_GET['id']))||(is_nan($_GET['id']))) { //there was a problem so list the users again list_users(); //kill the script die(); }else{ //all is ok and assign the data to a local variable $id = $_GET['id']; }//end if $sql = "select * from coordinator where id = {$id} order by KVCode;"; $result = conn($sql); if (mysql_num_rows($result)==1){ //call the form and pass it the handle to the resultset show_form($result); }else{ $msg = "No data found for selected Coordinator"; confirm($msg); //call the list users function list_users(); }//end if }//end function /************************************************************************* show the input / edit form *************************************************************************/ function show_form($handle='',$data='') { //$handle is the link to the resultset, the ='' means that the handle can be empty / null so if nothing is picked it won't blow up //set default values $KVCode = ''; $FullName = ''; $PhoneNumber = ''; $Email = ''; $AccessLevel = ''; $Commission = ''; $ReportsTo = ''; $id = ''; $value = 'Add'; //submit button value $action = 'add'; //default form action is to add a new dma/station to db //set the action based on what the user wants to do if ($handle) { //set form values for button and action $action = "edit"; $value = "Update"; //get the values from the db resultset $row = mysql_fetch_array($handle); $KVCode = $row['KVCode']; $FullName = $row['FullName']; $PhoneNumber = $row['PhoneNumber']; $Email = $row['Email']; $AccessLevel = $row['AccessLevel']; $Commission = $row['Commission']; $ReportsTo = $row['ReportsTo']; $id = $row['id']; }//end if //error handling from the processing form function if($data != '') { $elements = explode("|",$data); $KVCode = $elements[0]; $FullName = $elements[1]; $PhoneNumber = $elements[2]; $Email = $elements[3]; $AccessLevel = $elements[4]; $Commission = $elements[5]; $ReportsTo = $elements[6]; $id = $elements[7]; } ?> <body> <?php include "smsinclude.php"; echo $navigation; ?> <p style="font-size:18px; font-weight:bold;">Manage Coordinators Log</p> <form name="form1" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>?action=<?php echo $action?>"> <table width="700" bgcolor="ffffff" cellpadding="5" cellpsacing="0" border="1" bordercolor="#000000"> <tr> <td><input type="hidden" value="<?php echo $id?>" name="id"> <table width="700" cellpadding="0" cellpsacing="0" border="0" bordercolor="#000000"> <tr> <td align="left" width="180">KV Code</td> <td width="320" align="left"><input type="text" name="KVCode" size="15" value="<?php echo $KVCode ?>"></td> <td align="left" width="200">ex) ccdhc6</td> </tr> <tr> <td align="left" width="180">Full Name</td> <td width="320" align="left"><input type="text" name="FullName" size="15" value="<?php echo $FullName ?>"></td> <td align="left" width="200">ex) David Coombs </td> </tr> <tr> <td align="left" width="180">Phone Number</td> <td width="320" align="left"><input type="text" name="PhoneNumber" size="40" value="<?php echo $PhoneNumber ?>"></td> <td align="left" width="200">ex) 765-473-3396 </td> </tr> <tr> <td align="left" width="180">Email</td> <td width="320" align="left"><input type="text" name="Email" size="40" value="<?php echo $Email ?>"></td> <td align="left" width="200">ex) dcoombs@kindervision.org </td> </tr> <tr> <td align="left" width="180">Access Level</td> <td width="320" align="left"><input type="text" name="AccessLevel" size="40" value="<?php echo $AccessLevel ?>"></td> <td align="left" width="200">ex) 1 is NC, 2 is RC, 3 is CC </td> </tr> <tr> <td align="left" width="180">Commission Percentage</td> <td width="320" align="left"><input type="text" name="Commission" size="40" value="<?php echo $Commission ?>"></td> <td align="left" width="200">ex) 25% leave out % sign </td> </tr> <tr> <td align="left" width="180">Reports To:</td> <td width="320" align="left"><input type="text" name="ReportsTo" size="40" value="<?php echo $ReportsTo ?>"></td> <td align="left" width="200">ex) Andy Mars KVRC</td> </tr> <tr> <td colspan="3"> <p align="center"><input name="submit" type="submit" value="<?php echo $value ?>"> <input name="reset" type="reset" value="Clear Form"></p> </td> </tr> </table> </td> </tr> </table><br /> </form> <?php echo $navigation2; ?> <? }//end function /************************************************************************* list all the DMA/Stations in the db *************************************************************************/ function list_users() { $y = 0; //counter $sql = "select * from coordinator order by KVCode;"; $result = conn($sql); include "smsinclude.php"; echo "<table width=\"700\" cellpadding=\"0\" cellspacing=\"0\"> <tr><td colspan=\"2\" style=\"font-size:18px; font-weight:bold;\">Manage Coordinator Log</td></tr> <tr> <td valign=\"top\"><br><a href='".$_SERVER['PHP_SELF']."?action=add'>Add a new Coordinator</a></td> <td valign=\"top\"><br>$navigation</td> </tr> </table> <table width=\"1060\" cellpadding=\"5\" cellspacing=\"0\"> <tr> <td width=\"80\"><b><u>KV Code</u></b></td> <td width=\"150\"><b><u>Full Name</u></b></td> <td width=\"150\"><b><u>Phone Number</u></b></td> <td width=\"150\"><b><u>Email</u></b></td> <td width=\"150\"><b><u>Access Level</u></b></td> <td width=\"150\"><b><u>Commission Percentage</u></b></td> <td width=\"150\"><b><u>Reports To</u></b></td> <td width=\"80\"><b><u>Delete</u></b></td></tr>"; if (mysql_num_rows($result)){ //show a list of kids with name as a link to the prepopulated form with their data in it while($rows = mysql_fetch_array($result)){ //change row background color (($y % 2) == 0) ? $bgcolor = "#F8F7F2" : $bgcolor=" #FFFFFF"; //build strings to make life easier $KVCode = $rows['KVCode']; $FullName = $rows['FullName']; $PhoneNumber = $rows['PhoneNumber']; $Email = $rows['Email']; $AccessLevel = $rows['AccessLevel']; $Commission = $rows['Commission']; $ReportsTo = $rows['ReportsTo']; $id = $rows['id']; $field_data = "coordinator"; //convert status to readable string from 1 or 0 ($status == 0) ? $status = "Available to contact" : $status = "Do not contact at present."; //echo out the row echo "<tr style='background-color:$bgcolor;'> <td valign=\"top\" width=\"80\" height=\"30\" valign=\"middle\"><a href='".$_SERVER['PHP_SELF']."?id=$id'>$KVCode</a></td> <td valign=\"top\" height=\"30\" valign=\"middle\">$FullName</td> <td valign=\"top\" height=\"30\" valign=\"middle\">$PhoneNumber</td> <td valign=\"top\" height=\"30\" valign=\"middle\">$Email</td> <td valign=\"top\" height=\"30\" valign=\"middle\">$AccessLevel</td> <td valign=\"top\" height=\"30\" valign=\"middle\">$Commission</td> <td valign=\"top\" height=\"30\" valign=\"middle\">$ReportsTo</td> <td width=\"80\" valign=\"top\" height=\"30\" valign=\"middle\"><a href='delete_record.php?id=$id&field_data=$field_data'>Delete</a></td><tr>"; $y++; //increment the counter }//end while echo "</table><br>$navigation2 <br><br>If you wish to print this page you must use Landscape Printing for best results"; }else{ //handle no results echo "<tr><td colspan='9' align='center'><b>No data found.</b></td></tr>"; }//endif } /************************************************************************* add / update the contact's data *************************************************************************/ function process_form() { $KVCode = ''; $FullName = ''; $PhoneNumber = ''; $Email = ''; $AccessLevel = ''; $Commission = ''; $ReportsTo = ''; $id = ''; $action = ''; $status = 0; //default value $KVCode = @$_POST['KVCode']; $FullName = @$_POST['FullName']; $PhoneNumber = @$_POST['PhoneNumber']; $Email = @$_POST['Email']; $AccessLevel = @$_POST['AccessLevel']; $Commission = @$_POST['Commission']; $ReportsTo = @$_POST['ReportsTo']; $id = @$_POST['id']; $action = @$_GET['action']; $status = @$_POST['status']; //if no status is set, defaults to 0 (allow contact) if ($status == ''){$status = 0; } if (($KVCode=='')||($FullName=='')||($PhoneNumber=='')||($Email=='')||($AccessLevel==''))||($Commission=='')||($ReportsTo=='')) { $msg = "Some data from the form was forgotten. Please fill in the entire form."; confirm($msg); $data = "$KVCode|$FullName|$PhoneNumber|$Email|$AccessLevel|$Commission|$ReportsTo|$id"; show_form('',$data); die(); }//end if //You could add some validation of the data ( I recommend it and its a great way to get your feet wet with php ) if ($action == "add") { $sql = "insert into coordinator (KVCode, FullName, PhoneNumber, Email, AccessLevel, Commission, ReportsTo) values('{$KVCode}','{$FullName}','{$PhoneNumber}','{$Email}','{$AccessLevel}','{$Commission}','{$ReportsTo}');"; $msg = "Record successfully added"; }elseif($action=="edit"){ $sql = "update coordinator set KVCode = '{$KVCode}', FullName = '{$FullName}', PhoneNumber = '{$PhoneNumber}', Email = '{$Email}', AccessLevel = '{$AccessLevel}', Commission = '{$Commission}', ReportsTo = '{$ReportsTo}' where id = {$id};"; $msg = "Record successfully updated"; } $result = conn($sql); if (mysql_errno()==0) { confirm($msg); list_users(); }else{ $msg = "There was a problem adding the user to the database. Error is:".mysql_error(); confirm($mag); }//end if } /************************************************************************* db connection function *************************************************************************/ function conn($sql) { $host = "localhost"; $user = "root"; $pass = "root"; $db = "dreamteam_db"; //echo "commnecing connection to local db<br>"; if (!($conn=mysql_connect($host, $user, $pass))) { printf("error connecting to DB by user = $user and pwd=$pass"); exit; } $db3=mysql_select_db($db,$conn) or die("Unable to connect to local database"); $result = mysql_query($sql) or die ("Can't run query because ". mysql_error()); return $result; }//end function /************************************************************************* alert box popup confimation message function *************************************************************************/ function confirm($msg) { echo "<script langauge=\"javascript\">alert(\"".$msg."\");</script>"; }//end function ?>

Thanks for the replies, unfortunately the first one is not what I am wanting to do jkewlo you tried exactly what I did but that does not work from what i found. HOWEVER, this did work: <?php if ($password == "ccrab1"){ $name = "Randy Bennett"; $phone = "not available"; $kvcc = "Your name is $name and your phone number is: $phone This is all pertinent information for all that correctly logged in, no one else should be able to see it"; echo $kvcc; } elseif ($password == "ccrab2"){ $name = "Richard Burnett"; $phone= "not available"; $kvcc = "Your name is $name and your phone number is: $phone This is all pertinent information for all that correctly logged in, no one else should be able to see it"; echo $kvcc; } ?> The only thing i do NOT like about this is it's very redundant to have to repost the variable $kvcc numerous times....surely there is a way to get it to work logically like this. I did solve my problem but I am still not happy with having to waste more resources than are necessary...if anyone has an idea I would be much appreciative.

Basically I am having difficulties structuring my code. I want to echo out a variable only if it meets the criteria (a password) if it does not then the average user would never know that it existed. I tried rearranging the code a few times but I am back to square one. End result i get : Your name is and your phone number is: the variables are not assigned because its being called before the variables are set... i understand this, if i put it after the if code then everyone can see it, i just want password people to see it. Any ideas? Thanks so much. <?php $kvcc = "Your name is $name and your phone number is: $phone This is all pertinent information for all that correctly logged in, no one else should be able to see it"; ?> <?php if ($password == "xxx1"){ $name = "Rick Baggot"; $phone = "not available"; echo $kvcc; } elseif ($password == "xxx2"){ $name = "Richard Burnett"; $phone= "not available"; echo $kvcc; } ?>

Thanks Blade but can you put Javascript like that with in a php IF statement if ($somevariable == "showpopup") { window.open("http://google.com","myWindow","status = 1, height = 300, width = 300, resizable = ") } which im assuming it would look more like this because the above would not execute anything that i know of. Put it in a .js file and then if ($somevariable == "showpopup") { <script type=javascript file=popup.js> } Ill check this out, if you think i misintepreted you let me know so it can save me time from trial and error ( i do know that I was just winging the html script above so i know i will correct in final version. Thanks

Let me see if i can put this another way that may be more efficient but still need help on how to accomplish it. Say if I do give into just the one redirect using the header location to http://www.thegreatestsave.org/wtvr-tgs .... which works just fine but instead i use the header location link to use a query string such as http://www.thegreatestsave.org/wtvr-tgs/index.php?somevariable=showpopup this would let me keep the integrity of the initial http://www.thegreatestsave.org/wtvr-tgs for those who dont use this dropdown so they would not see a pop up. Here is where I get lost now. Now i have this page http://www.thegreatestsave.org/wtvr-tgs/index.php "INDEX.php" that I need to alter the code so I can have a pop when somevariable=showpopup. index.php <?php if ($somevariable == "showpopup") { ******* this is where i need a pop up (when i say pop up; new window on top of index.php so if they are to close the page they are still looking at index.php) **** } else..... ?> Honestly after thinking about this, this is the way i need to go, but how do i accomplish the if statement to execute Thanks

I have surfed around php.net and really did not find my answer which makes me think that I may be using the wrong method about how i should do this. Basically I have a drop down and when you hit submit it reads the variables to decide where its going to go. In this code if I were to select state: VA and city Richmond-Petersburg I have it redirecting to the URL http://www.thegreatestsave.org/wtvr-tgs. That works FINE. But what I want to do is for it to open two links instead of one so it opens the above link as well as Yahoo! header('Location: http://www.thegreatestsave.org/wtvr-tgs'); header('Location: http://www.yahoo.com'); Of course I already know putting two header locations will basically just cancel the first one out and execute the second. This is where I am lost. How do i process this? Another idea i had was inserting meta redirect instead of header location but like header you cant put 2 of them back to back or one will just get canceled out by the other. ob_start(); $state = $_GET['state']; $city = $_GET['city']; /* WTVR Richmond, VA */ if ($state == "VA" && $city =="Richmond-Petersburg"){ header('Location: http://www.thegreatestsave.org/wtvr-tgs'); } /* KBCI Boise, ID */ elseif ($state == "ID" && $city =="Boise"){ header('Location: http://www.thegreatestsave.org/kbci-tgs'); } etc...... * a small note after browsing forums to make sure this has not been answered... the url that its going to can not have code to pop up the window i want. So http://www.thegreatestsave.org/wtvr-tgs can not have a pop up that shows YAHOO because this drop down is only intended for select users to see this special pop up where the general public should only see http://www.thegreatestsave.org/wtvr-tgs unless they were to use the drop down method to get to the page. Thanks

You were exactly right Jabop on that the second variable $sql ran that sql statement only and not both of them conjuctively... How do i make them two seperate inserts upon submit. Here's a little more of the code shwonig you i do have error catching just not sure how to make 2 sql statements run at same time since they are both $sql if ($action == "add") { $sql = "insert into event_master (station_id, eventdate, eventname, eventcity, participated, notes) values('{$station_id}','{$eventdate}','{$eventname}','{$eventcity}','{$participated}','{$notes}');"; $sql = "insert into dateonupdate (dayonupdate) values('{$dayonupdate}');"; $msg = "Record successfully added"; }elseif($action=="edit"){ $sql = "update event_master set station_id = '{$station_id}', eventdate = '{$eventdate}', eventname = '{$eventname}', eventcity = '{$eventcity}', participated = '{$participated}', notes = '{$notes}' where id = {$id};"; $sql = "insert into dateonupdate (dayonupdate) values('{$dayonupdate}');"; $msg = "Record successfully updated"; } $result = conn($sql); if (mysql_errno()==0) { confirm($msg); list_users(); }else{ $msg = "There was a problem adding the user to the database. Error is:".mysql_error(); confirm($mag); }//end if }

would it be like this? if ($action == "add") { $sql = "insert into event_master (station_id, eventdate, eventname, eventcity, participated, notes) values('{$station_id}','{$eventdate}','{$eventname}','{$eventcity}','{$participated}','{$notes}');"; $sql = "insert into dateonupdate (dayonupdated) values('{$dayonupdated}');"; $msg = "Record successfully added"; }elseif($action=="edit"){ $sql = "update event_master set station_id = '{$station_id}', eventdate = '{$eventdate}', eventname = '{$eventname}', eventcity = '{$eventcity}', participated = '{$participated}', notes = '{$notes}' where id = {$id};"; $sql = "insert into dateonupdate (dayonupdated) values('{$dayonupdated}');"; $msg = "Record successfully updated"; } or will 2 $sql back to back screw it up?

Basically I have a form that updates and inserts new records that works perfectly fine but I need to show a updated timestamp/date of when the last update or insert was done. (Code below shows insert and update). Below my code i will show you what i thought was a correct way to go but need insight to find out how to do it. Original snippet of code of insert/update: if ($action == "add") { $sql = "insert into event_master (station_id, eventdate, eventname, eventcity, participated, notes) values('{$station_id}','{$eventdate}','{$eventname}','{$eventcity}','{$participated}','{$notes}');"; $msg = "Record successfully added"; }elseif($action=="edit"){ $sql = "update event_master set station_id = '{$station_id}', eventdate = '{$eventdate}', eventname = '{$eventname}', eventcity = '{$eventcity}', participated = '{$participated}', notes = '{$notes}' where id = {$id};"; $msg = "Record successfully updated"; } How i thought it would be done: basically just tryign to do a dual sql insert to show date/timestamp of update. form would have a hiddent date field that would allow it to do this. if ($action == "add") { $sql = "insert into event_master (station_id, eventdate, eventname, eventcity, participated, notes) values('{$station_id}','{$eventdate}','{$eventname}','{$eventcity}','{$participated}','{$notes}');" "insert into dateonupdate (dayonupdated) values ('{$dayonupdate}');" ; $msg = "Record successfully added"; }elseif($action=="edit"){ $sql = "update event_master set station_id = '{$station_id}', eventdate = '{$eventdate}', eventname = '{$eventname}', eventcity = '{$eventcity}', participated = '{$participated}', notes = '{$notes}' where id = {$id};" insert into dateonupdate (dayonupdated) values ('{$dayonupdate}');" ; $msg = "Record successfully updated"; } Any help would be great. Just a dual sql insert to two different tables in the database but unsure how to write the sql or how to structure it! Thanks in advance.

Thank You Dark!

bump*