calling/echo problem

Anon

alright, i'm having some major headaches with this one. i'm pretty new to php, but i can't find a problem with this code. when the page is loaded, the php is running the loop correctly, but it's not calling the information from the mysql database properly. http://www.factory201.com/sa/groove.php3 shows the page (the colons in the news headline section should have information on either side)

here is the relevant code:

<?php
$table_name = "news";
$dbname = "slide_away";
$id_link = @mysql_connect("localhost","","");

if (! $id_link) {
		echo '<head><title>Error</title></head><body>';
		echo 'Connection to PHP has failed.';
		echo '</body>';
	exit();
   }

$str_sql_all = "
select count(*) as number_of_records
from $table_name
";

$result =
mysql_db_query($dbname, $str_sql_all, $id_link);

$record = @mysql_fetch_object($result);
$number_of_records = $record->number_of_records;

$number_records_to_display = 8;
$initial_record = $number_of_records;
$sort_field = 'key_news';
$sort_direction = 'DESC';

$str_sql = "
select *
from $table_name
order by $sort_field $sort_direction
limit $initial_record, $number_records_to_display
";

$result2 = mysql_db_query($dbname, $str_sql, $id_link);

$number_of_records_on_current_page =
@mysql_num_rows($result2);
?>

and the loop code:

<?php
for ($iindex = 0; $iindex < $number_of_records; $iindex++) {
$record = mysql_fetch_array($result2);
echo "$record[date_shown] : $record[update_headline] <br>";
}
?>

help is greatly appreciated

owen

Anon

Hi!

What means "date_shown" ans "update_headline"? I think PHP is trying to fetch the value in the array interpreting date_shown and update_headline as a key of an associative array, and the array you got calling mysql_fetch_row isn't an associative array, instead use mysql_fetch_array

HTH

inK

echo "$record[date_shown] : $record[update_headline] <br>";

Anon

To be nice, I'll show you what loop I run. Sound good? Honestly, I didn't feel like readin the code =). So ya, posting what I use might help? Uh huh, let's hope so eh?

A slight explanation first: You run the db query, all that mess. Right? Then, what you do is a for loop, running through the DESCENDED sql query, going from the last post first, and running negatively to the last ten right? Well to do that, check the code my main man:

Simpler than you thought huh?
<?php
/Note: the $num_rows deal is so that if there's more than 15 posts, it throughs the option of going to another page to see the older posts/

$num_rows = mysql_num_rows($news_result);

//For query to run the latest 10 news entries...
if ( $num_rows <= 15 )
{
for( $i = 0; $i <= ($num_rows) - 1; ++$i )
{
//echo ("<br>".$i);

			//Query to get the news from it's table...
			$news_row = mysql_fetch_array($news_result);
			mysql_fetch_field($news_result);
		?>
                 The info you want printed

<?php
} //end for loop

		//Clear result from memory
		mysql_free_result($news_result);
	} //end if $num_rows <= 15

$news_result is the result of a mysql_db_query, where I just set $result = mysql_db_query(DatabaseName, $sqlCmd);

Make sense? If not, just talk to me more I'd be happy to explain.

Anon

chuck -

thanks for the help.. however, i'm an idiot and don't quite get your loop. first, where did you get $news_result? secondly, i assume i should continue running the query minus the limit?

i'm just not quite sure what of the old code, if any, i should keep in relation to your code.