| Re: Dynamic Links (MySQL/PHP) [message #179221 is a reply to message #179219] |
Tue, 25 September 2012 17:58   |
tom.rankin51
Messages: 17
Registered: September 2012
Karma:
|
Junior Member |
|
|
I'm looking into my error logs but can't find an error anywhere. For the record, I found a .log file in my Apache Logs folder, and a .htaccess file that contains nothing in my Error Logs folder.
I apologise, this is not something I've ever had to do before.
Tom
On Tuesday, September 25, 2012 6:41:09 PM UTC+1, The Natural Philosopher wrote:
> tom 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.
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]