PHP - Mysql_fetch_assoc()

Would both of the below snippets do the same job, if so why are both ways taught in text books, can one method do somthing that the other cannot?

mysql_fetch_array($result, MYSQL_ASSOC))

And...

mysql_fetch_assoc($result)

I have the following code
Code: [Select]
$hidden_client_id_query = mysql_query("SELECT id from `pdp_client_info` WHERE lead_id='$post_lead_id'");
$hidden_client_id=mysql_fetch_assoc($hidden_client_id_query);
$this->view->hidden_client_id=$hidden_client_id['id'];
I get the following error for the above code. I wonder where I am wrong. I am getting the $post_lead_id as expected.
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean

Okay, I had a similar problem before.

$users = mysql_query("SELECT * FROM users");

while($users = mysql_fetch_assoc($users)){
		echo "<tr><td><p><a href='users.php?id={$users['user_id']}'>{$users['user_name']}</a></p></td><td>{$users['user_clan']}</td><td>{$users['troop_donations']}</td></tr>";
}

Following is the simple code to print name of states. However it doesn't print "Alabama" or in short it misses id=1.Can someone please point out my mistake or tell me why won't it print Alabama and ignoring id = 1 ? While debugging i found out it starts from id= 2.

Code -

Code: [Select]
<?php
  $sql = "SELECT * FROM state";
             $result = mysql_query($sql); ?>
 <SELECT NAME="state">
              <OPTION value="">Select State</option>
                           
              <?php while($arrayRow = mysql_fetch_assoc($result)) {
                     $strA = $arrayRow["id"];
                     $strB = $arrayRow["state"];
                     echo "<option value=\"$strB\">$strB</option>\n";
                      }?>
              </SELECT>
Sql table image -

Thank you for looking into this!

I need to use result from mysql query twice or more on a page
Should I do this:
$sql = mysql_query("SQL");
while ($row = mysql_fetch_assoc($sql))
     CODE
...
while ($row = mysql_fetch_assoc($sql))
    CODE2

OR should I keep result of a query in an array and use FOREACH instead? My concern is performance.

Can I use the data fetched with the mysql_fetch_assoc command more than once?  What I'm trying to do is query a MySQL DB, and print a list of the results by gender.  So far I've only been able to do it by querying the DB twice, and I know there's got to be a more efficient way.  I think I should be able to go through the array once, print all the males, then go through the array again and print all the females.  But I'm stumped as to how to do it.

Here's basically what I'm doing to get my results:

Code: [Select]
$cxn=mysqli_connect("localhost","username","password","table_name") or die ("Could not connect to database");               
$query= "SELECT * FROM blah blah blah";
$result=mysqli_query($cxn,$query) or die ("Couldn't execute query.");
                           
while ( $row = mysqli_fetch_assoc($result))
{
           extract($row);
           IF ($gender == 'M')
               {
                  echo "Here is my data for Males";
                }
}
I basically want to re-run the WHILE statement, but check for $gender == 'F', without having to re-run the $result=mysqli_query command again.  But when I do that, nothing is displayed and the script ends. Is it just a matter of moving a pointer to the beginning of an array or something similar?

Thanks in advance.

i get this error

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\website\viewvideos.php on line 25

Code: [Select]
$addviews = $views + 1;

$query = mysql_query("UPDATE headlines SET views='$addviews' WHERE id=$viewid");
$rows = mysql_fetch_assoc($query);
i dont get whats wrong

Hi,

I have tried to merge two queries into one however a piece of code keeps coming up with an error:

mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource.

It relates to this.  I cant see it doesn't work and I have tried around 10 different options but this is the nearest I can get.  Can anyone advise me what the problem is and why this no longer works please?

while($row = mysql_fetch_assoc($myQuery)) 


<?php

ini_set('display_errors', 1);
error_reporting(-1);

if( isSet($_GET['description'])) 
$description = $_GET['description'];


if(isSet($_GET['price'])) 
$price = explode('-',$_GET['price']);
$low = (int)$price[0];
$high = (int)$price[1];

($myQuery = "SELECT * FROM productfeed WHERE 1 . 
if(isset($description)) ' AND if description = '. $description;
if(isset($price)) ' AND if price = '. $price;
. ");

while($row = mysql_fetch_assoc($myQuery)) {
$id = $row['id'];
$image = $row['awImage'];
$link = $row['link'];
$description = $row['description'];
$fulldescription = $row['fulldescription'];
$price = $row['price'];

$fulldescription = substr("$fulldescription", 0, 400);    

echo "<div class='productdisplayshell'>
<div class='productdisplayoutline'>
<div class='productborder'><center>
<a href='$link' target='_blank'><img src='$image' width=\"95%\" /></a>
</center> </div></div>
<div class='productdescriptionoutline'>
<div class='productdescriptionbox'>
<a href='$link' target='_blank' >$description</a>
</div>
<div class='productfulldescriptionbox'>$fulldescription</div>
</div>
<div class='productpriceoutline'>
<div class='productpricebox'>
<center>&#38;#163; $price</center>
</div>
<div class='productbuybutton'>
<center><a href='$link' target='_blank' ><img src=/images/buybutton.png /></a></center>
</div>
</div>
</div>";
}

I cannot retrieve my records from my table, neither can I display them on my website.  I do not even get any errors when I run the script on my site. Any help or tips would be greatly appreciated.  My current php script is:

// connection to database server
$db_selected = mysql_select_db('database1', $dbc);
if (!$db_selected) {
    die ('Can\'t use database1 : ' . mysql_error());
}
$query = "SELECT * FROM chesstable ORDER BY chapter, lastname";
$result = mysql_query($query) or die('Could not connect' . mysql_error());

echo mysql_num_rows($result);
If (!$result) {
    $message = 'Invalid query: ' . mysql_error();
        $message = 'Whole query: ' . $query;
        die ($message);
  }
while($row = mysql_fetch_assoc($result)) {
  echo $row['firstname'] . " " . $row['lastname'] . $row['chapter'];
  }
mysql_free_result($result);
mysql_close($dbc);
?>

I got this code at the top:
Code: [Select]
<?php
require_once("configuration.php");
$uid = $_GET['uid']; ?>

And another main one:
Code: [Select]
<?php
if(isset($_GET['uid']))
{ 

$d = "";
$query = mysql_query("SELECT `username`,`level`,`email,`,`alevel`,`tester` FROM `users` WHERE `id`='$uid'");
if(!mysql_num_rows($query))
echo "No user.";
while($d = mysql_fetch_assoc($query))
{
?>
&nbsp <b>Username:</b> <?php echo $d['username']; ?> <br />
&nbsp <b>Level:</b> <?php echo $d['level']; ?> <br />
&nbsp <b>Email:</b> <?php echo $d['email']; ?> <br />
&nbsp <b>Admin level:</b> <?php echo $d['alevel']; ?> <br />
&nbsp <b>Tester:</b> <?php echo $d['tester']; ?>
<?php } } ?>
</font>
</div>
</center>


Now I get this error:
Code: [Select]
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\learning\viewuser.php on line 20
No user.
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\learning\viewuser.php on line 22
How can I fix it?

we did an exercise in IT class it was about how to inject php code in css code we took a template as an example to work on. i injected php code in the page "services.php"as instructed but it didn't work and i keep getting this 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;
}

Warning:  mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\test.php on line 58

line 58 is the where the while loop starts.. what have i done wrong?

Code: [Select]
$query2 = mysql_query("SELECT student.SID, course.CID FROM student, course WHERE student.SID = `student-course.SID` AND course.CID = `student-course.CID` AND GRADE BETWEEN $beginning AND $grade",$this->connect);

while($row = mysql_fetch_assoc($query2)) {

$sid = $row['student.SID'];
$cid = $row['course.CID'];

echo "$sid-$cid";

}

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.

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>";
}
}
}