[RESOLVED] Changing data in a table

[MitchEvans]

I have the following results coming up on my page:

$glossary = "SELECT * FROM glossary WHERE authorisation='n' ORDER BY 'item' ASC";
$glossaryResults = mysql_query($glossary);
while ($glossaryRow = mysql_fetch_array ($glossaryResults)){
$Item = $glossaryRow["item"];
$Description = $glossaryRow["description"];

echo"
<tr>
<td>$Item</td>
<td>$Description</td>
<td><a href='change.php'>Authorise</a></td>
</tr>";}

What can I put in change.php in order to change one of the fields in the database?

change.php:

$res= mysql_query ("INSERT INTO glossary (authorisation) VALUES ('y') WHERE authorisation='n'");

Obviously I only want to change the certain ones that I click on (Authorise), if I don't click on some of them then I don't want the data to change.

Would love some help on this please???

[bogu]

MitchEvans, after 5 month on this forum and 170 post u still dont know how to add code in your post, please use php tags ([php ]...[ /php] <-- without white spaces).

MitchEvans wrote:

Obviously I only want to change the certain ones that I click on (Authorise), if I don't click on some of them then I don't want the data to change.

Obviously if u what to change, u need to update the record u click on ...

[MitchEvans]

Ok thanks, i'm unsure of what the code would be in change.php, where the value is 'n' I want to change it to 'y':

$res= mysql_query ("UPDATE glossary (authorisation) VALUES ('y') WHERE authorisation='n'");

[bogu]

I put a link to the update syntax in my first post ...

UPDATE glossary SET 
authorisation = 'Y'
WHERE id = 'the_id_u need to make authorisation Y'

[MitchEvans]

Thats excellent cheers bogu!
When authorise is clicked I only want it to authorise the one I have clicked next to, any ideas how this would be done?

$glossary = "SELECT * FROM glossary WHERE authorisation='n' ORDER BY 'item' ASC";
$glossaryResults = mysql_query($glossary);
while ($glossaryRow = mysql_fetch_array ($glossaryResults)){
$Item = $glossaryRow["item"];
$Description = $glossaryRow["description"];

echo"
<tr>
<td>$Item</td>
<td>$Description</td>
<td><a href='change.php'>Authorise</a></td>
</tr>";}

This code i'm using now for change.php changes all of the fields:

$res= mysql_query ("UPDATE glossary SET 
authorisation = 'y'
WHERE authorisation = 'n'");

[MitchEvans]

Okay so i'm getting closer, I have passed the details via the URL, so on change.php I have this code still:

$res= mysql_query ("UPDATE glossary SET 
authorisation = 'y'
WHERE authorisation = 'n' AND item=item");

But now from the previous page I have this to pass the information via the URL:

<td><img src='change.jpg'><a href='change.php?item=$Item'>Change</a></td>

How do I use this now it's passed to change.php?

[rincewind456]

As you have passed it via $GET then you would access it by $GET.

So like this in change.php if $item is an integer

$item = $_GET['item'];  // you need to add some testing to this for security purposes

$res= mysql_query ("UPDATE glossary SET 
authorisation = 'y' 
WHERE authorisation = 'n' AND item=".$item); 

If $item is a string rather than an integer then

$item = $_GET['item'];  // you need to add some testing to this for security purposes

$res= mysql_query ("UPDATE glossary SET 
authorisation = 'y' 
WHERE authorisation = 'n' AND item='".$item."'"); 

[MitchEvans]

Thats fantastic thank you very much! Its all working as I wanted now!

echo"You're a Star";