MySQL_Narb Posted October 20, 2009 Share Posted October 20, 2009 Error: Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/runevid/public_html/Quests/finished_tutorial.php on line 28 Code: <?php $username = $_SESSION['username']; //connect $connect = mysql_connect("l","","pebopebogizmo96") or die("Connection failed!"); mysql_select_db("runevid_betas") or die("Database fail!"); //check to see if they have or haven't done the quest $get = mysql_query("SELECT * FROM betas"); while ($row = mysql_fetch_assoc($get)) $check = $row['quest1']; if ($check ==1) { echo "<br /><br />It seems you've already done this quest and gained your reward.<br /><br />"; } else { //write $update_complete = mysql_query("UPDATE betas SET quest1 = quest1 + 1 WHERE username='$username'"); $points = mysql_query("UPDATE betas SET points = points + 3 WHERE username='$username'"); echo "<b><span style='color:green'>You have completed quest and gained 3 points!</span></b>"; } ?> Link to comment https://forums.phpfreaks.com/topic/178394-solved-mysql-error/ Share on other sites More sharing options...
MySQL_Narb Posted October 20, 2009 Author Share Posted October 20, 2009 Never mind, fixed! Link to comment https://forums.phpfreaks.com/topic/178394-solved-mysql-error/#findComment-940763 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.