Jump to content

Archived

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

kusal

Need Help!!

Recommended Posts

<?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 9


kusal Sri Lanka

Share this post


Link to post
Share on other sites
The correct post is
[code]$_POST['username'];[/code]

And make sure youhave admin column.

Share this post


Link to post
Share on other sites
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]

Share this post


Link to post
Share on other sites

×

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.