Otrie desmit

[Snukzz]

Hmm.. kaads var pateikt luudzu priekshaa, kaa lai pasaka MySQL ar PHP paliidziibu ka man no konkreetaas tabulas vajag otros 10 ierakstus no konkreetas tabulas? :blink:

[Grey_Wolf]

Hmm.. kaads var pateikt luudzu priekshaa, kaa lai pasaka MySQL ar PHP paliidziibu ka man no konkreetaas tabulas vajag otros 10 ierakstus no konkreetas tabulas?  :blink:

23418[/snapback]

 

luudzu :)

$no=10;

$lidz=20;

 

$query="SELECT * FROM tabula WHERE nosacijums LIMIT $no, $liidz";

 

:P

[v3rb0]

nu gan..

 

limit 10, 10

 

vispārigi

limit <no kura, neieskaitot>, <cik ierakstus>

[Snukzz]

Blaaaviens pareizi! :lol: ... tagad atcereejos!!! :D .. vecums nenaak viens - smadzenes saak izkalst! :lol:

[Grey_Wolf]

nu gan..

 

limit 10, 10

 

vispārigi

limit <no kura, neieskaitot>, <cik ierakstus>

23420[/snapback]

mjaa .. aatrumaa rakstiju sajaucu shadi ir pareizi ....

[Snukzz]

Klau, kaapeec MySQL saka viss ok, bet PHP saka pee...

 

<TABLE cellpadding=0 cellspacing=0 width="140" align="center">
<tr><td align="center"><img src="Index_img/pes.jpg"></td></tr>
<?php

$resurs=mysql_query('SELECT id, texc FROM buy ORDER by id DESC LIMIT 0, 5');
while($rinda=mysql_fetch_row($resurs)){
?>
<TR><TD><? $rinda[1] ?></TD></TR>
 <TR><TD><HR size=1 color=#333333></TD></TR>
<?
}
?>
</TABLE>

 

Izvadaas tikai bildziite! :huh: ...ar eerroriem ar neblauj!

[v3rb0]

<? $rinda[1] ?> ?

[litt]

Jābūt

$rinda['id']

[Analgiins]

Jēzus Marija!! Dati tak jaizvada

<?=$rinda[1] ?>

vai

<? echo $rinda[1] ?>

vai

<? print $rinda[1] ?>

[Snukzz]

Jēzus Marija!! Dati tak jaizvada

<?=$rinda[1] ?>

vai

<? echo $rinda[1] ?>

vai

<? print $rinda[1] ?>

23450[/snapback]

Meeginaaju - nepaliidz! Iisteniibaa man bija rakstiic <?=$rinda[1] ?> bet"=" kaut kur pazuda kameer liic shejienei atstiepu!

[Analgiins]

nu mosh tev jaaraksta nevis $rinda[1], bet gan $rinda['id']. Es jau nezinu, kaadi tev tur lauku nosaukumi

Un vispaar, ja nekas neraadaas tad debugo, tais print_r($rinda), nu skaties, kas tev tur ir, kas nav. Es tak neesmu gaishregjis

[Snukzz]

Nu tip man i shitaa:

<TABLE cellpadding=0 cellspacing=0 width="140" align="center">
<tr><td align="center"><img src="Index_img/pes.jpg"></td></tr>
<?php

$resurs=mysql_query('SELECT id, texc FROM buy ORDER by id DESC LIMIT 0, 5');
while($rinda=mysql_fetch_row($resurs)){
?>
 <TR><TD><?=$rinda[1] ?></TD></TR>
 <TR><TD><HR size=1 color=#333333></TD></TR>
<?
}
?>
</TABLE>

Bet browserii no shitaa atnaak tikai:

<TABLE cellpadding=0 cellspacing=0 width="140" align="center">
<tr><td align="center"><img src="Index_img/pes.jpg"></td></tr>
</TABLE>

:huh:

[Analgiins]

nu skaidri redzams, ka cikls neizpildaas

un vispaar, ieliec skriptaa

error_reporting(E_ALL);

ini_set('display_errors', 1);

[Snukzz]

Njaa.. un errooru vsipaar nav! NEKAADU! :blink:

[bubu]

Varbūt tabula tukša?