finally i got it to work in this manner.
$i=1;
while ($image_row = mysql_fetch_array($result_images)){
$image="image".$i;
$caption="caption".$i;
$$image = $image_row["image1"];
if ($$image == ""){
$$image = $folder."logo.jpg";
}
$$caption = $image_row["caption"];
$i++;
}
great so thanks Adams.
GD
"Geckodeep" <geckodeep@yahoo.com> wrote in message
20030204140551.48310.qmail@pb1.pair.com">news:20030204140551.48310.qmail@pb1.pair.com...
> thanks i m going to test ride it and let you know.
> tks again to adam & jason.
>
> "Adam Voigt" <adam@cryptocomm.com> wrote in message
> 1044366586.976.8.camel@beowulf.cryptocomm.com">news:1044366586.976.8.camel@beowulf.cryptocomm.com...
> $counter = 1;
> $query = mysql_query("SELECT image,caption FROM tablename ORDER BY id;");
>
> while($row = mysql_fetch_array($query))
> {
>
> $imagevar = "image" . $counter;
> $captionvar = "caption" . $counter;
>
> $$imagevar = $row[image];
> $$captionvar = $row[caption];
>
> $counter++;
>
> }
>
> Change the query to match what you need, and that should work, if
> your interested, check out the manual page on "Variable Variables" at:
>
> http://www.php.net/manual/en/language.variables.variable.php
>
> Enjoy.
>
> On Tue, 2003-02-04 at 07:02, Geckodeep wrote:
> May be some one could help me here, I am trying to retrieve results from a
> table that gives 9 rows, from each row I am trying to pull out two fields
> and assign the two values of those column fields to a variable $image1 and
> $caption1, and now I want to go to the next row and pick up the values of
> the corresponding fields and store it in the next variable $image2 and
> $caption2 and to continue until I reach 9 rows.
>
> The reason for this technique is I am trying to inject the dynamic data
> inside a page which is already formatted with HTMLs (kind of template) and
> by means of Php tags I can echo these variables where needed.
>
>
>
> Thanks for your time and help in advance I'd appreciate it.
>
>
>
> GD
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
> --
> Adam Voigt (adam@cryptocomm.com)
> The Cryptocomm Group
> My GPG Key: http://64.238.252.49:8080/adam_at_cryptocomm.asc
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
