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

Home » Imported messages » comp.lang.php » Dynamic Links (MySQL/PHP)
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Dynamic Links (MySQL/PHP) [message #179218] Tue, 25 September 2012 13:27 Go to next message
tom.rankin51 is currently offline  tom.rankin51
Messages: 17
Registered: September 2012
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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
Re: Dynamic Links (MySQL/PHP) [message #179219 is a reply to message #179218] Tue, 25 September 2012 13:41 Go to previous messageGo to next message
The Natural Philosoph is currently offline  The Natural Philosoph
Messages: 993
Registered: September 2010
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
tom(dot)rankin51(at)googlemail(dot)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.
Re: Dynamic Links (MySQL/PHP) [message #179221 is a reply to message #179219] Tue, 25 September 2012 13:58 Go to previous messageGo to next message
tom.rankin51 is currently offline  tom.rankin51
Messages: 17
Registered: September 2012
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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.
Re: Dynamic Links (MySQL/PHP) [message #179222 is a reply to message #179218] Tue, 25 September 2012 14:02 Go to previous messageGo to next message
Luuk is currently offline  Luuk
Messages: 329
Registered: September 2010
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
On 25-09-2012 19:27, tom(dot)rankin51(at)googlemail(dot)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
>

There is a missing 'mysql_select_db()'
http://php.net/manual/en/function.mysql-select-db.php
Re: Dynamic Links (MySQL/PHP) [message #179224 is a reply to message #179222] Tue, 25 September 2012 14:17 Go to previous messageGo to next message
tom.rankin51 is currently offline  tom.rankin51
Messages: 17
Registered: September 2012
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Both sections of code contain 'mysql_select_db() - should it be included a third time?

On Tuesday, September 25, 2012 7:10:02 PM UTC+1, Luuk wrote:
> On 25-09-2012 19:27, tom(dot)rankin51(at)googlemail(dot)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
>
>>
>
>
>
> There is a missing 'mysql_select_db()'
>
> http://php.net/manual/en/function.mysql-select-db.php
Re: Dynamic Links (MySQL/PHP) [message #179230 is a reply to message #179219] Tue, 25 September 2012 14:34 Go to previous messageGo to next message
tom.rankin51 is currently offline  tom.rankin51
Messages: 17
Registered: September 2012
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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(dot)rankin51(at)googlemail(dot)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.
Re: Dynamic Links (MySQL/PHP) [message #179234 is a reply to message #179230] Tue, 25 September 2012 15:07 Go to previous messageGo to next message
Luuk is currently offline  Luuk
Messages: 329
Registered: September 2010
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
On 25-09-2012 20:34, tom(dot)rankin51(at)googlemail(dot)com wrote:
> 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(dot)rankin51(at)googlemail(dot)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!
>>
>>>


try to add some 'debugging' code

and change '@mysql_select_db' to 'mysql_select_db'

add some echo statements after assignements

and see where the output stops, or is wrong/unexpected.......
Re: Dynamic Links (MySQL/PHP) [message #179235 is a reply to message #179224] Tue, 25 September 2012 15:04 Go to previous messageGo to next message
Luuk is currently offline  Luuk
Messages: 329
Registered: September 2010
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
On 25-09-2012 20:17, tom(dot)rankin51(at)googlemail(dot)com wrote:
> Both sections of code contain 'mysql_select_db() - should it be included a third time?
>
> On Tuesday, September 25, 2012 7:10:02 PM UTC+1, Luuk wrote:
>> On 25-09-2012 19:27, tom(dot)rankin51(at)googlemail(dot)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
>>
>>>
>>
>>
>>
>> There is a missing 'mysql_select_db()'
>>
>> http://php.net/manual/en/function.mysql-select-db.php
>

aaargh ;)

you did not pos the content of "php/dbinfo.inc.php"
and i missed $database.....

so i got a 'No database selected'... message

sorry...
Re: Dynamic Links (MySQL/PHP) [message #179251 is a reply to message #179235] Wed, 26 September 2012 02:24 Go to previous messageGo to next message
tom.rankin51 is currently offline  tom.rankin51
Messages: 17
Registered: September 2012
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
So is this worth debugging even though my error logs show nothing?
Re: Dynamic Links (MySQL/PHP) [message #179255 is a reply to message #179218] Wed, 26 September 2012 08:05 Go to previous messageGo to next message
Captain Paralytic is currently offline  Captain Paralytic
Messages: 204
Registered: September 2010
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
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.
Re: Dynamic Links (MySQL/PHP) [message #179258 is a reply to message #179251] Wed, 26 September 2012 10:03 Go to previous messageGo to next message
Denis McMahon is currently offline  Denis McMahon
Messages: 634
Registered: September 2010
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
On Tue, 25 Sep 2012 23:24:33 -0700, tom.rankin51 wrote:

> So is this worth debugging even though my error logs show nothing?

You're error logs might be showing nothing if you use "@" before function
calls, as this prevents errors from being logged.

Remove any "@" symbols that precede function calls and see if the logs
are still empty? It may be that you're looking at the wrong logs - what
web server are you using? On my ubuntu server with apache2, the errors
turn up in /var/log/apache2/error.log, which seems to be the default as I
have nothing specific in /etc/php5/apache2/php.ini to send them anywhere
else

If you (a) can identify the relevant php config file and (b) have the
access needed to edit it, check the settings in the "error handling and
logging" section and adjust if appropriate.

If you need guidance, don't post the whole section, just post the current
settings. Also post details of OS and server (eg linux/suse + apache2 or
windows XP server + IIS etc)

Rgds

Denis McMahon
Re: Dynamic Links (MySQL/PHP) [message #179260 is a reply to message #179255] Wed, 26 September 2012 11:16 Go to previous message
Jerry Stuckle is currently offline  Jerry Stuckle
Messages: 2598
Registered: September 2010
Karma: 0
Senior Member
add to buddy list
ignore all messages by this user
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
==================
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
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: Thu Dec 14 08:04:15 EST 2017

Total time taken to generate the page: 0.00834 seconds