searching a mysql database

[tbrenner]

i'm trying to search a database and really have no clue where to start. i can connect to the database via php, that's about it. can anyone give me some sample code of a search or a tutorial? anything is welcomed...brbrthanksbr

[zslotyi]

Hello tbrenner,

after connecting a database server(from php), you have to connect to a specific database to start a search.

this looks sg like:
$link = mysql_connect("localhost", "yourlogin", "yourpw")
or die("Could not connect");
mysql_select_db("your_db_name") or die("Could not select database");

you can start searching after this.

Searching looks sg like

SELECT "xyz" FROM your_table WHERE "zbd"

or from php
mysql_query("SELECT &bkfls;"xyz&bkfls;" FROM your_table WHERE &bkfls;"zbd&bkfls;"");

search criterias "xyz" and "zbd" can of course vary in a quite wide range. The most straightforward is this:

SELECT * FROM yourtable;

which gives you every record of your table.

Check out the MySql documentation, as that is a quite nice tutorial as well:
http://dev.mysql.com/doc/refman/5.0/en/tutorial.html

regards
zsl