Help with MySQL

[Anon]

Hi, i'm new to using MySQL databases in my PHP pages, and I would like some help with this:

If I have a table like this:

---

| Name: | Value: |

OnE | valueone
TwO | valuetwo

ThrEE | valuethree

If i put a variable like this in my script:
$value = "valueone"

How do i make the script print out the corresponing value in the same row of the "Name" column?

Please help me with this.

[Anon]

Well, first, we need to open a connection to the mysql server from php. We do this with mysql_connect() :

$dblink = mysql_connect("localhost", "root", "");

Note, this is host, user, and password. Your mileage may vary.

Next, we need to tell it what database to use

mysql_select_db("name_of_database");

Now that we have the connection setup, we need to issue an SQL query (if you don't understand the SQL part of this next command, search the internet you'll find some valuable resources):

$results = mysql_query("SELECT * FROM table_name WHERE Value = '$value'");

Note: all of the table names and column names here are CASE SESITIVE under unix. Now, we should have a result resource in $results. We now need the first row:

$data_row = mysql_fetch_array($results);

We should now have an array of all the data in the row that fufills the WHERE Value = '$value' clause. This array is in the form $data_row["field_name"] = value. So, to get the Name to print to the browser, we do:

echo $data_row["Name"];

And that should be it 😉 This might be a little much, but have a look at www.php.net/mysql, there is a lot of documentation and many examples for reference. Hope that helps!

Chris King

[Anon]

Thanks. I think this was what I was looking for =)