using contents of an array anywhere on the page

[ali_p]

Right , i have the results of a query looping through an array to display all 'headlines' from field in a table. I know that i can use $display block to view all the records but i need to have these records displayed not in that kind of list. I would like to call 'headline 1' here.

'headline 2' here etc. All with html etc in between. I only have three 'headlines' so there is no worry of it getting out of hand. Do i put something in my SQL query or is there another way to achieve this.

Many thanks

[dalecosp]

<?php

$stuff=array("foo", "bar", "baz", "qux");

echo "<h2>".$stuff[0]."</h2>
<br>
I think that I shall never ".$stuff[0]."<br>
A poem lovely as a ".$stuff[1]."<br>
And when I type this lovely ".$stuff[2]."<br>
I hope that you'll have read my ".$stuff[3]."<br>
<br>
<font size=1>by dalecosp</font>";

/*  Should yield something like this:

I think that I shall never foo
A poem lovely as a bar
And when I type this lovely baz
I hope that you'll have read my qux
*/


// Or I guess this:
?>
I think that I shall never <? echo $stuff[0]; ?> 
<br>A poem lovely as a <? echo $stuff[1]; ?>
<br>And when I type this lovely <? echo $stuff[2]; ?>
<br>I hope that you'll have read my <? echo $stuff[3]; ?>
<br>
<br>by Dalecosp

HTH,

PS> did I even understand your ??

[ali_p]

yeah but what if i'm getting the results from a query. ie

<?

$conn = mysql_connect("host", "name", "password");
mysql_select_db("database", $conn);
//create the sql statement
$sql = "SELECT *
FROM news
LIMIT 3";

$result = mysql_query($sql, $conn)or die(mysql_error());
$display_block = "";
$count=0;
while ($row = mysql_fetch_array($result)) {
//give a name to the fields
$date = $row['date'];
$headline = $row['headline'];
$news_id = $row['news_id'];

echo "$headline<br>\n";
}

?>
I want the three headines to appear not in a block but call them seperatly elsewhere on the page.

Big Thanks

[Shrike]

while($row = mysql_fetch_assoc($result){
  array_push($myrows, $row);
}

echo "I wandered lonely as a ".$myrows[0]['foo'];

That is of course assuming that you get them out of the database in the correct order. If not then instead of array_push() use

...
$myrows[$row['uniqueidentifier']] = $row;
...
echo "I wandered lonely as a ".$myrows['uniqueidentifier']['foo'];

[ali_p]

Thanks but i don't know if this is the answer. I just need an alternative to display block when displaying results from a db query. I know there are three records in the db the order in which they are displayed is not important only that they are displayed on the page. At the moment i get three occurances of only one record.
Cheers

[Shrike]

That's because mysql_fetch_row()/mysql_fetch_array()/mysql_fetch_assoc() only gets one row from the database. You need to do a while() loop and either process the data there and then, or put each returned row into an array (or some other holder) for use later.

In your code example, you iterate through the result set, but each time you overwrite the variables with the new row.

[ali_p]

Tut. not very good with arrays. Know of any good articles that might help. I know the basics but not anything like creating them from database queries.

[bigswifty]

something along these lines perhaps

WHILE ($i < $number):

PRINT "<table valign=top width=100% cellspacing=5 cellpadding=5><tr>

<td width=85%><font face=\"Verdana, Arial, Helvetica,sans-serif\" size=\"-1> $yourheadline</font></td>

</tr>

</table>";

}

$i++;ENDWHILE;

this proably will not work for you as a cut and paste.. as it is just a bit of a much larger script, but it gives you an idea.

what this does is takes the results and creates a new table for each result found from the initial query, until there are no more results to add, then the loop ends.

the base code is from an article on this site, one of the search engine script articles I believe.

[dalecosp]

Originally posted by ali_p
Tut. not very good with arrays. Know of any good articles that might help. I know the basics but not anything like creating them from database queries.

Here, courtesy of some fine PHP writers....

function result_to_array($result) {
   $res_array = array();
   for ($count=0; $row = @mysql_fetch_array($result); $count++) { $res_array[$count] = $row; }
   return $res_array;
        }

Call your query thus:

$result=mysql_query("select * from foo:);
$my_array=result_to_array($result);

Happy Thanksgiving! 😉

[dalecosp]

Originally posted by dalecosp
Here, courtesy of some fine PHP writers....

function result_to_array($result) {
   $res_array = array();
   for ($count=0; $row = @mysql_fetch_array($result); $count++) { $res_array[$count] = $row; }
   return $res_array;
        }

Call your query thus:

$result=mysql_query("select * from foo");
$my_array=result_to_array($result);

Happy Thanksgiving! 😉 [/B]