How would i do this?

[LiamProductions]

Hey.

 

How do i check if $_POST['user'] is equal to any of the values in row username in my db?

 

Any pointers or code snippets?

[pocobueno1388]

<?php

$user = $_POST['user'];
$query = "SELECT col FROM users WHERE user='$user'";
$result = mysql_query($query)or die(mysql_error());

if (mysql_num_rows($result) > 0){
  echo "Found a match!";
} else {
   echo "No results found.";
}

?>

 

 

[marcus]

$user = mysql_real_escape_string($_POST['user']);

$sql = "SELECT * FROM `table` WHERE `username` LIKE '%$user%'";
$res = mysql_query($sql) or die(mysql_error());

if(mysql_num_rows($res) == 0){
echo "No users with that username exist!\n";
}else {
while($row = mysql_fetch_assoc($res)){
echo "<a href=\"/users.php?username=$row[username]\">$row[username]</a><br>\n";
}
}

[Barand]

But if the username entered is "fred"

 

then ...LIKE '%$user%'

 

will also pull "alfred", "frederick", "freddy", "freda" etc