Wrox Home  
Search P2P Archive for: Go

  Return to Index  

sql_language thread: Variables from FORM


Message #1 by Jefferis Peterson <jefferis@p...> on Wed, 25 Sep 2002 19:46:12 -0400
 This works:
> <a href="<?php echo $row_viewall['pictures']; ?>" ><?php echo
> $row_viewall['pictures']; ?>' </a>
>       </div></td>

In information is displayed as text like "image/diamondring.gif"  and
clicking on the text opens the image in a new window.  What I'm finding that
since the sql data changes from row to row, if I try to pass the variable
info from one page to another, only the first image in the catalog will open
up. 

Perhaps I could just force an onclick javascript behavior to accomplish my
goal, but I'm not sure:

Goal: To open a varying image, centered, in a  new window, black background.

I have the data I need. It is being returnd to my page via queries:

MySql $query returns this info: <?php echo $row_viewall['pictures']; ?>

'pictures' is  a field with a url for an image in my website.

If I ad a link to this information:
> <a href='<?php echo $row_viewall['pictures']; ?>'>

It will open a new window with the image.

What I want to do is either
A] paste this link data into an existing php page surrounded by< img src =>

OR, if necessary, 

B] to create a brand new pop up page with the larger image.


So far, I'm not able to pass the information to a new page for A, and for B,
all I get is an uncontrollable image on a large browser page with white
background.  I've been trying in B to use javascript, but it isn't passing
the $query variable, or I'm not getting it right.

Other attempts listed in separate post.

JEff
On 9/29/02 8:23 PM, "David Cameron" <dcameron@i...> wrote:

> There is an easy way to localise issue between database and you php code.
> Remember that when you create a SQL Statement you are generating a string.
> Check this string by printing your SQL statement to the screen and test it
> using the client tools for your database. If the db client gives a problem,
> play around with the SQL string until you get it working, then work out how
> to generate that string.
> 
> regards
> David Cameron
> nOw.b2b
> dcameron@i...
> 
>> -----Original Message-----
>> From: Jefferis Peterson

~~~~~~~~~~~~
Jefferis Peterson, Pres.
Web Design and Marketing
http://www.PetersonSales.net
Tel .  xxx-xxx-xxxx
ICQ 19112253

http://www.Slippery-Rock.com - 7,000 hits per year


  Return to Index