It appears you have not yet registered with DEVPPL. To register please click here... (it's fast, easy and free!)

Forum

Log In Sponsors
Board index Programming PHP and MySQL Forum

While Loop 5x

Moderator: Malcolm

Postby webmaster on Fri Oct 03, 2008 2:52 pm

Oh, I'm sorry, missed a detail, try this:

[php]$page_query = tep_db_query("select
p.pages_id,
p.sort_order,
p.status,
s.pages_title,
s.pages_html_text,
s.intorext,
s.externallink,
s.link_target
from
" . TABLE_PAGES . " p LEFT JOIN " .TABLE_PAGES_DESCRIPTION . " s on p.pages_id = s.pages_id
where
p.status = 1
and
p.page_type != 1
and
s.language_id = '" . (int)$languages_id . "'
order by
p.sort_order, s.pages_title LIMIT 5");[/php]
Make sure to check out our TNX Review and Link Vault Review
User avatar
webmaster
Site Admin
 
Posts: 2695
Joined: Tue Aug 17, 2004 1:07 pm
Location: Sweden

Postby nighthawk on Sat Oct 04, 2008 8:12 am

@Johnathan


Put your php code inside [php] tags.
The Zeitgeist Movement
User avatar
nighthawk
250+ Club
 
Posts: 420
Joined: Sun Jun 11, 2006 1:53 pm
Location: SFRJ

Postby cutibiz on Sat Oct 04, 2008 3:16 pm

o thx! it working fine now~!!!

thanks alot
cutibiz
 
Posts: 13
Joined: Fri Aug 22, 2008 6:47 pm

Postby flabbyrabbit on Sun Oct 05, 2008 3:13 pm

Seems to change the font for the whole post.

[php][/php]

Flabby Rabbit
Image
User avatar
flabbyrabbit
500+ Club
 
Posts: 706
Joined: Thu Jan 25, 2007 1:10 pm
Location: Midlands, England

Re: While Loop 5x

Postby npsari on Sun Jan 11, 2009 10:55 pm

You need to add this ; after LIMIT 15

So, it will be LIMIT 15;
npsari
 
Posts: 19
Joined: Thu Mar 08, 2007 7:14 pm
Location: England

Previous

Who is online

Users browsing this forum: No registered users and 0 guests