FUDforum: comp.lang.php » Dynamic Links (MySQL/PHP)

Home » Imported messages » comp.lang.php » Dynamic Links (MySQL/PHP)

Show: Today's Messages :: Polls :: Message Navigator

Re: Dynamic Links (MySQL/PHP) [message #179255 is a reply to message #179218]

Wed, 26 September 2012 12:05

Captain Paralytic
Messages: 204
Registered: September 2010

Karma:

Senior Member

On Sep 25, 6:27 pm, tom.ranki...@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>
> 
> <?
> 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 />';
> } ?>
> 
> </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>
> </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

You haven't got any php in your files. In order for the contents of a
file to be parsed as php, it must be within a pair of php open/close
tags. The php open tag is <?php and the closing one is ?>

Since you have no <?php tag, you have no php to be parsed.

Report message to a moderator

[Message index]

		Dynamic Links (MySQL/PHP) By: tom.rankin51 on Tue, 25 September 2012 17:27
		Re: Dynamic Links (MySQL/PHP) By: The Natural Philosoph on Tue, 25 September 2012 17:41
		Re: Dynamic Links (MySQL/PHP) By: tom.rankin51 on Tue, 25 September 2012 17:58
		Re: Dynamic Links (MySQL/PHP) By: tom.rankin51 on Tue, 25 September 2012 18:34
		Re: Dynamic Links (MySQL/PHP) By: Luuk on Tue, 25 September 2012 19:07
		Re: Dynamic Links (MySQL/PHP) By: Luuk on Tue, 25 September 2012 18:02
		Re: Dynamic Links (MySQL/PHP) By: tom.rankin51 on Tue, 25 September 2012 18:17
		Re: Dynamic Links (MySQL/PHP) By: Luuk on Tue, 25 September 2012 19:04
		Re: Dynamic Links (MySQL/PHP) By: tom.rankin51 on Wed, 26 September 2012 06:24
		Re: Dynamic Links (MySQL/PHP) By: Denis McMahon on Wed, 26 September 2012 14:03
		Re: Dynamic Links (MySQL/PHP) By: Captain Paralytic on Wed, 26 September 2012 12:05
		Re: Dynamic Links (MySQL/PHP) By: Jerry Stuckle on Wed, 26 September 2012 15:16

Previous Topic:	Updating Zend 5.0 to use PHP 5.3.9
Next Topic:	Multiple <a> Tags, Filled With MySQL DB data with PHP

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 03:42:47 GMT 2024

Total time taken to generate the page: 0.03988 seconds