I need a little script

Discussion in 'PHP' started by Carey, Apr 28, 2007.

0
  1. #1
    I own an image hosting website and would like to know how I could get the amount of pictures uploaded on the frontpage of the site. Anyone know how I could do this?
     
    Carey, Apr 28, 2007 IP
  2. Subikar

    Subikar Active Member

    Messages:
    241
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    60
    #2
    Subikar, Apr 28, 2007 IP
  3. yourihost

    yourihost Well-Known Member

    Messages:
    1,708
    Likes Received:
    45
    Best Answers:
    0
    Trophy Points:
    115
    #3
    Does your script you mysql if yes it is simple
     
    yourihost, Apr 28, 2007 IP
  4. Carey

    Carey Active Member

    Messages:
    370
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    80
    #4
    my site does.. yes
     
    Carey, Apr 28, 2007 IP
  5. yourihost

    yourihost Well-Known Member

    Messages:
    1,708
    Likes Received:
    45
    Best Answers:
    0
    Trophy Points:
    115
    #5
    Ok do this , make a mysql connection to the database then run this.

    Edit it according

    $query = mysql_query("SELECT * FROM Images");
    $number=mysql_num_rows($query);
    echo "Total Images Hosted= ". $number;
     
    yourihost, Apr 28, 2007 IP
  6. Carey

    Carey Active Member

    Messages:
    370
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    80
    #6
    im a newb.. could you go step by step?
     
    Carey, Apr 28, 2007 IP
  7. Wyla

    Wyla Well-Known Member

    Messages:
    924
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    140
    #7
    can't get much more step-by-step than that.

    replace Images with your tables name and your set.

    Paste the code into your frontpage.
     
    Wyla, Apr 28, 2007 IP
  8. Carey

    Carey Active Member

    Messages:
    370
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    80
    #8
    perfect haha. thanks a bunch
     
    Carey, Apr 28, 2007 IP
  9. yourihost

    yourihost Well-Known Member

    Messages:
    1,708
    Likes Received:
    45
    Best Answers:
    0
    Trophy Points:
    115
    #9
    No problem.
     
    yourihost, May 12, 2007 IP