How to access the same catid when i am using the next previous buttons and in this i am showing the images limited that is 9
what i need is to get the catname and with that catid and imgid this tblcat and tblimage are two different tables
please help me i am in a big trouble
thanks in advance
help me from the php code
Moderator: General Moderators
-
salmanshafiq
- Spammer :|
- Posts: 2
- Joined: Sat May 27, 2006 7:54 am
- Contact:
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
Descriptive subjects
No the air is too clear.
See how vagueness makes people wonder what you meant?
See how vagueness makes people wonder what you meant?
[url=http://forums.devnetwork.net/viewtopic.php?t=30037]Forum Rules[/url] Section 1.1 wrote:2. Use descriptive subjects when you start a new thread. Vague titles such as "Help!", "Why?" are misleading and keep you from receiving an answer to your question.
What i think he/she is trying to say is that is that they have a limit of 9 images per page and they want multiple pages per catagorey.
well best way to do this is create a query that limits the selection to the page ou are on.
$endrows = ($page * $maxperpage)
$startrows = $endrows - $maxperpage
them limit it to
SELECT * FROM images WHERE catid = $catid ORDER BY imgid LIMIT $startdown, $endrows;
hope it helps
well best way to do this is create a query that limits the selection to the page ou are on.
$endrows = ($page * $maxperpage)
$startrows = $endrows - $maxperpage
them limit it to
SELECT * FROM images WHERE catid = $catid ORDER BY imgid LIMIT $startdown, $endrows;
hope it helps