Posts by srinivas88

Re: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result in PHP

3 Years Ago

-1

now line 38 is line 40...save code as any xyz.php....modify form action as xyz.php and u can see the error...

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\admin_loggedin_search_admin.php on line 40

srinivas88

Light Poster

39 posts since Nov 2009

Reputation Points: 10

Solved Threads: 0

Skill Endorsements: 0

Re: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result in PHP

3 Years Ago

-1

now the search functionality has failed.....error:
SQL Syntax Error - query was:

Unknown column '' in 'where clause'

code is

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
	<title>Search for Administrators</title>
</head>

<body bgcolor="#FF9900" text="#FFFFCC" link="#FFFFFF" vlink="#FF3300" alink="#FFFF00">

<table width="1080">

<tr>

        
    <td width="710">
    <p>Search For Administrators
    <hr size="1">         <p/>
		 <form action="admin_loggedin_search_admin.php" method="post">
         Search by :
           <select name="searchby">
                      <option value="" SELECTED>-Select One-</option>
                      <option value="name" >Name</option>
                      <option value="state">State</option>
                      <option value="username">Username</option>
           </select>
		   <input type="text" name="query" size="10" maxlength="100" >  
           <input type="submit" name="submit" value="submit">
 <?php
$con = mysql_connect("localhost","root","");
if(!$con)
  { 
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db("polling",$con);
$query1 = "SELECT * FROM administrator WHERE ".$_POST[searchby]." like  '%".$_POST[query]."%'";
$result = mysql_query($query1);
//$result=mysql_query("SELECT * FROM administrator WHERE $_POST[searchby] LIKE '%$_POST[query]%'" );
//$query1 = 'SELECT * FROM `administrator` WHERE `'.mysql_real_escape_string($_POST['searchby']).'` LIKE "%'.mysql_real_escape_string($_POST['query']).'%"';
//mysql_query($query1) or die('SQL Syntax Error - query was: <u>'.$query.'</u><hr>'.mysql_error());
$found=0;
while($sri=mysql_fetch_array($result))
{
 if($sri['name']!="")
 {
 $found++;
 echo "<br />&nbsp;&nbsp;&nbsp;&nbsp;".$sri['name']."->".$sri['username'];
 }
}
if($found!=0)
{echo "<br />Found ".$found." results!";}


/*if(!mysql_query($sri,$con))
{
 die('Error: '.mysql_error());
}*/
mysql_close($con)
?>
 
<td width="270">
<td width="170">
<p>Search For
<hr size="1">
</p>
<a href="admin_loggedin_search_voter.php" title="Search for Voters" >Voters</a>
<p><a href="admin_loggedin_search_candidate.php" title="Search for Candidates" >Candidates</a></p>
<p><a href="admin_loggedin_search_officer.php" title="Search for Officers" >Officers</a></p>

<tr/>
</table>
</body>
</html>

srinivas88

Light Poster

39 posts since Nov 2009

Reputation Points: 10

Solved Threads: 0

Skill Endorsements: 0

Re: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result in PHP

3 Years Ago

-1

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\admin_loggedin_search_admin.php on line 38....and the code is same as above....Does the name of the file make any difference in PHP.for instance saving a file as loginpage.php or login_page.php

srinivas88

Light Poster

39 posts since Nov 2009

Reputation Points: 10

Solved Threads: 0

Skill Endorsements: 0

Re: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result in PHP

3 Years Ago

-1

please help me...even i m getting this error:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\admin_loggedin_search_admin.php on line 35

<?php $con = mysql_connect("localhost","root",""); if(!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("polling",$con); $result = mysql_query("SELECT * FROM administrator WHERE $_POST[searchby] like '%$_POST[query]%'"); $found=0; [LINE 35]while($sri=mysql_fetch_array($result)) { if($sri['name']!="") { $found++; echo "     ".$sri['name']."->".$sri['username']."<br />"; } } if($found!=0) {echo "Found ".$found." results!";} mysql_close($con) ?> [code/][code=php]
<?php
$con = mysql_connect("localhost","root","");
if(!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("polling",$con);
$result = mysql_query("SELECT * FROM administrator WHERE $_POST[searchby] like '%$_POST[query]%'");
$found=0;
[LINE 35]while($sri=mysql_fetch_array($result))
{
if($sri!="")
{
$found++;
echo "     ".$sri."->".$sri."<br />";
}
}
if($found!=0)
{echo "Found ".$found." results!";}
mysql_close($con)
?>
[code/]

srinivas88

Light Poster

39 posts since Nov 2009

Reputation Points: 10

Solved Threads: 0

Skill Endorsements: 0

Posts by srinivas88 which have been Voted Down

Re: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result in PHP

Re: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result in PHP

Re: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result in PHP

Re: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result in PHP