kusal Posted June 28, 2006 Share Posted June 28, 2006 <?php // open the connection $conn = mysql_connect("localhost", "root", "kusal"); // pick the database to use mysql_select_db("test",$conn); // create the SQL statement $x=mysql_query("select * FROM test WHERE name = kusal", $conn); // execute the SQL statement print("$x"); echo mysql_error(); ?>(user is varchar)this code gives me the following error why is it?"unknown column 'admin' in 'where clause'" if i change like this $_POST'[username']" the following error,Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in c:\Inetpub\wwwroot\php\log.php on line 9kusal Sri Lanka Quote Link to comment Share on other sites More sharing options...
hackerkts Posted June 28, 2006 Share Posted June 28, 2006 The correct post is[code]$_POST['username'];[/code]And make sure youhave admin column. Quote Link to comment Share on other sites More sharing options...
trq Posted June 28, 2006 Share Posted June 28, 2006 Your code is a nightmare! :) Try this...[code]<?php mysql_connect("localhost", "root", "kusal") or die("Unable to connect"); mysql_select_db("test") or die("Cannot select database"); if ($result = mysql_query("select * FROM test WHERE `name` = 'kusal'")) { $row = mysql_fetch_assoc($result); print_r($row); } else { echo mysql_error(); }?>[/code] Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.