Jump to content

Archived

This topic is now archived and is closed to further replies.

Drezard

Searching a mysql database

Recommended Posts

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

Share this post


Link to post
Share on other sites
SELECT name, password from tablename WHERE username = 'p0001'

Share this post


Link to post
Share on other sites
like this:

[CODE]
<html>
<head>
</head>

<body>

<p>
My Profile:
</p>

<?php
if (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

Share this post


Link to post
Share on other sites
[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]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.