MySQL Question...

admin

Administrator
Staff member
How do I refer to a field within a table of a database to edit it so that I don't have to refer to one of the variables within the database itself so that I can alter all of the fields without any problems?

Here is what I have right now:
$result = mysql_query("SELECT * FROM $table_movies WHERE name='$name' AND time='$time'");

What i want to have is:
$result = mysql_query("SELECT * FROM $table_movies WHERE $record_id=987");
 
Top