links | back | to check loops and prints 'rows' by setting which rows to print

\n"; //gets what's in the rows and prints while ($myrow = mysql_fetch_row($result)) { printf("
  • %s %s %s\n", $myrow[1], $myrow[2], $myrow[3]); } //finishes by printing this shit echo "

    edit

    "; ?> loops and gets row by specifying item in row to print with error handling\n"; do { printf("
  • %s %s %s
    • \n", $myrow["id"], $myrow["item"], $myrow["priority"]); } while ($myrow = mysql_fetch_array($result)); echo "

    done\n"; } else { echo "Sorry, no records were found!"; } ?> creates a link that connects to self to print only that record based on id number

    "; do { printf("
  • %s %s
    \n", $PHP_SELF, $myrow["id"], $myrow["item"], $myrow["priority"]); if ($id) { $result = mysql_query("SELECT * FROM todo WHERE id=$id",$db); $myrow = mysql_fetch_array($result); printf("

    item: %s\n
    ", $myrow["item"]); printf("priority: %s\n

    ", $myrow["priority"]); } else { // show employee list $result = mysql_query("SELECT * FROM todo",$db); if ($myrow = mysql_fetch_array($result)) { // display list if there are records to display do { printf("
  • %s %s
    \n", $PHP_SELF, $myrow["id"], $myrow["item"], $myrow["priority"]); } while ($myrow = mysql_fetch_array($result)); } else { // no records to display echo "Sorry, no records were found!"; } } } while ($myrow = mysql_fetch_array($result)); } else { echo "Sorry, no records were found!"; } ?> this prints based on id in the url, or if nothing specified, prints whole table with links to select by id"; if ($id) { $result = mysql_query("SELECT * FROM todo WHERE id=$id",$db); $myrow = mysql_fetch_array($result); printf("

    item: %s\n
    ", $myrow["item"]); printf("priority: %s\n

    ", $myrow["priority"]); } else { // show employee list $result = mysql_query("SELECT * FROM todo",$db); if ($myrow = mysql_fetch_array($result)) { // display list if there are records to display do { printf("
  • %s %s
    \n", $PHP_SELF, $myrow["id"], $myrow["item"], $myrow["priority"]); } while ($myrow = mysql_fetch_array($result)); } else { // no records to display echo "Sorry, no records were found!"; } } ?> "; if ($submit) { // process form while (list($name, $value) = each($HTTP_POST_VARS)) { echo "$name = $value
    \n"; } } else{ // display form ?>
    id:
    item:
    priority:
    "; if ($submit) { // process form $db = mysql_connect("oak.he.net", "evanrose", "t3zydodx"); mysql_select_db("evanrose",$db); $sql = "INSERT INTO todo (id,item,priority) VALUES ('$id','$item','$priority')"; $result = mysql_query($sql); echo "Thank you! Information entered.\n"; } else{ // display form ?>
    id:
    item:
    priority:
    oddly, this returns a new record, with next available id number
    actually, this block does nothing.
    "; if ($id) { // query the DB $sql = "SELECT * FROM todo WHERE id=$id"; $result = mysql_query($sql); $myrow = mysql_fetch_array($result); ?>
    "> item:">
    priority:">
    %s %s
    \n", $PHP_SELF, $myrow["id"], $myrow["item"], $myrow["priority"]); } } ?>
    this block prints links, then upon select by id allows to edit individual rows
    then upon submit, inserts into db
    "; if ($id) { if ($submit) { $sql = "UPDATE todo SET item='$item',priority='$priority' WHERE id=$id"; $result = mysql_query($sql); echo "Thank you! Information updated.\n"; } else { // query the DB $sql = "SELECT * FROM todo WHERE id=$id"; $result = mysql_query($sql); $myrow = mysql_fetch_array($result); ?>
    "> item name:">
    priority name:">
    %s %s
    \n", $PHP_SELF, $myrow["id"], $myrow["item"], $myrow["priority"]); } } ?> create table work (forwhom CHAR(64), name CHAR(64), id INT ); ok, this is the finale, item, if submitted...

    "; if ($submit) { // here if no ID then adding else we're editing if ($id) { $sql = "UPDATE todo SET item='$item',priority='$priority' WHERE id=$id"; } else { $sql = "INSERT INTO todo (item,priority) VALUES ('$item','$priority')"; } // run SQL against the DB $result = mysql_query($sql); echo "Record updated/edited!

    "; } elseif ($delete) { // delete a record $sql = "DELETE FROM todo WHERE id=$id"; $result = mysql_query($sql); echo "$sql Record deleted!

    "; } else { // this part happens if we don't press submit if (!$id) { // print the list if there is not editing $result = mysql_query("SELECT * FROM todo",$db); while ($myrow = mysql_fetch_array($result)) { printf("%s %s \n", $PHP_SELF, $myrow["id"], $myrow["item"], $myrow["priority"]); printf("(DELETE)
    ", $PHP_SELF, $myrow["id"]); } } ?>

    ADD A RECORD

    item name:
    priority name:

    begin new testing