Some questions.

[ghosttr]

I have a table that i would like to display.

There are 2 fields in this table, name & color.

And i have a table, html of course.

The first column in the table will be a lit of names,
The second the names, written in the color specified
The third is a form where you can change the color.

Im trying to learn php, and I know how to do this in a program such as excel, but unfortunately the tutorials I find on the internet are often vague😕

I know that i can output the data to a table. And I can use the form to change the database. But I am having a few issues getting everything in there.

Does anyone know where i could look up some examples of what i am looking for?

[ghosttr]

I have spent a foe hours playing around and have got everything how i think it should be. I have setup variables that display the color, and the form will post data into the database.

There is one problem that i am still having, I cannot access the database right.

I have it setup to access the database, and select the variables from the database.

I start getting into trouble when i want to assign the results to a variable and have it print only one row.

this code just puts out a list of everything

while ($row = mysql_fetch_array ($result)) {

echo "color: ".$row["color"]."<br>\n";

echo "name: ".$row["name"]."<br>\n";

}

I need to be able to select on row and output it, not just have it sipt out all of the data

[laserlight]

If you only want one row, then you should change your SQL query to select only one row, and then remove the loop.

[ghosttr]

I decided to make an array and use that to get it.

Now i have everything working fine except the forms.

I want to use a drop down list like this one

<form id="form1" name="form1" method="post" action="">
      <select name="select" id="select">
        <option value="<?php print $results[0]['color']; ?>" selected>Keep Color</option>
        <option value="FF0000">Red</option>
        <option value="3300FF">Blue</option>
        <option value="33FF00">Green</option>
      </select>
    </form>

With the form i want it to update the change for a certain color name

So if i want to display the text "red" in green i would want to change the database with the form.