Php print single id issue

Question

So here's what I want.. When user clicks on some link e.g. http://www.keevik.com/vicevi.php?id=24 that script prints out only that single id.

Here's my code

    /* Get data. */
$sql = "SELECT * FROM $tbl_name ORDER BY id DESC LIMIT $start, $limit";
$result = mysql_query($sql);
while($row = mysql_fetch_array($result))
    {
    echo "<a href ='vicevi.php?id=".$row['id']."'>".$row['id']."</a>";
    echo "<br>";
    echo nl2br($row["VicText"]);
    echo "<hr>";
    }

So, when I click on some link it doesn't do what I actually want :S

Add a where clause WHERE id=$id and get it from $_GET['id']; — Waygood
– Waygood, Commented Apr 23, 2013 at 12:21
this is the code of the page where you display the list. What's in the page where you display an item detail ? — Laurent S.
– Laurent S., Commented Apr 23, 2013 at 12:24

Waygood · Accepted Answer · 2013-04-23 12:24:18Z

4

$sql = "SELECT * FROM $tbl_name ORDER BY id DESC LIMIT $start, $limit";
if(isset($_GET['id']))
{
    $id=intval($_GET['id']);
    $sql = "SELECT * FROM $tbl_name WHERE id=$id";
}
$result = mysql_query($sql);
if(!$result)
{
    echo 'no data found!';
}
else
{
    // etc..
}

answered Apr 23, 2013 at 12:24

Waygood

2,6832 gold badges17 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Waygood Over a year ago

lookup mysql_real_escape_string() but I suggest moving to mysqli

Collectives™ on Stack Overflow

Php print single id issue

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related