Results 1 to 5 of 5

Thread: 2 Questions

  1. #1

    Thread Starter
    Fanatic Member Gimlin's Avatar
    Join Date
    Dec 2001
    Location
    Hell
    Posts
    734

    2 Questions

    1. How would I go about editing an entry?
    2. How would make it only show then, then have a link that would show next 10

    thanks

  2. #2
    Assuming we're talking about MySQL...

    1.
    Code:
    UPDATE table SET column=value
    2.
    Code:
    SELECT columns FROM table LIMIT first row returned, last row returned

  3. #3
    scoutt
    Guest
    actually #2 would be

    SELECT columns FROM table LIMIT first row returned, # of rows returned

  4. #4
    Right, sorry.

    Also elaborating on 1:
    Code:
    UPDATE table SET column=value, another column=another value... WHERE boolean LIMIT start row, total rows

  5. #5

    Thread Starter
    Fanatic Member Gimlin's Avatar
    Join Date
    Dec 2001
    Location
    Hell
    Posts
    734
    So for 1.

    Can I do this

    $sql = ("UPDATE cat SET title=$_REQUEST[title] WHERE id=1");

    And it will update title?

    If now how do I tell it where to update?

    EDIT:Nevemind I was just missing some qoutes
    Last edited by Gimlin; Jul 5th, 2002 at 03:07 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width