Jump to content

Searching a mysql database


Drezard

Recommended Posts

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
[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]

Archived

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

×
×
  • Create New...

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.