PHP - Mysql_fetch_assoc() Expects Parameter 1 To Be Resource, Boolean Given In ....

i am having problem with this error, could you please help me

Code: [Select]
function cart () {
foreach($_SESSION as $name => $value) {
if ($value>0) {
if (substr($name, 0, 5) == "cart_") {
$productid = substr($name, 5, (strlen($name)-5));
$query = mysql_query("SELECT ProductID, Name, Price FROM product WHERE ProductID = '".mysql_real_escape_string((int)$productid."'"));
while ($query_row = mysql_fetch_assoc($query)) {
$sub = $query["Price"]*$Value;
echo $query["Name"]. ' x ' .$value. ' @ '.$query["Price"]. ' = '.$sub.'<br />';
}
}
}
else {
echo "<p>Your Shopping Basket is empty</p>";
}
}
}

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

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!

Hello,
Im developing simple user registration system with my knowledge.but got this error with this file

Code: [Select]
<?php
//database connection
require_once("dbconnection/connect.php");

$success_massage ="";

if (isset($_POST['hiddenstudentid']))
$passstudent_id=$_POST['hiddenstudentid'];
else 
$passstudent_id=$_POST['student_id_hidden'];


$sql=mysql_query("SELECT * FROM student WHERE StudentID=$passstudent_id");
echo $sql;


while ($row=mysql_fetch_assoc($sql))
{
$update_nic=$row['NIC'];
$update_name=$row['Student_Name'];
$update_addr=$row['Address'];
$take_bday=$row['Birthday'];
echo $take_bday;
$update_bday=date('d',strtotime($take_bday));
$update_month=date('m',strtotime($take_bday));
$update_year=date('y',strtotime($take_bday));
$update_tele=$row['Telephone'];
$update_email=$row['Email'];

}

if (isset($_POST['btnupdate']))
{
$insert_nic=$_POST['nic_txt'];
$insert_name=$_POST['name_txt'];
$insert_addr=$_POST['address_txt'];
$insert_bday=$_POST['bdate'];
$insert_month=$_POST['bmonth'];
$insert_year=$_POST['byear'];
$insert_tele=$_POST['telephone_txt'];
$insert_email=$_POST['email_txt'];

$Birthday =date("$insert_year-$insert_month-$insert_bday");//Bday eka $Birthday ta set kereema.


$sql="update student set NIC='$insert_nic',Student_Name='$insert_name',Address='$insert_addr',Birthday='$Birthday',Telephone='$insert_tele',Email='$insert_email' where StudentID=$passstudent_id" ;

/*(Student_ID,NIC,Student_Name,Address,Birthday,Telephone,Email)values('$student_id','$insert_nic','$insert_name','$insert_addr','$Birthday','$insert_tele','$insert_email')";*/

//echo $sql;
$result=mysql_query($sql) or die ("database error");

$success ="Records updated successfully";
$success_massage =$success;
header('Location:editdisplay.php');
}
if ($_POST['btndelete']=='DELETER')
{
$delete = "delete from student where StudentID=$passstudent_id";
$result =mysql_query($delete) or die ("data deleting error");

$delete_massage="Record deleted";
//$success_massage = $delete_massage;

}
if (isset($_POST['btncancel']))
{
header ('Location:registration.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" />
<title>Untitled Document</title>
<script type="text/javascript">
function GetConfirmation()
{
var res=confirm("Are you sure to delete this Student?");

if(res==true)
{
var btn=document.getElementById("btndelete");
btn.value="DELETER";
        // alert ("YES");
document.editForm.submit();

}
}

</script>


</head>

<body>
<form id="form1" name="form1" method="post" action="">
  <table width="406" border="1">
    <tr>
      <td width="149">&nbsp;</td>
      <td width="241">Student Registration</td>
    </tr>
    <tr>
      <td>NIC</td>
      <td><label for="nic_txt"></label>
      <input type="text" name="nic_txt" id="nic_txt" value="<?php echo $update_nic ?>" /><input type="hidden" name="student_id_hidden" id="student_id_hidden" value="<?php echo $passstudent_id ?>" />
      </td>
    </tr>
    <tr>
      <td>Name</td>
      <td><label for="name_txt"></label>
      <input type="text" name="name_txt" id="name_txt" value="<?php echo $update_name ?>" /><span style="color:#F00"><?php echo $massage_name?></span></td>
    </tr>
    <tr>
      <td>Address</td>
      <td><label for="address_txt"></label>
      <input type="text" name="address_txt" id="address_txt" value="<?php echo $update_addr ?>" /><span style="color:#F00"><?php echo $massage_address?></span></td>
    </tr>
    <tr>
      <td>Birthday</td>
      <td><label for="bdate"></label>
        <select name="bdate" id="bdate">
        <option selected="selected"><?php echo $update_bday ?></option>
        <?php 
 
  for ( $i=1;$i<=31;$i++)
 {echo '<option>'.$i.'</option>';
  }
?>
        </select>
        <label for="bmonth"></label>
        <select name="bmonth" id="bmonth">
        <option selected="selected"><?php echo $update_month ?></option>
        <?php 
echo '<option>'.'-month-'.'</option>';
for ($b=1;$b<=12;$b++)
 {echo '<option>'.$b.'</option>';

}
?>
        </select>
        <label for="byear"></label>
        <select name="byear" id="byear" />
        <option selected="selected"><?php echo $update_year ?></option>
        <?php 
echo '<option>'.'-year-'.'</option>';
for ($b=1960;$b<=2000;$b++)
 {echo '<option>'.$b.'</option>';

}
?>
       
      </select><span style="color:#F00"><?php echo $massage_bday?></span></td>
    </tr>
    <tr>
      <td>Email</td>
      <td><label for="email_txt"></label>
      <input type="text" name="email_txt" id="email_txt" value="<?php echo $update_email?>" /></td>
    </tr>
    <tr>
      <td>Telephone</td>
      <td><label for="telephone_txt"></label>
      <input type="text" name="telephone_txt" id="telephone_txt" value="<?php echo $update_tele?>"/></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td><input type="submit" name="btnupdate" id="btnupdate" value="Update" />
     
      <input type="submit" name="btndelete" id="btndelete" value="Delete" onclick="GetConfirmation()" />
      <input type="submit" name="btncancel" id="btncancel" value="Cancel" /></td>
    </tr>
  </table>
  <?php echo $success_massage?>
</form>
</body>
</html>
got error from these codes in this file

Code: [Select]
if (isset($_POST['hiddenstudentid']))
$passstudent_id=$_POST['hiddenstudentid'];
else
$passstudent_id=$_POST['student_id_hidden'];


$sql=mysql_query("SELECT * FROM student WHERE StudentID=$passstudent_id");
echo $sql;
it is showing this error this this warning error.in here that details from DB will show in form.and im going to edit them from this file.

please help me to find the error.

Please help,

This code is giving me the warning stated in the above given Subject line. And combo box is also not populating.

Code: [Select]
function populatecombo()
{
$dropdown = "";
$sqlcmb = "select wardno from wards";

mysql_query($sqlcmb) or die(mysql_error('Unable to query the table'));

while($row = mysql_fetch_assoc($sqlcmb)) {
$dropdown .= "\r\n<option value='{$row['wardno']}>'{$row['wardno']}</option>";
}
echo $dropdown;
}