Posts tagged database

PHP HELP….. SORTING MYSQL DATABASE INFO ON 5 PAGES…?

Apr 27th

Posted by admin in Script

1 comment

Question by x_9th.gate_x:
PHP help….. sorting mysql database info on 5 pages…?
I have a game tournament site, I need to display the current tournaments available sorted by game name throughout 5 pages (10 tournaments per page).

The current script for it is….

$ table_select = mysql_query(‘SELECT * FROM 9Gt_tables ORDER BY game DESC LIMIT 10′);

this displays the first 10, for the other pages how do i begin at 11 and go to 20, the 21-30, etc….
ok, so how do i go about that?

Read More >>

, , , , ,

USING A DATABASE VARIABLE INSIDE AN OPTION VALUE IN A DROP DOWN BOX?

Dec 20th

Posted by admin in Script

2 comments

Question by shortpc89:
Using a database variable inside an option value in a drop down box?
I want to put a drop-down box on my gaming site. The user will be able to click on the box and the box will drop down and show a list of games that are in the database. Each game listed in the box will have a link to it. The link will be generated based on the ID of the game in the database.

At the moment, the code I have right now is this:

The Javascript:

The dropdown box:

    • The problem is that when it shows up on my site, the actual names of the games do not show up. Instead the code shows up. For instance, ” .$ row['gameName']. ” will loop itself over and over again int he menu and the link, when clicked on, will look like this: http://www.mmocraze.com/game-directory/game-profile/?gameId=” .$ row[

    Here's the code my friend sent me (without the javascript and action page (haven't tried it yet):

    < ?php

    $ sql = "SELECT gameId, gameName FROM game ORDER BY gameName";
    $ result = mysql_query($ sql);

    while($ row = mysql_fetch_array($ result))
    {

    $ gameId = $ row['gameId'];
    $ gameName = $ row['gameName'];

    print(”

    Can anyone help me with this?

    Read More >>

    , , , , , , ,

    HOW DO YOU CREATE AN ONLINE DATABASE FOR LETS SAY.. A GAME SITE.?

    Feb 6th

    Posted by admin in Script

    3 comments

    Search engine

    Question by Scare:
    How Do you Create An On the web Database for Lets Say.. A Game Site.?
    Something Like Neopets, or Gaiaonline.. How Does that System Work and where would i Have to Look to Learn About it. So Far all i know is that its Got something to Do with Scripting..

    Also, Does Anyone Know a Good Website Host?

    Read More >>

    , , , , , ,

    WHERE CAN I FIND A HUGE DATABASE OF WEBSITE SCRIPTS?

    Dec 25th

    Posted by admin in Script

    8 comments

    Question by Willy Foroner:
    Where can I find a large database of website scripts?
    Or maybe a script clone? I do not know. I am trying to learn how to create a Top 100 Sites voting page. Any suggestions?

    Read More >>

    , , , ,