Advanced Search

Page 4 of 9 FirstFirst ... 23456 ... LastLast
Results 31 to 40 of 86

Thread: MySQL Database showing on a page.

  1. #31
    Join Date
    Jun 2006
    Posts
    148
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    I think its like accross the top...

    Habbo Name, Song Request, Shoutout/Joke, ID
    Cheap Webhosting At ONE TIME fees! Also offering Scripts, Software, Web Designs, and Graphic Designs. Outstanding Designs and Webhosting!

  2. #32
    Join Date
    Jun 2005
    Location
    英国
    Posts
    11,878
    Thanks
    1
    Thanked 180 Times in 172 Posts
    Blog Entries
    2

    Default

    Well how about you find out?
    Twey | I understand English | 日本語が分かります | mi jimpe fi le jbobau | mi esperanton komprenas | je comprends franšais | entiendo espa˝ol | t˘i Ýt hiểu tiếng Việt | ich verstehe ein bisschen Deutsch | beware XHTML | common coding mistakes | tutorials | various stuff | argh PHP!

  3. #33
    Join Date
    Jun 2006
    Posts
    148
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Yeah its....

    Habbo Name, Song Request, Shoutout/Joke, ID


    (I found out...)
    Cheap Webhosting At ONE TIME fees! Also offering Scripts, Software, Web Designs, and Graphic Designs. Outstanding Designs and Webhosting!

  4. #34
    Join Date
    Jun 2006
    Posts
    148
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    -sighs-
    Cheap Webhosting At ONE TIME fees! Also offering Scripts, Software, Web Designs, and Graphic Designs. Outstanding Designs and Webhosting!

  5. #35
    Join Date
    Jun 2006
    Posts
    148
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    hmmmmmmmmmmmmmmmmmmmmmmm...
    Cheap Webhosting At ONE TIME fees! Also offering Scripts, Software, Web Designs, and Graphic Designs. Outstanding Designs and Webhosting!

  6. #36
    Join Date
    Apr 2006
    Posts
    429
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Joe, have u tried the latest script posted by Twey?

    anywayz, i did and it worked on my local web server

    <EDIT>

    HTML Code:
    <table border=1><tr><th>0</th><th>ID</th><th>1</th><th>Habbo Name</th><th>2</th><th>Song Request</th><th>3</th><th>ShoutOut/Joke</th><th>del</th></tr><tr>
    <td></td>
    <td></td>
    <td></td>
    <td></td>
    <td></td>
    <td></td>
    </tr></table>
    why is there an additional table header before the ID, Habbo Name, Song Request, ShoutOut/Joke? and extra table data after the execution of the request.php
    Last edited by jr_yeo; 07-12-2006 at 05:51 PM.

  7. #37
    Join Date
    Jun 2006
    Posts
    148
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Ok... I am reallly confused.

    This is EXACCLY whats in the requests.php file:

    Code:
    <?php
    
    $conn = mysql_connect('localhost', 'smiletest', 'jjaadd');
    mysql_select_db('smiletest');
    $tablename = 'request';
    $uniquerow = 'ID';
    if(isset($_GET['delete']))
      if(!is_numeric($_GET['delete'])) die();
      else mysql_query('delete from `' . $tablename . '` where ' . $uniquerow . '=\'' . $_GET['delete'] . '\';');
    
    $rs = mysql_query('select * from `' . $tablename . '`;');
    $row = mysql_fetch_array($rs);
    $cols = array();
    foreach($row as $k => $v)
      array_push($cols, $k);
    array_push($cols, 'del');
    echo('<table><tr>');
    for($i = 0; $i < count($cols); ++$i)
      echo('<th>' . $cols[$i] . '</th>');
    echo('</tr>');
    do {
      $row['del'] = '<form action="?delete=' . $row[$uniquerow] . '" method="get"><input type="submit" value="Delete"></form>';
      echo('<tr>');
      for($i = 0; $i < count($cols); ++$i) {
    ?>
    <td><?php echo($row[$i]); ?></td>
    <?php
      }
      echo('</tr>');
    } while($row = mysql_fetch_array($rs));
    echo('</table>');
    ?>

    And what was the thingy you posted?????? Huh?:

    Code:
    <table border=1><tr><th>0</th><th>ID</th><th>1</th><th>Habbo Name</th><th>2</th><th>Song Request</th><th>3</th><th>ShoutOut/Joke</th><th>del</th></tr><tr>
    <td></td>
    <td></td>
    <td></td>
    <td></td>
    <td></td>
    <td></td>
    </tr></table>
    Where is that supposed to go? :| God i'm confused...
    Cheap Webhosting At ONE TIME fees! Also offering Scripts, Software, Web Designs, and Graphic Designs. Outstanding Designs and Webhosting!

  8. #38
    Join Date
    Apr 2006
    Posts
    429
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    the output of the request.php if u run the script
    Quote Originally Posted by jr_yeo
    Joe, have u tried the latest script posted by Twey?
    anywayz, i did and it worked on my local web server
    Last edited by jr_yeo; 07-13-2006 at 10:57 AM.

  9. #39
    Join Date
    Jun 2006
    Posts
    148
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    Omg i am REALLY CONFUSED!
    Cheap Webhosting At ONE TIME fees! Also offering Scripts, Software, Web Designs, and Graphic Designs. Outstanding Designs and Webhosting!

  10. #40
    Join Date
    Apr 2006
    Posts
    429
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    question have u tried running the request.php?

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
  •