[SOLVED] mysql problem..

[MadTechie]

$_SESSION[ic] is incorrect, yes it works but its wrong, unless ic is a constant,

but as its not a constant php corrects it but will give a notice error (mild warning),

 

use $_SESSION['ic'] instead (good habbit)

[zgkhoo]

then why `Ownerid`<--?  `<--this quote i never use before, what it for?

thanks.

[MadTechie]

i used `Ownerid` as i wasn't sure if Ownerid is a reserved word..

 

change it to Ownerid and if it works then its not reserved

[zgkhoo]

then `<--wat this quote meant?

u meant reserved word for php or mysql?

 

[MadTechie]

its not a quote is a "backtick" its the MySQL identifiers quote character..

 

i am talking about MySQL reserved words

 

An identifier may be quoted or unquoted. If an identifier is a reserved word or contains special characters, you must quote it whenever you refer to it. (Exception: A word that follows a period in a qualified name must be an identifier, so it need not be quoted even if it is reserved.) For a list of reserved words, see Section 8.3, “Reserved Words”. Special characters are those outside the set of alphanumeric characters from the current character set, ‘_’, and ‘$’.

[zgkhoo]

'{$_SESSION['ic']}'  <---why this?

why use { }?

why not "$_SESSION['ic']" ?

or ' ".$_SESSION['ic']." ' ?

or '$_SESSION['ic'].'

wat different between these?

thanks..

[MadTechie]

its my coding style

{} same the ".$var."