Codezwiz >> Forums >> General PHP Nuke Help >> msql help

Register

hello all,

Question:

i want to ad a module to my top 10 listingpage.
Now i know i have to ad the index page of the TOP module.

But its all with Mysql id's and stuff and i realy dont know annything about adding mysql commands into the phpnuke pages.
is there a tutorial about this, or a standard page that i can alter? because i want to do this by myself

(ill probably ask for help within 24 hours LOL)

I tried some things already but it doesnt show up in the index page

I have putted the code below (dont laugh...i know its messed up

)

$sql = "SELECT memberid, sitename, url, counter FROM ".$prefix."_nuke_mstopsites ORDER BY counter DESC LIMIT 0,$top";
$result = $db->sql_query($sql);
if ($db->sql_numrows($result) > 0) {
echo "<table border=\"0\" cellpadding=\"10\" width=\"100%\"><tr><td align=\"left\">\n"
."$top "._sitename." \n";
$lugar=1;
while ($row = $db->sql_fetchrow($result)) {
$memberid = $row[memberid];
$sitename = $row[sitename];
$url = $row[url];
$counter = $row[counter];
if($counter>0) {
echo "<big>�;</big> ;;$lugar: <a href=\"modules.php?name=MS_TopSites&memberid=memberid&op=newindex&memberid=$memberid\">$title</a> - ($counter "._sitename.") \n";
$lugar++;
}
}
echo "</td></tr></table> \n";
}

Just copy the code from another module in the Top page and change it ever so slightly to reflect the new table your trying to query.

Hi Telli,

Thats what is did with the code i provided above.
The thing i dont get is, all the different commands for the mysql database.
I tried to compare different kinds of mysql commands but its to confusing.

I also tried it with 3 different kind of PHP editors with integrated mysgl commands (to manny diffrent ones

), but i dont know withs command does what.

Is there anny way that you can help me? PLEASE

THNX

I might be wrong on this, but in all of my Mysql scripts, when i output stuff, i use single quotes like

echo "<td>".$meetingdate['month']." ".$meetingdate['mday'].", ".$meetingdate['year']."</td>";

Register

Originally posted by Milkman @ Thu Apr 15, 2004 10:03 pm:

I might be wrong on this, but in all of my Mysql scripts, when i output stuff, i use single quotes like
echo "<td>".$meetingdate['month']." ".$meetingdate['mday'].", ".$meetingdate['year']."</td>";

What is $top set to? Is it possible this is set to 0 or not initialized and the query is not returning any thing?

Also, maybe try and test the query, maybe there is an error. so the code would look like $result = $db->mysql_query($sql) or die (mysql_error()); I think thats the syntax for catching the error code.