1.
      got problem with php/mysql. The think is i alredy retype 4 times, dont know wahat to do.So i let ya'll know my work:
   2.
       
   3.
       
   4.
      Mysql table: (the table name is, jokes)
   5.
        id  ;   text  ;  other
   6.
      -------------------------
   7.
        1   ;   blah  ;  bluh
   8.
        2   ;  blah   ; bluh
   9.
       
  10.
      Here is the complete script for this table
  11.
      ----------------------------------------------------------------------------------------
  12.
      <?php
  13.
      $dbcnx=@mysql_connect('localhost', 'root', '');
  14.
      if (!@dbcnx) {
  15.
         echo( '<p>Unable co connect to the database server at this time.</p>' );
  16.
         exit();
  17.
         }
  18.
      mysql_select_db('jokes', $dbcnx);
  19.
      if (! @mysql_select_db('jokes') ) {
  20.
         
  21.
      die ( '<p>Unable to locate the joke' .
  22.
          ' database at this time.</p>');
  23.
         }
  24.
       
  25.
      $sql = 'create table Jokes (
  26.
         id int not null auto_increment primary key,
  27.
         JokeText text,
  28.
         JokeOther text,
  29.
         JokeDate date not null)';
  30.
      if (@mysql_query($sql)) {
  31.
         echo('<p>Jokes table successfuly created!</P>' );
  32.
         }
  33.
         else {
  34.
            die('<p>Error creating Jokes table:' .
  35.
            mysql_error() . '</p>');
  36.
            }
  37.
      ?>
  38.
      -------------------------------------------------------------------------------------------
  39.
       
  40.
      Add heres the joke list scrip (i think no problemo for this scrip)
  41.
       
  42.
      ------------------
  43.
      <?php
  44.
      $dbcnx=@mysql_connect('localhost', 'root', '');
  45.
      if (!@dbcnx) {
  46.
         echo( '<p>Unable co connect to the database server at this time.</p>' );
  47.
         exit();
  48.
         }
  49.
      mysql_select_db('jokes', $dbcnx);
  50.
      if (! @mysql_select_db('jokes') ) {
  51.
         
  52.
      die ( '<p>Unable to locate the joke' .
  53.
          ' database at this time.</p>');
  54.
         }
  55.
       
  56.
      $sql = 'create table Jokes (
  57.
         id int not null auto_increment primary key,
  58.
         JokeText text,
  59.
         JokeOther text,
  60.
         JokeDate date not null)';
  61.
      if (@mysql_query($sql)) {
  62.
         echo('<p>Jokes table successfuly created!</P>' );
  63.
         }
  64.
         else {
  65.
            die('<p>Error creating Jokes table:' .
  66.
            mysql_error() . '</p>');
  67.
            }
  68.
      ?>
  69.
      ---------------------------------------------------------------
  70.
       
  71.
      the PROBLEM IS IN HERE, adding+deleting data. for the adding data its ok. but the problem is from the DELETING data. CANNOT DELETE.
  72.
      This is the script:
  73.
       
  74.
      ---------------------------------------------------------------------------------------------
  75.
       
  76.
      <html>
  77.
      <body>
  78.
       
  79.
      <?php
  80.
        if (isset($_GET['addjoke'])):
  81.
      ?>
  82.
       
  83.
       
  84.
      <form action="<?=$_SERVER['PHP_SELF']?>" method="post">
  85.
      <p>Type your jokes here:<br />
  86.
      <textarea name="joketext" rows="10" cols="40" wrap>
  87.
      </textarea><br />
  88.
      <input type="submit" name="submitjoke" value="submiT" /></p>
  89.
      </form>
  90.
      <?php
  91.
         else:
  92.
       
  93.
      $dbcnx=@mysql_connect('localhost', 'root', '');
  94.
      if (!@dbcnx) {
  95.
         echo( '<p>Unable co connect to the database server at this time.</p>' );
  96.
         }
  97.
       
  98.
      if (! @mysql_select_db('jokes') ) {
  99.
         die ( '<p>Unable to locate the joke database at this time.</p>');
 100.
         }
 101.
       
 102.
       
 103.
       
 104.
      if (isset($_POST['submitjoke'])){
 105.
         $joketext = $_POST['joketext'];
 106.
       
 107.
      $sql = "insert into jokes set
 108.
         joketext='$joketext',
 109.
         jokedate=CURDATE()";
 110.
       
 111.
      if (@mysql_query($sql)) {
 112.
         echo('<p>your joke has been added</P>' );
 113.
         }
 114.
         else {
 115.
            echo('<p>error adding joke: ' . mysql_error() . '</p>');
 116.
            }
 117.
         }
 118.
       
 119.
       
 120.
       
 121.
       
 122.
       
 123.
       
 124.
       
 125.
       
 126.
       
 127.
      if (isset($_GET['deletejoke'])) {
 128.
         $jokeid = $_GET['deletejoke'];
 129.
         $sql = ("DELETE FROM jokes WHERE id='$jokeid'");
 130.
       
 131.
         if (@mysql_query($sql)) {
 132.
              echo('<p>The joke deleted.</p>');
 133.
         } else {
 134.
              echo ('<p>ERROR DELETING JOKE: ' . mysql_error() . '</p>');
 135.
           }
 136.
      }
 137.
       
 138.
       
 139.
       
 140.
       
 141.
       
 142.
       
 143.
       
 144.
       
 145.
       
 146.
       
 147.
       
 148.
       
 149.
       
 150.
      echo('<p>Here are all the jokes in database:</p>');
 151.
       
 152.
       
 153.
      $result = @mysql_query('select joketext from jokes');
 154.
       
 155.
      if (!$result) {
 156.
         die('<p>Error performing query' . mysql_error() . '</p>');
 157.
         }
 158.
       
 159.
       
 160.
       
 161.
       
 162.
       
 163.
       
 164.
       
 165.
       
 166.
       
 167.
       
 168.
       
 169.
      while ($row= mysql_fetch_array($result) ) {
 170.
         $jokeid = $row['id'];
 171.
         $joketext = $row['joketext'];
 172.
         echo('<p>' . $joketext . '<a href="' . $_SERVER['PHP_SELF'] . '?deletejoke=' . $jokeid . '">' . 'Delete this joke<a/></p>');
 173.
      }
 174.
       
 175.
       
 176.
       
 177.
       
 178.
       
 179.
       
 180.
       
 181.
       
 182.
       
 183.
       
 184.
       
 185.
       
 186.
       
 187.
       
 188.
      echo('<p><a href="' . $SERVER['PJP_SELF'] .
 189.
         '?addjoke=1">Add  a Joke!</a></p>');
 190.
       
 191.
       
 192.
      endif;
 193.
       
 194.
      ?>
 195.
       
 196.
       
 197.
      </body>
 198.
      </html>
 199.
      ---------------------------------------------------------------------------
 200.
      When i click the delete link,nothing happen, it wont delete the data, just said "the joke is deleted" when i click the link.
 201.
      ---------------------------------------------------------------------
 202.
      thanx for the help