What I am finding difficult

Language: PHP
echo "<table border=';1';> 
<tr bgcolor=';#cccccc';><td>Book title</td><td>Author name</td><td>Author surname</td><td>Price</td><td colspan=';2';>Action</td></tr>"; //put the table header column outside the loop
 
 
……//query statement here
while($row = mysql_fetch_array($result)){ // the loop part of your query
 
$book_id=$row[';book_id]; // I want to use this later in a hidden field
 
echo "<tr><td>"; //put the table rows inside the loop, and draw the information from the db into a table row, one at a time
echo $row[';title';];
echo "</td><td>";
echo $row[';auth_name';];
echo "</td><td>";
echo $row[';auth_surname';];
echo "</td><td>";
echo $row[';price';];
echo "</td><td>";
echo "<a href=edit.php?book_id=$book_id&update=yes>Edit</a>";
echo "</td><td>";
echo "<a href=delete.php?book_id=$book_id&delete=yes>Delete</a>";
echo "</tr>";
}
echo "</table>"; //end the table outside the loop

Language: PHP
//insert
..array of data sent from form (if more than one course that is selected and needs to be inserted)
..array loop start to extract data from the array
....query 1 to insert into table 1...
.....get the ID generated in the last with query mysql_insert_id... 
.....query 2 to insert ID into table 2 
..array loop ends
 
//PHP nested queries to extract data (not good but just to get into the logic)
...query 1 to extract data
...while loop
...get data
......... query 2 to extract data from another table using the data above
.............while loop
.............get data
.............end while loop
...end while loop
 
// nested mysql
SELECT * FROM mytable WHERE ID in (SELECT ID FROM  other table);

Language: PHP
<input type="text" name="cname" value="<?php echo "$cname"; ?>">
//or
echo "<input type=\"text\" name=\"cname\" value="$cname">";

Language: PHP
$id=mysql insertid();

Language: PHP
//either
INSERT INTO table (fieldname1, fieldname2) VALUES....
//or
INSERT INTO table values (fieldname1, fieldname1, ';';.... the latter for empty fields