I have problem with mysql_fetch_array()
and while
loop. I have the query:
$tagsquery = mysql_query("SELECT `url` FROM `tags`, `mapa-tagow`, `statusy` WHERE `tags`.`id` = `mapa-tagow`.`tag-id` AND `statusy`.`id` = `mapa-tagow`.`article-id` AND `tags`.`tag` ='$tag' ORDER BY `url` ASC ") or die("ERROR: Tags doesn't exist.");
And results in while loop:
while($tags = mysql_fetch_array($tagsquery)) {
echo "<a href='tags.php?url=$url'>$url</a>, ";
}
When testing this query in PHPMyAdmin I have one more result than I get in PHP. I dont know why PHP always missing first result.