Jump to content

[SOLVED] list of subjects which are links for bulletins


patelp7

Recommended Posts

hello, 

 

I am trying to list all the subjects of bulletins for a logged on user.  I am stuck.

 

can some one please help?

 

Thanks

 

<?

session_start();

require ("db.php.inc");

//require ("ViewBulletin.inc");

 

 

 

$query = "select B.Subject From Bulletin B, Relative R

          WHERE

  B.Adminusername = R.Adminusername

  AND R.Username = '".$_SESSION['Username']."' ";

 

$result = mysql_query(result_query);

 

$result = mysql_query ($query);

 

// Run the query.

$numofsubs = mysql_num_rows($result);

 

if ($numofsubs > 0) { // If it ran OK, display the records.

echo "<p>There are currently $numofsubs registered users.</p>\n";

 

// Fetch and print all the records.

while ($numsofsubs = mysql_fetch_array($result))

{

echo '<tr><a href="viewActualBull.php?id=' . $row['Subject'] . '">View</a></td>';

}

?>

what error are you getting?? also your includes should end in .inc.php, not .php.inc

 

if they end in .inc, people can read the files as though they were text files, unless you have a mime type identified for .inc

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.