MySQL Update Query

[adamchippy]

Hey there. I'm building a project in PHP/MySQL and it is a sort of FaceMash project. I am able to call the images (with image name and points) from the database. I have managed to use the MySQL Update query in order to increase the points that each image gets when clicked but it just applies this to every image in the database. I cannot work out how to use the WHERE part of the update query that gives the point to that specific image that was clicked.

I have it set up as follows:

rate.php (the main page) *Click on an image* --> update.php (Which contains the update query) 

The query I currently have is:

<?php
  include_once("connect.php");
  include_once("rate.php");

  $con=mysqli_connect("10.168.1.49","danielaf_adam","adamchip22","danielaf_adam");

  mysqli_query($con,"UPDATE teachers SET points= points+1 WHERE row='$row'");

?>

Some help would be really appreciated as I have been pondering on this one for ages. Cheers.

[Bob Hensley]

Where are you defining the $row variable? And what is it defined as? Also, what data type is the row attribute in the table

[adamchippy]

It is in my main rate.php file:

while($row = mysql_fetch_array($result))
  {
  echo $row['name'] . "<br /><br />";
  echo '<a href="update.php">' . $row['image'] . '</a><br /><br />';
  echo '<button class="btn btn-success">&nbsp;<span class="glyphicon glyphicon-thumbs-up"></span>&nbsp;' . $row['points'] . '&nbsp;pnts</button>';
  }

Not sure what you mean by the last bit.

[GliderPilot]

$row is an array that contains your data that was retrieved from the DB, it is not a column in your table and it's not passed to update.php. You need to change your link so that it passes a unique identifier (The table row's Unique Key, possibly ID). Than when you do your update statement you can use that to only update the one row.

[adamchippy]

So the link would be something like this - update.php?id=7 ??

[GliderPilot]

that's correct, than you get use the $_GET['id] to retreive that number in your update script