WebSavvy
18-04-2006, 11:07/11:07AM
You need to make sure you've added a user & password for the db.
Use the MySQL section of CPanel and add a user/pass.
Then, there's a drop menu to add that newly created user to the db to give permissions to that user for the db. Select that user, and add them to the db.
When mysql tables are accessed it uses your root user as the prefix to the db.
So, if your path from root was something like:
/home/elbyweb/public_html/
Your mysql db would use elbyweb_ as the db prefix.
So, if your db is named www it becomes elbyweb_www
The user you create for the db would become elbyweb_user
(replacing user with whatever username you've created for use in that db).
So, now from start to finish in random.php we'd have all of this:
<?php
$connection = @mysql_connect("localhost" , "elbyweb_user" , "pass") or die (" Could not connect to the server. ");
$db = @mysql_select_db("elbyweb_db" , $connection) or die (" Could not select database. ");
$sql = "SELECT id, title, url, content FROM rotate ORDER BY RANDOM() LIMIT 1";
$sql_result = mysql_query($sql , $connection) or die ("Couldn't execute query.");
while ($row = mysql_fetch_array($sql_result))
{
$id = $row["id"];
$title = $row["title"];
$url = $row["url"];
$content = $row["content"];
echo <<<EOF
<p><a href="$url">$title</a><br>
$content</p>
EOF;
} // close db while loop
?>
Change from above "elbyweb_user" to reflect your root path user, and db user that you created.
Change from above "elbyweb_db" to reflect your root path user, and the db name you've created (e.g., www from our example).
Change from above "pass" to reflect the password you've assigned to the elbyweb_user in the elbyweb_db where the table rotate lives.
Create a folder on your site in the root, that you'll call /inc/ and place random.php there.
Then in your pages, call random.php into the page as follows:
<?php
@include("{$_SERVER['DOCUMENT_ROOT']}/inc/random.php");
?>
This should work. Let me know if there's any more issues?