Kylo

just one last question.... if I wanted to link one of those demo1 or demo2 to a file to download, what would I do to edit the code?

ahhh, its all good, I delete that db user and created a new one with new password. I got the code to work by tweaking the table to this.. { echo ' <TR> <TD>', $myrow["demo1"], '</TD></TR> <TR> <TD>', $myrow["demo2"], '</TD></TR> <TR> <TD>', $myrow["demo3"], '</TD></TR> <TR> <TD>', $myrow["demo4"], '</TD></TR> <TR> <TD>', $myrow["demo5"], '</TD></TR> </TR>'; } and now the it looks perfect on my site, thank you.

what u mean Barand?

alright... I am trying this but getting a parse error... [code] <?php $db = mysql_connect("localhost", "******", "********"); mysql_select_db("nwn2wor_veneratio",$db); $result = mysql_query("SELECT * FROM `demos`",$db); or die("Query failed: $sql<br />".mysql_error()); if(!mysql_num_rows($result))   {   echo "No results returned by query $sql";   } else   { "<TABLE>"; while($myrow = mysql_fetch_array($result)) { "<TR><TD>"; $myrow["demo1"]; "</TR></TD>"; "<TR><TD>"; $myrow["demo2"]; "</TR></TD>"; "<TR><TD>"; $myrow["demo3"]; "</TR></TD>"; "<TR><TD>"; $myrow["demo4"]; "</TR></TD>"; "<TR><TD>"; $myrow["demo5"]; "</TR></TD>"; } "</TABLE>"; ?> [/code] also... cant someone just view source and see the login/password? mod edit  : security data removed and code tags added

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: NO) in /home/nwn2wor/public_html/Veneratio2/index.php on line 113 this is what I got back, but if I am going to have to put in my user and password... cant someone steal that?

well, I have created a database and a table within the db called demos.... trying to get this code to work in my .html page now... I tried this... <?php $db = mysql_connect("localhost", "root", ""); mysql_select_db("nwn2wor_veneratio",$db); $result = mysql_query("SELECT * FROM `demos` WHERE 1`demo1``demo2``demo3``demo4``demo5`",$db); echo "<TABLE>"; while($myrow = mysql_fetch_array($result)) { echo "<TR><TD>"; echo $myrow["demo1"]; echo "<TR><TD>"; echo $myrow["demo2"]; echo "<TR><TD>"; echo $myrow["demo3"]; echo "<TR><TD>"; echo $myrow["demo4"]; echo "<TR><TD>"; echo $myrow["demo5"]; } echo "</TABLE>"; ?>

okay, which is the easiest way, cause I aint the hotest with DBs and such. Which code would I insert into those cells.

What I wana do is make it so if I changed the "Latest Demos" section on the index.html it will automatically change the other .html pages like roster.html, sponsors.html and so forth. This way I dont have to manually edit each page by itself.

I have been doing a lot of google searching and such but still havent be able to come up with anything to help me with what I need, and I finally found this site and decided I will post to see if anybody can help. I am currently trying to code my clan site (best viewed in IE, Firefox hates me), and I am trying to find a way to make information update itself on multiple pages by only changing it on one. I know this can be done, cause I have seen it mentioned, but never seen any code. I dont know php or how to make or code a database. So all the more help, the better I can understand to help someone else if needed. Alright, my test site is www.nwn2world.com/Veneratio2 The information I want to update on all pages is the "Latest Demos", "Latest Matches" and "Veneratio Misc." Boxes. (Again, please view in IE for best results atm) Thank you.