[SOLVED] String and integer? help wanted....

[Johan Beijar]

Dear all,

 

I have the following code and I get an errormsg because of it...

 

$sql = "SELECT * FROM pictures WHERE username = '$username' AND parent_album = '.$album['album_id']'";

 

I get the following errormsg:

Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in

 

I think there is a problem with ' or " or .

 

I appriciate any help!

 

Thank you,

 

//Johan Beijar

[ILMV]

Your SQL statement is not formed correctly.

 

$sql = "SELECT * FROM pictures WHERE username = '".$username."' AND parent_album = '".$album['album_id']."'";

 

 

If you're string starts with a ", you should open and close it at all times with ".

 

 

Edit: This might not be the main problem, come back to us if it isn't

 

 

 

 

ILMV

[Johan Beijar]

Hi ILMV,

 

THANK YOU! That did the trick and I truely appriciate your prompt answer. helped me alot!

 

People like you are what makes the world a better place!

 

/Johan

[Johan Beijar]

:-)

[ILMV]

You're very welcome.

 

ILMV