Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #7164

Re: Dynamic Links (MySQL/PHP)

Show all headers | View raw

On 25-09-2012 20:17, tom.rankin51@googlemail.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.rankin51@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
>>
>>>
>>
>>
>>
>> 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...

Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Dynamic Links (MySQL/PHP) tom.rankin51@googlemail.com - 2012-09-25 10:27 -0700
  Re: Dynamic Links (MySQL/PHP) The Natural Philosopher <tnp@invalid.invalid> - 2012-09-25 18:41 +0100
    Re: Dynamic Links (MySQL/PHP) tom.rankin51@googlemail.com - 2012-09-25 10:58 -0700
    Re: Dynamic Links (MySQL/PHP) tom.rankin51@googlemail.com - 2012-09-25 11:34 -0700
      Re: Dynamic Links (MySQL/PHP) Luuk <luuk@invalid.lan> - 2012-09-25 21:07 +0200
  Re: Dynamic Links (MySQL/PHP) Luuk <luuk@invalid.lan> - 2012-09-25 20:02 +0200
    Re: Dynamic Links (MySQL/PHP) tom.rankin51@googlemail.com - 2012-09-25 11:17 -0700
      Re: Dynamic Links (MySQL/PHP) Luuk <luuk@invalid.lan> - 2012-09-25 21:04 +0200
        Re: Dynamic Links (MySQL/PHP) tom.rankin51@googlemail.com - 2012-09-25 23:24 -0700
          Re: Dynamic Links (MySQL/PHP) Denis McMahon <denismfmcmahon@gmail.com> - 2012-09-26 14:03 +0000
  Re: Dynamic Links (MySQL/PHP) Captain Paralytic <paul_lautman@yahoo.com> - 2012-09-26 05:05 -0700
    Re: Dynamic Links (MySQL/PHP) Jerry Stuckle <jstucklex@attglobal.net> - 2012-09-26 11:16 -0400

csiph-web