Forum PHP Romania - Discutii despre PHP, MySQL, Javascript, AJAX, etc

[copot]

Problema relativ simpla pentru cineva care stie:

cms_contents:
ArticleID bigint(20)
Title varchar(255)

cms_related
ArticleID bigint(20)
RelatedTo bigint(20)

Cum fac sa obtin toate informatiile din cms_contents aferente campului RelatedTo (din cms_related_articles).
Eu am incercat asa:

select cms_contents.* from cms_contents inner join (select cms_related.RelatedTo from cms_related where cms_related.ArticleID=$id) related on cms_contents.ArticleID=related.RelatedTo

unde $id e preluat prin _GET

[beeuser]

Cod: SELECT *
FROM cms_related cr, cms_contents cc
WHERE cr.RelatedTo=$id AND cr.ArticleID=cc.ArticleID

[copot]

Solutia asta era:
select cms_contents.* from cms_contents inner join (select cms_related.RelatedTo from cms_related where cms_related.ArticleID=$id) related on cms_contents.ArticleID=related.RelatedTo

Problema e alta:

Haven't considered the RDS factor -> mysql version.... :twisted:

Acuma trebe` sa mearga cu mysql 3.[/b]

[Radical]

Cod: SELECT `cms_contents`.`ArticleID`,`cms_contents`.`Title`
      FROM `cms_related`
      [INNER] JOIN `cms_contents` ON `cms_contents`.`ArticleID`=`cms_related`.`RelatedTo`
      WHERE `cms_related`.`ArticleID`= $id
E ok asa ?

Chiar vor fi mai mult de 16.777.215 inregistrari ca sa se justifice BIGINT ?

[copot]

multam !

[PHPRomania Bot]