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

Dynamic Links (MySQL/PHP) [message #179218]

Tue, 25 September 2012 17:27

tom.rankin51
Messages: 17
Registered: September 2012

Karma:

Junior Member

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

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: Sat Nov 23 17:13:14 GMT 2024

Total time taken to generate the page: 0.10909 seconds