It's the first time I ask a question here, and I'm having the following difficulty.
I am doing my info CBT, it is a site for students and such ... is it like Facebook bags? I caught in the part where PHP retrieves the data from the 'post' table of Mysql to appear on the timeline.
I tried this way:
SELECT * FROM 'usuario', 'post' WHERE 'usuario'.'id' = '[ID_DO_USUÁRIO]'
And using PHP's Var_dump () I get this result:
I'mnotsurewhattodo,
ThenItriedlikethis:
(Ishouldhavemissedthisclasskk)
SELECT'id','nome','sobre_nome','foto'FROM'usuario',SELECT*FROM'post'WHERE'usuario'.'id'='9223372036854775807'
Andgivemethiserror:
#1064-YouhaveanerrorinyourSQLsyntax;checkthemanualthatcorrespondstoyourMySQLserverversionfortherightsyntaxtousenear'SELECT*FROM'post'WHERE'usuario'.'id'='9223372036854775807'LIMIT0,25'atline1
Ifyounoticed,intheresultofVar_dump...Igettworesultsthatisequivalenttotheuserid(unnecessary)
This is personal, I do not know if they will get the logic, but I just want to get some (not all) arguments from the 'user' table and the 'posts' table without having to do 2 querys (I do not know if it's like this that speaks ...).
In short, Relief kk.