Drezard Posted September 17, 2006 Share Posted September 17, 2006 Hello, Im wondering how do i search a mysql database (code wise) when i want to know the username "p0001" 's name and password.would it be like:SELECT WHERE "p0001" = $username AND name = NULL AND password = NULL?- Cheers, Daniel Quote Link to comment Share on other sites More sharing options...
AndyB Posted September 17, 2006 Share Posted September 17, 2006 SELECT name, password from tablename WHERE username = 'p0001' Quote Link to comment Share on other sites More sharing options...
Drezard Posted September 17, 2006 Author Share Posted September 17, 2006 like this:[CODE]<html><head></head><body><p>My Profile:</p><?phpif (isset($_COOKIE['user'])) {include('connect.php');$user = $_COOKIE['user']; $sql = "SELECT * FROM users WHERE user='$user'";$result = mysql_query($sql);$count=mysql_num_rows($result);if ($count = 1){echo "Welcome to your profile, $user";$sql = "SELECT name FROM users WHERE user = '$user'";$name = mysql_query($sql);$sql = "SELECT email FROM users WHERE user = '$user!";$email = mysql_query($sql);echo "$name, $email";}if ($count = 0){?><meta http-equiv="refresh" content="0;url=logout2.php">;<?php}}?></body></html>[/CODE]- Cheers, Daniel Quote Link to comment Share on other sites More sharing options...
AndyB Posted September 17, 2006 Share Posted September 17, 2006 [code]$sql = "SELECT name FROM users WHERE user = '$user'";$result = mysql_query($sql) or die("Error: ". mysql_error(). " with query ". $sql);$row = mysql_fetch_array($result);$name = $row['name'];$email = $row['email'];echo $name, $email;[/code] Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.