Is this correct syntax?

$sql = "SELECT * FROM 'users' WHERE 'username'='{$username}'";


Im not sure because im getting errors from this

$sql = "SELECT * FROM 'users' WHERE 'username'='{$username}'";


Im not sure because im getting errors from this
what errors? post the message.

regards

The code above

The code above
the code above is the query not the error message. You said that give you errors. What errors?

regards

I should say that I'm in the process of learning mySQL and PHP. Though I might be at mistake, but I believe the syntax is erroneous, and should have been:

$sql = "SELECT * FROM 'users' WHERE 'username'='".$username."'";

I should say that I'm in the process of learning mySQL and PHP. Though I might be at mistake, but I believe the syntax is erroneous, and should have been:

$sql = "SELECT * FROM 'users' WHERE 'username'='".$username."'";

if {} is the problem, php can use curly syntax, :)

http://www.php.net/manual/en/language.types.string.php#language.types.string.parsing.complex

I guess op must say what is his problem if want help, :)

regards

Thats right. {} can be wrapped around variables within strings, thought you'll likely use it more for array indices within double quoted text.
Are you actually executing this query? This is just a string representation of you're query, you need to run it though a mysql_query or whatever database querying function you are using to create a resultset for it. Once you have a resultset you can retrieve records with mysql_fetch_[row/assoc/array/object] methods. I assumed mysql, but you may be using mysqli or mssql or whatever. They are all pretty similar to use.

Oh, just as a side note. I always write my queries either like how you have it rangana, or using sprintf or prepared statements. Just a habit I got into I suppose :P

Try:

$sql = "SELECT * FROM `users` WHERE username = '".$username."'";

If you want to quote fields and table names use the backquote, e.g. `users`. This is typically only necessary if these names are reserved for SQL syntax (for example if you have a field named "order", though some DBs handle even these names just fine).

Values, however, must be quoted using either single or double quotes, e.g. "my value". It is unnecessary to enclose integers in quotes (but it doesn't hurt either).

dumpfi