Jump to content
MakeWebGames

[mccode] Need help


Arkvoodle`
 Share

Recommended Posts

K just made a newspaper mod and it doesn't work. Forsome reason it doesn't give any errors either =/

As I believe, the error occours on these lines.

Can anyone help me? SELECT is not my strong point =x

 

$q=mysql_query("SELECT np.*,u1.username as poster FROM newspaper np LEFT JOIN users u1 ON u1.userid=np.pID LEFT JOIN newspaper u2 ON u2.userid=np.npSUBJECT ORDER BY np.npID DESC",$c) or die(mysql_error());
while($r=mysql_fetch_array($q))
{
print "\n<tr> <td>[url='viewuser.php?u={$r[']{$r['poster']}[/url] [{$r['pID']}]</td> <td>[{$r['npSUBJECT']}]</td> <td>{$r['npTEXT']}</td> <td>[url='admin.php?action=repclear&ID={$r[']Clear[/url]</td> </tr>";
}

 

SQL's are:

 npID 	pID 	npSUBJECT 	npTEXT

npID = Newspaper ad id

pID = player id

npSUBJECT = subject ofcourse

npTEXT = main ad..

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...