The Arcive of vBulletin Modifications Site.

Nickeh32 · #1 03-15-2005, 04:24 PM

I'm making my own news system, i am having a problem showing the second table, it will only show one.
my code:

Code:

//selecting the 'news' database to use 
    mysql_select_db("news");
	
//Get todays date 
    $today = date("l F dS Y"); 
	
// create sql statement
$query="SELECT * FROM news";
$result=mysql_query($query);

// total row number
$num=mysql_numrows($result);

// news fieds
$title=mysql_result($result,$i,"title");
$news=mysql_result($result,$i,"news");

I know it's simple, but i'm quite new to this.
Can anyone help?

sabret00the · #2 03-15-2005, 05:24 PM

PHP Code:


			
//selecting the 'news' database to use 

mysql_select_db("news");

    

//Get todays date 

$today = date("l F dS Y"); 

    

// create sql statement

$query = "SELECT * FROM news";

$result = mysql_query($query);



// total row number

$num = mysql_num_rows($result);



// news fieds

$title = mysql_result($result,$i,"title");

$news = mysql_result($result,$i,"news");

was the only thing i noticed.

Nickeh32 · #3 03-15-2005, 05:35 PM

Just works the same.

It may be the template.

Code:

$stylevar[htmldoctype]
<html dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">
<head>
<title>$vboptions[bbtitle] - $pagetitle</title>
$headinclude
</head>
<body>
$header
$navbar
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%">
<tr>
	<td class="tcat">$pagetitle</td>
</tr>
<tr>
	<td class="tfoot"><table width="100%"  border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td colspan="2" scope="row"><b>$title</b></td>
      </tr>
      <tr>
        <td colspan="2" scope="row">$news</td>
      </tr>
      <tr>
        <td width="50%" scope="row"><i>$today by </i></td>
        <td width="50%" scope="row">&nbsp;</td>
      </tr>
    </table></td>
</tr>
</table>

$footer
</body>
</html>

sabret00the · #4 03-15-2005, 06:14 PM

is this is vB you should vBulletinise your script.

if you want to return more than the first row you're gonna have to throw in a loop (while) to cycle through the rows.

Nickeh32 · #5 03-15-2005, 06:54 PM

Yes, i have no added a loop.
It is because of the template but i don't know how to sort it,
I'm getting very conffused by it all.

Code update:

PHP Code:


			
//selecting the 'news' database to use 

    mysql_select_db("news");

    

//Get todays date 

    $today = date("l F dS Y"); 

    

// create sql statement

$query="SELECT * FROM news";

$result=mysql_query($query);



// total row number



$num=mysql_num_rows($result);



if ($num>5) {

$to=5;

}else{

$to=$num;

}



$i=0;

while ($i < $to) {

// news fieds

$title=mysql_result($result,$i,"title");

$news=mysql_result($result,$i,"news");

// news fields end

$i++;

}

mysql_close();

and what do you mean by bulletinise?

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05588 seconds Memory Usage 4,680KB Queries Executed 11 (?)
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 (2)bbcode_code (2)bbcode_php (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (5)post_thanks_box (5)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (5)post_thanks_postbit_info (5)postbit (5)postbit_onlinestatus (5)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_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
Messages: