pls help me on MySQL query......

[Rai_87]

I need help on MySQL query, the problem i faced is that i need to retrieve and display the image on a website. I have two tables to use one of them is name aspnet_Users, it contain applicationid, userid, username, loweredusername..... and another table is completeuserdetails, it contain userid, username, companyname, companylogo(binary data). so how should i do if i wan to retrieving image from completeuserdetails and place it to aspnet_user's userid to update the image....... :(

[tfit]

I need help on MySQL query, the problem i faced is that i need to retrieve and display the image on a website. I have two tables to use one of them is name aspnet_Users, it contain applicationid, userid, username, loweredusername..... and another table is completeuserdetails, it contain userid, username, companyname, companylogo(binary data). so how should i do if i wan to retrieving image from completeuserdetails and place it to aspnet_user's userid to update the image....... :(

I 'm afraid I don't completely understand you. Do you want to compare userid in aspnet_Users against userid in completeuserdetails and take action when they match?

[Rai_87]

i mean that if any user from the table log in and changes the info how should i update the info... using the select command?

[tfit]

Sorry, sometimes i forget to which threads i replied. Ok, what you're describing sounds like a cms to me. Chapter 11 of Wiley - Mysql PHP Database Applications has a full explanation/implementation. Google for it and you will find the pdf. Hope this helps.