dottore11

Ok, I've started to work on the script that the post before the previous one described. I don't want to totally redesign my script right now, plus I'm not quite understanding what I'd have to do to make that way work. Here's what I have: Getuser.php - Asks user for the user they wish to edit and submits it to the next page [code] <form action="finduser.php" method="post"> Username: <input type="text" name="find_usernamec"><br> <input type="submit"><br> [/code] Finduser.php - Uses data from getuser.php and displays customized data in checkboxes based on whether their values in the table are on or not. [code] <? include("dbinfo.inc.php"); mysql_connect(localhost,$username,$password); mysql_select_db($database) or die( "Unable to select database"); $find_usernamec=$_POST['find_usernamec']; $query="SELECT * FROM cardbase WHERE usernamec='$find_usernamec'"; $result="mysql_query($query)"; ?> <?php if($dark == "on"){ ?> <input type="checkbox" name="ud_dark" checked="checked"> <?php }else{ ?> <input type="checkbox" name="ud_dark"> <?php } ?> [/code] Please note I've only done the script for Dark so far. The script is displaying an unchecked checkbox in places where it should be displaying a checked one. I have echoed some variables and the username is getting passed to the finduser.php page. Help please?

[!--quoteo(post=373883:date=May 14 2006, 10:28 PM:name=ProjectFear)--][div class=\'quotetop\']QUOTE(ProjectFear @ May 14 2006, 10:28 PM) [snapback]373883[/snapback][/div][div class=\'quotemain\'][!--quotec--] first of all i would make it so they must enter the username and search for the user first. [/quote] Ok, so how would I do that? Sorry to be so pesky -_- PHP is definitely not my specialty X_X

Ok, so I am starting this new game on my website, and it will be called Card Quest or something similar to that. Basically, they need to complete different objectives to earn cards to add to their online "collections". What I need is a script that will allow me to: 1. Manage and add new users to the system, and later add cards they have earned 2. Allows a way to display the users and which cards they have collected and which ones they haven't. Here's the idea; I'm a visitor and I want to view which cards "Susie" has collected. So I click her name in the userlist and up pops a window that has highlighted which cards they have collected out of the total number of cards. Clicking the name of the card or rolling over it shows the picture of the card. ----------------------------------------------------- Right now I'm in the phase of the project where I am developing the admin panel that will let me add and edit the users/cards. I have completed the part that adds users and their respective cards to the database, but now I'm on the editing part. I've figured out a primitive update script that will work for me: here's what I have; Update.php [code] <? include("dbinfo.inc.php"); mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); ?> <form action="updated.php" method="post"> Username: <input type="text" name="ud_usernamec"><br> Air: <input type="checkbox" name="ud_air"><br> Dark: <input type="checkbox" name="ud_dark"><br> <input type="Submit" value="Update"> </form> [/code] Updated.php [code] <? include("dbinfo.inc.php"); mysql_connect(localhost,$username,$password); $query="UPDATE cardbase SET air='$ud_air', dark='$ud_dark' WHERE usernamec='$ud_usernamec'"; @mysql_select_db($database) or die( "Unable to select database"); mysql_query($query); echo "Record Updated"; mysql_close(); ?> [/code] My problem is that for example, if a user already has a card, I have to click the checkbox for that card anyways, or it will get submitted and turn the value for that row on that user to off. Does that make sense? I know now that it shouldn't be hard since there are only 2 cards, but once I get this going there are like 42 total. So, you can see me having to click the checkboxes over and over could get old. Is there anyways I can modify the update.php script or something else where if the checkbox is submitted without a value that it isn't put in as a 0?