Jump to content


Photo

Page not showing new DB update!!


  • Please log in to reply
4 replies to this topic

#1 webdevised

webdevised
  • New Members
  • Pip
  • Newbie
  • 6 posts

Posted 16 September 2006 - 04:45 AM

I made this CMS that would allow a band to login and update their show list. The problem I am having is that after they have updated their show list and then use the link to go to the page that displays the shows the page is not updated.. I have to it the refresh button to have the new shows displayed.

What am I doing wrong??

I am using PHP and MYsql,

thanks - BRad

#2 Wintergreen

Wintergreen
  • Members
  • PipPipPip
  • Advanced Member
  • 107 posts

Posted 16 September 2006 - 04:49 AM

You're going to have to show your code, otherwise we have nothing to go on

#3 markbett

markbett
  • Members
  • PipPipPip
  • Advanced Member
  • 133 posts

Posted 16 September 2006 - 04:51 AM

does the page call to the db before the information is written to the database?  if so then you cannt expect the DB to know what info is going to be there.... if this is the case then have the landing page jump go somewhere which will then redirect to the show list so it will do the "refresh" silently during the redirect...

#4 webdevised

webdevised
  • New Members
  • Pip
  • Newbie
  • 6 posts

Posted 16 September 2006 - 05:10 AM

this is the view page....

<?php include("pwp.php"); ?>

<?
include("dbinfo.inc.php");
mysql_connect($host,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM contacts ORDER BY id ASC";
$result=mysql_query($query);

$num=mysql_numrows($result); 

mysql_close();

?>

<table border="0" cellspacing="2" cellpadding="2">
<tr> 
<th><font face="Arial, Helvetica, sans-serif">Name</font></th>
<th><font face="Arial, Helvetica, sans-serif">Phone</font></th>
<th><font face="Arial, Helvetica, sans-serif">Mobile</font></th>
<th><font face="Arial, Helvetica, sans-serif">Fax</font></th>
<th><font face="Arial, Helvetica, sans-serif">E-mail</font></th>
<th><font face="Arial, Helvetica, sans-serif">Website</font></th>
<th><font face="Arial, Helvetica, sans-serif">&nbsp;</font></th>
</tr>

<?
$i=0;
while ($i < $num) {
$id=mysql_result($result,$i,"id");
$first=mysql_result($result,$i,"first");
$last=mysql_result($result,$i,"last");
$phone=mysql_result($result,$i,"phone");
$mobile=mysql_result($result,$i,"mobile");
$fax=mysql_result($result,$i,"fax");
$email=mysql_result($result,$i,"email");
$web=mysql_result($result,$i,"web"); 
?>

<tr> 
<td><font face="Arial, Helvetica, sans-serif"><? echo "$first $last"; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><? echo "$phone"; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><? echo "$mobile"; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><? echo "$fax"; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><a href="mailto:<? echo "$email"; ?>">E-mail</a></font></td>
<td><font face="Arial, Helvetica, sans-serif"><a href="<? echo "$web"; ?>">Website</a></font></td>
<td><font face="Arial, Helvetica, sans-serif"><a href="update.php?id=<? echo "$id"; ?>">Edit</a>&nbsp;&nbsp;&nbsp;<a href="delete.php?id=<? echo "$id"; ?>">delete</a></font></td>
</tr>
<?
++$i;
} 
echo "</table><BR /><br /><a href=\"add.php\">Add Info</a>&nbsp;|&nbsp;<a href=\"pwp.php?logout\">logout</a>";


?>



#5 webdevised

webdevised
  • New Members
  • Pip
  • Newbie
  • 6 posts

Posted 18 September 2006 - 05:01 AM

*Bump*




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users