necken18

Hello. I've got two tables one that contains general information and one that contains links. example: Table: general id, name, date Table: links id, objekt_id, link, title i wan't to loop out these tables together and put all links with the same objekt_id in one field-array. (links.objekt_id matches general.id). SELECT g.name, g.date, link.link FROM general g INNER JOIN link links ON link.objekt_id = g.id WHERE g.id = 10 There is multiplie links on every objekt_id. How can i put all of them in one field?

Hello. I want to extract year and month from a datetime column in the database. And i want to display the results like this: 2008 Jan May 2010 Oct 2011 Dec But my code gets this result 2008 Jan May 2010 Oct 2011 Dec Here's my code. $get = $db->query(" SELECT EXTRACT(YEAR FROM date) year, EXTRACT(MONTH FROM date) month FROM test GROUP BY year "); foreach ($get as $row) { echo $row['year']."<br/>"; echo $row['month']."<br/>"; } } catch(PDOException $e) { echo $e->getMessage(); }

$query = mysql_query('SELECT * FROM user ORDER BY user ASC');

Don't mix the var and the public keyword. they have the same functionality.