Jump to content


Photo

Need Help!!


  • Please log in to reply
2 replies to this topic

#1 kusal

kusal
  • Members
  • PipPipPip
  • Advanced Member
  • 36 posts
  • LocationSri Lanka - Colobmo

Posted 28 June 2006 - 07:57 AM

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

www.kuppiya.com

#2 hackerkts

hackerkts
  • Members
  • PipPipPip
  • Advanced Member
  • 593 posts
  • LocationSingapore
  • Age:18

Posted 28 June 2006 - 08:05 AM

The correct post is
$_POST['username'];

And make sure youhave admin column.

Regards,
hackerkts

To be a coder, you must learn how to think and not to give up so easily.


#3 trq

trq
  • Staff Alumni
  • Advanced Member
  • 31,041 posts

Posted 28 June 2006 - 08:07 AM

Your code is a nightmare! :) Try this...
<?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();
  }

?>





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users