twilitegxa Posted August 31, 2009 Share Posted August 31, 2009 Can someone help me with how I can update two fields (available and username) in my table (scouts) when a user presses a button? I have the button set to go to this page when the press it: accept_character.php which will have the update code on it. I think I need to start like this: <?php $accept_scout = mysql_query("UPDATE scouts SET usename = '$_SESSION[userName]' AND available = '0' WHERE identity = '$identity'"; ?> I want the username to be changed to the username that is logged in, which should be $_SESSION[userName]. I also want to change available to 0. I need it to change the record based on the identity of the profile they are viewing, which should be $identity. Is the above statement right? Quote Link to comment Share on other sites More sharing options...
twilitegxa Posted August 31, 2009 Author Share Posted August 31, 2009 Here is the code for the page that has the button: <?php session_start(); //Access Tracking Snippet //set up static variables $page_title = "showprofile.php"; $user_agent = getenv("HTTP_USER_AGENT"); $date_accessed = date("Y-m-d"); //connect to server and select database $conn = mysql_connect("localhost", "root", "") or die(mysql_error()); $db = mysql_select_db("smrpg", $conn) or die(mysql_error()); //create and issue query $sql = "insert into access_tracker values ('', '$page_title', '$user_agent', '$date_accessed')"; mysql_query($sql,$conn); ?> <?php //check for required info from the query string if (!$_GET['id']) { header("Location: listcharacters.php"); exit; } //connect to server and select database $conn = mysql_connect("localhost", "root", "") or die(mysql_error()); mysql_select_db("smrpg", $conn) or die(mysql_error()); //verify the topic exists $verify_topic = "select identity from scouts where id = $_GET[id]"; $verify_topic_res = mysql_query($verify_topic, $conn) or die(mysql_error()); if (mysql_num_rows($verify_topic_res) < 1) { //this character does not exist $display_block = "<p><em>You have selected an invalid character. Please <a href=\"listcharacters.php\">try again</a></em></p>"; } else { //gather rest of profile $get_posts = "select *, date_format(create_time, '%b %e %Y at %r') as fmt_scout_create_time from scouts where id = $_GET[id]"; $get_posts_res = mysql_query($get_posts, $conn) or die(mysql_error()); //create the display string $display_block = " <table cellpadding=3 cellspacing=1 border=0 class=list_tables>"; while ($posts_info = mysql_fetch_array($get_posts_res)) { $post_id = $posts_info['id']; $identity = ucwords($posts_info['identity']); $character_create_time = $posts_info['fmt_scout_create_time']; $username = $posts_info['username']; $name = ucwords(strtolower($posts_info['name'])); $element_of_influence = $posts_info['element_of_influence']; $age = $posts_info['age']; $birth_month = $posts_info['birth_month']; $birth_date = $posts_info['birth_date']; $birth_year = $posts_info['birth_year']; $height_feet = $posts_info['height_feet']; $height_inches = $posts_info['height_inches']; $blood_type = strtoupper($posts_info['blood_type']); $hobbies = ucwords(strtolower($posts_info['hobbies'])); $favorite_color = ucwords(strtolower($posts_info['favorite_color'])); $favorite_gemstone = ucwords(strtolower($posts_info['favorite_gemstone'])); $favorite_food = ucwords(strtolower($posts_info['favorite_food'])); $least_favorite_food = ucwords(strtolower($posts_info['least_favorite_food'])); $favorite_school_subject = ucwords(strtolower($posts_info['favorite_school_subject'])); $least_favorite_school_subject = ucwords(strtolower($posts_info['least_favorite_school_subject'])); $strengths = ucwords(strtolower($posts_info['strengths'])); $weaknesses = ucwords(strtolower($posts_info['weaknesses'])); $goal = ucfirst($posts_info['goal']); $mission = ucfirst($posts_info['mission']); $biography = nl2br($posts_info['biography']); $biography = str_replace("\n", "<p>", $biography ); $getMonth = date('F', mktime(0, 0, 0, $birth_month)); $character_attack_level = $posts_info['attack_level']; $get_images = "select * from upload where identity = '$identity'"; $get_images_res = mysql_query($get_images, $conn) or die(mysql_error()); while ($images_info = mysql_fetch_array($get_images_res)) { $image_id = $images_info['id']; $image_identity = $images_info['identity']; $image_name = $images_info['name']; $image_type = $images_info['type']; $image_size = $images_info['size']; $image_content = $images_info['content']; //add to display $display_block .= " <tr> <td width=24% valign=top><strong>Character Name:</strong></td> <td width=55% valign=top>$name</td> <td align=center valign=top rowspan=18><img src='download.php?id=$image_id'></td> </tr> <tr> <td><strong>Element Of Influence:</strong></td> <td>$element_of_influence</td> </tr> <tr> <td><strong>Age:</strong></td> <td>$age</td> </tr> <tr> <td><strong>Date Of Birth:</strong></td> <td>$getMonth $birth_date, $birth_year</td> </tr> <tr> <td><strong>Height:</strong></td> <td>$height_feet feet $height_inches inches</td> </tr> <tr> <td><strong>Blood Type:</strong></td> <td>$blood_type</td> </tr> <tr> <td><strong>Hobbies:</strong></td> <td>$hobbies</td> </tr><tr> <td><strong>Favorite Color:</strong></td> <td>$favorite_color</td> </tr> <tr> <td><strong>Favorite Gemstone:</strong></td> <td>$favorite_gemstone</td> </tr> <tr> <td><strong>Favorite Food:</strong></td> <td>$favorite_food</td> </tr> <tr> <td><strong>Least Favorite Food:</strong></td> <td>$least_favorite_food</td> </tr> <tr> <td><strong>Favorite School Subject:</strong></td> <td>$favorite_school_subject</td> </tr> <tr> <td><strong>Least Favorite School Subject:</strong></td> <td>$least_favorite_school_subject</td> </tr> <tr> <td><strong>Strengths:</strong></td> <td>$strengths</td> </tr> <tr> <td><strong>Weaknesses:</strong></td> <td>$weaknesses</td> </tr> <tr> <td><strong>Goal:</strong></td> <td>$goal...</td> </tr> <tr> <td><strong>Mission:</strong></td> <td>$mission.</td> </tr> <td> </td> <td> </td> </tr> <tr> <td align=right colspan=3>Created By: <strong>$username</strong><br> Created On: <em>$character_create_time</em></td> </tr>"; } //close up the table $display_block .= "</table><br> <p>$biography</p><br>"; } } //gather stats and derived values; fix where statement $get_stats = "select * from stats where identity = '$identity'"; $get_stats_res = mysql_query($get_stats, $conn) or die(mysql_error()); $display_block .= " <table cellpadding=3 cellspacing=3 border=0 width=100%>"; while ($stats_info = mysql_fetch_array($get_stats_res)) { $body = $stats_info['body']; $mind = $stats_info['mind']; $soul = $stats_info['soul']; $display_block .= " <tr> <td valign=top> <table cellspacing=3 cellpadding=3 border=0 width=90% align=center class=list_tables> <th colspan=3>Stats And Derived Values</th> <tr> <td>Body</td> <td class=align_levels>$body</td> <td> </td> </tr> <tr> <td>Mind</td> <td class=align_levels>$mind</td> <td> </td> </tr> <tr> <td>Soul</td> <td class=align_levels>$soul</td> <td> </td> </tr>"; } //gather derived values $get_derived = "select * from derived_values where identity = '$identity'"; $get_derived_res = mysql_query($get_derived, $conn) or die(mysql_error()); while ($derived_info = mysql_fetch_array($get_derived_res)) { $health = $derived_info['health']; $energy = $derived_info['energy']; $acv1 = $derived_info['acv1']; $acv2 = $derived_info['acv2'] . ' (for Sailor Scout Attack)'; $dcv1 = $derived_info['dcv1']; $dcv2 = $derived_info['dcv2'] . ' (for Sailor Scout Attack)'; $total_cp = $derived_info['total_cp']; if($health == 0 || $health == '0' || $health == null){$GLOBALS['health'] = "";} if($energy == 0 || $energy== '0' || $energy == null){$GLOBALS['energy'] = "";} if($acv1 == 0 || $acv1 == '0' || $acv1 == null){$GLOBALS['acv1'] = "";} if($acv2 == 0 || $acv2 == '0' || $acv2 == null){$GLOBALS['acv2'] = "";} if($dcv1 == 0 || $dcv1 == '0' || $dcv1 == null){$GLOBALS['dcv1'] = "";} if($dcv2 == 0 || $dcv2 == '0' || $dcv2 == null){$GLOBALS['dcv2'] = "";} if($total_cp == 0 || $total_cp == '0' || $total_cp== null){$GLOBALS['total_cp'] = "";} $display_block .= " <tr> <td colspan=3> </td> </tr> <tr> <td>Health Points</td> <td class=align_levels>$health</td> <td> </td> </tr> <tr> <td>Energy Points</td> <td class=align_levels>$energy</td> <td> </td> </tr> <tr> <td>Attack Combat Value</td> <td class=align_levels>$acv1</td> <td>$acv2</td> </tr> <tr> <td>Defense Combat Value</td> <td class=align_levels>$dcv1</td> <td>$dcv2</td> </tr> <tr> <td>Total Character Points</td> <td class=align_levels>$total_cp</td> <td> </td> </tr> </table><br>"; } //gather defects $get_defects = "select * from scout_defects where identity = '$identity'"; $get_defects_res = mysql_query($get_defects, $conn) or die(mysql_error()); $display_block .= " <table cellpadding=3 cellspacing=3 border=0 width=90% align=center class=list_tables> <th colspan=3>Character Defects</th>"; while ($defects_info = mysql_fetch_array($get_defects_res)) { $defects_id = $defects_info['id']; $defects_identity = $defects_info['identity']; $defects_id = $defects_info['defect_id']; $desc = $defects_info['desc']; $defects_level = $defects_info['level']; if($defects_info['desc'] != ""){ $desc = "(" . $defects_info['desc'] . ")"; }else{ $desc = ""; } $get_defects_names = "select * from defects where id = '$defects_id'"; $get_defects_names_res = mysql_query($get_defects_names, $conn) or die(mysql_error()); while ($defects_names_info = mysql_fetch_array($get_defects_names_res)) { $defects_names_id = $defects_names_info['id']; $defect = $defects_names_info['defect']; $display_block .= " <tr> <td>$defect $desc</td> <td>$defects_level</td> <td> </td> </tr>"; } } $display_block .= " </table></td>"; // gather attributes and sub-attributes $get_attributes = "select * from scout_attributes where identity = '$identity'"; $get_attributes_res = mysql_query($get_attributes, $conn) or die(mysql_error()); $display_block .= " <td valign=top> <table cellspacing=3 cellpadding=3 border=0 width=90% align=center class=list_tables> <th colspan=3>Character Attributes And Sub-Attributes</th> <tr> <td align=center><b>Attribute/Sub-Attribute</b></td> <td align=center><b>Level</td> <td align=center><b>Points</b></td> </tr>"; while ($attributes_info = mysql_fetch_array($get_attributes_res)) { $attributes_id = $attributes_info['id']; $attribute_identity = $attributes_info['identity']; $attribute_id = $attributes_info['attribute_id']; $attribute_level = $attributes_info['level_id']; $get_attribute_names = "SELECT * FROM attributes WHERE id = '$attribute_id'"; $get_attribute_names_res = mysql_query($get_attribute_names, $conn) or die(mysql_error()); while ($attribute_names_info = mysql_fetch_array($get_attribute_names_res)) { $attribute_names_id = $attribute_names_info['id']; $attribute_names_attribute = $attribute_names_info['attribute']; $attributes_names_points = $attribute_names_info['points']; $attributes_points = ($attributes_names_points * $attribute_level); $display_block .= " <tr> <td>$attribute_names_attribute</td> Quote Link to comment Share on other sites More sharing options...
twilitegxa Posted August 31, 2009 Author Share Posted August 31, 2009 Rest of the code: <td class=align_levels>$attribute_level</td> <td class=align_levels>$attributes_points</td> </tr>"; } } $get_sub_attributes = "select * from scout_sub_attributes where identity = '$identity'"; $get_sub_attributes_res = mysql_query($get_sub_attributes, $conn) or die(mysql_error()); while ($sub_attributes_info = mysql_fetch_array($get_sub_attributes_res)) { $sub_attributes_id = $sub_attributes_info['id']; $sub_attributes_identity = $sub_attributes_info['identity']; $sub_attributes_attribute_id = $sub_attributes_info['sub_attribute_id']; $sub_attributes_level_id = $sub_attributes_info['level_id']; $sub_attributes_notes = $sub_attributes_info['notes']; $get_sub_attribute_names = "select * from sub_attributes where id = '$sub_attributes_attribute_id'"; $get_sub_attribute_names_res = mysql_query($get_sub_attribute_names, $conn) or die(mysql_error()); while ($sub_attribute_names_info = mysql_fetch_array($get_sub_attribute_names_res)) { $sub_attribute_names_id = $sub_attribute_names_info['id']; $sub_attribute_names_attribute = $sub_attribute_names_info['sub_attribute']; $sub_attribute_names_points = $sub_attribute_names_info['points']; $sub_attributes_points = ($sub_attribute_names_points * $sub_attributes_level_id); $display_block .= " <tr> <td class=indent>$sub_attribute_names_attribute</td>"; if ($sub_attributes_level_id == null) { $display_block .= "<td> </td> <td> </td></tr>"; } else { $display_block .= " <td class=align_levels>$sub_attributes_level_id</td> <td class=align_levels>$sub_attributes_points</td></tr>"; } //gather attacks $get_items = "select * from items where identity = '$identity' and acquired = 1 order by level asc"; $get_items_res = mysql_query($get_items, $conn) or die(mysql_error()); while ($items_info = mysql_fetch_array($get_items_res)) { $item_id = $items_info['id']; $item_identity = $items_info['identity']; $items = $items_info['item']; $item_desc = $items_info['desc']; $item_level = $items_info['level']; $item_points = ($sub_attribute_names_points * $item_level); if ($sub_attribute_names_attribute == 'Item Of Power') { $display_block .= " <tr> <td class=indent2>- $items</td> <td class=align_levels>$item_level</td> <td class=align_levels>$item_points</td> </tr> <tr>"; } } } } //gather attacks $get_attacks = "select * from attacks where identity = '$identity' and level <= '$character_attack_level' and learned = 1 order by level desc"; $get_attacks_res = mysql_query($get_attacks, $conn) or die(mysql_error()); while ($attacks_info = mysql_fetch_array($get_attacks_res)) { $attack_id = $attacks_info['id']; $attack_identity = $attacks_info['identity']; $attack = $attacks_info['attack']; $primary = $attacks_info['primary_attack']; $secondary = $attacks_info['secondary_attack']; $attack_level = $attacks_info['level']; $attack_points = ($sub_attribute_names_points * $attack_level); $learned = $attacks_info['learned']; //checks for primary and secondary attacks if($secondary == 1) $attack_points = 2; elseif($primary == 0 && $secondary == 0) $attack_points = 1; if ($sub_attribute_names_attribute == 'Sailor Scout Attack') { $display_block .= " <tr> <td class=indent2>- $attack</td> <td class=align_levels>$attack_level</td> <td class=align_levels>$attack_points</td> </tr> <tr>"; } } //gather neutral attributes $get_neutral_attributes = "select * from scout_neutral_attributes where identity = '$identity'"; $get_neutral_attributes_res = mysql_query($get_neutral_attributes, $conn) or die(mysql_error()); while ($neutral_attributes_info = mysql_fetch_array($get_neutral_attributes_res)) { $neutral_attributes_id = $neutral_attributes_info['id']; $neutral_attributes_identity = $neutral_attributes_info['identity']; $neutral_attributes_attribute_id = $neutral_attributes_info['attribute_id']; $neutral_attributes_level_id = $neutral_attributes_info['level_id']; $get_neutral_attribute_names = "select * from neutral_attributes where id = '$neutral_attributes_attribute_id'"; $get_neutral_attribute_names_res = mysql_query($get_neutral_attribute_names, $conn) or die(mysql_error()); while ($neutral_attribute_names_info = mysql_fetch_array($get_neutral_attribute_names_res)) { $neutral_attribute_names_id = $neutral_attribute_names_info['id']; $neutral_attribute_names_attribute = $neutral_attribute_names_info['attribute']; $neutral_attribute_names_points = $neutral_attribute_names_info['points']; $neutral_attribute_points = ($neutral_attributes_level_id * $neutral_attribute_names_points); $display_block .= " <tr> <td>$neutral_attribute_names_attribute</td> <td class=align_levels>$neutral_attributes_level_id</td> <td class=align_levels>$neutral_attribute_points</td> </tr>"; } } $display_block .= " </table></td></tr></table><br>"; $display_block .= " <table border=0 width=100%> <tr> <td width=50% valign=top> <table> <tr> <td align=center><h1>Items Of Power</h1></td>"; $get_items = "select * from items where identity = '$identity' and acquired = 1"; $get_items_res = mysql_query($get_items, $conn) or die(mysql_error()); while ($items_info = mysql_fetch_array($get_items_res)) { $items_id = $items_info['id']; $items_identity = $items_info['identity']; $item = $items_info['item']; $item_desc = nl2br($items_info['desc']); $item_level = $items_info['level']; $item_points = ($sub_attribute_names_points * $item_level); $display_block .= " <tr> <td class=hanging-indent> <i>$item --- </i><br> $item_desc</td></tr>"; } $display_block .= "</table></td><td valign=top width=50%> <table> <tr> <td align=center><h1>Sailor Scout Attacks</td></tr>"; //gather attacks $get_attacks = "select * from attacks where identity = '$identity' and learned = 1 order by level asc"; $get_attacks_res = mysql_query($get_attacks, $conn) or die(mysql_error()); while ($attacks_info = mysql_fetch_array($get_attacks_res)) { $attack_id = $attacks_info['id']; $attack_identity = $attacks_info['identity']; $attack = $attacks_info['attack']; $attack_desc = nl2br($attacks_info['desc']); $primary = $attacks_info['primary_attack']; $secondary = $attacks_info['secondary_attack']; $attack_level = $attacks_info['level']; $attack_points = ($sub_attribute_names_points * $attack_level); $display_block .= " <tr> <td class=hanging-indent> <i>$attack --- </i><br> $attack_desc</td></tr>"; } $display_block .= "</table></td></tr></table>"; $display_block .= "<table border=0 cellpadding=3 cellspacing=3 width=100%> <tr> <td width=50% valign=top> <table> <tr> <td align=center><h1>Transformations</h1></td> </tr>"; $get_transformations = "select * from transformations where identity = '$identity'"; $get_transformations_res = mysql_query($get_transformations, $conn) or die(mysql_error()); while ($transformation_info = mysql_fetch_array($get_transformations_res)) { $transformation_id = $transformation_info['id']; $transformation_identity = $transformation_info['identity']; $transformation = $transformation_info['transformation']; $transformation_desc = $transformation_info['desc']; $transformation_level = $transformation_info['level']; $display_block .= " <tr> <td class=hanging-indent> <i>$transformation --- </i><br> $transformation_desc</td></tr>"; } $display_block .= "</table></td> <td width=50% valign=top> <table> <tr> <td align=center><h1>Attribute/Sub-Attribute Notes</h1></td></tr> <tr> <td> <ol>"; //gather attributes and sub-attributes notes $get_sub_notes = "select * from scout_sub_attributes where identity = '$identity' and notes IS NOT NULL"; $get_sub_notes_res = mysql_query($get_sub_notes, $conn) or die(mysql_error()); while ($sub_notes_info = mysql_fetch_array($get_sub_notes_res)) { $sub_notes = nl2br($sub_notes_info['notes']); $sub_id = $sub_notes_info['sub_attribute_id']; $display_block.= " <li>$sub_notes</li>"; } //gather neutral notes $get_neutral_notes = "select notes from scout_neutral_attributes where identity = '$identity' and notes IS NOT NULL"; $get_neutral_notes_res = mysql_query($get_neutral_notes, $conn) or die(mysql_error()); while ($neutral_notes_info = mysql_fetch_array($get_neutral_notes_res)) { $neutral_notes = nl2br($neutral_notes_info['notes']); $display_block .= " <li>$neutral_notes</li>"; } //gather defect notes $get_defect_notes = "select notes from scout_defects where identity = '$identity' and notes IS NOT NULL"; $get_defect_notes_res = mysql_query($get_defect_notes, $conn) or die(mysql_error()); while ($defect_notes_info = mysql_fetch_array($get_defect_notes_res)) { $defect_notes = nl2br($defect_notes_info['notes']); $display_block .= " <li>$defect_notes</li>"; } $display_block .= "</ol></table></td></tr></table>"; ?> <html> <head> <title><?php print $identity; ?>'s Profile</title> <style type="text/css" media="screen"> /*<![CDATA[*/ @import url(global.css); /*]]>*/ </style> </head> <body> <!-- HEADER --> <h1 class="logo">Sailor Moon RPG</h1> <!-- /HEADER --> <?php include("topnav.php"); ?> <div id="main"> <?php include("includes/log.php"); ?> <?php include("mainnav.php"); ?> <h1 align="center"><?php print $identity; ?></h1> <?php print $display_block; ?> <table width="100%"> <tr> <td align="center"> <h3>Would you like to use this character?</h3> <a href="accept_character.php"><input type="button" value="Yes" /></a> <a href="existing.php"><input type="button" value="No" /></a> </td> </tr> </table> </div> <?php include("bottomnav.php"); ?><!-- FOOTER --> <!-- FOOTER --> <div id="footer_wrapper"> <div id="footer"> <p>Sailor Moon and all characters are<br /> trademarks of Naoko Takeuchi.</p> <p>Copyright © 2009 Liz Kula. All rights reserved.<br /> A product of <a href="#" target="_blank">Web Designs By Liz</a> systems.</p> <div id="foot-nav"> <ul> <li><a href="http://validator.w3.org/check?uri=http://webdesignsbyliz.com/digital/index.php" target="_blank"><img src="http://www.w3.org/Icons/valid-xhtml10-blue" alt="Valid XHTML 1.0 Transitional" height="31" width="88" /></a></li> <li><a href="http://jigsaw.w3.org/css-validator/validator?uri=http://webdesignsbyliz.com/digital/global.css" target="_blank"><img class="c2" src="http://jigsaw.w3.org/css-validator/images/vcss-blue" alt="Valid CSS!" /></a></li> </ul> </div> </div> </div> <!-- /FOOTER --> </body> </html> Quote Link to comment Share on other sites More sharing options...
twilitegxa Posted August 31, 2009 Author Share Posted August 31, 2009 I set it as two separate statements, but it works. Thanks guys! $identity = $_SESSION['identity']; $accept_scout_username = mysql_query("UPDATE scouts SET username='$_SESSION[userName]' WHERE identity = '$_SESSION[identity]'"); $accept_scout_available = mysql_query("UPDATE scouts SET available='0' WHERE identity = '$_SESSION[identity]'"); Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.