runeb0x Posted January 22, 2013 Share Posted January 22, 2013 PHP Error Message Warning: mysql_query() [function.mysql-query]: Access denied for user 'a4712001'@'localhost' (using password: NO) in /home/a4712001/public_html/forums/index.php on line 70 Free Web Hosting PHP Error Message Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/a4712001/public_html/forums/index.php on line 70 Free Web Hosting PHP Error Message Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/a4712001/public_html/forums/index.php on line 71 Free Web Hosting PHP Error Message Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/a4712001/public_html/forums/index.php on line 72 Free Web Hostin website: http://runeb0x.hostei.com/forums/index.php Quote Link to comment Share on other sites More sharing options...
Jessica Posted January 22, 2013 Share Posted January 22, 2013 Sounds like you need a password. Did you READ the error? Quote Link to comment Share on other sites More sharing options...
runeb0x Posted January 22, 2013 Author Share Posted January 22, 2013 Sounds like you need a password. Did you READ the error? yeah i know the mysql password! do you think i may have imput it wrong? Quote Link to comment Share on other sites More sharing options...
Jessica Posted January 22, 2013 Share Posted January 22, 2013 PHP Error MessageWarning: mysql_query() [function.mysql-query]: Access denied for user 'a4712001'@'localhost' (using password: NO) in /home/a4712001/public_html/forums/index.php on line 70 Did you actually read it? Quote Link to comment Share on other sites More sharing options...
runeb0x Posted January 22, 2013 Author Share Posted January 22, 2013 Did you actually read it? typed in the right password got a new error! PHP Error Message Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/a4712001/public_html/forums/index.php on line 71 Free Web Hosting PHP Error Message Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/a4712001/public_html/forums/index.php on line 72 Free Web Hosting Quote Link to comment Share on other sites More sharing options...
Jessica Posted January 22, 2013 Share Posted January 22, 2013 See my signature. Quote Link to comment Share on other sites More sharing options...
runeb0x Posted January 22, 2013 Author Share Posted January 22, 2013 See my signature. idk what to click :S Quote Link to comment Share on other sites More sharing options...
runeb0x Posted January 22, 2013 Author Share Posted January 22, 2013 here is my index <?php //This page displays the list of the forum's categories include('config.php'); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <link href="<?php echo $design; ?>/style.css" rel="stylesheet" title="Style" /> <title>Forum</title> </head> <body> <div class="header"> <a href="<?php echo $url_home; ?>"><img src="<?php echo $design; ?>/images/logo.png" alt="Forum" /></a> </div> <div class="content"> <?php if(isset($_SESSION['username'])) { $nb_new_pm = mysql_fetch_array(mysql_query('select count(*) as nb_new_pm from pm where ((user1="'.$_SESSION['userid'].'" and user1read="no") or (user2="'.$_SESSION['userid'].'" and user2read="no")) and id2="1"')); $nb_new_pm = $nb_new_pm['nb_new_pm']; ?> <div class="box"> <div class="box_left"> <a href="<?php echo $url_home; ?>">Forum Index</a> </div> <div class="box_right"> <a href="list_pm.php">Your messages(<?php echo $nb_new_pm; ?>)</a> - <a href="profile.php?id=<?php echo $_SESSION['userid']; ?>"><?php echo htmlentities($_SESSION['username'], ENT_QUOTES, 'UTF-8'); ?></a> (<a href="login.php">Logout</a>) </div> <div class="clean"></div> </div> <?php } else { ?> <div class="box"> <div class="box_left"> <a href="<?php echo $url_home; ?>">Forum Index</a> </div> <div class="box_right"> <a href="signup.php">Sign Up</a> - <a href="login.php">Login</a> </div> <div class="clean"></div> </div> <?php } if(isset($_SESSION['username']) and $_SESSION['username']==$admin) { ?> <a href="new_category.php" class="button">New Category</a> <?php } ?> <table class="categories_table"> <tr> <th class="forum_cat">Category</th> <th class="forum_ntop">Topics</th> <th class="forum_nrep">Replies</th> <?php if(isset($_SESSION['username']) and $_SESSION['username']==$admin) { ?> <th class="forum_act">Action</th> <?php } ?> </tr> <?php $dn1 = mysql_query('select c.id, c.name, c.description, c.position, (select count(t.id) from topics as t where t.parent=c.id and t.id2=1) as topics, (select count(t2.id) from topics as t2 where t2.parent=c.id and t2.id2!=1) as replies from categories as c group by c.id order by c.position asc'); $nb_cats = mysql_num_rows($dn1); while($dnn1 = mysql_fetch_array($dn1)) { ?> <tr> <td class="forum_cat"><a href="list_topics.php?parent=<?php echo $dnn1['id']; ?>" class="title"><?php echo htmlentities($dnn1['name'], ENT_QUOTES, 'UTF-8'); ?></a> <div class="description"><?php echo $dnn1['description']; ?></div></td> <td><?php echo $dnn1['topics']; ?></td> <td><?php echo $dnn1['replies']; ?></td> <?php if(isset($_SESSION['username']) and $_SESSION['username']==$admin) { ?> <td><a href="delete_category.php?id=<?php echo $dnn1['id']; ?>"><img src="<?php echo $design; ?>/images/delete.png" alt="Delete" /></a> <?php if($dnn1['position']>1){ ?><a href="move_category.php?action=up&id=<?php echo $dnn1['id']; ?>"><img src="<?php echo $design; ?>/images/up.png" alt="Move Up" /></a><?php } ?> <?php if($dnn1['position']<$nb_cats){ ?><a href="move_category.php?action=down&id=<?php echo $dnn1['id']; ?>"><img src="<?php echo $design; ?>/images/down.png" alt="Move Down" /></a><?php } ?> <a href="edit_category.php?id=<?php echo $dnn1['id']; ?>"><img src="<?php echo $design; ?>/images/edit.png" alt="Edit" /></a></td> <?php } ?> </tr> <?php } ?> </table> <?php if(isset($_SESSION['username']) and $_SESSION['username']==$admin) { ?> <a href="new_category.php" class="button">New Category</a> <?php } if(!isset($_SESSION['username'])) { ?> <div class="box_login"> <form action="login.php" method="post"> <label for="username">Username</label><input type="text" name="username" id="username" /><br /> <label for="password">Password</label><input type="password" name="password" id="password" /><br /> <label for="memorize">Remember</label><input type="checkbox" name="memorize" id="memorize" value="yes" /> <div class="center"> <input type="submit" value="Login" /> <input type="button" onclick="javascript:document.location='signup.php';" value="Sign Up" /> </div> </form> </div> <?php } ?> </div> <div class="foot"><a href="http://www.webestools.com/scripts_tutorials-code-source-26-simple-php-forum-script-php-forum-easy-simple-script-code-download-free-php-forum-mysql.html">Simple PHP Forum Script</a> - <a href="http://www.webestools.com/">Webestools</a></div> </body> </html> Quote Link to comment Share on other sites More sharing options...
Christian F. Posted January 22, 2013 Share Posted January 22, 2013 idk what to click :S What about the link that says "Debugging your SQL"? You know, you have to put in some effort on your own, and take your time to actually understand what you're doing. If not, you're just going to create a LOT of problems for yourself; Problems which could have been easily avoided; And no-one here are neither interested in, nor stocked up on enough free time to be able to, do(ing) all of the work for you. Our efforts to help are directionally proportional to your efforts, to understand and to make it work on your own. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.