Learn VBA & Macros in 1 Week!

PHP - Warning: Mysql_fetch_array() Expects Parameter 1 To Be Resource, Boolean Given In (please Help Me With This Warning I Really Need This)

Full Excel VBA Course - Beginner to Expert

Warning: Mysql_fetch_array() Expects Parameter 1 To Be Resource, Boolean Given In (please Help Me With This Warning I Really Need This)	View Content

<?php
if(isset($_POST['submit'])){
$name = $_POST['name'];
}
?>
<form method="POST" action="hist1.php">
<br />
<input type="hidden" name="name" value="<?php echo $name ?>" />
<?php
$q = mysql_query("SELECT * FROM histact1 ORDER BY RAND() LIMIT 1");
while ($r1 = mysql_fetch_array($q)){
$id = $r1[0];
$question1 = $r1[1];
$opt1 = $r1[3];
$opt2 = $r1[4];
$opt3 = $r1[5]; 
?>


<div class="Qset" id="q1"><br /><br />
<label class="items">1st Question :</label> <br />
<center>
<textarea class="textareaQ" name="question1" readonly><?php echo $question1; ?></textarea>
</center>
<br /><br />
<p class="marA">
<input type="radio" name="rad1" value="<?php echo $opt1; ?>" />
<label class="lbl"><?php echo $opt1 ?></label><br />


<input type="radio" name="rad1" value="<?php echo $opt2; ?>" />
<label class="lbl"><?php echo $opt2 ?></label><br />


<input type="radio" name="rad1" value="<?php echo $opt3; ?>" />
<label class="lbl"><?php echo $opt3 ?></label><br />
</p>
</div>
<div class="lr">
<center>
<br /><br /><br /><br />
<a class="nxt"  href="#q2"><label title="Proceed to 2nd Question">Next</label></a>
</center> 
</div> 
<br /><br /><br />
<center><hr width="90%" /></center><br />
<?php } ?>


<br /><br />
<?php
$q = mysql_query("SELECT * FROM histact1 ORDER BY RAND() LIMIT 1");
while ($r1 = mysql_fetch_array($q)){
$id = $r1[0];
$question2 = $r1[1];
$opt1 = $r1[3];
$opt2 = $r1[4];
$opt3 = $r1[5]; 
?>


<div class="Qset" id="q2"><br /><br />
<label class="items">2nd Question :</label> <br />
<center>
<textarea class="textareaQ" name="q2" readonly><?php echo $question2; ?></textarea>
</center>
<br /><br />
<p class="marA">
<input type="radio" name="rad2" value="<?php echo $opt1; ?>" />
<label class="lbl"><?php echo $opt1 ?></label><br />


<input type="radio" name="rad2" value="<?php echo $opt2; ?>" />
<label class="lbl"><?php echo $opt2 ?></label><br />


<input type="radio" name="rad2" value="<?php echo $opt3; ?>" />
<label class="lbl"><?php echo $opt3 ?></label><br />
</p>
</div>
<div class="lr">
<center>
<br /><br /><br /><br />
<a class="nxt"  href="#q1"><label title="Proceed to 1st Question">Back</label></a> &nbsp;|&nbsp; 
<a class="nxt"  href="#q3"><label title="Proceed to 3rd Question">Next</label></a>
</center> 
</div> 
<br /><br /><br />
<center><hr width="90%" /></center><br />
<?php } ?>


<br /><br />
<?php
$q = mysql_query("SELECT * FROM histact1 ORDER BY RAND() LIMIT 1");
while ($r1 = mysql_fetch_array($q)){
$id = $r1[0];
$question3 = $r1[1];
$opt1 = $r1[3];
$opt2 = $r1[4];
$opt3 = $r1[5]; 
?>


<div class="Qset" id="q3"><br /><br />
<label class="items">3rd Question :</label> <br />
<center>
<textarea class="textareaQ" name="q3" readonly><?php echo $question3; ?></textarea>
</center>
<br /><br />
<p class="marA">
<input type="radio" name="rad3" value="<?php echo $opt1; ?>" />
<label class="lbl"><?php echo $opt1 ?></label><br />


<input type="radio" name="rad3" value="<?php echo $opt2; ?>" />
<label class="lbl"><?php echo $opt2 ?></label><br />


<input type="radio" name="rad3" value="<?php echo $opt3; ?>" />
<label class="lbl"><?php echo $opt3 ?></label><br />
</p>
</div>
<div class="lr">
<center>
<br /><br /><br /><br />
<a class="nxt"  href="#q2"><label title="Proceed to 2nd Question">Back</label></a> &nbsp;|&nbsp; 
<a class="nxt"  href="#q4"><label title="Proceed to 4th Question">Next</label></a>
</center> 
</div> 
<br /><br /><br />
<center><hr width="90%" /></center><br />
<?php } ?>


<br /><br />
<?php
$q = mysql_query("SELECT * FROM histact1 ORDER BY RAND() LIMIT 1");
while ($r1 = mysql_fetch_array($q)){
$id = $r1[0];
$question4 = $r1[1];
$opt1 = $r1[3];
$opt2 = $r1[4];
$opt3 = $r1[5]; 
?>


<div class="Qset" id="q4"><br /><br />
<label class="items">4th Question :</label> <br />
<center>
<textarea class="textareaQ" name="q4" readonly><?php echo $question4; ?></textarea>
</center>
<br /><br />
<p class="marA">
<input type="radio" name="rad4" value="<?php echo $opt1; ?>" />
<label class="lbl"><?php echo $opt1 ?></label><br />


<input type="radio" name="rad4" value="<?php echo $opt2; ?>" />
<label class="lbl"><?php echo $opt2 ?></label><br />


<input type="radio" name="rad4" value="<?php echo $opt3; ?>" />
<label class="lbl"><?php echo $opt3 ?></label><br />
</p>
</div>
<div class="lr">
<center>
<br /><br /><br /><br />
<a class="nxt"  href="#q3"><label title="Proceed to 3rd Question">Back</label></a> &nbsp;|&nbsp; 
<a class="nxt"  href="#q5"><label title="Proceed to 5th Question">Next</label></a>
</center> 
</div> 
<br /><br /><br />
<center><hr width="90%" /></center><br />
<?php } ?>


<br /><br />
<?php
$q = mysql_query("SELECT * FROM histact1 WHERE question != '$question1' AND question != '$question2' AND question != '$question3' AND question != '$question4' ORDER BY RAND() LIMIT 1");
while ($r1 = mysql_fetch_array($q)){
$id = $r1[0];
$question5 = $r1[1];
$opt1 = $r1[3];
$opt2 = $r1[4];
$opt3 = $r1[5]; 
?>


<div class="Qset" id="q5"><br /><br />
<label class="items">5th Question :</label> <br />
<center>
<textarea class="textareaQ" name="q5" readonly><?php echo $question5; ?></textarea>
</center>
<br /><br />
<p class="marA">
<input type="radio" name="rad5" value="<?php echo $opt1; ?>" />
<label class="lbl"><?php echo $opt1 ?></label><br />


<input type="radio" name="rad5" value="<?php echo $opt2; ?>" />
<label class="lbl"><?php echo $opt2 ?></label><br />


<input type="radio" name="rad5" value="<?php echo $opt3; ?>" />
<label class="lbl"><?php echo $opt3 ?></label><br />
</p>
</div>
<div class="lr">
<center>
<br /><br /><br /><br />
<a class="nxt"  href="#q4"><label title="Proceed to 4th Question">Back</label></a> &nbsp;|&nbsp; 
<input type="submit" title="Submit Answers" name="submit" class="submit" value=" Submit " onclick="return confirm('Are you sure you want to submit your answers?\nYou can review your answer by click the Back link')" />
</center> 
</div> 
<br /><br /><br />
<center><hr width="90%" /></center><br />
<?php } ?>
</form>

Edited by mac_gyver, 09 October 2014 - 10:51 AM.
code in code tags please

Full Excel VBA Course - Beginner to Expert

Warning: Mysql_fetch_array() Expects Parameter 1 To Be Resource, Boolean Given I

Similar Tutorials

View Content

hey. im new to php and i get this error and i dnt know how to make it r8.here is my code
and also i get undefined index for name/comment/submit but they all seems to work fine.please help

<?php
            require('contact.php');
            $name=$_POST["name"];
            $comment=$_POST["comment"];
            $submit=$_POST["submit"];

            if($submit){
               if($name&&$comment){
                  $insQry=mysql_query("INSERT INTO `comment`.`comment` (`name`,`comment`) VALUES ('$name','$comment')");
               }else{
                  echo "pleace Fill All the Fields";
               }
            }
         ?>
         <?php
         $getqry=mysql_query("SELECT * FROM comment ORDER BY id DECS");
         while($grows=mysql_fetch_array($getqry)){
         $id=$grows['id'];
         $name=$grows['name'];
         $comment=$grows['comment'];

         echo $name . "<br />".$comment."<br />"."<hr />";

         }
         ?>

Warning: Mysql_fetch_array() Expects Parameter 1 To Be Resource, Boolean Given I

Similar Tutorials

View Content

I am getting the below error message:

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\Program Files (x86)\EasyPHP-5.3.9\www\a.php on line 78

The two issues a

1. The red text I need to somehow use the DISTINCT function as it is duplicating a person for every skill they have.

2. The blue text is causing the error above, if I remove the join it works but assigns every possible skill to the person (because skill table and resource table are not joined). I therefore need the join there but without the error.

My code is below:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
   <html>
     <head>
     <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
     <title>Search Contacts</title>

<style type="text/css" media="screen">
   ul li{
     list-style-type:none;    }
   </style>
     </head>

     <p><body>
     <h3>Search Contacts Details</h3>
     <p>You may search either by first or last name</p>
     <form method="post" action="a.php?go" id="searchform">
     <input type="text" name="name">
     <input type="submit" name="submit" value="Search">
        </form>

<?php
     if(isset($_POST['submit'])){
     if(isset($_GET['go'])){
     if(preg_match("/^[ a-zA-Z]+/", $_POST['name'])){
     $name=$_POST['name'];

//connect to the database
     $db=mysql_connect ("127.0.0.1", "root", "") or die ('I cannot connect to the database because: ' . mysql_error());

//-select the database to use
     $mydb=mysql_select_db("resource matrix");


//-query the database table

     $sql="SELECT * FROM ((resource l inner join resource_skill ln on l.Resource_ID = ln.Resource_ID) inner join skill n on ln.Skill_ID = n.Skill_ID) WHERE First_Name LIKE '%" . $name . "%' OR Last_Name LIKE '%" . $name ."%' OR Skill_Name LIKE '%" . $name ."%'";

//-run the query against the mysql query function
     $result=mysql_query($sql);

//-create while loop and loop through result set
     while($row=mysql_fetch_array($result)){
     $First_Name =$row['First_Name'];
     $Last_Name=$row['Last_Name'];
     $Resource_ID=$row['Resource_ID'];

//-display the result of the array
     echo "<ul>\n";
     echo "<li>" . "<a href=\"a.php?id=$Resource_ID\">" .$First_Name . " " . $Last_Name . "</a></li>\n";
     echo "</ul>";
     }
     }
     else{
     echo "<p>Please enter a search query</p>";
     }
     }
     }

//end of our letter search script
if(isset($_GET['id'])){
$contactid=$_GET['id'];

//connect to the database
$db=mysql_connect ("127.0.0.1", "root", "") or die ('I cannot connect to the database because: ' . mysql_error());

//-select the database to use
$mydb=mysql_select_db("resource matrix");

//-query the database table
$sql="SELECT * FROM ((resource l inner join resource_skill ln on l.Resource_ID = ln.Resource_ID) inner join skill n on ln.Skill_ID = n.Skill_ID) WHERE Resource_ID=" . $contactid;

//-run the query against the mysql query function
$result=mysql_query($sql);

//-create while loop and loop through result set
while($row=mysql_fetch_array($result)){
     $First_Name =$row['First_Name'];
$Last_Name=$row['Last_Name'];
$Mobile_Number=$row['Mobile_Number'];
$Email_Address=$row['Email_Address'];
     $Level=$row['Level'];
     $Security_Cleared=$row['Security_Cleared'];
$Contract_Type=$row['Contract_Type'];
$Contract_Expiry=$row['Contract_Expiry'];
$Day_Rate=$row['Day_Rate'];
$Post_Code=$row['Post_Code'];
     $Skill_Name=$row['Skill_Name'];

//-display the result of the array
echo "<ul>\n";
echo "<li>" . $First_Name . " " . $Last_Name . "</li>\n";
echo "<li>" . $Mobile_Number . "</li>\n";
echo "<li>" . "<a href=mailto:" . $Email_Address . ">" . $Email_Address . "</a></li>\n";
echo "<li>" . $Level . "</li>\n";
echo "<li>" . $Security_Cleared . "</li>\n";
echo "<li>" . $Contract_Type . "</li>\n";
echo "<li>" . $Contract_Expiry . "</li>\n";
echo "<li>" . $Day_Rate . "</li>\n";
echo "<li>" . $Post_Code . "</li>\n";
echo "<li>" . $Skill_Name . "</li>\n";
echo "</ul>";
}
}

   ?>

   </body>
   </html>

Warning: Mysql_fetch_array() Expects Parameter 1 To Be Resource, Boolean Given..

Similar Tutorials

View Content

Hey all,

The mysql_query function is failing in the show function and I'm not sure why:

function index($item){
db_connect();
$query = "SELECT * FROM $item ORDER BY $item.id DESC";
$result = mysql_query($query);
$result = db_result_to_array($result);
return $result;
}

function show($item, $id){
db_connect();
$query = sprintf("SELECT * FROM $item WHERE $item.id = '%s",
mysql_real_escape_string($id));
$result = mysql_query($query);
$row = mysql_fetch_array($result);
return $row;
}

//Stuff that belongs in view
$books = index('books');

foreach($books as $book){
echo $book['title'].'</ br>';
}

$book = show('books', 1);
echo $book['title'].'</ br>';

Thanks for any response.

Warning: Mysql_fetch_array() Expects Parameter 1 To Be Resource Boolean Given In

Similar Tutorials

View Content

HELP ME TO CHANGE THE ERROR

<?PHP
//Include connection to database
include('connect.php');

//Get posted values from form
$status=$_POST['status'];
$date=$_POST['date'];

//Strip slashes
$status = stripslashes($status);
$date = stripslashes($date);

//Strip tags
$status = strip_tags($status);
$date = strip_tags($date);

//Inset into database

$insert_status = mysql_query(" insert into status (status) value ('$status')") or die (mysql_error());
$insert_status = mysql_query("insert into status (date) value ('$date')") or die (mysql_error());

while($row = mysql_fetch_array($insert_status)) { (ERROR IS IN THIS LINE)
$status=$row['status'];
$date=$row['date'];
}

//Line break after every 80
$status = wordwrap($status, 80, "\n", true);

//Line breaks
$status=nl2br($status);

//Display status from data base
echo '<div class="load_status">
<div class="status_img"><img src="blankSilhouette.png" /></div>
<div class="status_text"><a href="#" class="blue">Anonimo</a><p class="text">'.$status.'</p>
<div class="date">'.$date.' · <a href="#" class="light_blue">Like</a> · <a href="#"
class="light_blue">Comment</a></div>
</div>
<div class="clear"></div>
</div>';
?>

Warning: Mysql_fetch_array() Expects Parameter 1 To Be Resource, Boolean Given

Similar Tutorials

View Content

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\wamp\www\ajaxpages\attendance\student_attendance.php on line 7

<?php $i=1;?>
<?php error_reporting();include("../../connect.php"); session_start();

$class_id = $_POST['class_id'];

$query = mysql_query("SELECT * FROM attendance WHERE class='$class_id' ORDER BY student ASC ");
while($row = mysql_fetch_array($query)) ####LINE 7<----------------------------------------
{
?>
<li><div class="num"><?php print $i++?></div><?php print $row['student']; ?></li>
<?php }?>

Warning: Mysql_fetch_array() Expects Parameter 1 To Be Resource, Boolean Given I

Similar Tutorials

View Content

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\New\cartnisya.php on line 15
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\New\cartnisya.php on line 74
CODE
$db = mysql_connect("localhost", "root","");
mysql_select_db("vinnex",$db);
mysql_query("Delete From temptransaction",$db);
//mysql_query("Delete From temporderdetails",$db);
$Username = $_POST['Username'];
$Password = $_POST['Password'];
$result = mysql_query("Select TransNo From transaction", $db);
$myrow = mysql_fetch_array($result);
if ($myrow=='')
{
   $TransNo='1000';
   $q = mysql_query("Select Username, Lastname, Firstname From customer where Username=$Username, Lastname=$Lastname, Firstname=$Firstname ");
   $myrow1 = mysql_fetch_array($q);
   $Username = $myrow1['Username'];
   $Firstname = $myrow1['Firstname'];
   $Lastname = $myrow1['Lastname'];
   $name = $Firstname. " ".$Lastname;
   $sql1 = " INSERT INTO temptransaction (TransNo, Username, Firstname, Date)
           VALUES ('$TransNo', '$Username', '$Firstname', '$Date')";
   $result = mysql_query($sql1) or die(mysql_error());
}
else
{
   $sql = mysql_query("Select max(TransNo) maxTransNo From transaction", $db);
   $myrow1 = mysql_fetch_array($sql);
   $orderno = $myrow1['maxTransNo']+1;
   $sql = mysql_query("Select Username, Lastname, Firstname From customer where Username=$Username, Lastname=$Lastname, Firstname=$Firstname");
   $myrow1 = mysql_fetch_array($sql);
   $Username = $myrow1['Username'];
   $Firstname = $myrow1['Firstname'];
   $Lastname = $myrow1['Lastname'];
   $Date = date('m/d/y');
   $sql1 = " INSERT INTO temptransaction (TransNo, Username, Firstname, Date)
           VALUES ('$TransNo', '$Username', '$Firstname', '$Date')";
   $result = mysql_query($sql1) or die(mysql_error());
}

please help masters im just newbie in php.

Warning: Mysql_fetch_array() Expects Parameter 1 To Be Resource, Boolean Given I

Similar Tutorials

View Content

Code: [Select]
<?php
$limit=12;
if(isset( $_GET['page']))
      $page=$_GET['page'];
      if($page<=0) $page = 1;

      else {$start=0;}
   $sql=mysql_query('select * from tbl_gallery where status=1 AND category_name="0"');
   $count=mysql_num_rows($sql);
   $totalcount=ceil($count/$limit);
   $start=($page-1)*$limit;
   $s=mysql_query('select * from tbl_gallery where status=1 AND category_name="0" limit $start, $limit');
   while($result=mysql_fetch_array($s)){
      $start++;

?>

MOD EDIT: code tags added.

Warning: Mysql_fetch_array() Expects Parameter 1 To Be Resource, Boolean Given In

Similar Tutorials

View Content

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\websiteku\modul\laporan\laporan.php on line 48

 
$query2 = "SELECT count(*) as jum1 FROM transaksi WHERE nama_kategori = '$namaBidang' AND nama_bayar = Uang";
  $hasil2 = mysql_query($query2);
  $data3 = mysql_fetch_array($hasil2);
  $jumGol1 = $data3['jum1'];

help me guys, how i fix this problem ??

Warning: Mysql_fetch_array() Expects Parameter 1 To Be Resource, Boolean Given I

Similar Tutorials

View Content

I have that error repeated alot : here are the other errors

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given i
n C:\Users\Andrew Hunt\Desktop\iFox.snap\Engines\MySQL\MySQL.php on line 14

Warning: mysql_free_result() expects parameter 1 to be resource, boolean given i
n C:\Users\Andrew Hunt\Desktop\iFox.snap\Engines\MySQL\MySQL.php on line 15

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given i
n C:\Users\Andrew Hunt\Desktop\iFox.snap\Engines\MySQL\MySQL.php on line 14

Warning: mysql_free_result() expects parameter 1 to be resource, boolean given i
n C:\Users\Andrew Hunt\Desktop\iFox.snap\Engines\MySQL\MySQL.php on line 15

The first 20 lines look like this :
Code: [Select]
final class MySQL {
const ASSOC = MYSQL_ASSOC;

public static function Connect($func_host, $func_user, $func_pass) { return mysql_connect($func_host, $func_user, $func_pass); }
public static function Select($func_database) { return mysql_select_db($func_database); }
public static function &Query($func_query) { return mysql_query($func_query); }
public static function FetchArray(&$func_res, $func_type) { return mysql_fetch_array($func_res, $func_type); }
public static function FreeResult(&$func_res) { return mysql_free_result($func_res); }
public static function Error() { return mysql_error(); }

public static function GetData($func_statement) {
$func_retVal = array();

$func_res = self::Query($func_statement);
while($func_line = self::FetchArray($func_res, MySQL::ASSOC)) $func_retVal[] = $func_line;
MySQL::FreeResult($func_res);

return $func_retVal;
}

public static function Insert($func_table, $func_data) {
Thanks for help and the mysql info is correct..

Warning: Mysql_fetch_array() Expects Parameter 1 To Be Resource, Boolean Given I

Similar Tutorials

View Content

Full error:
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\MyWebsite\poll\functions.php on line 28

Been working all day to set up some stuff in my website. Now currently working on the poll. Been stuck on this error and I don't know what to do.

That's the function that throws this:

Any help would be appreciated.

Code: [Select]
function getPoll($pollID){
$query = "SELECT * FROM polls LEFT JOIN pollAnswers ON polls.pollID = pollAnswers.pollID WHERE polls.pollID = " . $pollID . " ORDER By pollAnswerListing ASC";
$result = mysql_query($query);
//echo $query;jquery

$pollStartHtml = '';
$pollAnswersHtml = '';

while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
$pollQuestion = $row['pollQuestion'];
$pollAnswerID = $row['pollAnswerID'];
$pollAnswerValue = $row['pollAnswerValue'];

if ($pollStartHtml == '') {
$pollStartHtml = '<div id="pollWrap"><form name="pollForm" method="post" action="poll/functions.php?action=vote"><h3>' . $pollQuestion .'</h3><ul>';
$pollEndHtml = '</ul><input type="submit" name="pollSubmit" id="pollSubmit" value="Vote" /> <span id="pollMessage"></span></form><>';
}
$pollAnswersHtml = $pollAnswersHtml . '<li><input name="pollAnswerID" id="pollRadioButton' . $pollAnswerID . '" type="radio" value="' . $pollAnswerID . '" /> ' . $pollAnswerValue .'<span id="pollAnswer' . $pollAnswerID . '"></span></li>';
$pollAnswersHtml = $pollAnswersHtml . '<li class="pollChart pollChart' . $pollAnswerID . '"></li>';
}
echo $pollStartHtml . $pollAnswersHtml . $pollEndHtml;
}

Warning: Mysql_fetch_array() Expects Parameter 1 To Be Resource, Boolean Given I

Similar Tutorials

View Content

I can't find what's wrong with the code...

<?php
$Sql = "select team1, team2, t1outcome, t2outcome, winner from coupons where user='$User'";
$Result = mysql_query($Sql, $Link);
print "<table cellpadding=0 cellspacing=0 border=0>";
print "<tr>";
print "<td align=left valign=top>     </td>";
print "<td align=left valign=top> </td>";
print "</tr>";
while($Row = mysql_fetch_array($Result)){

if($Row[team1] == $Row[winner]){
print "<tr>";
print "<td align=left valign=top>     </td>";
print "<td align=left valign=top><bold>$Row[team1]</bold> - $Row[team2] $Row[t1outcome]-$Row[t2outcome]</td>";
print "</tr>";
} else {
print "<tr>";
print "<td align=left valign=top>     </td>";
print "<td align=left valign=top>$Row[team1] - $Row[team2] $Row[t1outcome]-$Row[t2outcome]</td>";
print "</tr>";
}

}
print "</table>";

mysql_close($Link);
?>

Warning: Mysql_fetch_array() Expects Parameter 1 To Be Resource, Boolean Given In /home/path/public_html/path/path/stats.php On Line 41

Similar Tutorials

View Content

Hi!

So I'm working for someone, and they want me to fix this error in a PHP file..

Here is the code:

<?php
    include_once('config.php');
    
    $online = mysql_query("SELECT * FROM bots WHERE status LIKE 'Online'");
    $offline = mysql_query("SELECT * FROM bots WHERE status LIKE 'Offline'");
    $dead = mysql_query("SELECT * FROM bots WHERE status LIKE 'Dead'");
    $admintrue = mysql_query("SELECT * FROM bots WHERE admin LIKE 'True'");
    $adminfalse = mysql_query("SELECT * FROM bots WHERE admin LIKE 'False'");
    $windows8 = mysql_query("SELECT * FROM bots WHERE so LIKE '%8%'");
    $windows7 = mysql_query("SELECT * FROM bots WHERE so LIKE '%7%'");
    $windowsvista = mysql_query("SELECT * FROM bots WHERE so LIKE '%vista%'");
    $windowsxp = mysql_query("SELECT * FROM bots WHERE so LIKE '%xp%'");
    $unknown = mysql_query("SELECT * FROM bots WHERE so LIKE 'Unknown'");
    $totalbots = mysql_num_rows(mysql_query("SELECT * FROM bots"));

    $onlinecount = 0;
    $offlinecount = 0;
    $deadcount = 0;

    $admintruecount = 0;
    $adminfalsecount = 0;

    $windows8count = 0;
    $windows7count = 0;
    $windowsvistacount = 0;
    $windowsxpcount = 0;
    $unknowncount = 0;

    while($row = mysql_fetch_array($online)){
        $onlinecount++;
    }
                 
    while($row = mysql_fetch_array($offline)){
        $offlinecount++;
    }
                 
    while($row = mysql_fetch_array($dead)){
        $deadcount++;
    }
                 
    while($row = mysql_fetch_array($admintrue)){
        $admintruecount++;
    }
                 
    while($row = mysql_fetch_array($adminfalse)){
        $adminfalsecount++;
    }
    
    while($row = mysql_fetch_array($windows8)){
        $windows8count++;
    }
                 
    while($row = mysql_fetch_array($windows7)){
        $windows7count++;
    }
                 
    while($row = mysql_fetch_array($windowsvista)){
        $windowsvistacount++;
    }
                 
    while($row = mysql_fetch_array($windowsxp)){
        $windowsxpcount++;
    }
                 
    while($row = mysql_fetch_array($unknown)){
        $unknowncount++;
    }

    $statustotal    = $onlinecount + $offlinecount + $deadcount;
    $admintotal     = $admintruecount + $adminfalsecount;
    $sototal        = $windows7count + $windowsvistacount + $windowsxpcount + $unknowncount;
?>

Can anyone tell me the error here, can how to fix it?

Warning: Mysql_fetch_array() Expects Parameter 1 To Be Resource

Similar Tutorials

View Content

I am trying to install a comments box, im new to php and mysql so havent been able to work this out for myself following other threads, hope someone can shed some light on the problem.

The posts ive entered arent being returned to the page essentially and im getting the error: Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in commentbox.php on line 42.

This is the code from the entire page.

Code: [Select]
<?php
require('commentconnect.php');
$name=@$_POST['name'];
$comment=@$_POST['comment'];
$submit=@$_POST['submit'];
if($submit)
{
if($name&&$comment)
{
$insert=mysql_query("INSERT INTO commenttable (name,comment) VALUES ('$name','$comment')");
/*header("Location: index.php");*/
echo "<script>document.location.href='index.php'</script>";
echo "<script>'Content-type: application/octet-stream'</script>";
}
else
{
echo "Please fill out the fields";
}
}
?>

<div id="commentdiv">

<div id="commentinput">

<form action="index.php" method="POST">
<table>
<tr><td>Name: </td><td><input type="text" name="name" /></td></tr>
<tr><td colspan="2">Comment: </td></tr>
<tr><td colspan="2"><textarea name="comment"></textarea></td></tr>
<tr><td colspan="2"><input type="submit" name="submit" value="Comment" /></td></tr>

</table>
</form>

</div>

<div id="commentarea">

<?php
$getquery=mysql_query("SELECT * FROM commenttable ORDER BY id DESC");
while($rows=mysql_fetch_array($getquery))
{
$id=$rows['id'];
$name=$rows['name'];
$comment=$rows['comment'];
$dellink="<a href=\"delete.php?id=" . $id . "\"> Delete </a>";
echo $name . '' . '<br />' . $comment . '<br />' . '<hr/>';
}
?>
</div>

</div>

Any help is greatly appreciated!

Warning: Mysql_result() Expects Parameter 1 To Be Resource, Boolean Given

Similar Tutorials

View Content

I have this code

Code: [Select]
$id = $_GET['esitysid'];
$esitysnimi = mysql_query("SELECT * FROM varasto WHERE id = '".$id."", $yhteys);
print "esitysnimi $esitysnimi";
$esitysnim = mysql_result($esitysnimi, "0", "nimi");
varasto:
Code: [Select]
nimi hinta maara id lippuja
Esitys Nimi 1 10 14 0 5
Esitys Nimi 2 120 5 1 0
Esitys Nimi 3 950 5 2 0
and it says

Code: [Select]
Warning: mysql_result() expects parameter 1 to be resource, boolean given
How can I fix it? Thank you for help

Warning: Mysql_result() Expects Parameter 1 To Be Resource, Boolean Given In D:\

Similar Tutorials

View Content

don't know what to do next with this error popping up,,,any help?

<?php
      //set up the variables
      $loguser = $_POST['loguser'];
      $logpass = md5($_POST['logpass']);
      $login = $_get['login'];

      //connect with the server and the database
      mysql_connect("localhost","root","") or die("Can't connect with the Server!");
      mysql_select_db("comp3project") or die("Can't connect with the database!");

      if($login="yes")
      {
         $get = mysql_query("SELECT count(cid) FROM customer_data WHERE username = '$loguser'
            and password = '$logpass'");
         $result = mysql_result($get,0);

         if($result!=1){print "Login Failed!";}
         else {print "Login Successful!";}
      }
   ?>

Warning: Mysql_num_rows() Expects Parameter 1 To Be Resource, Boolean Given In

Similar Tutorials

View Content

i give it up after 4 h.

please help me, what i do wrong

Warning: Mysql_fetch_assoc() Expects Parameter 1 To Be Resource, Boolean Given

Similar Tutorials

View Content

When i try and use this app on my website i get the error,
Code: [Select]
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/unionc/public_html/auction/scripts/updateTables.php on line 15
Code: [Select]
<?php
    $now = time();

add_column_if_not_exist("WA_SellPrice", "seller", "VARCHAR( 255 ) NULL");
add_column_if_not_exist("WA_SellPrice", "buyer", "VARCHAR( 255 ) NULL");
add_column_if_not_exist("WA_Players", "canBuy", "INT(11) NOT NULL DEFAULT  '0'");
add_column_if_not_exist("WA_Players", "canSell", "INT(11) NOT NULL DEFAULT  '0'");
add_column_if_not_exist("WA_Players", "isAdmin", "INT(11) NOT NULL DEFAULT  '0'");
add_column_if_not_exist("WA_Auctions", "created", "INT(11) NULL");

function add_column_if_not_exist($table, $column, $column_attr){
    $exists = false;
    $columns = mysql_query("show columns from $table");
    while($c = mysql_fetch_assoc($columns)){
        if($c['Field'] == $column){
            $exists = true;
            break;
        }
    }
    if(!$exists){
        mysql_query("ALTER TABLE `$table` ADD `$column`  $column_attr");
    }
}

?>Please Help!

Warning: Mysql_fetch_assoc() Expects Parameter 1 To Be Resource, Boolean Given I

Similar Tutorials

View Content

Hi, I'm fairly new to PHP and have run into this problem, I have tried looking through some other peoples solutions to this but don't quite understand them!

I have set up a simple news post on a website which works fine, however when I go to edit a post and try to submit it again it comes up with this error:

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /Users/mdfcows/Sites/atelier/editnews.php on line 61

It still works, i.e. posts it, however I don't quite know what this means, and now I am trying to set it up so that another page can be edited and all I am getting is the same error on the page without any of the other info or PHP coming up!

this is the PHP I am using, with the line
"while ($row = mysql_fetch_assoc ($result)) {"
being line number 61

Code: [Select]
<?php
require_once('config.php');

$con = mysql_connect(DB_HOST,DB_USER,DB_PASSWORD);
if (!$con){
die('Failed to connect to server' . mysql_error());
}

mysql_select_db(DB_DATABASE);

$ide = $_POST[idf];
$query = "SELECT image,id,title,text FROM news WHERE id = $ide";
$result = mysql_query($query);

while ($row = mysql_fetch_assoc ($result)) {
$title = htmlentities ($row['title']);
$news = nl2br (strip_tags ($row ['text'], '<a><b><i><u>'));
$image = $row['image'];

echo "<form class ='addform' action='editnews.php' enctype='multipart/form-data' method='post'>";
echo "<input type='hidden' name='ida' value='$ide' />";
echo "<p>Title:<br /><input class='titlefield' type='text' name='title' value='$title' /></p><br />";
echo "<p>News Post:<br /> <textarea name='news' rows='12' cols='50'>$news</textarea></p><br />";
echo "<p>If you uploaded an image with your post you will need to upload it again<br /><input type='hidden' name='MAX_FILE_SIZE' value='20000000' /> <input name='userfile' type='file' value='$image' id='userfile' /></p><br />";
echo "<p><input name='submit' type='submit' value='Submit' /></p>";
echo "</form>";
}

if ($_POST['submit'])
{

  mysql_select_db(DB_DATABASE);

  $upid = $_POST[ida];
  $uptitle = $_POST[title];
  $upnews = $_POST[news];
  $upimage = $_FILES['userfile']['name'];

  $sql = "UPDATE news SET title = '$uptitle', text = '$upnews', image = '$upimage' WHERE id = '$upid'";

  mysql_query($sql);

  if ($_POST['submit'])
  {

  echo "<p class='admintext'>Your post has been Edited - <a href='index.php'>View Latest News Page</a></p><br />";
  $name = $_FILES['userfile']['name'];
  $type = $_FILES['userfile']['type'];
  $size = $_FILES['userfile']['size'];
  $tmpname = $_FILES['userfile']['tmp_name'];
  $ext = substr($name, strrpos($name, '.'));

  if (strstr($type, "image"))
  {
  move_uploaded_file($tmpname, "images/".$name);
  }

  }
}

?>

Any help would be much appreciated!

Thank you

Martin

Warning: Mysql_num_rows() Expects Parameter 1 To Be Resource, Boolean Given In

Similar Tutorials

View Content

i am try to make a name, address search system into my website from my database. but i got this msg [Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampplite\htdocs\3\searchresult.php on line 54]

my full php code i.e. searchresult.php is under......

what i have mistake.....

searchresult.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=iso-8859-1" />
<title>Untitled Document</title>
</head>

<body>
<?php

// TAKE THE INFORMATION FROM FORM.

$search = $_GET['search'];

// IF THERE IS NOT A KEYWORD GIVE A MISTAKE.

if (!$search)

echo "You didn't enter a keyword";

else

{

echo "<td>You searched for: <strong>$search </strong></td>";

mysql_connect('localhost','root','');

mysql_select_db('search');

$id=@$_GET['id'];

//QUERY IS THE CODE WHICH WILL MAKE THE SEARCH IN YOUR DATABASE.

//I WROTE AN EXPLANATION ABOUT IT AFTER THE CODE.

$sql = "CREATE TABLE searchform \n"
    ."(\n"
    ."ID int NOT NULL AUTO_INCREMENT ,\n"
    ."FirstName varchar( 255 ) NOT NULL ,\n"
    ."LastName varchar( 255 ) NOT NULL ,\n"
    ."Email varchar( 255 ) NOT NULL ,\n"
    ."PhoneNumber varchar( 255 ) NOT NULL ,\n"
    ."PRIMARY KEY ( ID ) )";;

$result1 = MySQL_query($query);

if(!$result1) {

echo MySQL_error()."<br>$query<br>";

}

if(MySQL_num_rows($result1) > 5) {

echo "<table width='750' align='center' border='0' cellspacing='0' cellpadding='0'>";

while($result2 = MySQL_fetch_array($result1)) {

//A short description from category.

$description = $result2['category'];

$searchPosition = strpos($description, $search);

$shortDescription = substr($description, $searchPosition, 150);

// I added a link to results which will send the user to your display page.

echo '<tr><td><p><strong><a href="displayresults.php?id='.$result2['id'].'">'.$result2['title'].'</strong></p></td></tr>';

echo "<tr><td>$shortDescription ...</td></tr>";

echo "<td>{$result2['name']} {$result2['surname']}</td><tr/>";

}

echo "</table>";

}else {

echo "No Results were found in this category.<br>";

}echo "<br>";

}

?>

</body>
</html>

and

searchform.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=iso-8859-1" />
<title>Untitled Document</title>
</head>

<body>
<form action="searchresult.php" method="get">

<div align="center">

<p>

<input name="search" type="text" size="60"/>

<input name="submit" type="submit" value="Search" />

</p>

</div>

</form>
</body>
</html>

Warning: Mysql_result() Expects Parameter 1 To Be Resource, Boolean Given

Similar Tutorials

View Content

Hi there
I am having a problem with this warning message being thrown
"Warning: mysql_result() expects parameter 1 to be resource, boolean given in C:\wamp\www\css\rnfunctions.php on line 302"
and again for line 303
Here is the code

function receiveuserchange()
{
if (isset($_POST['level'])){
$query = "SELECT * FROM users";
$result=mysql_query($query) or die("Invalid Query : ".mysql_error());
$num=mysql_numrows($result);
$i=0;

while ($i < $num) {

////////////////here are lines 302 and 303///////////////////////////////
$user=mysql_result($result,$i,"user");
$id=mysql_result($result,$i,"id");
/////////////////////////////////////////////////////////////////////////////

if (isset($_POST["$user"])){
$level = ($_POST["$user"]);
$query = "update profiles set level='$level' where pid='$id'";
$result=mysql_query($query) or die("Invalid Query : ".mysql_error());
ViewUsers('viewusers.php');
}else{
echo "$user not recieved";
}
$i++;
}

Can anyone see what the problem is?