[RESOLVED] Passing a value from one page to another

[phprooky]

Hi everybody,
Can anyone please help me, I don't know how to pass a value from one page to another using a url like the one I have here. When I click on that url I want to delete or edit the row I have choose:

<form name="form1" method="post" action="">
<table width="584" border="1">
<tr>
<td width="65">&nbsp;</td>
<td colspan="5"><strong>Delete and Edit Sports</strong></td>
</tr>
<tr>
<td height="20" colspan="2"><div align="center">Edit / Delete</div></td>
<td width="46">Id</td>
<td width="135">Date</td>
<td width="104">Title</td>
<td width="119">Author</td>
</tr>

while($rows=mysql_fetch_array($result)){

<tr>
<td align="center"><a href="edit_row.php?ID=$rows['id']">Edit</a></td>
<td width="75" align="center"><a href="delete_row.php?ID=$rows['id']">Delete</a></td>
<td align="center"><div align="left">

Php echo $rows['id'];

</div></td>
<td align="center"><div align="left">

echo $rows['date'];

</div></td>
<td align="center"><div align="left">

Php echo $rows['tittle'];

</div></td>
<td align="center"><div align="left">

echo $rows['author'];

</div></td>
</tr>

}

</table>
<br />
</form>

[cretaceous]

I'd recommend that you bring the edit and delete functions within this script that you already have - it makes it easier in the long run.
But either way, at the top of the delete_row.php script you should put:

$idfromclick=$_GET['ID'];

then use $idfromclick as you want

[phprooky]

Hi cretaceous and thanks for your reply,
You mean putting it before the: while($rows=mysql_fetch_array($result)){
or after that.

[cretaceous]

put this at the top before everything else :

$idfromclick=$_GET['ID'];

so when the page is accessed via the url : delete_row.php?ID=123
your script can then identify which item to delete

and your sql is something like:
DELETE FROM mytable WHERE my_row_id='$idfromclick';

which wil delete row 123
(you need to add the sql control code yourself - I assume you know how to do that)

[phprooky]

Hi again and thanks for replying,
What I this is this: In one php page I changed the url with this:
<?Php while($rows=mysql_fetch_array($result)){ ?>
<td align="center"><a href="edit_row.php?id=<?Php echo $rows['id']; ?>">Edit</a></td>
<td align="center"><a href="delete_row.php?id=<?Php echo $rows['id']; ?">Delete</a></td>
<td align="center"><div align="left"><?Php echo $rows['id']; ?></div></td>
<td align="center"><div align="left"><?Php echo $rows['date']; ?></div></td>
<td align="center"><div align="left"><?Php echo $rows['tittle']; ?></div></td>
<td align="center"><div align="left"><?Php echo $rows['author']; ?></div></td>
</tr>
<?Php
}
?>
Then I created another php page called delete.php where I put the following:
require("my_db.php");
$id_fromclick=$_GET['id'];
$sql="Delete from $tbl_name where id=$id_fromclick";
$result=mysql_query($sql);
I already try it and deleted the only row I had it, but I don't know if it's going to work with more than one row.
What do you think?

[cretaceous]

you'd better try it and see if it works a second time...
of course it might make your computer go bang - that's the trouble with computer code you can never tell what it might do from one day to the next ;-)

by the way, standard usage is <?php not <?Php

[phprooky]

Ok, thanks a lot for your help!!