Increase id by 1 with each link??

[loftusp]

My code reads:

 

<a href="index.php?action=delete&id=" >Delete</a>

 

How do i change it so the id=1,2,3 etc with each link??

 

[fugix]

how are the links being generated?

[loftusp]

Manually entering data into a form which is transferred into a database. These are then given an id, so I need to pass an id into my php (at least i think i do )

 

http://homepages.cs.ncl.ac.uk/p.a.loftus/csc2511/

 

I'm don't know a great amount so here is the site  ^^

 

 

[spiderwell]

so you want to pull the id(s) from the database and turn into delete link(s)?

 

[loftusp]

so you want to pull the id(s) from the database and turn into delete link(s)?

 

Yes I think so. I have the code written to delete the database entries but I don't know how to make the links!

Thanks!

[xyph]

Someone wants us to do their homework for them

[loftusp]

Someone wants us to do their homework for them

 

Maybe....

[spiderwell]

a little shove never helps

 

get a record set of users (or whatever it is) and loop through it.

use the data to create links a bit like this:

 

<?php
echo "<a href='deleteuser.php?id=" . $row['id'] . "'>delete " . $row['username'] . "</a>";
?>

[loftusp]

a little shove never helps

 

get a record set of users (or whatever it is) and loop through it.

use the data to create links a bit like this:

 

<?php
echo "<a href='deleteuser.php?id=" . $row['id'] . "'>delete " . $row['username'] . "</a>";
?>

 

 

Sorry I'm really not good at this. Basically my table is called locations into which a user adds their location and activity. This is then linked to a user in a person_location table. This is the delete code I have created. Not sure how good it is.

 

 

case 'delete' :

$id = isset($_REQUEST['id']) ? $_REQUEST['id'] : '';

if (!$id) {

echo 'No Location identified!';

} else

{

$currentLocation = R::findOne('location', 'id=?', array($id));

$pps = R::findOne('person', 'name=?', array($_SESSION['name']));

// Why is this not deleting it from the database???

R::unassociate($_SESSION['name'], $currentLocation);

R::trash($currentLocation);

}

$tpl = 'loggedin.twig';

break;

 

 

Using that detail what would the . $row['id'] . be??

[loftusp]

Also this is how the data is stored:

 

case 'location' :

    if ($_POST['location'] && $_POST['activity'])

            {

              $pld = R::dispense('locations');

$pld->location = $_REQUEST['location'];

$pld->activity = $_REQUEST['activity'];

$id=R::store($pld);

R::associate($_SESSION['name'], $pld);

$vals['location'] = R::related ($_SESSION['name'], 'locations');

$tpl='loggedin.twig';

    }else

    {

        echo "no user!";

$tpl='loggedin.twig';

    }

    break;