[SOLVED] Simple Query

[steveangelis]

I know the answer is something simple but I cannot figure it out:

 

<?PHP
$ip = $_POST['ip'];
echo $ip;
include('config.php');
$linkid = @mysql_connect("$dbhost", "$dbuser", "$dbpasswd");
mysql_select_db("$dbname", $linkid);

$result = mysql_query('SELECT ip, username FROM phpbb_ip where ip="$ip"'); 
while($row = mysql_fetch_array($result)) 
{ 
echo $row['ip']." - - - - - - - - ".$row['username'];
} 
?>
<form action="ipsearch.php" method="post"><input name="ip" type="text" />
<input name="Submit" type="submit" /></form>

 

I have done and mysql_error and I figured out that it is coming up with a blank and empty query, but I KNOW the database it is coming from is correct.  Any ideas?

[DarkWater]

You're using ' ' around the string in mysql_query so the $ip variable is not being parsed.

[revraz]

$result = mysql_query("SELECT ip, username FROM phpbb_ip where ip='$ip'");

 

[steveangelis]

Thank you I knew it was something simple.