ok this is getting me quite stuck and its real important i fix it. this is whats goin on...
i have a page called 'skills.php'
Code:<p>Modify the skills table</p> <form action="addskill.php" method="post"> Skill name: <input type="text" name="skillname"><br /> Skill description: <input type="textarea" rows="5" cols="20" name="description"><br /> <input type="Submit"> </form> <br /> <?php include("config.php"); mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $query="SELECT * FROM Skills"; $result=mysql_query($query) or die( "Unable to do query"); $num=mysql_num_rows($result); mysql_close(); if ($num==0) { echo "The database contains no skills"; } else { echo "<b><center>Skills table</center></b><br /><br /><table><form><tr><td>id</td><td>name</td><td>description</td><td>update</td><td>delete</td></tr>"; $i=0; while ($i < $num) { $skillid=mysql_result($result,$i,"skillid"); $skillname=mysql_result($result,$i,"skillname"); $description=mysql_result($result,$i,"description"); echo "<tr> <td>$skillid</td> <td><input type='text' input value='$skillname' name='formname'></td> <td><input type='textarea' rows='1' cols='100' input value='$description' name='formdescription'></td> <td><a href='updateskill.php'>U</a></td> <td><a href='killskill.php'>D</a></td> </tr>"; $i++; } echo "</form></table>"; } ?>
ok so basically its got the add thing at the top and the table below. im gonna use this in my admin section so i can add new skills.
however next to each record there is 'U' which means i can type something in that box and click U to update that record.
it does this [updateskill.php]:
Code:<?php include("config.php"); $_GET['skillid2']; $_GET['name']; $_GET['description']; mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $query="UPDATE Skills SET skillname='$name', description='$description' WHERE skillid=$skillid"; mysql_query($query); mysql_close();
Problem is this just won't work! when i click on the U it clears the record and thats it - doesnt add or update anything!!! Whats going on please help!!![]()




Reply With Quote