NERVi

Nu, kur links redirektē ir jaskatās, ko viņs izvelk laukā un tml... vai pareizi esi datus savadījis, šitais

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');

$query = "SELECT `name`, `link` FROM `categorys`";

btw, parādi visu failu.

<?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>";

}


?>

pareizāk būtu..

$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>";
}

Un jā, vēl tad varētu iesaistīt, mysql num rows un tml..

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