Sql Statement not working!

[pontypete]

$query_rsGetOrderDetails = "SELECT * FROM hd_order WHERE order_by = '$usernameLoggedin' ORDER BY order_id DESC LIMIT 3";

 

Any ideas?

[Pikachu2000]

What errors are returned when it's executed?

[SergeiSS]

I bet you don't use function mysql_query() You statement is not a real statement. It's just a string now.

[Twister1004]

Your statement is not going to work. It will put inside the database '$thisvariable'. But even then, it wont do that and return an error.

 

Your Statement:

$query_rsGetOrderDetails = "SELECT * FROM hd_order WHERE order_by = '$usernameLoggedin' ORDER BY order_id DESC LIMIT 3"

Fixed Statement
$query_rsGetOrderDetails = "SELECT * FROM hd_order WHERE order_by = '{$usernameLoggedin}' ORDER BY order_id DESC LIMIT 3"

 

However as SergeiSS said, you have to use the mysql_query function for it to run.

[Pikachu2000]

Your statement is not going to work. It will put inside the database '$thisvariable'. But even then, it wont do that and return an error.

 

Your Statement:

$query_rsGetOrderDetails = "SELECT * FROM hd_order WHERE order_by = '$usernameLoggedin' ORDER BY order_id DESC LIMIT 3"

Fixed Statement
$query_rsGetOrderDetails = "SELECT * FROM hd_order WHERE order_by = '{$usernameLoggedin}' ORDER BY order_id DESC LIMIT 3"

 

However as SergeiSS said, you have to use the mysql_query function for it to run.

 

There is nothing syntactically wrong with the query string the way the OP has it written. The curly braces aren't needed.