Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #7159

Re: Dynamic Links (MySQL/PHP)

Show all headers | View raw

Just to update, my error logs are completely empty

On Tuesday, September 25, 2012 6:41:09 PM UTC+1, The Natural Philosopher wrote:
> tom.rankin51@googlemail.com wrote:
> 
> > Hello
> 
> > 
> 
> > I have a very basic knowledge of PHP and MySQL and sought help from a friend who initially was someone I can turn to but now can't provide me with any help (!) ...and so to Google Groups!
> 
> > 
> 
> > I am trying to display preview text on a webpage and then after clicking a link it will take you to the full item.  It must be quite a simple thing to do, however, I am getting a completely blank page.  I get no errors, and I have no syntax errors that I can see so I'm struggling to see what I have done wrongly.
> 
> > 
> 
> > My code on the main page is : 
> 
> > 
> 
> > <?
> 
> >                     include("php/dbinfo.inc.php");
> 
> >                 
> 
> >                     mysql_connect($hostname,$username,$password);
> 
> >                     @mysql_select_db($database) or die( "Unable to select database");
> 
> > 
> 
> > 					$mydate=date("Y-m-d",strtotime("-2 weeks"));
> 
> > 					
> 
> >   					$news_query=mysql_query("SELECT id, postdate, title, SUBSTRING_INDEX(body,' ',20) as preview_text, body FROM NewsContent WHERE postdate > '$mydate' ORDER BY postdate DESC");
> 
> > 					
> 
> >                     mysql_close();
> 
> >                     ?>
> 
> > 
> 
> > <div>
> 
> >                    <ol>
> 
> >                    	<!-- START OF PHP SCRIPT (NEWS) -->
> 
> >                     <?
> 
> >                     while($r=mysql_fetch_assoc($news_query)) {
> 
> >                    		echo '<li id="'.$r["id"].'">';
> 
> >                    		echo '<h2 class="body-headline">';
> 
> > 						echo $r["title"];
> 
> >                    		echo '</h2>';
> 
> >                    		echo '<h3 class="date-heading">';
> 
> >                    		echo date("d-M-Y",strtotime($r["postdate"]));
> 
> >                    		echo '</h3>';
> 
> >                    		echo nl2br ($r["preview_text"]);
> 
> >                    		echo '...<a class="fancybox fancybox.ajax" href="news.php?id='.$r["id"].'">show more</a>';
> 
> >                     	echo '</li><hr />';
> 
> >                    	} ?>
> 
> >                    	<!-- END OF PHP SCRIPT (NEWS) -->
> 
> >                    </ol>
> 
> >                    </div>
> 
> > 
> 
> > Note that I'm using a fancybox script, but this happens without using that script also.
> 
> > 
> 
> > In my news item page I have done the following:
> 
> > 
> 
> > <?
> 
> > 	include("php/dbinfo.inc.php");
> 
> > 	
> 
> > 	mysql_connect($hostname,$username,$password);
> 
> >     @mysql_select_db($database) or die( "Unable to select database");
> 
> > 					
> 
> > 	$id = $_GET['id'];
> 
> > 	$sql = "SELECT id, postdate, title, body FROM NewsContent WHERE id = '$id'";
> 
> > 	$news_query=mysql_query($sql);
> 
> > 	IF ($news_query){
> 
> > 		$r = mysql_fetch_row($news_query);
> 
> > 		
> 
> > 		$title = $r["title"];
> 
> > 		$body = $r["body"];
> 
> > 		}
> 
> > 	
> 
> > 	mysql_close();
> 
> > 	?>
> 
> > 
> 
> > <div>
> 
> >             <h2>
> 
> >             	<?
> 
> >             	echo $r["title"];
> 
> >             	?>
> 
> >             </h2>
> 
> >             <div class="modal-nav-links">
> 
> >             <p><?php echo $r["body"] ?></p>
> 
> >             <!-- <div style="clear: both;"></div> -->
> 
> >             </div>
> 
> > </div>
> 
> > 
> 
> > 
> 
> > I was under the impression that this would work, but no dice.  Can someone with a bit of experience give me an idea of what I'm doing incorrectly?
> 
> > 
> 
> > Thanks in advance
> 
> > Tom
> 
> 
> 
> 
> 
> Haven't time to explore your source, but if its on a server that you 
> 
> administer, look in apache* error logs: that's where PHP errors can end up.
> 
> 
> 
> *or whatever web server it is
> 
> 
> 
> -- 
> 
> Ineptocracy
> 
> 
> 
> (in-ep-toc’-ra-cy) – a system of government where the least capable to 
> 
> lead are elected by the least capable of producing, and where the 
> 
> members of society least likely to sustain themselves or succeed, are 
> 
> rewarded with goods and services paid for by the confiscated wealth of a 
> 
> diminishing number of producers.

Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Dynamic Links (MySQL/PHP) tom.rankin51@googlemail.com - 2012-09-25 10:27 -0700
  Re: Dynamic Links (MySQL/PHP) The Natural Philosopher <tnp@invalid.invalid> - 2012-09-25 18:41 +0100
    Re: Dynamic Links (MySQL/PHP) tom.rankin51@googlemail.com - 2012-09-25 10:58 -0700
    Re: Dynamic Links (MySQL/PHP) tom.rankin51@googlemail.com - 2012-09-25 11:34 -0700
      Re: Dynamic Links (MySQL/PHP) Luuk <luuk@invalid.lan> - 2012-09-25 21:07 +0200
  Re: Dynamic Links (MySQL/PHP) Luuk <luuk@invalid.lan> - 2012-09-25 20:02 +0200
    Re: Dynamic Links (MySQL/PHP) tom.rankin51@googlemail.com - 2012-09-25 11:17 -0700
      Re: Dynamic Links (MySQL/PHP) Luuk <luuk@invalid.lan> - 2012-09-25 21:04 +0200
        Re: Dynamic Links (MySQL/PHP) tom.rankin51@googlemail.com - 2012-09-25 23:24 -0700
          Re: Dynamic Links (MySQL/PHP) Denis McMahon <denismfmcmahon@gmail.com> - 2012-09-26 14:03 +0000
  Re: Dynamic Links (MySQL/PHP) Captain Paralytic <paul_lautman@yahoo.com> - 2012-09-26 05:05 -0700
    Re: Dynamic Links (MySQL/PHP) Jerry Stuckle <jstucklex@attglobal.net> - 2012-09-26 11:16 -0400

csiph-web