While Loop 5x

[cutibiz]

Hello

I need some PHP help here. I have got a list of name generated out from the database.

It actually a OSC site.

Code: Select all

$page_query = [i]the normal query code[/i]               
   
echo '<ul>';

    while ($page = tep_db_fetch_array($page_query)) {   
         echo '<li>' . $page['pages_title'] . '</li>';
   }

echo '</ul>';


This codes works however, I want to show only the 1st 5 data row in the database. How do I do that?

Please help!!! thanks

[webmaster]

When writing the query, just add LIMIT 5 at the end, like this:

Code: Select all

SELECT * FROM tablename LIMIT 5

[cutibiz]

hi

thanks for responding however when I insert the "LIMIT 5" , no data is display.

[webmaster]

Can you write the whole query

[cutibiz]

sry for the late reply.

here you go!


[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");[/php]

[webmaster]

If that query works, this should also work:

[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]

[Johnathan]

WM, how if your font different from everyone elses?

[cutibiz]

there an error

"Parse error: syntax error, unexpected T_STRING in C:\Program Files\xampplite\htdocs\osc\includes\boxes\artist_bio.php on line 34"

[webmaster]

Do you get that error before adding "LIMIT 5" too?

[cutibiz]

no. it working fine, without error before I add "LIMIT 5"