Код |
$query ="SELECT * FROM `user`"; $result = mysql_query($query, $db); $row=mysql_fetch_array($result); echo "User's<br>"; while($row = mysql_fetch_array($result)) { echo "id: ".$row['user_id']; echo "name:".$row['user_login']."<br>"; echo "name:".$row['user_password']."<br>"; echo "name:".$row['user_city']."<br>"; } |
PHP |
<? |
PHP |
echo "".$row['id']."" ; |
SQL |
CREATE TABLE `shinobi_users` ( `id` smallint(8) unsigned NOT NULL auto_increment, `login` varchar(50) NOT NULL default '', `password` varchar(32) NOT NULL default '', `salt` char(3) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `login` (`login`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=23 ; |
Цитата (kirik @ 25.12.2008 - 16:31) |
Читай про JOIN. Какая структура первой таблицы? |
SQL |
CREATE TABLE `shinobi_warstat` ( `id` int(10) unsigned default NULL, `war` int(6) unsigned default '10', `win` int(6) default '10', `lose` int(6) unsigned default '10', `lvl` int(3) default '1', `money` int(6) NOT NULL default '10', `exp` int(7) unsigned NOT NULL default '0' ) ENGINE=MyISAM DEFAULT CHARSET=cp1251; |
SQL |
CREATE TABLE `shinobi_warstat` ( `id` int(10) unsigned default NULL, `war` int(6) unsigned default '10', `win` int(6) default '10', `lose` int(6) unsigned default '10', `lvl` int(3) default '1', `money` int(6) NOT NULL default '10', `exp` int(7) unsigned NOT NULL default '0' ) ENGINE=MyISAM DEFAULT CHARSET=cp1251; CREATE TABLE `shinobi_users` ( `id` smallint(8) unsigned NOT NULL auto_increment, `login` varchar(50) NOT NULL default '', `password` varchar(32) NOT NULL default '', `salt` char(3) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `login` (`login`) ) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=23 ; |
SQL |
SELECT `u`.`login` FROM `shinobi_warstat` AS `w` INNER JOIN `shinobi_users` AS `u` ON `u`.`id` = `w`.`id` WHERE `w`.`id` = X |
PHP |
$query ="select shinobi_users.login, shinobi_warstat.war,win,lose,lvl,money,exp |
Цитата (kirik @ 16.07.2008 - 04:31) |
попробуй - $query ="SELECT * FROM `user`"; $result = mysql_query($query, $db); // $row=mysql_fetch_array($result); echo "User's<br>"; while($row = mysql_fetch_assoc($result)) { echo "id: ".$row['user_id']; echo "name:".$row['user_login']."<br>"; echo "name:".$row['user_password']."<br>"; echo "name:".$row['user_city']."<br>"; } |
PHP |
<a href="index.php?page=academy">Ученик (от 1-го до 5-го уровня) - оплата 1 монета в день</a><br /> |
PHP |
$query ="SELECT lvl FROM `shinobi_warstat` WHERE 'id'='{$_SESSION['user_id']}'"; |
PHP |
$query ="SELECT job FROM `shinobi_warstat` WHERE 'id'='{$_SESSION['user_id']}'"; |
PHP |
if($row['lvl']==от 1 до пяти) |
PHP |
if($row['lvl'] >= 1 && $row['lvl'] <=5) |
PHP |
if (date('G', time())==0) |
Цитата (kirik @ 30.12.2008 - 04:17) |
и запускаем по крону |