[RESOLVED] Problem again with the article script.

god0fgod

New problem. When adding another row to the database I realised I need to collect information from a multidimensional array. I changed the script for this and now it has gone crazy. Also I used mysgl_fetch_array so I have a numerical array.

$datacat = array('general_cat', 'funny_cat', 'help_cat', 'quiz_cat', 'chat_cat', 'game_cat'); 
$categorys = array('General', 'Funny', 'Help related', 'Quizzes', 'Chatbots', 'Video game related'); 
    for($ix=0; $ix<6; $ix++) { 
      echo "<font face=\"arial\" size=\"3\"><u><b>" . $categorys[$ix] . ":</b></u></font></br>"; 
      $query = "SELECT id, title FROM articles WHERE $datacat[$ix]=1 ORDER BY date DESC"; 
      $result = mysql_query($query); 
      $count = 0; 
      while($count < 5 && $row = mysql_fetch_array($result)){
        $id = $row[0][$count];
        $title = $row[1][$count];
        // Here you need to add the rest of the html tags and so forth but you get the idea 
        echo "<a href=\"http://www.godofgod.co.uk/newssub/view_article.php?id=" . $id . "\"><font face=\"arial\">" . $title . "</font></a></br>";
        $count++;  

      }
    echo "</br>"; 
    }

What happened here I do not know - http://www.godofgod.co.uk/newssub/articles.php

It wouldn't let me unresolve my other thread.

Scriptmaker

The best way to solve multidimmensional/associative array problems is to make sure you are following the structure exactly. Have you tried print_r($row);

Also, I just want to make sure I understand your structure:

$datacat[$ix]=1

so your article table has the columns:
id
title
general_cat
funny_cat
help_cat
quiz_cat
chat_cat
game_cat

And if the article is in either of those categories, it gets a "1" in that particular column, right?

The only reason I'd see for doing it this way is if you want to be able to put an article in multiple categories. Why not instead make a single "category" column?

igorlopez

Duplicate thread by mistake se thread:
http://phpbuilder.com/board/showthread.php?p=10826412#post10826412

god0fgod

assoc did the same thats why I tried it another way. Didn't work either. I've managed to get 5 test links before. I keep experimenting but it goes wrong each time assoc or not.

igorlopez

Which thread should we work on? This on or the old one?

god0fgod

I went back to assoc and experimeanted again. I think it was something to do with the title. It works now. Thanks for that. Now I've got rid of the annoying part everything should be okay (hopefully).

I know what the assoc way does now. I hope to be able to use it without problems from now on. Thanks again.