Warning: mysql_result(): Unable to jump to row 1...

[markspec87]

Error:

[!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]Warning: mysql_result(): Unable to jump to row 1 on MySQL result index 5 in /home/terraarm/public_html/index.php on line 108[/quote]

Code:

[!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]$query="SELECT * FROM news ORDER BY datum DESC LIMIT 1,1";
$result=mysql_query($query);
$num=mysql_numrows($result);

$i=1;

$author2=mysql_result($result,$i,"author");
$text2=mysql_result($result,$i,"text");
$datum2=mysql_result($result,$i,"Datum");
$readmore2=mysql_result($result,$i,"readmore");
$image2=mysql_result($result,$i,"image");
$title2=mysql_result($result,$i,"title");
$summary2=mysql_result($result,$i,"summary");

?>[/quote]


Any ideas whats wrong? (The DB is def setup correctly, i.e the row exists.)

[redarrow]

[code]
$query="SELECT * FROM news ORDER BY datum DESC LIMIT 1,1";
$result=mysql_query($query);

$num=mysql_num_rows($result) {

$i=1;

$author2=mysql_result($result,$i,"author");
$text2=mysql_result($result,$i,"text");
$datum2=mysql_result($result,$i,"Datum");
$readmore2=mysql_result($result,$i,"readmore");
$image2=mysql_result($result,$i,"image");
$title2=mysql_result($result,$i,"title");
$summary2=mysql_result($result,$i,"summary");
}
?>
[/code]

[markspec87]

[!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]Parse error: parse error, unexpected '{' in /home/terraarm/public_html/index.php on line 106[/quote]

:(

[kenrbnsn]

Don't use the mysql_result() function, use mysql_fetch_assoc() instead:
[code]<?php
$query="SELECT * FROM news ORDER BY datum DESC LIMIT 1,1";
$result=mysql_query($query);
$num=mysql_numrows($result);
$rw = mysql_fetch_assoc($result);
$author2=$rw['author'];
$text2=$rw['text'];
$datum2=$rw['Datum'];
$readmore2=$rw['readmore'];
$image2=$rw['mage'];
$title2=$rw['title'];
$summary2=$rw['summary'];
?>[/code]
Ken

[markspec87]

ah thanks mate works a treat.

Your a life Saver :)