<?php
		include ("bd.php");
		
		if (!isset($id))
		{  
		
		$result = mysql_query ("SELECT title,id FROM lessons");
		$myrow = mysql_fetch_array($result);
		
		do
		{
		printf ("<p><a href='edit_lesson.php?id=%s'>%s</a></p>",$myrow["id"],$myrow["title"]);
		}
		
		while ($myrow = mysql_fetch_array($result));
		
		}
		
		else
		
		{
		$result = mysql_query ("SELECT * FROM lessons WHERE id=$id");
		$myrow = mysql_fetch_array($result);
		
		echo<<<CODE
		form name="form1" method="post" action="update_lesson.php">
          <p>
            <label>title of lesson<br />
              <input value="$myrow[title]" type="text" name="title" id="title" />
              </label>
          </p>
          <p>
            <label>description<br />
            <input value="$myrow[meta_d]" type="text" name="meta_d" id="meta_d" />
            </label>
          </p>
          <p>
            <label>keywords<br />
            <input value="$myrow[meta]" type="text" name="meta_k" id="meta_k" />
            </label>
          </p>
          <p>
            <label>insert date<br />
            <input value="$myrow[date]" name="date" type="text" id="date" />
            </label>
          </p>
          <p>
            <label>enter description<br />
            <textarea value="$myrow[description]" name="description" id="description" cols="60" rows="5"></textarea>
            </label>
          </p>
          <p>
            <label>text<br />
            <textarea value="$myrow[text]" name="text" id="text" cols="60" rows="20"></textarea>
            </label>
          </p>
          <p>
            <label>author <br />
            <input type="text" name="author" id="author" />
            </label>
          </p>
          <p>
            <label>
            <input type="submit" name="submit" id="submit" value="Submit" />
            </label>
          </p>
        </form>
		CODE;
		
		}
		?>