|
|
Posted by Rik on 08/16/07 23:28
On Thu, 16 Aug 2007 23:56:01 +0200, Allan Drake <supercool@chartermi.net=
> =
wrote:
> I am a beginning programmer, and I am trying to display a single cell
> of data from my database. This php script is for displaying profile
> information, specifically an e-mail in the same row as the member name=
> (grabbed from URL)
>
>
> <?php
> //Connection Data is in the header I think
> include_once("head.php");
>
> //Grabs the name from the URL and I know it is working
> $names =3D $_REQUEST["name"];
>
> // set up query?
> $sql =3D "select * from db_members where idmembers =3D $names";
>
> //performs query I think?
> $result =3D MYSQL_QUERY($sql);
>
> //trying to grab his email from the email column
> $array =3D mysql_fetch_array($result);
> $mymail =3D $array[email];
> ?>
>
> My e-mail is: <?=3D$mymail?> <-----------This comes up blank
> <br>
> Result is working as <?=3D$result?> <------This comes up=
> as blank
>
> If you could point me in the right direction as to where my code is
> going wrong, and how to correct it that would be great.
As long as the table db_members exists and has a field 'email', every SQ=
L =
question is anwered, and this is a PHP issue (funny, usually the other w=
ay =
around...)
Crossposted to comp.lang.php & f'upped there, care to follow me there? =
Lots & lots of comments to follow :-)
-- =
Rik Wasmus
Navigation:
[Reply to this message]
|