$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];
Change the query to match what you need, and that should work, if
your interested, check out the manual page on "Variable Variables" at:
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.
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
-- Adam Voigt ([EMAIL PROTECTED]) The Cryptocomm Group My GPG Key: http://18.104.22.168:8080/adam_at_cryptocomm.asc
Description: This is a digitally signed message part