Jump to content

Froggaard

Members
  • Content Count

    3
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Froggaard

  • Rank
    Newbie
  • Birthday 07/08/1989

Profile Information

  • Location
    Denmark
  1. Hello.I have this code $get_cart_info = mysql_query("select c.*,g.*,m.* from cart as c left join games as g on c.tid = g.id left join movies as m on c.tid=m.id where c.user = {$CURUSER['id']} GROUP BY c.tid") or die(mysql_error()); But what I need is when c.type is movie its only takes info from movies tabel, but still have to take everything out, because I both have movies and games in cart..Can it be done, or do I have to trying something else?
  2. Hello. I have this code, but how can I do so the latest news is shown and they other are closed? I can't figure it out by my self, there are ask you guys $res = mysql_query("select * from news order by added desc") or die(mysql_error());if (mysql_num_rows($res) > 0) { while ($news = mysql_fetch_assoc($res)) {$ret = ($CURUSER['class'] >= 10 ? " <a href='admin_news.php?action=edit&id={$news['id']}'><img src='{$SITEINFO['picdir']}edit.png' alt='Ret' title='Ret' /></a>":"");$slet = ($CURUSER['class'] >= 10 ? " <a href='admin_news.php?action=slet&id={$news
×
×
  • Create New...