Hey! I am trying to redo my website onto a new layout, but every time, im getting an error. My new layout is at: rapidadds.com/adder/ Here is the code to that layout: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html><head> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Tmplt02wiP</title> <link href="Files/layout.css" rel="stylesheet" type="text/css" /></head> <body> <div id="mBody"> <div id="cLeft"> <div id="CHeader"><b>Your Status</b></div> <div id="SideC"> <table width="100%"> <tr id="Nav"> a </table> </div> <div id="CHeader"><b>Not Sure</b></div> <div id="SideC"><b><u></u></b><br /> b </div> <div id="CHeader"><b>News & Updates</b></div> <div id="SideC"><b><u></u></b><br /> c </div> </div> <!-- The Difference between Left and Right is this message --> <div id="cRight"> <div id="CHeader"><b>Site Status</b></div> <div id="SideC"><b><u></u></b><br /> d </div> <div id="CHeader"><b>Not Sure</b></div> <div id="SideC"> e </div> <div id="CHeader"><strong>Featured Artists</strong></div> <div id="SideC"> f </div> </div> <div id="ContentHead"><b>Tell About Whats going on</b></div> <div id="Content">g</td></tr> </table><br> </div> <div id="ContentHead"><b>Add Users ECT</b></div> <div id="ContentGallery"> h</div> </table> </div> <center> Legal Info... </div> </body> </html> PHP: ----------------- and, where is says: "h" (I labeled the boxes), I try to put this code: <?php $page_name="home.php"; if(!isset($start)) { $start = 0; } $eu = ($start - 0); $limit = 500; $counter = 0; $columns = 6; $this1 = $eu + $limit; $back = $eu - $limit; $next = $eu + $limit; $nume = 500; $query=" SELECT * FROM xtrm_users WHERE DAYS > 0 ORDER BY days DESC LIMIT $eu, $limit "; $result=mysql_query($query); echo mysql_error(); while($user = mysql_fetch_array($result)) { $date = date(Ymd); ?> <td align=center><fieldset class=userfieldset><legend class=userlegend align=center><small><?PHP echo $user[name]?></small></legend><a href=add.php?id=<?PHP echo $user[fid]?>&date=<?PHP echo $date?> target=_blank><img src=<?PHP echo $user[pic]?> width=70 height=70><br><center><small><?PHP if($user[days]>0){ echo $user[days];?> days.<?php } else { echo $user[points];?> pts.<?PHP }?></small></center></a></fieldset></td> <?PHP $counter++; if($counter%$columns==0) echo "<tr></tr>"; } if($nume > $limit ){ ///if($back >=0) { ///print "<a href='$page_name?start=$back'><font face='Verdana' size='2'>PREVIOUS PAGE</font></a> -- "; ///} ///$i=0; ///$l=1; ///for($i=0;$i < $nume;$i=$i+$limit){ ///if($i <> $eu){ ///echo " <a href='$page_name?start=$i'><font face='Verdana' size='2'>$l</font></a> "; ///} ///else { echo "<font face='Verdana' size='4' color=red>$l</font>";} ///$l=$l+1; ///} if($this1 < $nume) { print "<a href='$page_name?start=$next'> <font face='Verdana' size='2'>CLICK HERE TO ADD MORE!</font> </a>";} else { echo "<font face='Verdana' size='2'>DAILY LIMIT REACHED...</font>"; } } ?> </tr> PHP: and, i get an error that says: Warning: mysql_query() [function.mysql-query]: Access denied for user 'tyler99'@'localhost' (using password: NO) in /home/tyler99/public_html/adder/index.php on line 148 Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/tyler99/public_html/adder/index.php on line 148 & Access denied for user 'tyler99'@'localhost' (using password: NO) Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/tyler99/public_html/adder/index.php on line 150 -------------------------------------------------------------------------- Now, the file script with the errors is: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html><head> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Tmplt02wiP</title> <link href="Files/layout.css" rel="stylesheet" type="text/css" /></head> <body> <div id="mBody"> <div id="cLeft"> <div id="CHeader"><b>Your Status</b></div> <div id="SideC"> <table width="100%"> <tr id="Nav"> a </table> </div> <div id="CHeader"><b>Not Sure</b></div> <div id="SideC"><b><u></u></b><br /> b </div> <div id="CHeader"><b>News & Updates</b></div> <div id="SideC"><b><u></u></b><br /> c </div> </div> <!-- The Difference between Left and Right is this message --> <div id="cRight"> <div id="CHeader"><b>Site Status</b></div> <div id="SideC"><b><u></u></b><br /> d </div> <div id="CHeader"><b>Not Sure</b></div> <div id="SideC"> e </div> <div id="CHeader"><strong>Featured Artists</strong></div> <div id="SideC"> f </div> </div> <div id="ContentHead"><b>Tell About Whats going on</b></div> <div id="Content">g</td></tr> </table><br> </div> <div id="ContentHead"><b>Add Users ECT</b></div> <div id="ContentGallery"> <?php $page_name="home.php"; if(!isset($start)) { $start = 0; } $eu = ($start - 0); $limit = 500; $counter = 0; $columns = 6; $this1 = $eu + $limit; $back = $eu - $limit; $next = $eu + $limit; $nume = 500; $query=" SELECT * FROM xtrm_users WHERE DAYS > 0 ORDER BY days DESC LIMIT $eu, $limit "; $result=mysql_query($query); echo mysql_error(); while($user = mysql_fetch_array($result)) { $date = date(Ymd); ?> <td align=center><fieldset class=userfieldset><legend class=userlegend align=center><small><?PHP echo $user[name]?></small></legend><a href=add.php?id=<?PHP echo $user[fid]?>&date=<?PHP echo $date?> target=_blank><img src=<?PHP echo $user[pic]?> width=70 height=70><br><center><small><?PHP if($user[days]>0){ echo $user[days];?> days.<?php } else { echo $user[points];?> pts.<?PHP }?></small></center></a></fieldset></td> <?PHP $counter++; if($counter%$columns==0) echo "<tr></tr>"; } if($nume > $limit ){ ///if($back >=0) { ///print "<a href='$page_name?start=$back'><font face='Verdana' size='2'>PREVIOUS PAGE</font></a> -- "; ///} ///$i=0; ///$l=1; ///for($i=0;$i < $nume;$i=$i+$limit){ ///if($i <> $eu){ ///echo " <a href='$page_name?start=$i'><font face='Verdana' size='2'>$l</font></a> "; ///} ///else { echo "<font face='Verdana' size='4' color=red>$l</font>";} ///$l=$l+1; ///} if($this1 < $nume) { print "<a href='$page_name?start=$next'> <font face='Verdana' size='2'>CLICK HERE TO ADD MORE!</font> </a>";} else { echo "<font face='Verdana' size='2'>DAILY LIMIT REACHED...</font>"; } } ?> </tr> </div> </table> </div> <center> Legal Info... </div> </body> </html> PHP: so, if you could, please help me...
Where do you have your mysql username and password to connect to your database at? The errors you are receiving sound like you don't have permission to access the database.
Hi guys, i bought a script from a guy yesterday for a friend adder site... its supposed to be straight forward but it isnt working. i emailed the seller & got an auto response that he is "currently traveling" can anyone pleaaaase help? I have 2 issues I need help fixing! the site is www.tyrealmusic.com/index.php i followed these instructions INSTALLATION: 1: Create a database on your server and name it whatever you like... attach a user to that database 2: Import xtrm_database.sql file into the database 3: Edit the database connection info in these files, config.php - cronjob.php I use Geocities Pro & per their instructions the $host is mysql (not localhost) so I changed that & the front of house website appears by not the admin page which is www.tyrealmusic.com/admin_control Im getting this error but i dont know why... SQL query: SELECT label, id FROM `__DBNAME__`.`PMA_bookmark` WHERE dbase = 'adder' AND ( user = 'tyreal' OR user = '' ) ORDER BY label MySQL said: #1146 - Table '__DBNAME__.PMA_bookmark' doesn't exist PHP: ok thats 1 issue.. the second is.. when I try to log in with a valid myspace ID it says invalid ID & doesn't sign in however when i put nothing in the login field it goes to the other pages inside which should a protected area. You help would be greatly appreciated!!