Whats wrong with this? (searching database for specific id)

killaklown · 02-23-2007, 06:16 PM

This is the code which im having problems with (its not all the code, so i am not missing the <?php, or a })

Code:

    $sql_query = "SELECT * FROM links WHERE id='$id'";
    //store the SQL query in the result variable
    $result = mysql_query($sql_query);

    if(mysql_num_rows($result))
    {
    //output as long as there are still available fields
    while($row = mysql_fetch_array($result))
    {
        $title = $row["title"];
        $url = $row["url"];
        $id = $row["id"];
        $status = $row["status"];
		$email = $row["email"];
   }

Im trying to get it to let you edit the information in the 'links' part of the database. The page before has this code:

Code:

<a href=\"editlink.php?id=$id\">Edit</a>

The id is right and everything, but the page always shows it as blank. I had it working a long time ago, then kind of forgot about it and now it doesnt work.

shreder · 02-23-2007, 07:29 PM

Try this:

<a href=\"editlink.php?id=<?= $id ?>\">Edit</a>

Slewey · 02-24-2007, 12:40 AM

aren't you forgetting to get the id from the link?
try this query

PHP Code:

  SELECT * FROM links WHERE id='".$_GET['id']."'";

or you shloud define your variable id before executing the query

PHP Code:

  $id = $_GET['id'];

 
    $sql_query = "SELECT * FROM links WHERE id='$id'";

    //store the SQL query in the result variable

    $result = mysql_query($sql_query);

 
    if(mysql_num_rows($result))

    {

    //output as long as there are still available fields

    while($row = mysql_fetch_array($result))

????: NamePros.com http://www.namepros.com/programming/297903-whats-wrong-searching-database-specific-id.html
    {

        $title = $row["title"];

        $url = $row["url"];

????: NamePros.com http://www.namepros.com/showthread.php?t=297903
        $id = $row["id"];

        $status = $row["status"];

        $email = $row["email"];

   }

killaklown · 02-24-2007, 09:57 AM

Originally Posted by Slewey

aren't you forgetting to get the id from the link?
????: NamePros.com http://www.namepros.com/showthread.php?t=297903
try this query

PHP Code:

  SELECT * FROM links WHERE id='".$_GET['id']."'";

Haha, thanks slewey, i knew it was something to do with that line.

Rep added. I see the rep also got you another green bar

Matthew. · 02-24-2007, 10:20 AM

Please remember to validate and secure your inputs folks, killaklown remember that is extremely insecure as it is right now

Just my piece of advice although the problem is solved

Matt

Slewey · 02-25-2007, 11:52 AM

Originally Posted by killaklown

Haha, thanks slewey, i knew it was something to do with that line.
????: NamePros.com http://www.namepros.com/showthread.php?t=297903

Rep added. I see the rep also got you another green bar

np

02-23-2007, 06:16 PM	THREAD STARTER #1 (permalink)
killaklown Senior Member Join Date: Oct 2003 Posts: 3,472	Whats wrong with this? (searching database for specific id) This is the code which im having problems with (its not all the code, so i am not missing the <?php, or a }) Code: $sql_query = "SELECT * FROM links WHERE id='$id'"; //store the SQL query in the result variable $result = mysql_query($sql_query); if(mysql_num_rows($result)) { //output as long as there are still available fields while($row = mysql_fetch_array($result)) { $title = $row["title"]; $url = $row["url"]; $id = $row["id"]; $status = $row["status"]; $email = $row["email"]; } Im trying to get it to let you edit the information in the 'links' part of the database. The page before has this code: Code: <a href=\"editlink.php?id=$id\">Edit</a> The id is right and everything, but the page always shows it as blank. I had it working a long time ago, then kind of forgot about it and now it doesnt work.

02-23-2007, 07:29 PM	#2 (permalink)
shreder NamePros Regular Join Date: Mar 2006 Posts: 780	Try this: <a href=\"editlink.php?id=<?= $id ?>\">Edit</a> __________________ EKED.COM BDPU.COM FFHF.COM BXNN.COM SFUZ.COM OOHH.NET EOEI.COM NSTO.COM SPMQ.COM CODV.COM - Pm Offers *"What doesn't kill you only makes you stronger..."*

02-24-2007, 12:40 AM	#3 (permalink)
Slewey NamePros Regular Join Date: Apr 2004 Location: NL Posts: 808	aren't you forgetting to get the id from the link? try this query PHP Code: `SELECT * FROM links WHERE id='".$_GET['id']."'";` or you shloud define your variable id before executing the query PHP Code: $id = $_GET['id']; $sql_query = "SELECT * FROM links WHERE id='$id'"; //store the SQL query in the result variable $result = mysql_query($sql_query); if(mysql_num_rows($result)) { //output as long as there are still available fields while($row = mysql_fetch_array($result)) ????: NamePros.com http://www.namepros.com/programming/297903-whats-wrong-searching-database-specific-id.html { $title = $row["title"]; $url = $row["url"]; ????: NamePros.com http://www.namepros.com/showthread.php?t=297903 $id = $row["id"]; $status = $row["status"]; $email = $row["email"]; }

02-24-2007, 10:20 AM	#5 (permalink)
Matthew. Senior Member Join Date: Dec 2006 Location: England Posts: 1,568	Please remember to validate and secure your inputs folks, killaklown remember that is extremely insecure as it is right now Just my piece of advice although the problem is solved Matt __________________ University Grade Calculator juegosjuegos Your Hotel in Austria Matratzen

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)