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 Link to comment https://forums.phpfreaks.com/topic/21032-searching-a-mysql-database/ 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' Link to comment https://forums.phpfreaks.com/topic/21032-searching-a-mysql-database/#findComment-93382 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 Link to comment https://forums.phpfreaks.com/topic/21032-searching-a-mysql-database/#findComment-93385 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] Link to comment https://forums.phpfreaks.com/topic/21032-searching-a-mysql-database/#findComment-93390 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.