On Tue,  4 Dec 2001 11:30, Tom Beidler wrote:
> I'm trying to pull three results from a database and then display them
> in a page. The HTML is clugey so I would like to place print statements
> in three different places, rather then in a while loop and try and
> rewrite the HTML for each item.
> So far I have;
> $gethot_query = "SELECT title FROM events WHERE status = 'hot' ORDER BY
> date";
> $gethot_result = mysql_query ($gethot_query)
>     or die ("Cannot get hot
> items!");
> $gethot_row = mysql_fetch_array ($gethot_result);
> ?>
>  <tr>
>     <td colspan="7" valign="top" bgcolor="#FFE49A"
> class="hotheadlines"> <p><br>
>         <? print ("$gethot_row[1]"); ?></p>
> I know I'm not calling the print statement correctly but hopefully you
> get the idea. I would like to add
> <? print ("$gethot_row[1]"); ?> for the first item.
> <? print ("$gethot_row[2]"); ?> for the second
> <? print ("$gethot_row[1]"); ?> for the third.
> Am I approaching this from the wrong way?
> Thanks,
> Tom

First, I suspect that your query might fail, as you are attempting to 
sort by a filed you haven't selected.

On to the meat of your question: I think you misunderstand how 
mysql_fetch_array works - it only fetches an array of the current record 
returned from the database, not an array with all the records found.

What you might consider doing is retrieving all the records into an 
array, then displaying the elements of the array where you need them. 
Assuming that you are only interested in the filed 'title', something 
like this might do the job:

$gethot_result = mysql_query ($gethot_query) or die ("Cannot get hot
 items! Error: " . mysql_error());
while ($gethot_row = mysql_fetch_array ($gethot_result)) {
  $your_array[] = $title;

and here you have all the values of title in $your_array.

David Robley      Techno-JoaT, Web Maintainer, Mail List Admin, etc

   This tagline will reformat your hard drive in 1.5 seconds!

PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to