[Listing X Amount of Items From A MySQL Database?]

I guess I asked that wrong. :(

I have pages of data that come across but I need page breaks every 5 items so when we print it out, it doesn't run across the bottom/top margins.

[Listing X Amount of Items From A MySQL Database?]

We have information that I display in tables in PHP. I need to be able to list 5 items per page (since 5 is the max amount that looks like it would fit on a page without running over into the next page.)

What is the easiest way to accomplish this?

Thanks!

[Modification To ONE Entry When Multiples Exist?]

In my game I have several tables of different decks of cards. Now, some of these cards are duplicated in the deck (items, spells, etc.) and each card has a unique \'cardid\' entry in the table.

 

Now, if a player achieves a spell, and the deck has 3 copies of the same spell (and they have separate unique cardid\'s), all 3 entries are tagged as drawn by the player - where it should only tag one of them, freeing the other two entries to be drawn by other players.

 

The Table search is done based on the Spell NAME (not the cardid) so that I have the ability to add more spells in the future.

 

How do I tag just ONE instance of the card in the DB instead of ALL of them?

 

Thanks!

[Graphic Popups On Mouse RollOvers?]

Hey Buzzweiser, will this also make the window disappear when you roll off the original image?

[Graphic Popups On Mouse RollOvers?]

I have some graphics on a page that are kind of small. I would like a larger image of the graphic to popup when someone puts the mouse over the top of one of these graphics (w/out clicking) and then have the larger version of the graphic disappear when the mouse is rolled off.

 

What\'s the best way to do that in DW MX?

 

Thanks!

[Using Rollovers As 'Submit' Buttons And Passing Values?]

That\'s what I ended up doing and it works like a charm!

[Do You HAVE To Split MySQL Querys Into 2 Lines?]

Gotcha!

 

So it\'s best that I go ahead and keep doing it for consistancy.

[Deleting sql entries older than a certain date]

Check the source for something like phpbb2. It\'ll have ALL that sorta info in it.

[Do You HAVE To Split MySQL Querys Into 2 Lines?]

I was just wondering what the difference was between:

 

$query = \"SELECT * FROM [tablename] WHERE [whatever]=[whatever]\";

$result = mysql_query($query);

 

and

 

$result = mysql_query(\"SELECT * FROM [tablename] WHERE [whatever]=[whatever]\");

 

Is it just better programming practice to split them up? I\'m still very new to this and would like to start off on the right foot.

 

Thanks!

[Intermittant Error]

Every so often I get this error when I go to load my game:

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in index.php on line 23

 

The query is setup just like every other query in the game and it doesn\'t happen all the time. :/ What would cause this?

 

Thanks!

[Loading Files In Code View - Sometimes Fonts Are Different?]

\'Small Fonts\' and 7pt.

[Loading Files In Code View - Sometimes Fonts Are Different?]

Okie Dokie - checked and they\'re both Courier New - one was 9 pt and the other was 10 pt. :/

[Using Rollovers As 'Submit' Buttons And Passing Values?]

First off, sorry for the crosspost, but I wasn\'t sure which one to put this in. I\'m using Dreamweaver but the function is Javascript.

 

Since starting to use DW (6.1) - I\'ve been changing my Form Submit buttons into Graphic Rollovers and they work great if I need to go from page to page:

 

<form name=\"activatedok\" method=\"post\" action=\"index.php\">

<a onmouseout=\"MM_swapImgRestore()\" onmouseover=\"MM_swapImage(\'Image1\',\'\',\'./images/button-sdragon.gif\',1)\"><img name=\"Image1\" border=\"0\" src=\"./images/button-return.gif\" onclick=\"document.activatedok.submit()\"></a>

</form>

 

Now I\'ve come to a point that I need to actually PASS a variable to another php file like a normal Submit button but I can\'t figure out how to do it. :/ The statement that would need to pass would be:

 

<form name=\"purchase_guide\" method=\"post\" action=\"purchase.php\">

<font color=\"#FFFFFF\" size=\"3\" face=\"Times New Roman, Times, serif\"><strong><em>Only 1 Allowed Per Game</em></strong></font><br>

<a onmouseout=\"MM_swapImgRestore()\" onmouseover=\"MM_swapImage(\'Image6\',\'\',\'./images/button-sdragon.gif\',1)\"><img name=\"Image6\" border=\"0\" src=\"./images/button-buy.gif\" onclick=\"document.purchase_guide.submit()\"></a>

</form>

 

And I would need to pass (to \'purchase.php\') the values of:

 

value=\"Buy Guide\" name=\"buyitem\"

 

How would I do this?

 

Thanks!

[Loading Files In Code View - Sometimes Fonts Are Different?]

LOL - that\'s how I feel too

 

OK - I\'m working on my site - I load one .php into the codeview so that I can work on it. I realize that I want to copy some code from a 2nd .php prgram so I open that too. Now, when I opened the first .php, it displays in, like, the system font. When I open the 2nd .php, it displays in something like Times New Roman or something (it\'s just a bit harder to read.)

 

Hopefully that makes sense now.

[Loading Files In Code View - Sometimes Fonts Are Different?]

I noticed last night while working on different files in Code View that sometimes a window will list the code in a different font than a previous window. One will window will be arial and the next will be times.

 

Is there a way to set a default so that all the different coding windows are in ONE font?

 

Thanks!

[Dreamweaver Loads Blank Files?]

DOH!

 

<Humbly sits down in the corner with the dunce cap on>

[Dreamweaver Loads Blank Files?]

I was working on my site last night and then tried to work on them today. I see them listed in the project window on the right, but when I double click them, they come up blank. If I go File/Open they still come up blank.

 

I know they\'re not empty because I can load them into PHPEdit and they list the way they\'re supposed to.

 

Any ideas why this would be happening?

 

Using DW-MX 6.1.

 

Thanks!

[Too Many Connections accessing MySQL from PHP]

I was wondering about that. What happens if a person gets into the game, opens the connection and then leaves? Does the next person open a new connection or do they just \'piggyback\' onto the existing one?

[Too Many Connections accessing MySQL from PHP]

Greetings!

 

I am Soooooo glad I found this site. It actually helped me finish my Game Project (http://www.dk-tower.com) but while working on it, I ran into some issues.

 

While looking at the code (which I based on the Membership System Tutorial v1) , there seem to be an awful lot of hits to the database and at times, the website (game & support site itself) show MySQL errors (Too Many Connections).

 

Is there something I can do to optimize the code so that it doesn\'t do this?

 

Thanks!