Re: [PHP-DB] Storing iterated results into various variables
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" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> thanks i m going to test ride it and let you know.
> tks again to adam & jason.
>
> "Adam Voigt" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> $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 ([EMAIL PROTECTED])
> 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
Re: [PHP-DB] Storing iterated results into various variables
thanks i m going to test ride it and let you know.
tks again to adam & jason.
"Adam Voigt" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
$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 ([EMAIL PROTECTED])
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
Re: [PHP-DB] Storing iterated results into various variables
$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 ([EMAIL PROTECTED])
The Cryptocomm Group
My GPG Key: http://64.238.252.49:8080/adam_at_cryptocomm.asc
signature.asc
Description: This is a digitally signed message part
Re: [PHP-DB] Storing iterated results into various variables
Here is a part of my code:
while ($image_row = mysql_fetch_array($result_images)){
$image1 = $image_row[0]["image1"];
if ($image1 == ""){
$image1 = $folder."logo.jpg";// it
places a log when there are no images
}
$caption1 = $image_row[0]["caption"];
}
This loop fetches the row and assigns the two variables $image1 and
$caption1 with its associated value from the fields in the 1st row.
How can I get the loop to fetch in the same way as above but from the 2nd
row and assigns the values to the new variable $image2 and $caption2 until
it reaches the 9th row with $image9 and $caption9?
thanks again
"Jason Wong" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> On Tuesday 04 February 2003 20: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.
>
> What exactly are you having problems with? What is your code so far?
>
> --
> Jason Wong -> Gremlins Associates -> www.gremlins.biz
> Open Source Software Systems Integrators
> * Web Design & Hosting * Internet & Intranet Applications Development *
> --
> Search the list archives before you post
> http://marc.theaimsgroup.com/?l=php-db
> --
> /*
> Ah, sweet Springtime, when a young man lightly turns his fancy over!
> */
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Storing iterated results into various variables
On Tuesday 04 February 2003 20: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. What exactly are you having problems with? What is your code so far? -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db -- /* Ah, sweet Springtime, when a young man lightly turns his fancy over! */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Storing iterated results into various variables
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
