SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Zealot
    Join Date
    Nov 2002
    Posts
    110
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    links database help

    hey guys im trying to set up a link database whereby people submit links and then i approve them.

    I've manged to get the links in to the database which all go in with a approved value of no.

    I want to be able to see all the unaproved links and approve them indervidualy. here is my code what do I need to modify? exmaples would be great.

    Thanks for yout time,

    PHP Code:
    <?php
        $result 
    mysql_query("SELECT * FROM links WHERE approved In ('no')",$dbcnx);

            while (
    $myrow mysql_fetch_row($result)) 
            {
            
    printf("\n%s \t %s \t %s \n"$myrow[1], $myrow[2], $myrow[3]);
            }

    ?>

  2. #2
    SitePoint Addict The Mog's Avatar
    Join Date
    Dec 2002
    Location
    Manchester UK
    Posts
    310
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    change your query to

    PHP Code:
    $query "SELECT * FROM links WHERE approved = 'no'";
        
    $result mysql_query($query,$dbcnx) or die("Query failed"); 


Bookmarks

Posting Permissions

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