vb.org Archive - View Single Post

#2 09-17-2006, 01:52 AM

Quote:

Originally Posted by error_22

Hi,

I was wondering if someone could explain something to me. I have a file called news.php:

news.php

PHP Code:


			
<?


require ("./includes/db_con.php"); //connects to DB

$sql = "SELECT * FROM `p_news` ORDER BY `p_id` DESC";  
$result = mysql_query($sql) or die(mysql_error());  
while ($row = mysql_fetch_object($result))  
{      
$title = $row->p_title;
$content = $row->p_content;

echo $title;
echo "<br />";
echo $content;
echo "<br /><br />";

}
?>

Then I have another file, index.php:

index.php

PHP Code:


			
<?
require ("./includes/news.php");

echo $title;
echo "<br />";
echo $content;
echo "<br /><br />";
?>

My problem is, only the first row shows up, why is that, and how do I fix it?

Thanks in advance
Niklas

Because that while loop is already processed before you echo $title and $content...

If you make it like this:

PHP Code:


			
<?


 require ("./includes/db_con.php"); //connects to DB

$sql = "SELECT * FROM `p_news` ORDER BY `p_id` DESC";  
$result = mysql_query($sql) or die(mysql_error());  
while ($row = mysql_fetch_object($result))  
{      
$title = $row->p_title;
$content = $row->p_content;

 echo $title;
 echo "<br />";
 echo $content;
 echo "<br /><br />";

}
?>

It should work...

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01267 seconds Memory Usage 1,765KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD_SHOWPOST (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_php (1)bbcode_quote (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_box (1)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit_info (1)postbit (1)postbit_wrapper (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit reputationlevel showthread	Included Files: ./showpost.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 showpost_start bbcode_fetch_tags bbcode_create postbit_factory showpost_post 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 bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start showpost_complete
Messages: