Welcome Guest, Not a member yet? Register   Sign In
getting data from two different tables problem
#11

[eluser]TheFuzzy0ne[/eluser]
I don't understand the question. The method I wrote gives you all the data you showed in your table, apart from description, because I've no idea where that's meant to come from.

With what I've given you, you should be able to work it to do exactly what you want. If you want full names, you'll need to use [url="http://www.tutorialspoint.com/mysql/mysql-concat-function.htm"]CONCAT()[/url].

I'm happy to help, but I refuse to write the code for you.
#12

[eluser]haris244808[/eluser]
[quote author="TheFuzzy0ne" date="1364152958"]I don't understand the question. The method I wrote gives you all the data you showed in your table, apart from description, because I've no idea where that's meant to come from.

With what I've given you, you should be able to work it to do exactly what you want. If you want full names, you'll need to use [url="http://www.tutorialspoint.com/mysql/mysql-concat-function.htm"]CONCAT()[/url].

I'm happy to help, but I refuse to write the code for you.[/quote]

what u gave me its exactly what i did ... but u r missunderstanding my qyestion files_query is an array holding all data from the table 'files' however i need to take creators and senders full name from the table 'users' and display data that i got from two different methods in the same view .

shortly how can i make two foreach loops:
Code:
foreach($files_query as $results){ //data from file table (subject, sender_id)
foreach($users_query as $results2){ //data from user table (senders and creators name)

}
}
#13

[eluser]haris244808[/eluser]
Ok forget it...i solved it....
THnx for everything....and sorry for bothering Wink




Theme © iAndrew 2016 - Forum software by © MyBB