using while loops

[pezkingrich]

Hi again,
I want to display all the news titles that i have in my database, which i have managed, but also to display a link with their news id in so that the edit page can be displayed with the article in.
i am currently using this to display the news titles:

$result = mysql_query("SELECT title FROM news") or die(mysql_error());
  while($row = mysql_fetch_row($result))
  {
      print("Title: $row[0]<br>");
  }

Thanks

[laserlight]

Try:

$result = mysql_query("SELECT title FROM news")
	or die(mysql_error());
while ($row = mysql_fetch_row($result))
{
	echo "Title: " . $row[0] . "<br>";
}

or you can use the complex (i.e. curly brace) syntax for interpolating variables within strings.

[pezkingrich]

what i want is for a link to be printed that say goes to admin.php?id=$id that is the id for the news. The bit of code above works fine allready, i just am wanting to add another thing to what is printed..if you get me

Thanks for trying

rich

[laserlight]

Ah.
You have to change your query to select the id as well.

I suggest a change from mysql_fetch_row() to mysql_fetch_assoc() for this, then you can use $row['id'] and $row['title'] instead of the more confusing $row[1] and $row[2]

After that, printing the id in a query string should be trivial.

[pezkingrich]

Thanks a lot, works perfectly!

Cheers - rich