Database Question

[Hector]

Hi all,

New here. I am looking to build a database. I am new to PHP/mySQL. I have already followed Kevin's tutorial and been able to build a very simple database almost identical to his jokes database.

My problem is that I want my database to be able to return common entries. For eg. if one column is called names and has the same name entered, with associated different entries for the other column, I want to be able to select all the entries for that name. also same for the other columns.

Also How do I password protect the database so that anyone can make entries but you need a password to delete/modify entries.

Thanks, Hector

[sonique]

where is this tutorial?

[Hector]

Kevin Yank's Tutorial from this very site

[Aes]

The article is located here:
http://www.webmasterbase.com/article.php?aid=228&pid=0

For pulling multiple entries out of a database, suppose you have a field named name in a database named mysite. To select all entries that contain the name Colin, use a construct like this:

select * from mysite where name like "%Colin%"

That will select all of the data from the table that has the value Colin anywhere in the name field. To print that out, I would use a simple while-loop statement with the mysql_fetch_array function like so:

<?php
while ($result = mysql_fetch_array($query))
{
     $name = $result["name"];
     echo("content from database where name is $name");
}
?>

Does this make sense at all?

As for the password protecting, you could use a simple if;elseif;else set of statements to allow or disallow people to edit the database. If you're wanting extremely high security though, I would recommend looking into PHP's session handling capabilites or the .htaccess file on your server.

Good luck!