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?
03-15-2005, 04:24 PM
Coding assistance (news system)
Threaded Mode