NERVi

Esmu visu pareizi savadījis Lapas source: link: <a href=''>link</a> link: <a href=''>link</a> link: <a href=''>link</a> link: <a href=''>link</a> Šobrīd lapas kods izskatās šādi: <?php require_once 'connect.inc.php'; $query = "SELECT `name`, `link` FROM `categorys`"; $query = mysql_query($query) or die(mysql_error()); while($row = mysql_fetch_row($query)){ echo $row['name']." link: <a href='".$row['link']."'>link</a><br>"; } ?> Datubāze: CREATE TABLE `categorys` ( `id` int(11) NOT NULL auto_increment, `name` varchar(30) NOT NULL, `link` varchar(40) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ; -- -- Dumping data for table `categorys` -- INSERT INTO `categorys` VALUES (1, 'category1', 'http://lol.com'); INSERT INTO `categorys` VALUES (2, 'category2', 'http://lol2.com'); INSERT INTO `categorys` VALUES (3, 'category3', 'http://lol3.com'); INSERT INTO `categorys` VALUES (4, 'category4', 'http://lol4.com');

<?php require_once 'connect.inc.php'; $query = "SELECT `name`, `link` FROM `categorys`"; $query = mysql_query($query) or die(mysql_error()); while($row = mysql_fetch_row($query)){ echo $row['name']." link: <a href='".$row['link']."'>link</a>"; } ?>

Nospiežot uz linka, netiek redirektots uz citu lapu.Paliek tajā pašā lokalhostā

Ko es daru nepareizi? <?php require_once 'connect.inc.php'; $query = "SELECT `id` FROM `categorys`"; $query_run = mysql_query($query); for($field = 1;$field <= mysql_num_rows($query_run);$field++){ $query2 = "SELECT `title` , `link` FROM `categorys` WHERE `id` = '$field'"; if( $query2_run = mysql_query($query2)){ $query_title = mysql_result($query2_run,`title`); $query_link = mysql_result($query2_run,`link`); echo $query_title." Link: ".$query_link."<br>"; } } ?> Tabula izskatās šādi: Galarezultātam jābūt šādam: category1 Link: http://lol.com category2 Link: http://lol2.com category3 Link: http://lol2.com category4 Link: http://lol3.com Bet ir šāds: category1 Link: category1 category2 Link: category2 category3 Link: category3 category4 Link: category4