September 12th, 2002, 01:25 PM
|
|
Contributing User
|
|
Join Date: Apr 2002
Location: Anchorage
Posts: 118
Time spent in forums: < 1 sec
Reputation Power: 7
|
|
|
Trouble calling just one table...
I thought I was finished with my teachers' newsletter maker, but I was wrong. First I had a problem with security, then I used simple password authentication to access the "make newsletter forms", this solved that problem ( for now ). Then it seemed to word fine. Now I am getting a repeating post when before I used sessions, I had no such problem.
Here is the code that calls for 1 newsletter to be posted from a table row:
PHP Code:
<?php
echo "<tr><td><p align=center><font size='+2'>Newsletters by date:</font></p></td></tr>\n";
$db = @mysql_connect ( "home", "home", "home");
mysql_select_db("home", $db);
$result = mysql_query("SELECT * FROM tablehome",$db);
if ($myrow = mysql_fetch_array($result))
{ do {
echo "<p align=center>\n";
printf ("<a href=msemilynewsletter1.php?id=%s%s>%s</a><br>\n", $php_self,$myrow["id"],$myrow["date"]);
echo "</p>\n";
}
while ($myrow = mysql_fetch_array($result));
}
else {
echo "Sorry, no records were found.";
}
?>
Above is the code for a page that posts the names of the newsletters entered.
I have sessions registered on all the "make forms" pages and the member's only pages, they look like this:
PHP Code:
<?
session_start();
echo "<h1>Members only</h1>";
// check session variable
if (session_is_registered("valid_user"))
{
echo "<p>You are logged in as $valid_user.</p>";
}
else
{
echo "You are not logged in, try logging again at: <a href='authmain.php'>Teacher Log In</a>.";
die();
}
?>
All the tables are different ( mysql ), one for each user, and one for the passwords and user names and id's.
The page that allows parents to view the list of newsletters does not have the above session validation, only the members only pages.
What is happening?
Please help.
<< mod edit: please put the PHP tags around PHP code, it makes things easier to read. Thank you >>
__________________
bow wow!
Last edited by ejbe99 : September 12th, 2002 at 03:07 PM.
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
