I have a database which contains my color definitions for GD2 in the format:

ColorName, Red, Green, Blue

Example:

Red, 255, 0, 0

I am pulling the values from the database and want to assign them via GD2"imagecolorallocate", I just can't seem to get my head around it today so please help if you can... This is the code I have so far.

PHP Code:

 SQL="Select * From Colors";
$ColorValues = mysql_query($SQL);
while $Values = mysql_fetch_array($ColorValues)
{
    $ColorName = $Values["Name"];
    $Red = $Values["Red"];
    $Green = $Values["Green"];
    $Blue = $Values["Blue"];
} 


your while statement needs to be this:

PHP Code:

while($Values = mysql_fetch_array($ColorValues)) 


instead of this:

PHP Code:

while $Values = mysql_fetch_array($ColorValues) 


for one thing

***EDIT***
Did you know that instead of this:

PHP Code:

    $Red = $Values["Red"];
    $Green = $Values["Green"];
    $Blue = $Values["Blue"]; 


You may do this?

PHP Code:

      extract($Values); 


This will create variables of the same name as the associate array index names.