Ramin Rahimi’s Question:
What I am trying to do is to select a update from a portion of my site where users upload pictures and I know I have to create a field for that in my database but first I was wondering to know if I can use this syntax like:
SELECT UPDATE FROM photos WHERE album LIKE BINARY 'loggedin_avatar' ORDER BY datemade ASC
so is this a right syntax? also where can I learn about filtering the files being uploaded to my site. Generally filtering the files being uploaded.
No, that is not the correct syntax.
UPDATE are two different query statements.
If you trying to select a field called
update from your database table, then you have to quote them
SELECT `update` FROM photos WHERE album LIKE BINARY 'loggedin_avatar' ORDER BY datemade ASC";
If you are trying to select a updated row after updating them, you have to send mulitple statements.
- First update the rows
- Select the updated row which the help of a primary key field.