Re: [PHP] PHP mySQL Syntax problem

MYSQL($Dbname, "INSERT INTO $Tbname_1 VALUES(1, 'John Doe', '$color')"); - single quotes around $color Jo Ann Comito wrote: I'm working in PHP4 and have suceeded in creating a mySQL table. I can fill the table using the INSERT command as follows: The above works fine. Here is the problem: In

[PHP] PHP mySQL Syntax problem

I'm working in PHP4 and have suceeded in creating a mySQL table. I can fill the table using the INSERT command as follows: The above works fine. Here is the problem: Instead of specifying the color, red, green, etc. I would like to generate a random color and store it in a variable, then use the