vb.org Archive - Coding assistance (news system)

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - Coding assistance (news system) (https://vborg.vbsupport.ru/showthread.php?t=78169)

Nickeh32

03-15-2005 04:24 PM

Coding assistance (news system)

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

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

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

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

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?

All times are GMT. The time now is 11:34 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01736 seconds Memory Usage 1,732KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (2)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (5)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: