Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
  #1  
Old 12-31-2002, 11:02 PM
Ember's Avatar
Ember Ember is offline
 
Join Date: Sep 2002
Location: Hereford, England
Posts: 200
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Only display a certain number of chars? (and other problems)

Ok, I am working on making a news script for a new site... I have currently come up with these problems:

I want to show a snippet of the news post on the main page, but how can i restrict the number of characters that are displayed?

For example - "Yadda Yadda has died today after an assasination in his home..."

I only want it to display a certain number of characters or words, or whatever I can restrict! Can anyone help me with that?

Also...

Can anyone tell me an effective way to have user comments on news posts, I thought of having a table called "comments" and then a "postid" field... and then displaying all the comments where the postid=1 or whatever, but how do I set postid from one table and then read it in another?

Please help me in as plain-english as possible, I havent been into this PHP stuff too long, I have made some scripts though, so I know a fair bit.

Thanks for your time!
Reply With Quote
  #2  
Old 12-31-2002, 11:54 PM
Ember's Avatar
Ember Ember is offline
 
Join Date: Sep 2002
Location: Hereford, England
Posts: 200
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Here's the query I have at the moment:

PHP Code:

<?

$sqlhostname = "localhost";
$login = "******";
$password = "******";
$base = "******";

$db_connect = mysql_connect($sqlhostname,$login,$password);
$base_selection = mysql_select_db($base,$db_connect);

$query = "SELECT * FROM gaming_news ORDER BY id  ASC  LIMIT 0,1";
$req = mysql_query($query);

if (!$req)
{ echo "<B>Error ".mysql_errno()." :</B> ".mysql_error()."";
exit; }
$res = mysql_num_rows($req);

if ($res == 0)
   { echo "<center><b>Sorry there is no result.</b></center>";}
else 
   { while($row = mysql_fetch_array($req))
            {
               extract($row);

                      echo"<img src=\"images/newslatest.gif\" align=\"left\"><b>$headline</b> posted by: <b>$author</b> - $story_text... <br>[<b>read full story</b>]

";
    }
mysql_free_result($req);
}

?>
I'll be wanting to limit $story_text

Hope that helps you to help me!
Reply With Quote
  #3  
Old 12-31-2002, 11:59 PM
Kevitt Kevitt is offline
 
Join Date: Oct 2002
Posts: 5
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally posted by OrangeCow.net
Ok, I am working on making a news script for a new site... I have currently come up with these problems:

I want to show a snippet of the news post on the main page, but how can i restrict the number of characters that are displayed?

For example - "Yadda Yadda has died today after an assasination in his home..."

I only want it to display a certain number of characters or words, or whatever I can restrict! Can anyone help me with that?
For this use the SUBSTR() function like so...

PHP Code:
echo substr($MY_SNIPPET,0,100); 
this would show the first 100 characters in that snippet.
Reply With Quote
  #4  
Old 01-01-2003, 12:00 AM
Kevitt Kevitt is offline
 
Join Date: Oct 2002
Posts: 5
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

whoa! instaposted!
Reply With Quote
  #5  
Old 01-01-2003, 12:01 AM
Ember's Avatar
Ember Ember is offline
 
Join Date: Sep 2002
Location: Hereford, England
Posts: 200
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks, but how would I work that into my current query?
Reply With Quote
  #6  
Old 01-01-2003, 12:01 AM
Ember's Avatar
Ember Ember is offline
 
Join Date: Sep 2002
Location: Hereford, England
Posts: 200
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thats quite mad, lol!
Reply With Quote
  #7  
Old 01-01-2003, 12:06 AM
Kevitt Kevitt is offline
 
Join Date: Oct 2002
Posts: 5
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I've adjusted your code to spit out the first 100 chars. Look at the line where $story_text is located. Notice $story_text has now become ".substr($story_text,0,100)."

Hope that helps
PHP Code:
<?

$sqlhostname = "localhost";
$login = "******";
$password = "******";
$base = "******";

$db_connect = mysql_connect($sqlhostname,$login,$password);
$base_selection = mysql_select_db($base,$db_connect);

$query = "SELECT * FROM gaming_news ORDER BY id  ASC  LIMIT 0,1";
$req = mysql_query($query);

if (!$req)
{ echo "<B>Error ".mysql_errno()." :</B> ".mysql_error()."";
exit; }
$res = mysql_num_rows($req);

if ($res == 0)
   { echo "<center><b>Sorry there is no result.</b></center>";}
else 
   { while($row = mysql_fetch_array($req))
            {
               extract($row);

                      echo"<img src=\"images/newslatest.gif\" align=\"left\"><b>$headline</b> posted by: <b>$author</b> - ".substr($story_text,0,100)."... <br>[<b>read full story</b>]

";
    }
mysql_free_result($req);
}

?>
Reply With Quote
  #8  
Old 01-01-2003, 12:08 AM
Ember's Avatar
Ember Ember is offline
 
Join Date: Sep 2002
Location: Hereford, England
Posts: 200
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

thanks very much, i'll keep you posted on how the site comes along!
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 09:00 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05905 seconds
  • Memory Usage 2,226KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (3)bbcode_php
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (8)post_thanks_box
  • (8)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (8)post_thanks_postbit_info
  • (8)postbit
  • (8)postbit_onlinestatus
  • (8)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete