Hi thanks for replying, i managed to find a registration script, which checks or updates the database and have adapted it but there are still a few mistakes in it that i cant iron out. Can you help?
[php]
<html>
<head>
<title>Untitled</title>
</head>
<body>
<?php
include 'll/connect.php';
include 'll/database.php';
if (isset($_POST['submit'])) {
if (!get_magic_quotes_gpc()) {
$_POST['colour'] = addslashes($_POST['colour']);
}
$usercheck = $_POST['colour'];
$check = mysql_query("SELECT colour FROM favourites WHERE colour = '$usercheck'")
or die(mysql_error());
$check2 = mysql_num_rows($check);
//if the colour exists add vote
if ($check2 != 0)
mysql_query("UPDATE favourites SET votes = 'votes+1'")
{
echo('your vote is counted!!');
}
// if it does not exist, add new row and 1 vote
$insert = "INSERT INTO favourites (colour, votes)
VALUES ('".$_POST['name']."', '1')";
$add_member = mysql_query($insert);
?>
<?php
}
else
{
?>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>"
method="post">
<table border="0">
<tr><td>name:</td><td>
<input type="text" name="colour" maxlength="60">
</td></tr>
<tr><th colspan=2><input type="submit" name="submit"
value="vote!"></th></tr> </table>
</form>
<?php
}
?>
</body>
</html>[/php]
6
