Another question for ya guys...

ctsttom

Can you tell me how to make the code bellow so it will record in the database and can ya also tell me how to delete/insert records into a database plz...

// Request the text of all the jokes
$result = @("SELECT * FROM members WHERE id = $id");

if (!$result) {
echo("<p>Error performing query: " . mysql_error() . "</p>");
exit();
}
// Display the text of each joke in a paragraph
while ( $row = mysql_fetch_array($result) ) {
echo("<form name=\"form1\" id=\"form1\" method=\"post\" action=\"\">");
echo(" <table width=\"100%\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\">");
echo(" <tr> ");
echo(" <td width=\"50%\" height=\"26\"> ");
echo("<div align=\"right\">Username:</div></td>");
echo(" <td><input name=\"username\" type=\"text\" id=\"username\" value=\"" . $row["username"] . "\" size=\"16\" maxlength=\"16\" />");
echo(" (max 16 char)</td>");
echo(" </tr>");
echo(" <tr> ");
echo(" <td width=\"50%\"> <div align=\"right\">Password:</div></td>");
echo(" <td><input name=\"password\" type=\"password\" id=\"password\" value=\"" . $row["password"] . "\" size=\"16\" maxlength=\"16\" />");
echo(" (max 16 char)</td>");
echo(" </tr>");
echo(" <tr> ");
echo(" <td width=\"50%\"> <div align=\"right\">DOB:</div></td>");
echo(" <td><input name=\"dob\" type=\"text\" id=\"dob\" value=\"" . $row["dob"] . "\" size=\"10\" maxlength=\"10\" />");
echo(" (dd/mm/yyyy)</td>");
echo(" </tr>");
echo(" <tr> ");
echo(" <td width=\"50%\"> <div align=\"right\">Email:</div></td>");
echo(" <td><input name=\"email\" type=\"text\" id=\"email\" value=\"" . $row["email"] . "\" size=\"20\" maxlength=\"20\" /></td>");
echo(" </tr>");
echo(" <tr> ");
echo(" <td width=\"50%\"> <div align=\"right\">Newsletter:</div></td>");
echo(" <td><input name=\"textfield\" type=\"text\" value=\"" . $row["newsletter"] . "\" size=\"3\" maxlength=\"3\" />");
echo(" (yes/no)</td>");
echo(" </tr>");
echo(" <tr> ");
echo(" <td width=\"50%\"> <div align=\"right\">AIM:</div></td>");
echo(" <td><input name=\"aim\" type=\"text\" id=\"aim\" value=\"" . $row["aim"] . "\" /></td>");
echo(" </tr>");
echo(" <tr> ");
echo(" <td width=\"50%\"> <div align=\"right\">ICQ:</div></td>");
echo(" <td><input name=\"icq\" type=\"text\" id=\"icq\" value=\"" . $row["icq"] . "\" /></td>");
echo(" </tr>");
echo(" <tr> ");
echo(" <td width=\"50%\"> <div align=\"right\">MSN:</div></td>");
echo(" <td><input name=\"msn\" type=\"text\" id=\"msn\" value=\"" . $row["msn"] . "\" /></td>");
echo(" </tr>");
echo(" <tr> ");
echo(" <td width=\"50%\"> <div align=\"right\">YIM:</div></td>");
echo(" <td><input name=\"yim\" type=\"text\" id=\"yim\" value=\"" . $row["yim"] . "\" /></td>");
echo(" </tr>");
echo(" <tr> ");
echo(" <td width=\"50%\"> <div align=\"right\">Permissions:</div></td>");
echo(" <td><select name=\"select\">");
echo(" <option selected=\"selected\">Select one</option>");
echo(" <option value=\"member\">Member</option>");
echo(" <option value=\"admin\">Admin</option>");
echo(" </select></td>");
echo(" </tr>");
echo(" </table>");
echo(" <div align=\"center\"><br>");
echo(" <input type=\"submit\" name=\"Submit\" value=\"Update\" />");
echo(" <input type=\"reset\" name=\"Submit2\" value=\"Reset\" />");
echo(" </div>");
echo("</form>");
}
?>
<p align="center"><a href="memberlist.php">Back</a> / <a href="delete.php?id=<?php echo($id) ?>">Delete</a></p>
</body>
</html>

ucbones

Tom,

Please when you have a question could you ask it!! Not quite sure what the problem is, and if you could try and post only the bits of your script which is causing a problem that would be cool, cheers,

ucbones

ctsttom

lol there ya go

batman

To insert:

$sql = mysql_query("INSERT INTO table (var1, var2, var3) VALUES ('$var1', '$var2', '$var3')");

Delete from DB

$sql = mysql_query("DELETE FROM table WHERE var='$var'");

Can you tell me how to make the code bellow so it will record in the database

Not sure what you wanted on this one.

-Blake

ctsttom

lol yeh i duno wot i went wrong in this post lol but can u show me how to edit records?

batman

$sql = mysql_query("UPDATE table SET var='$var'");

You can always go more in-depth on these querys if there not doing what you want them to.

-Blake

ctsttom

ok thx m8 ill see if they do wot i need, thx

ctsttom

ok so for my insert record it should be....

$sql = mysql_query("INSERT INTO members (username, password, dob, email, newsletter, aim, icq, msn, yim, permissions") VALUES ('$username1', '$password', '$dob', '$email', '$newsletter', '$aim', '$icq', '$msn', '$yim', '$permissions');

yeh? (assuming the vars are correct) but it dont work 🙁

batman

You forgot the ending ")
Should be:

$sql = mysql_query("INSERT INTO members (username, password, dob, email, newsletter, aim, icq, msn, yim, permissions") VALUES ('$username1', '$password', '$dob', '$email', '$newsletter', '$aim', '$icq', '$msn', '$yim', '$permissions')");

-Blake

ctsttom

thats gr8 still but its not working and i have got no idea on how to impliment the code, can i contact u via a im accout outside this place, it takes too long to get suming to work 🙁

batman

AIM sn: eradicatordfdk
MSN sn: blake_2050@hotmail.com

batman

I found another error. Use this:

$sql = mysql_query("INSERT INTO members (username, password, dob, email, newsletter, aim, icq, msn, yim, permissions) VALUES ('$username1', '$password', '$dob', '$email', '$newsletter', '$aim', '$icq', '$msn', '$yim', '$permissions')");

-Blake

ctsttom

thx, it worked

ctsttom

ok, im onto the edit bit now and its working but it updates all records, how do i make it only update the a specified record (my key id $id)

$sql = mysql_query("UPDATE members SET username='$username', password='$password'");

batman

use this:

$sql = mysql_query("UPDATE members SET username='$username', password='$password' WHERE id='$id'");

Whenever you want to do a query to a single field use the WHERE clause.

-Blake

ctsttom

its not working, theres no error message, its just not doing any thing... b4 it updated every single record and now its not updating at all...

heres the form code (edit.php)

<?php

// Request the text of all the jokes
$result = @("SELECT * FROM members WHERE id = $id");

if (!$result) {
echo("<p>Error performing query: " . mysql_error() . "</p>");
exit();
}
// Display the text of each joke in a paragraph
while ( $row = mysql_fetch_array($result) ) {
echo("<form name=\"form1\" id=\"form1\" method=\"post\" action=\"edituser.php\"> <table width=\"100%\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\"> <tr> <td width=\"50%\" height=\"26\"> <div align=\"right\">Username:</div></td> <td>");
echo("<input name=\"username\" type=\"text\" id=\"username\" size=\"16\" maxlength=\"16\" value=\"" . $row["username"] . "\"/>");
echo(" (max 16 char) ");
echo(" </td> </tr> <tr> <td width=\"50%\"> <div align=\"right\">Password:</div></td> <td>");
echo("<input name=\"password\" type=\"password\" id=\"password\" size=\"16\" maxlength=\"16\" value=\"" . $row["password"] . "\"/>");
echo(" (max 16 char) </td>");
echo(" </tr> <tr> <td width=\"50%\"> <div align=\"right\">DOB:</div></td> <td>");
echo("<input name=\"dob\" type=\"text\" id=\"dob\" size=\"10\" maxlength=\"10\" value=\"" . $row["dob"] . "\"/>");
echo(" (dd/mm/yyyy) ");
echo(" </td>");
echo(" </tr> <tr> <td width=\"50%\"> <div align=\"right\">Email:</div></td> <td>");
echo("<input name=\"email\" type=\"text\" id=\"email\" size=\"20\" maxlength=\"20\" value=\"" . $row["email"] . "\"/></td> </tr> <tr> <td width=\"50%\"> <div align=\"right\">Newsletter:</div></td> <td>");
echo("<input name=\"newsletter\" type=\"text\" size=\"3\" maxlength=\"3\" value=\"" . $row["newsletter"] . "\" />");
echo(" (yes/no) ");
echo(" </td>");
echo(" </tr> <tr> <td width=\"50%\"> <div align=\"right\">AIM:</div></td> <td>");
echo("<input name=\"aim\" type=\"text\" id=\"aim\" value=\"" . $row["aim"] . "\"/></td> </tr> <tr> <td width=\"50%\"> <div align=\"right\">ICQ:</div></td> <td>");
echo("<input name=\"icq\" type=\"text\" id=\"icq\" value=\"" . $row["icq"] . "\"/></td> </tr> <tr> <td width=\"50%\"> <div align=\"right\">MSN:</div></td> <td>");
echo("<input name=\"msn\" type=\"text\" id=\"msn\" value=\"" . $row["msn"] . "\"/></td> </tr> <tr> <td width=\"50%\"> <div align=\"right\">YIM:</div></td> <td>");
echo("<input name=\"yim\" type=\"text\" id=\"yim\" value=\"" . $row["yim"] . "\"/></td> </tr> <tr> <td width=\"50%\"> <div align=\"right\">Permissions:</div></td> ");
echo(" <td>" . $row["permissions"] . " <a href=\"permissions.php?id=" . $row["id"] . "\">Edit</a></td>");
echo(" </tr> </table>");
echo(" <p>");
echo(" <input type=\"submit\" name=\"Submit\" value=\"Update\" />");
echo(" <input type=\"reset\" name=\"Submit2\" value=\"Reset\" />");
echo(" </p>");
echo("</form>");
}
?>
<p align="center"><a href="memberlist.php">Back</a> / <a href="delete.php?id=">Delete</a></p>
</body>
</html>

heres the handler code (edituser.php)...

<html>
<head>
<title>Members List</title>
</head>
<body>
<?php
// Connect to the database server
$dbcnx = @mysql_connect("localhost", "dbaccess", "1234");
if (!$dbcnx) {
echo( "<p>Unable to connect to the " .
"database server at this time.</p>" );
exit();
}
// Select the jokes database
if (! @mysql_select_db("communitydb") ) {
echo( "<p>Unable to locate the joke " .
"database at this time.</p>" );
exit();
}
?>
<p>Edit User:
<?php
$sql = mysql_query("UPDATE members SET username='$username', password='$password' WHERE id='$id'");
?>
</p>
<p align="center"> <font color="#FF0000">Account Edited!</font></p>
<table width="100%" border="1" cellspacing="0" cellpadding="0">
<tr>
<td width="50%" height="26"> <div align="right">Username:</div></td>
<td><?php echo $username ?> </td>
</tr>
<tr>
<td width="50%"> <div align="right">Password:</div></td>
<td><?php echo $password ?> </td>
</tr>
<tr>
<td width="50%"> <div align="right">DOB:</div></td>
<td><?php echo $dob ?> </td>
</tr>
<tr>
<td width="50%"> <div align="right">Email:</div></td>
<td><?php echo $email ?> </td>
</tr>
<tr>
<td width="50%"> <div align="right">Newsletter:</div></td>
<td><?php echo $newsletter ?> </td>
</tr>
<tr>
<td width="50%" height="23"> <div align="right">AIM:</div></td>
<td><?php echo $aim ?> </td>
</tr>
<tr>
<td width="50%"> <div align="right">ICQ:</div></td>
<td><?php echo $icq ?> </td>
</tr>
<tr>
<td width="50%"> <div align="right">MSN:</div></td>
<td><?php echo $msn ?> </td>
</tr>
<tr>
<td width="50%"> <div align="right">YIM:</div></td>
<td><?php echo $yim ?> </td>
</tr>
<tr>
<td width="50%"> <div align="right">Permissions:</div></td>
<td><?php echo $permissions ?> </td>
</tr>
</table>
<div align="center"></div></p>
<p align="center"><a href="memberlist.php">Back</a></p>
</body>
</html>

wot do ya fink?

batman

Well that's because you have the WHERE id value set to $id. $id is not a set variable. You will have to do it like this:
edit.php

<html> 
<head> 
<title>Members List</title> 
</head> 
<body> 
<?php 
// Connect to the database server 
$dbcnx = @mysql_connect("localhost", "dbaccess", "1234"); 
if (!$dbcnx) { 
echo( "<p>Unable to connect to the " . 
"database server at this time.</p>" ); 
exit(); 
} 
// Select the jokes database 
if (! @mysql_select_db("communitydb") ) { 
echo( "<p>Unable to locate the joke " . 
"database at this time.</p>" ); 
exit(); 
} 
?> 
<p> Member Edit:</p> 

<?php 

// Request the text of all the jokes 
$result = @mysql_query("SELECT * FROM members WHERE id = $id"); 
if (!$result) { 
echo("<p>Error performing query: " . mysql_error() . "</p>"); 
exit(); 
} 
// Display the text of each joke in a paragraph 
while ( $row = mysql_fetch_array($result) ) { 
$id = $row['id'];
echo("<form name=\"form1\" id=\"form1\" method=\"post\" action=\"edituser.php?id=$id\"> <table width=\"100%\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\"> <tr> <td width=\"50%\" height=\"26\"> <div align=\"right\">Username:</div></td> <td>"); 
echo("<input name=\"username\" type=\"text\" id=\"username\" size=\"16\" maxlength=\"16\" value=\"" . $row["username"] . "\"/>"); 
echo(" (max 16 char) "); 
echo(" </td> </tr> <tr> <td width=\"50%\"> <div align=\"right\">Password:</div></td> <td>"); 
echo("<input name=\"password\" type=\"password\" id=\"password\" size=\"16\" maxlength=\"16\" value=\"" . $row["password"] . "\"/>"); 
echo(" (max 16 char) </td>"); 
echo(" </tr> <tr> <td width=\"50%\"> <div align=\"right\">DOB:</div></td> <td>"); 
echo("<input name=\"dob\" type=\"text\" id=\"dob\" size=\"10\" maxlength=\"10\" value=\"" . $row["dob"] . "\"/>"); 
echo(" (dd/mm/yyyy) "); 
echo(" </td>"); 
echo(" </tr> <tr> <td width=\"50%\"> <div align=\"right\">Email:</div></td> <td>"); 
echo("<input name=\"email\" type=\"text\" id=\"email\" size=\"20\" maxlength=\"20\" value=\"" . $row["email"] . "\"/></td> </tr> <tr> <td width=\"50%\"> <div align=\"right\">Newsletter:</div></td> <td>"); 
echo("<input name=\"newsletter\" type=\"text\" size=\"3\" maxlength=\"3\" value=\"" . $row["newsletter"] . "\" />"); 
echo(" (yes/no) "); 
echo(" </td>"); 
echo(" </tr> <tr> <td width=\"50%\"> <div align=\"right\">AIM:</div></td> <td>"); 
echo("<input name=\"aim\" type=\"text\" id=\"aim\" value=\"" . $row["aim"] . "\"/></td> </tr> <tr> <td width=\"50%\"> <div align=\"right\">ICQ:</div></td> <td>"); 
echo("<input name=\"icq\" type=\"text\" id=\"icq\" value=\"" . $row["icq"] . "\"/></td> </tr> <tr> <td width=\"50%\"> <div align=\"right\">MSN:</div></td> <td>"); 
echo("<input name=\"msn\" type=\"text\" id=\"msn\" value=\"" . $row["msn"] . "\"/></td> </tr> <tr> <td width=\"50%\"> <div align=\"right\">YIM:</div></td> <td>"); 
echo("<input name=\"yim\" type=\"text\" id=\"yim\" value=\"" . $row["yim"] . "\"/></td> </tr> <tr> <td width=\"50%\"> <div align=\"right\">Permissions:</div></td> "); 
echo(" <td>" . $row["permissions"] . " <a href=\"permissions.php?id=" . $row["id"] . "\">Edit</a></td>"); 
echo(" </tr> </table>"); 
echo(" <p>"); 
echo(" <input type=\"submit\" name=\"Submit\" value=\"Update\" />"); 
echo(" <input type=\"reset\" name=\"Submit2\" value=\"Reset\" />"); 
echo(" </p>"); 
echo("</form>"); 
} 
?> 
<p align="center"><a href="memberlist.php">Back</a> / <a href="delete.php?id=">Delete</a></p> 
</body> 
</html>

Then use this for the Edit page:

<html> 
<head> 
<title>Members List</title> 
</head> 
<body> 
<?php 
// Connect to the database server 
$dbcnx = @mysql_connect("localhost", "dbaccess", "1234"); 
if (!$dbcnx) { 
echo( "<p>Unable to connect to the " . 
"database server at this time.</p>" ); 
exit(); 
} 
// Select the jokes database 
if (! @mysql_select_db("communitydb") ) { 
echo( "<p>Unable to locate the joke " . 
"database at this time.</p>" ); 
exit(); 
} 
?> 
<p>Edit User: 
<?php 
$id = $_GET["id"];
$sql = mysql_query("UPDATE members SET username='$username', password='$password' WHERE id='$id'"); 
?> 
</p> 
<p align="center"> <font color="#FF0000">Account Edited!</font></p> 
<table width="100%" border="1" cellspacing="0" cellpadding="0"> 
<tr> 
<td width="50%" height="26"> <div align="right">Username:</div></td> 
<td><?php echo $username ?> </td> 
</tr> 
<tr> 
<td width="50%"> <div align="right">Password:</div></td> 
<td><?php echo $password ?> </td> 
</tr> 
<tr> 
<td width="50%"> <div align="right">DOB:</div></td> 
<td><?php echo $dob ?> </td> 
</tr> 
<tr> 
<td width="50%"> <div align="right">Email:</div></td> 
<td><?php echo $email ?> </td> 
</tr> 
<tr> 
<td width="50%"> <div align="right">Newsletter:</div></td> 
<td><?php echo $newsletter ?> </td> 
</tr> 
<tr> 
<td width="50%" height="23"> <div align="right">AIM:</div></td> 
<td><?php echo $aim ?> </td> 
</tr> 
<tr> 
<td width="50%"> <div align="right">ICQ:</div></td> 
<td><?php echo $icq ?> </td> 
</tr> 
<tr> 
<td width="50%"> <div align="right">MSN:</div></td> 
<td><?php echo $msn ?> </td> 
</tr> 
<tr> 
<td width="50%"> <div align="right">YIM:</div></td> 
<td><?php echo $yim ?> </td> 
</tr> 
<tr> 
<td width="50%"> <div align="right">Permissions:</div></td> 
<td><?php echo $permissions ?> </td> 
</tr> 
</table> 
<div align="center"></div></p> 
<p align="center"><a href="memberlist.php">Back</a></p> 
</body> 
</html>

There shouldn't be any editing needed,
-Blake

ctsttom

thx it worked... now i have that working how do i make it so the ppl signing up cant sign up if there is sum who alredy has that account name or email address...
signup.php

<html>
<head>
<title>Members List</title>
</head>
<body>
<p> Signup:</p>
<form name="form1" id="form1" method="post" action="signupuser.php">
<table width="100%" border="1" cellspacing="0" cellpadding="0">
<tr>
<td width="50%" height="26"> <div align="right">Username:</div></td>
<td><input name="username" type="text" id="username" value="" size="16" maxlength="16" />
(max 16 char)</td>
</tr>
<tr>
<td width="50%"> <div align="right">Password:</div></td>
<td><input name="password" type="password" id="password" value="" size="16" maxlength="16" />
(max 16 char)</td>
</tr>
<tr>
<td width="50%"> <div align="right">DOB:</div></td>
<td><input name="dob" type="text" id="dob" value="" size="10" maxlength="10" />
(dd/mm/yyyy)</td>
</tr>
<tr>
<td width="50%" height="26">
<div align="right">Email:</div></td>
<td><input name="email" type="text" id="email" value="" size="20" maxlength="20" /></td>
</tr>
<tr>
<td width="50%"> <div align="right">Newsletter:</div></td>
<td><input name="newsletter" type="radio" value="Yes" checked>
Yes  
<input type="radio" name="newsletter" value="no">
No</td>
</tr>
<tr>
<td width="50%"> <div align="right">AIM:</div></td>
<td><input name="aim" type="text" id="aim" value="" /></td>
</tr>
<tr>
<td width="50%"> <div align="right">ICQ:</div></td>
<td><input name="icq" type="text" id="icq" value="" /></td>
</tr>
<tr>
<td width="50%"> <div align="right">MSN:</div></td>
<td><input name="msn" type="text" id="msn" value="" /></td>
</tr>
<tr>
<td width="50%"> <div align="right">YIM:</div></td>
<td><input name="yim" type="text" id="yim" value="" />
<input name="permissions" type="hidden" id="permissions" value="member"></td>
</tr>
</table>
<div align="center"><br>
<input type="submit" name="Submit" value="Signup!" />
<input type="reset" name="Submit2" value="Clear" />
</div>
</form>
<p align="center"><a href="memberlist.php">Back</a></p>
</body>
</html>

signupuser.php

<html>
<head>
<title>Members List</title>
</head>
<body>
<?php
// Connect to the database server
$dbcnx = @mysql_connect("localhost", "dbaccess", "1234");
if (!$dbcnx) {
echo( "<p>Unable to connect to the " .
"database server at this time.</p>" );
exit();
}
// Select the jokes database
if (! @mysql_select_db("communitydb") ) {
echo( "<p>Unable to locate the joke " .
"database at this time.</p>" );
exit();
}
?>
<p>Signup:
<?php
$sql = mysql_query("INSERT INTO members (username, password, dob, email, newsletter, aim, icq, msn, yim, permissions) VALUES ('$username', '$password', '$dob', '$email', '$newsletter', '$aim', '$icq', '$msn', '$yim', '$permissions')");
?>
</p>
<p align="center"><font color="#FF0000">Signup Compleat!</font></p>
<table width="100%" border="1" cellspacing="0" cellpadding="0">
<tr>
<td width="50%" height="26"> <div align="right">Username:</div></td>
<td><?php echo $username ?> </td>
</tr>
<tr>
<td width="50%"> <div align="right">Password:</div></td>
<td><?php echo $password ?> </td>
</tr>
<tr>
<td width="50%"> <div align="right">DOB:</div></td>
<td><?php echo $dob ?> </td>
</tr>
<tr>
<td width="50%"> <div align="right">Email:</div></td>
<td><?php echo $email ?> </td>
</tr>
<tr>
<td width="50%"> <div align="right">Newsletter:</div></td>
<td><?php echo $newsletter ?> </td>
</tr>
<tr>
<td width="50%" height="23"> <div align="right">AIM:</div></td>
<td><?php echo $aim ?> </td>
</tr>
<tr>
<td width="50%"> <div align="right">ICQ:</div></td>
<td><?php echo $icq ?> </td>
</tr>
<tr>
<td width="50%"> <div align="right">MSN:</div></td>
<td><?php echo $msn ?> </td>
</tr>
<tr>
<td width="50%"> <div align="right">YIM:</div></td>
<td><?php echo $yim ?> </td>
</tr>
<tr>
<td width="50%"> <div align="right">Permissions:</div></td>
<td><?php echo $permissions ?> </td>
</tr>
</table>
<div align="center"></div></p>
<p align="center"><a href="memberlist.php">Back</a></p>
</body>
</html>

batman

Use this for the signupuser.php page:

<html> 
<head> 
<title>Members List</title> 
</head> 
<body> 
<?php 
// Connect to the database server 
$dbcnx = @mysql_connect("localhost", "dbaccess", "1234"); 
if (!$dbcnx) { 
echo( "<p>Unable to connect to the " . 
"database server at this time.</p>" ); 
exit(); 
} 
// Select the jokes database 
if (! @mysql_select_db("communitydb") ) { 
echo( "<p>Unable to locate the joke " . 
"database at this time.</p>" ); 
exit(); 
} 
?> 
<p>Signup: 
<?php
$email = $_POST["email"]; 
$username = $_POST["username"];
$check = mysql_query("SELECT * FROM members WHERE email='$email'");
$checkr = mysql_num_rows($check);
if($checkr > 0)
{
echo "I'm sorry that email address is already in use by another member.";
include "signup.php";
exit();
}
$check2 = mysql_query("SELECT * FROM members WHERE username='$username'");
$check2r = mysql_num_rows($check2);
if($check2r > 0)
{
echo "I'm sorry that username is already in use by another member.";
include "signup.php";
exit();
}
$sql = mysql_query("INSERT INTO members (username, password, dob, email, newsletter, aim, icq, msn, yim, permissions) VALUES ('$username', '$password', '$dob', '$email', '$newsletter', '$aim', '$icq', '$msn', '$yim', '$permissions')"); 
?> 
</p> 
<p align="center"><font color="#FF0000">Signup Compleat!</font></p> 
<table width="100%" border="1" cellspacing="0" cellpadding="0"> 
<tr> 
<td width="50%" height="26"> <div align="right">Username:</div></td> 
<td><?php echo $username ?> </td> 
</tr> 
<tr> 
<td width="50%"> <div align="right">Password:</div></td> 
<td><?php echo $password ?> </td> 
</tr> 
<tr> 
<td width="50%"> <div align="right">DOB:</div></td> 
<td><?php echo $dob ?> </td> 
</tr> 
<tr> 
<td width="50%"> <div align="right">Email:</div></td> 
<td><?php echo $email ?> </td> 
</tr> 
<tr> 
<td width="50%"> <div align="right">Newsletter:</div></td> 
<td><?php echo $newsletter ?> </td> 
</tr> 
<tr> 
<td width="50%" height="23"> <div align="right">AIM:</div></td> 
<td><?php echo $aim ?> </td> 
</tr> 
<tr> 
<td width="50%"> <div align="right">ICQ:</div></td> 
<td><?php echo $icq ?> </td> 
</tr> 
<tr> 
<td width="50%"> <div align="right">MSN:</div></td> 
<td><?php echo $msn ?> </td> 
</tr> 
<tr> 
<td width="50%"> <div align="right">YIM:</div></td> 
<td><?php echo $yim ?> </td> 
</tr> 
<tr> 
<td width="50%"> <div align="right">Permissions:</div></td> 
<td><?php echo $permissions ?> </td> 
</tr> 
</table> 
<div align="center"></div></p> 
<p align="center"><a href="memberlist.php">Back</a></p> 
</body> 
</html>

Try that,
    -Blake

ctsttom

that works gr8, i know ya probably think im just leaching code off ya for free but im not i am learning from this slowly and i wana make a full blown member ship system (to help me learn) so the next bit i need help with is login and security, incase ya hadent noticed its all to easy for sum1 to just get into admin and delete an account cos there is no protection, so can you help me to put that in? what do we need to do?