Results 21 to 30 of 33
Threaded View
-
23rd Jun 2010, 01:21 PM #1OPOH GOD!!!!!Website's:
HotNewHipHop.comMySQL Error
Im installed some script but i get this errors
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/XXXXXXX/public_html/index.php on line 99
line 99: while ($y=mysql_fetch_assoc($x))
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/XXXXXXX/public_html/index.php on line 80
Line 80:while ($y=mysql_fetch_assoc($x))
same thing for line 51
server php version is 5.2.13
MySQL version is 5.1.46-log
edit: more info
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/xxxxxx/public_html/index.php on line 51
(code in red is line 51)
Code:</script> </head> <body> <div id="fb-root"></div> <script> window.fbAsyncInit = function() { FB.init({appId: '48272f6b9a278d88b2ec480da8790513', status: true, cookie: true, xfbml: true}); }; (function() { var e = document.createElement('script'); e.async = true; e.src = document.location.protocol + '//connect.facebook.net/en_US/all.js'; document.getElementById('fb-root').appendChild(e); }()); </script> <div id="header"> <a href="index.php" id="branding"><span>LikeItNow</span></a> <p id="total_pages" class="rounded"><span id="count"> <? $x=mysql_query("SELECT * FROM fblike ORDER BY id DESC LIMIT 0,1"); $nr=0; while ($y=mysql_fetch_assoc($x)) { $id=$y['id']; $like=$y['like']; ?> <?=$id?><? echo substr(0,44);?> <? } ?></span> pages created</p> </div> <div id="page_details" class="rounded"> <h2>Create a New Page</h2> <p id="character_count"><span id="characters">50</span> characters available</p> <form method="POST" action="index.php"> <input type="text" name="like" class="comments" maxlength="50" value="Type your page name here ..."> <p id="url"></p> <button id="create_button" type="submit"></button> </form> </div>
the its only 1 table in the Database.
here is the whole Index.php file
Code:<? include ("config.php"); if ($_POST["like"]) { $like=$_POST["like"]; mysql_query("INSERT INTO fblike VALUES(NULL, '$like', '1')"); $x=mysql_query("SELECT * FROM fblike ORDER BY id DESC LIMIT 1"); while ($y=mysql_fetch_assoc($x)){ $id=$y['id']; } ?> <script type="text/javascript"> window.location.href="<?=$url_site?>like.php?id=<?=$id?>";</script> <? } ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"> <html lang="en"> <head> <title>Websie Title.</title> <link rel="stylesheet" href="styles.css"> <script type="text/javascript" src="js/jquery.js"></script> <script type="text/javascript" src="js/jquery.corner.js"></script> <script type="text/javascript" src="js/main.js"></script> </script> </head> <body> <div id="fb-root"></div> <script> window.fbAsyncInit = function() { FB.init({appId: '48272f6b9a278d88b2ec480da8790513', status: true, cookie: true, xfbml: true}); }; (function() { var e = document.createElement('script'); e.async = true; e.src = document.location.protocol + '//connect.facebook.net/en_US/all.js'; document.getElementById('fb-root').appendChild(e); }()); </script> <div id="header"> <a href="index.php" id="branding"><span>LikeItNow</span></a> <p id="total_pages" class="rounded"><span id="count"> <? $x=mysql_query("SELECT * FROM fblike ORDER BY id DESC LIMIT 0,1"); $nr=0; while ($y=mysql_fetch_assoc($x)) { $id=$y['id']; $like=$y['like']; ?> <?=$id?><? echo substr(0,44);?> <? } ?></span> pages created</p> </div> <div id="page_details" class="rounded"> <h2>Create a New Page</h2> <p id="character_count"><span id="characters">50</span> characters available</p> <form method="POST" action="index.php"> <input type="text" name="like" class="comments" maxlength="50" value="Type your page name here ..."> <p id="url"></p> <button id="create_button" type="submit"></button> </form> </div> <div id="popular_pages" class="rounded box_420"> <h2>Most Popular Pages</h2> <ul> <? $x=mysql_query("SELECT * FROM fblike ORDER BY hits DESC LIMIT 0,10"); $nr=0; while ($y=mysql_fetch_assoc($x)) { $id=$y['id']; $like=$y['like']; ?> <li><a href='like.php?id=<?=$id?>'><? echo substr($like, 0,44);?></a><br> </li> <? } ?> </ul> </div> <div id="new_pages" class="rounded box_420"> <h2>New Pages</h2> <ul> <? $x=mysql_query("SELECT * FROM fblike ORDER BY id DESC LIMIT 0,10"); $nr=0; while ($y=mysql_fetch_assoc($x)) { $id=$y['id']; $like=$y['like']; ?> <li><a href='like.php?id=<?=$id?>'><? echo substr($like, 0,44);?></a><br></li> <? } ?> </ul> </div> <p id="footer" class="rounded">LikeItNow © 2010. LikeItNow is not related to Facebook</p> </body> </html>
bxflow Reviewed by bxflow on . MySQL Error Im installed some script but i get this errors Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/XXXXXXX/public_html/index.php on line 99 line 99: while ($y=mysql_fetch_assoc($x)) Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/XXXXXXX/public_html/index.php on line 80 Rating: 5
Sponsored Links
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Similar Threads
-
MySQL Error
By KINGTHE_ALI in forum Webmaster DiscussionReplies: 4Last Post: 17th Nov 2011, 05:40 PM -
Database error-mysql error
By saini in forum vBulletinReplies: 8Last Post: 8th Nov 2011, 06:54 AM -
MYSQL Error while Import via MYSQL Dumper (Error
By desibreaker in forum Server ManagementReplies: 10Last Post: 5th Aug 2011, 07:26 PM -
MySQL Error
By II AnDo II in forum Web Application/Script SupportReplies: 2Last Post: 17th Aug 2009, 08:45 PM -
MySQL error
By mash-e1 in forum Webmaster DiscussionReplies: 2Last Post: 28th Mar 2009, 12:12 PM
themaLeecher - leech and manage...
Version 5.06 released. Open older version (or...