PDA

View Full Version : Coding assistance (news system)

Nickeh32
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:

//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
//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.


$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:

//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?