[Resolved] simple problem ( I think) linking

[Kyrst]

Here is the code I currently have to retreive my first set of results:

include('connect.php');

$result = mysql_query("SELECT art_name FROM artist WHERE 1 ORDER BY art_name ASC");

if ($result)
{
  for ($i=0; $i < mysql_num_rows($result); $i +=2)
  {
    $row = mysql_fetch_array($result);
    echo "<tr>";
    echo "<td align=center>" . $row['art_name'] . "</td>";
    if ((mysql_num_rows($result) % 2) == 0)
    {
      $row = mysql_fetch_array($result);
      echo "<td align=center>" . $row['art_name'] . "</td>";
    }
    echo "</tr>";
  }
}

What I want is for the art_names to link via id.

I know the code is roughly along the lines of

<a href='details.php?id=".$id."' target='main'>" . $row['art_name'] . "</a>

but where does the $id = ['art_id']; go?

[bubblenut]

Do you have an art_id in the database (I imagine you will have) if you do then you'll want to pull it out along with the art_name with your query.
HTH
Bubble

[Kyrst]

so far this has worked. Thank you very much. Now to just get the info I want to pull up on the details page, hehe.

iinclude('connect.php');

$result = mysql_query("SELECT art_name , art_id FROM artist WHERE 1 ORDER BY art_name ASC");

if ($result)
{
  for ($i=0; $i < mysql_num_rows($result); $i +=2)
  {
    $row = mysql_fetch_array($result);
    echo "<tr>";
    echo "<td align=center><a href='details.php?id=". $row['art_id']."' target='main'>" . $row['art_name'] . "</a></td>";
    if ((mysql_num_rows($result) % 2) == 0)
    {
      $row = mysql_fetch_array($result);
      echo "<td align=center><a href='details.php?id=". $row['art_id']."' target='main'>" . $row['art_name'] . "</a></td>";
    }
    echo "</tr>";
  }
}