Jump to content

Help with mysql_query select * from


Unholy Prayer

Recommended Posts

Ok, I am trying to display records from my mysql database table called "tutorial_programs".  I want to display the results in a navigation table as links to another page.  It kind of works, but it only displays one of the records from the table.  This is my code:

[code]
include('config.php');
          $result = mysql_query("select * from tutorial_programs");

while($r=mysql_fetch_array($result))
{
 
  $pid=$r["pid"];
  $pname=$r["pname"];
 
  //display the row
  echo "<td class='navlink'><a href='viewprogram.php?id=$pid>$pname</a></td>
</tr><tr>";
}
[/code]

Can anyone please help me?
Link to comment
https://forums.phpfreaks.com/topic/33858-help-with-mysql_query-select-from/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.