webdevised Posted September 16, 2006 Share Posted September 16, 2006 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 Quote Link to comment Share on other sites More sharing options...
Wintergreen Posted September 16, 2006 Share Posted September 16, 2006 You're going to have to show your code, otherwise we have nothing to go on Quote Link to comment Share on other sites More sharing options...
markbett Posted September 16, 2006 Share Posted September 16, 2006 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... Quote Link to comment Share on other sites More sharing options...
webdevised Posted September 16, 2006 Author Share Posted September 16, 2006 this is the view page....[code]<?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"> </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> <a href="delete.php?id=<? echo "$id"; ?>">delete</a></font></td></tr><?++$i;} echo "</table><BR /><br /><a href=\"add.php\">Add Info</a> | <a href=\"pwp.php?logout\">logout</a>";?>[/code] Quote Link to comment Share on other sites More sharing options...
webdevised Posted September 18, 2006 Author Share Posted September 18, 2006 *Bump* Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.