Oh! Yeah indeed, I knew the line, but I actually thought it wouldn't be that simple, but I guess it is! :)
It works completely and just the way I want it! Really really thanx for your great and patient help!
Yes I know, but that's not what I meant. Right now, if you're on the first page, with 10 rows, you are viewing the first 20 ID's. On the second page, as there are only 27 items in the table, you will view the items 21 - 27. But what I meant, was if it was possible to view the items 27 to 8 on...
Thx! I had already deleted the second '<' from the first code, that wasn't supposed to be there lol.
Awesome, that works! I also already fixed the download code and now I've got one question left. Is it easy to make it that the last ID's show on the first page and the first ID's show on the...
Okay, I know why the paging didn't work... since the code wasn't integrated into the rest of the code we talked about above (beginning of thread). If you check the page again: http://www.bar2ayunie.com/Blue_Layout_Pages/Graphics/Textures9.php (newest version)
You can see the paging code at the...
Ah sorry forget the first 'create' table, I took one from another table (the first one on my list), then I thought I'd better take the one that's linked to the page we're talking about. I forgot to delete it. Sorry and now I see that I could better dropped the codes into a code table, but I...
I am using MySQL version 5.0.32.
CREATE TABLE `affiliates` (
`id` int(4) NOT NULL auto_increment,
`url` varchar(250) NOT NULL default '',
`name` varchar(100) NOT NULL default '',
`this_month` int(5) NOT NULL default '0',
`last_month` int(5) NOT NULL default '0',
`month_count` tinyint(2) NOT...
It still shows all of the items from the database. I didn't do any customising yet, since I wanted it to work first. I tried setting the limit from 10 to 5 to see if it makes any difference, but nothing has changed. Maybe it helps if I show you the page I'm using it on?
Here's the link...
Okay, the error is gone! Thx! And yes, I'm stupid, it indeed had to state graphics_textures...
Anyway, no errors or whatsoever and I do have a 'next' button there, all of the 27 items are on the first page and by clicking on the next button leads to the same page or at least with the same...
I have found various options to use the paging script and I've used the following script:
$records_per_page = 10;
//find out how many records are in the table
$count_query = "SELECT count(*) from graphics_textures";
$rh = mysql_query ($count_query);
list ($record_count) =...
Omg! I fixed it! I thought the problem lied within the <div>'s somewhere. I've had that problem before (a <div> or </div> too much or too many( and the rest of the page was broken and not displayed. So I started deleting something out of the closing echo <div> tags from the code you provided...
When I add that code below the rest, it shows nothing. When I add it above the php code, it shows these errors:
Notice: Undefined index: id in /customers/bar2ayunie.com/bar2ayunie.com/httpd.www/Blue_Layout_Pages/Graphics/Textures5.php on line 57
Notice: Undefined variable: maxcols in...
Thx, but this still doesn't fix my right menu... the right menu (as I said above about the CSS method) is still missing... any idea how this is possible?
Thank you very very much!! I'm sorry for spiralling off the thread... It doesn't matter which one I use, as long as I've got a method that works...
I've tried out both of the codes, both work (for which I'm greatful), but both have a mistake. I'm not saying you made a mistake, but I think that...
Thx for helping out! From what you provided, I created the following code to insert the things I want to have displayed from the table. I used the plain code before and that totally works. Now I probably have an error somewhere in my code when trying to show the info from the table...
To show you what I mean, I re-created the code I made before combining the code of your link and my code. I get an error that the last line of code (no matter what the last line is) is wrong. It says: Parse error: syntax error, unexpected $end. I can delete everything after the code, it all is...
Yes I already read that topic and I tried to use the script, but I must do something wrong since it either goes into errors or I'm missing info or it's mainly just showing one column... That's what I asked in that topic, so maybe somebody can help me to put that code (the one from your link)...
Hello, I have a php code to display a few things from my sql database. Right now, it's listed in rows:
item 1
item 2
item 3
and so on
But I want to list all of the info in rows AND two columns, like this:
item 1 item 2
item 3 item 4
and so on
I've looked endlessly on google to find codes...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.