FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » Imported messages » comp.lang.php » Dynamic Links (MySQL/PHP)
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Re: Dynamic Links (MySQL/PHP) [message #179260 is a reply to message #179255] Wed, 26 September 2012 15:16 Go to previous message
Jerry Stuckle is currently offline  Jerry Stuckle
Messages: 2598
Registered: September 2010
Karma:
Senior Member
On 9/26/2012 8:05 AM, Captain Paralytic wrote:
> 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>
>> <!-- 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
>
> 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.
>

He's probably using short_open_tags, Paul. Another bad habit he needs
to break.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================
[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
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) ] [ RSS ]

Current Time: Sat Nov 23 18:14:03 GMT 2024

Total time taken to generate the page: 0.05869 seconds