При регистрация

haus

Registered
Искам да попитам как да направя при регистрация да те пита със какво да си със мотор или кола и когато избера напримвр мотор да ме пусне със мотор или пък ако съм със кола да ме пусне със кола
 
Това не ти е игра под уиндоус я.
Дай си кода за регистрация, и структурата на таблицата на потребителите, и ще се опитам да ти го направя.
 
Код за регистрацията

Код:
<?php
if(!$_POST['submit']) {
?>
<script src="chekname.js"></script>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251" />
Регистрация<hr color='black' width='300' align='center' />
<form action="?a=register" method="POST">
<table align="center">
<tr><td>Потребителско име:</td><td><input type="text" maxlength="12" style="background-color: #bbbbbb;" name="name" id="txt1" onblur="showHint(this.value)">
<span id="txtHint"></span>  </td></tr>
<tr><td>Парола:</td><td><input type="password" style="background-color: #bbbbbb;" name="pass1"></td></tr>
<tr><td>Отново:</td><td><input type="password" style="background-color: #bbbbbb;" name="pass2"></td></tr>
<tr><td>Емайл:</td><td><input type="text" style="background-color: #bbbbbb;" name="mail"></td></tr>
<tr><td>Избери начална кола:</td><td>
<select name='cars' size='1' style="background-color: #f1f1f1;"><option value="55">Ford Focus</option><option value="105">Acura RL</option><option value="155">Mazda MAZDA3</option></select>
</td></tr>
<tr><td>Пол:</td><td><input type="radio" checked name="sex" value="male">Мъж  <input type="radio" name="sex" value="female">Жена</td></tr>
<tr><td></td><td><input value="създай акаунта" class="field-submit" type="submit" name="submit"></td></tr>

</table>
</form>
<? } ?>
<?php
if(isset($_POST['submit']) && $_SESSION['name'] == NULL)
{
if($_POST['name'] == NULL || $_POST['pass1'] == NULL || $_POST['pass2'] == NULL || $_POST['mail'] == NULL)
{
echo '
<table class="error1-reg" width="40%" align="center">
<td class="error-reg" rowspan="4" width="5%" align="center">
<img src="images/task_error.gif" width="33" border="0" height="33">
</td>
<td width="50%" align="center"><span style="font-weight: bold;">Този емайл е зает.</span></td>
</table>';
}

elseif($_POST['pass1'] != $_POST['pass2'])
{
echo '
<table class="error1-reg" width="40%" align="center">
<td class="error-reg" rowspan="4" width="5%" align="center">
<img src="images/task_error.gif" width="33" border="0" height="33">
</td>
<td width="50%" align="center"><span style="font-weight: bold;">Паролите не си съвпадат.</span></td>
</table>';
}

else
{
$name = htmlspecialchars($_POST['name']);
$pass = md5($_POST['pass1']);
$mail = htmlspecialchars($_POST['mail']);
$sex = htmlspecialchars($_POST['sex']);
$cars = htmlspecialchars($_POST['cars']);
$insert = "INSERT INTO `users` (`name` , `pass` , `mail` , `sex`, `cars`) VALUES ('$name', '$pass', '$mail', '$sex', '$cars')";

$select_users = mysql_query('SELECT * FROM users WHERE mail="'.$mail.'"');

if(mysql_num_rows($select_users)==0)
{
if(mysql_query($insert))
{
echo '
<table class="active1-reg" width="36%" align="center">
<td class="active-reg" rowspan="4" width="5%" align="center">
<img src="images/task_done.gif" width="33" border="0" height="33">
</td>
<td width="50%" align="center"><span style="font-weight: bold;">Успешно се регистрирахте.</span></td>
</table>';
}
else
{
echo '
<table class="error1-reg" width="40%" align="center">
<td class="error-reg" rowspan="4" width="5%" align="center">
<img src="images/task_error.gif" width="33" border="0" height="33">
</td>
<td width="50%" align="center"><span style="font-weight: bold;">Регистрацията не е успешна.</span></td>
</table>';
}
}
else
{
echo '
<table class="error1-reg" width="46%" align="center">
<td class="error-reg" rowspan="4" width="5%" align="center">
<img src="images/task_error.gif" width="33" border="0" height="33">
</td>
<td width="50%" align="center"><span style="font-weight: bold;">Има потребител с този имейл адрес.</span></td>
</table>';
}
}
}
?>


ето и users

CREATE TABLE IF NOT EXISTS `users` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(11) NOT NULL,
`namepro` varchar(11) NOT NULL default '0',
`namecolor` varchar(255) NOT NULL default 'ffffff',
`adminlvl` varchar(11) default '0',
`avatar` varchar(255) NOT NULL default 'images/avatars/0.gif',
`description` varchar(255) NOT NULL,
`age` varchar(11) NOT NULL,
`city` varchar(30) NOT NULL,
`skype` varchar(30) NOT NULL,
`timestamp` text NOT NULL,
`time` varchar(255) NOT NULL,
`pass` varchar(60) character set cp1251 collate cp1251_bulgarian_ci NOT NULL default '',
`mail` varchar(60) NOT NULL,
`lvl` tinyint(2) NOT NULL default '0',
`exp` int(11) NOT NULL default '0',
`money` int(11) NOT NULL default '200',
`speed` int(255) NOT NULL default '46',
`acceleration` int(255) NOT NULL default '47',
`stability` int(255) NOT NULL default '47',
`power` int(11) NOT NULL default '50',
`points` int(11) NOT NULL default '1',
`cars` int(11) NOT NULL default '55',
`credits` int(11) NOT NULL default '10',
`training` int(11) default '10',
`weaponr` int(5) NOT NULL default '0',
`weaponl` int(5) NOT NULL default '0',
`weapong` int(5) NOT NULL default '0',
`bonus_turbo` int(11) NOT NULL default '0',
`bonus_nitrous` int(11) NOT NULL default '0',
`bonus_wheels` int(11) NOT NULL default '0',
`bonus_spoilers` int(11) NOT NULL default '0',
`bonus_generation` int(11) NOT NULL default '0',
`bonus_dampers` int(11) NOT NULL default '0',
`bonus_abs` int(11) NOT NULL default '0',
`wins` int(11) NOT NULL default '0',
`loses` int(11) NOT NULL default '0',
`drivercar` tinyint(1) NOT NULL default '0',
`fighter` tinyint(1) NOT NULL default '0',
`killer` tinyint(1) NOT NULL default '0',
`busy` tinyint(1) NOT NULL default '0',
`attacked` int(11) NOT NULL default '0',
`level` tinyint(1) NOT NULL default '0',
`jobs` int(11) NOT NULL default '0',
`nrg` int(3) NOT NULL default '100',
`maxnrg` int(3) NOT NULL default '100',
`bank` int(11) NOT NULL default '0',
`sex` varchar(11) character set cp1251 collate cp1251_bulgarian_ci NOT NULL default 'male',
`firm` varchar(11) default NULL,
`ip` varchar(244) default NULL,
`ban` int(22) default NULL,
`sellcars` varchar(20) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `mail` (`mail`),
UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=655 ;
 

Back
Горе