Jump to content

Orionsbelter

Members
  • Posts

    493
  • Joined

  • Last visited

Posts posted by Orionsbelter

  1. hi am trying to get an mysql array of some users, i want to randomly select 4 users that are online so i have done the following.

     

    mysql_fetch_object(mysql_query("SELECT username FROM users WHERE online > $timenow "));

     

    now i want to put all the usersnames into an array and the randomly pick four, anyone know how i would go about that please?

     

     

     

  2. ok, i set it too 100% height and it doesn't work, tried fillding for a few hours and given in :( any help pleases here is the code

     

    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>Untitled Document</title>
    <style type="text/css">
    <!--
    body {
    background-color: #000;
    }
    -->
    </style></head>
    
    <body>
    <img src="images/theebarn.png" width="258" height="56" />
    <table width="95%" border="1" bordercolor="#000000" align="center" cellpadding="0" cellspacing="0">
      <tr>
        <td height="30" bgcolor="#996600"> </td>
        <td bgcolor="#663300"> </td>
        <td bgcolor="#3E1F00"> </td>
        <td bgcolor="#BB5E00"> </td>
      </tr>
      <tr>
        <td colspan="4" height="100%"><iframe src="home.php" scrolling="auto" width="100%" height="600%" frameborder="0"></iframe></td>
        </tr>
    </table>
    <p>  <br />
    </p>
    </body>
    </html>
    

  3. Ok, am wanting to out put my top 10 forum posters but its not working here is the code

    <?php
                  $ex_query = mysql_query("SELECT * FROM `user_info` WHERE staff='0' ORDER BY `posts` DESC LIMIT 10");
    		  while ($ex = mysql_fetch_array($ex_query)) {
                  echo "
    		  <tr>
                    <td height='20' bgcolor='#333333'><div align='center'><a href='profile.php?user=$ex[username]'>$ex[username]</a></div></td>
                  </tr>
                       ";
                     }?>
    

     

    this out puts 10 people but not from highest to low or in an order help please!

  4. what i want is for someone to spell a word phonetically such as phone tick lee then the it searches the database to find  "phonetically"

     

     

    do you know where am going?

  5. ok say i want to search for hello world

     

     

    then it checks my database and i have two fields one called search next result

     

     

    it finds search(the) result(the hello world...)

     

    or gets (the) result(the hello world...)  how would that go?

  6. hello, am wanting to make a input box where someone will input a word/phases and a word suggestion will come up

     

     

    would the LIKE Function be best for this?

  7. Ok first i now hate IE how can i stop people on my website clicking submit buttons so it enters the data into the database lots of times

     

    for example

     

    someone clicks submit to get a hello message on there account

    after that they can't get another one

     

    but they click submit lots of times to get 100 messages

     

    it only happens in IE how can i stop this?

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.