lol, well..in order to retreive from a database, ur gona need a database, and ur tables - im gona asume uve already done this.
Now, in order to rereive, you also need data actually in the database to retrieve.
Your site's requirements arnt "complex" but they arn't "simple" for the php "newbie".
Youur really gona need a few things, heres some things i'd advice you to try and make in order for your site to function correctly:
1 - Basic Administration Section
(where you can add your clients to the database - i dont think you want a membership system as they are "clients" and not "members" - quite a difference). You could also use instead - PHPMyAdmin - whichever you prefer...perhaps the admin panel idea would enhance your php skills and experience therefore preparing yourself for future challanges?
2 - A script that fetches the info from the database and displays it on the page according to what value is called in the url.
In your admin section, you would basically have a form with fields like: Client Name, Client Info etc whatevever you want. Just make sure you have the columns made in your tables for them.
Now... lets say you have your "admin section" made, or your gona use PHPMyAdmin, and the url requested is: h**p://yoursite.com/clients.php?cid=Client1 -- clients.php is the page, Client1 is the value to cid carried via the url.
Now on clients.php you would basically do somelike this:
if ($cid)
{
mysql_connect($host, $user, $pass) or die ("Couldnt connect");
mysql_select_db($dbname) or die ("Couldnt select database");
$query = "SELECT * FROM $client_table WHERE ClientName='$cid'";
// This selects all fields from the database where the id is equal to that carried in the url of the value of "cid"
mysql_db_query($dbname, $query) or die ("Query failed: ".mysql_error());
// This actually "executes" the query to the database
$result = mysql_db_query($dbname, $query);
while ($row = mysql_fetch_array($result))
{
$col_1 = "$row[Col1]"; // Colume 1 from table
$col_2 = "$row[Col2]"; // Colume 2 from table etc etc
// Or; you could actually print stuff inside this while loop like:
echo "$row[Col1]<br>"; // etc
}
// Ive used the while loop here, to form an array using the $row variable in order to fetch the colums name from the table, therefor being able to assign different variables and echo within that loop for that spesific client id
}
else
{
echo "No valid client id has been spesified";
}
I've used a series of IF statements here in order for a more "accurate" display. All the above code would be on "clients.php" in this case. When you code, you really should think exactly what you want to do in each step, write it down and then work out how to do it, like: Insert Into Database. Fetch From Database For ID. Echo Variables. etc.
As for a URL like: h**p://yoursite.com/ClientId - I don't know sorry, but I thought id reply with the above info anyway, good luck!
(btw, havnt actually checked any of this code for errors etc).
