Jump to content


Photo

Dreamweaver PHP/SQL statement


  • Please log in to reply
2 replies to this topic

#1 ADL77

ADL77
  • New Members
  • Pip
  • Newbie
  • 1 posts
  • LocationMelbourne Australia

Posted 04 February 2006 - 10:04 AM

I am hoping someone can help me as i am scratching my head with this one.

I have a created a login page which allows users to login. I am trying to create a page that allows the user to view and subsequently edit there own informaiton. However my problem is that i am having trouble getting SQL statement i am using to generate the information from the table by using the persons log in name

Any ideas?

#2 cairesdesigns

cairesdesigns
  • Members
  • Pip
  • Newbie
  • 5 posts

Posted 06 February 2006 - 10:03 PM

I dont know if this will do you any good but try this

<?
$user = mysql_fetch_array(mysql_query("SELECT * FROM table WHERE username='$loginname';"));
?>
<table width="100%" height="100%">
<tr>
 <td>Username:<td><?=$user["username"]?></td>
</tr>
<tr>
 <td>Password:<td><?=$user["password"]?></td>
</tr>
</table>

If this doesn't help you out, i would be happy to take a look at your script, contact me by email if you would like that!
[!--fonto:Verdana--][span style="font-family:Verdana"][!--/fonto--]
Caires Designs
[!--sizeo:1--][span style="font-size:8pt;line-height:100%"][!--/sizeo--]Where the Web Comes to life![!--sizec--][/span][!--/sizec--]
[!--fontc--][/span][!--/fontc--]

#3 moberemk

moberemk
  • Members
  • PipPipPip
  • Advanced Member
  • 695 posts

Posted 06 February 2006 - 11:08 PM

Use the Dreamweaver Update Form option to take care of that. Just make the page password-protected, and get the user ID from the session ID, or the cookie you use to edit it.
Disclaimer: No matter how harsh I may be, I'm always IMO only.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users