twilitegxa Posted August 31, 2009 Share Posted August 31, 2009 I am having some trouble still. My updating statement seems to work, but it will only update a specific record. It will not update the record of the character I am trying to update it for. How can I choose the identity of the character that is displayed on the page? Here is my update statement: <?php session_start(); //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()); $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]'"); ?> And here is the page displaying the character's profile: <?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> <td class=align_levels>$attribute_level</td> <td class=align_levels>$attributes_points</td> </tr>"; } } 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 display page: $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> It will only update the record of a specific character, but not the one being displayed. What could be causing this? Quote Link to comment Share on other sites More sharing options...
Philip Posted August 31, 2009 Share Posted August 31, 2009 That's a lot of code to even bother to read.... $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]'"); Change it to this, and see what that outputs $query = "UPDATE scouts SET username='".$_SESSION['userName']."', available=0 WHERE identity = '".$identity."'"; echo $query; // check to make sure it's what you want the query to be $result = mysql_query($query); Also, why do you bother with this if you still used $_SES.... in the query?: $identity = $_SESSION['identity']; Quote Link to comment Share on other sites More sharing options...
twilitegxa Posted August 31, 2009 Author Share Posted August 31, 2009 I added all my code in case I was doing anythign wrong LOL And I forgot that I was still using the $_SESSION[identity] LOL But, it still isn't working. The values are being updated, but still only that that one specific record, not the one that was displayed: UPDATE scouts SET username='kainan', available=0 WHERE identity = 'Sailor Trinity' I was accessing Sailor Jupiter, but it always updates Sailor Trinity for some reason. Quote Link to comment Share on other sites More sharing options...
twilitegxa Posted August 31, 2009 Author Share Posted August 31, 2009 It appears to be only updating the last record inserted. Quote Link to comment Share on other sites More sharing options...
Philip Posted August 31, 2009 Share Posted August 31, 2009 Well, then your $_SESSION['identity'] is giving you the incorrect values. Check where that session value gets its data Quote Link to comment Share on other sites More sharing options...
twilitegxa Posted August 31, 2009 Author Share Posted August 31, 2009 How do I do that? When I display the identity on the profile page, I get it here: //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']); It displays right when I choose an identity from the page that displays all identities, but to get the identity on this page I am using select identity from scouts where id = $_GET[id]"; Do I need to use $_GET[id]? Quote Link to comment Share on other sites More sharing options...
darkfreaks Posted August 31, 2009 Share Posted August 31, 2009 <?php $verify_topic = "select identity from scouts where id = '".$_GET['id']."'";?> Quote Link to comment Share on other sites More sharing options...
twilitegxa Posted August 31, 2009 Author Share Posted August 31, 2009 I don't understand what you mean, darkfreaks. That $verify_topics statement is displaying the right information from the scouts table on the display page. The problem I'm having is when I try to update the two fields in the record from the scouts table, the identity is always the last record inserted into the table. I want to update the record of the identity of the page I am viewing when I click the button that takes the user to the update page. But for some reason the identity is showing as the last record inserted instead of the identity of the page that was being viewed right before pressing the button to update the record. Quote Link to comment Share on other sites More sharing options...
twilitegxa Posted August 31, 2009 Author Share Posted August 31, 2009 How can I put this update statement on the profile page so that when they click the Yes button, it updates and prints a message saying they have accepted the character? If I put the update statement on the page, it seems to shwo the right identity. I tried to do it like this: <h3>Would you like to use this character?</h3> <a href="<?php $query = "UPDATE scouts SET username='".$_SESSION['userName']."', available=0 WHERE identity = '".$identity."'"; echo $query; // check to make sure it's what you want the query to be $result = mysql_query($query); ?>"><input type="button" value="Yes" /></a> <a href="existing.php"><input type="button" value="No" /></a> But of course it didn't work because the php statement is not a url to link to. But it did display the right information: The requested URL /UPDATE scouts SET username='twilitegxa', available=0 WHERE identity = 'Sailor Jupiter' was not found on this server. Would I do this with an if statement? Like if yes is click, update. If no is clicked, go to exisiting.php? How can i write this statement? Quote Link to comment Share on other sites More sharing options...
Batosi Posted August 31, 2009 Share Posted August 31, 2009 Im not sure I am following what you are doing here but hit me up in mail with a bit more detail into what you are trying to accomplish, rpgs are what I learned to program on I should be able to help you out here. Quote Link to comment Share on other sites More sharing options...
twilitegxa Posted August 31, 2009 Author Share Posted August 31, 2009 I changed this on my display page: //verify the scout exists $verify_scout = "select identity from scouts where id = $_GET[id]"; $verify_scout_res = mysql_query($verify_scout, $conn) or die(mysql_error()); if (mysql_num_rows($verify_scout_res) < 1) { //this character does not exist $display_block = "<p><em>You have selected an invalid character. Please <a href=\"existing.php\">try again</a></em></p>"; } else { //gather rest of profile fields $get_scout = "select * from scouts where id = $_GET[id]"; $get_scout_res = mysql_query($get_scout, $conn) or die(mysql_error()); while ($scout_info = mysql_fetch_array($get_scout_res)) { $scout_id = $scout_info['id']; $identity = ucwords($scout_info['identity']); $display_block .= "<table width=100%> <tr> <td align=center> <h3>Would you like to use this character?</h3> <a href=accept_character.php?id=$scout_id><input type=button value=Yes /></a> <a href=existing.php><input type=button value=No /></a> </td> </tr> </table>"; } } and on the update page: <?php session_start(); //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()); //verify the scout exists $verify_scout = "select identity from scouts where id = $_GET[id]"; $verify_scout_res = mysql_query($verify_scout, $conn) or die(mysql_error()); if (mysql_num_rows($verify_scout_res) < 1) { //this character does not exist $display_block = "<p><em>You have selected an invalid character. Please <a href=\"existing.php\">try again</a></em></p>"; } else { //gather rest of profile fields $get_scout = "select * from scouts where id = $_GET[id]"; $get_scout_res = mysql_query($get_scout, $conn) or die(mysql_error()); while ($scout_info = mysql_fetch_array($get_scout_res)) { $scout_id = $scout_info['id']; $identity = ucwords($scout_info['identity']); $accept_scout_username = mysql_query("UPDATE scouts SET username='$_SESSION[userName]' WHERE id = '$scout_id'"); $accept_scout_available = mysql_query("UPDATE scouts SET available='0' WHERE id = '$scout_id'"); } } ?> <html> <head> <title>You Have Accepted Character: <?php print $identity; ?></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; ?>: Accepted</h1> <h3>You have accepted the existing character, <strong><?php print $identity; ?></strong>.</h3> </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> Thanks for your help! What you e-mailed me helped! 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.