Using variables in SQL statements

[rollOrDie]

I have an SQL statement like so:

 

"SELECT portTitle FROM tblPort WHERE portId = '$portId'"

 

But I would like to use something like this:

 

"SELECT $fieldName FROM tblPort WHERE portId = '$portId'"

 

So that the field can vary depending on the code before it. Does anyone know if or how this is possible?? Thanks

[.josh]

Yes it's possible. You just did it.  Pat yourself on the back and have a scooby snack.

 

Hey, that rhymes.

[LooieENG]

<?php

$fieldName = mysql_real_escape_string($_POST['fn']);

"SELECT '$fieldName' FROM tblPort WHERE portId = '$portId'"

?>

 

is that what you mean?

[rollOrDie]

Yes it's possible. You just did it.  Pat yourself on the back and have a scooby snack.

 

Hey, that rhymes.

 

Wow so it does work! I tied something before [being sure that it was that] and it never worked! Who knows what I typed...

 

Thanks for the replies anyway