Member Avatar for kristyan

Is there any way i can able to execute the 3rd query? The selected columns where columns 6,7 and 8 The output of the second query are output1, output2 and output3 I want to update the selected columns with the informations from the second query

$query=mysql_query("SHOW COLUMNS FROM table LIKE 'SELECTEDCOLUMNS%'");
while($result=mysql_fetch_array($query))
{
$column=$result[0];
echo $column;
}

$query1=mysql_query("SELECT * FROM table WHERE <MY_CONDITIONS>");
while($result1=mysql_fetch_array($query1))
{
$grade=$result1[0];
echo ('<input type=text value="$grade" name="have no idea what to put here">');
}

$query2=mysql_query("UPDATE table SET `$column`='name of textbox'");
  • 2 Contributors
  • 1 Reply
  • 188 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by diafol
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.