Shoutbox

code:

---

//Tags//

$query_tags = mysql_query("SELECT id, name FROM pp_tags GROUP BY name ORDER BY COUNT(id) DESC LIMIT 0,50");

while ($row_tag = mysql_fetch_array($query_tags)) {
$tags[] = $row_tag;
}
$smarty->assign('tag', $tags);
//tags end

---

Thanks for your help

I can't really help without the error messages, and it's a while since I have used php, but I don't think you can copy an array like that. You would need some sort of counter.

for example

code:

---

$i = 0;
while ($row_tag = mysql_fetch_array($query_tags)) {
$tags[$i] = $row_tag;
}

---

I can't remember if $row_tag is an array or not. But something along those lines.

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in [FILE LOCATION]

Try running the query in PMA. It will fail there. You are sorting by COUNT(id) when you are not declaring it in the SELECT clause. and COUNT(id) will be a constant number anyway.

code:

---

$query_tags = mysql_query("SELECT COUNT(id) AS count_id, name FROM pp_tags GROUP BY name ORDER BY count_id DESC LIMIT 0,50");

---

That should work for the query

Also that array copying code doesn't look right either like saralk was saying.

So try this:

code:

---

$i = 0;
while ($row_tag = mysql_fetch_array($query_tags)) {
$tags[$i] = $row_tag;
$i++;
}

---

You need to overwrite your while loop with that second piece of code.
Good Luck

while ($row_tag = mysql_fetch_array($query_tags)) {

It says that, that line is the wrong code.

Yeah.. it's saying it can't get the results from the query because the query failed. So you need to find out what is wrong with the query. Did you try replacing it with that code I gave you?

Or you could try and see if mysql_error() returns anything.

quote:

---

Originally posted by win_crook
Also that array copying code doesn't look right either like saralk was saying.

---

huh? what doesn't look right about it?

$row = mysql_fetch_array($confresult);

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

Ok whats wrong  with this.

Why are you ordering your results by the number of rows?

The order by should just be id of you want to order it by that column. Don't try to order it by a number that will likely not exist as a column

$query_tags = mysql_query("SELECT id, name FROM pp_tags GROUP BY name ORDER BY id DESC LIMIT 0,50");