I need MySQL stuff done please help

[Glee]

I need MySQL code for my news promo

<div id="promo-box">

    <div id="promo-bullets"></div>
    <div class="promo-container" id="'.$news["id"].'" style="background-image: url(http://www.habbotimes.net/assets/media/fancenter/topstorys/promo_roombuilding.png)">
            <div class="promo-content-container">
                <div class="promo-content">
                    <div class="title">'.stripslashes($news["title"]).'</div>
                    <div class="body">Welcome To New HobbaCMS :)</div>
                </div>
            </div>
            <div class="promo-link-container">

        <b></b>
    </div>
</div>
            </div>
        </div>


        </div>
        <b></b>

I'm using PhoenixPHP edit to my standard so I need help

 

[The General]

Only use phoenixphp if you want your hotel get hacked. Really, I'm talking with experience.

 

[Glee]

I've always used PhoenixPHP and I never got hacked

 

[ARMYDUDE]

Only use phoenixphp if you want your hotel get hacked. Really, I'm talking with experience.

-Agreed!

I've always used PhoenixPHP and I never got hacked

You must know how to secure your hotel?

 

[Doctorate]

I've always used PhoenixPHP and I never got hacked

There's a first time for everything.

What SQL code do you need..?
What do you want it to do?

 

[Glee]

Im trying to get mysql to grab my news articles from database instead of using it all manual by the PHP file

 

[GheddoMonsta]

test this: <?php $news = mysql_query("SELECT FROM * news"); ?>
<div id="promo-box">

<div id="promo-bullets"></div>
<div class="promo-container" id="'" style="background-image: url(http://www.habbotimes.net/assets/media/fancenter/topstorys/promo_roombuilding.png)">
<div class="promo-content-container">
<div class="promo-content">
<div class="title"><?php echo $news['title']; ?></div>
<div class="body">Welcome To New HobbaCMS </div>
</div>
</div>
<div class="promo-link-container">

<b></b>
</div>
</div>
</div>
</div>


</div>

 

[Glee]

Nope doesn't work

 

[Eronisch]

Let me help you a bit.
I've no idea what you exactly want, this will get the last inserted news article.
You will have to change some fields.

// Now you have the results from the last inserted news article
$query = mysql_query("select * from news order by id desc limit 1");
$results = mysql_fetch_assoc($query);

You can use the results by doing this:

<php echo $results['newsarticlename']; ?>

 

[Glee]

Okay, I can explain it better I want my news to switch from different pics like on habbo or habboon via MySQL so it would go like this

You must be registered to see links

 

[Jubatus]

Here is what I'm using for my CMS, I think it should work for you if you edit some parts.

<?php
$news = mysql_query("SELECT * FROM news_promo ORDER BY `order_id` DESC");
if(mysql_num_rows($news) == 0)
{
    echo '';
} 
else
{
    echo '<div id="promo-box">';
    echo '<div id="promo-bullets"></div>';
}
 
while($row = mysql_fetch_array($news))
{
    $id = $row['id'];
    $title = $row['title'];
    $text = $row['text'];
    $image_url = $row['image_url'];
    $url = $row['url'];
    $url_text = $row['url_text'];
           
    echo '<div class="promo-container" style="background-image: url(' .$image_url. ')">
          <div class="promo-content-container">
          <div class="promo-content">
          <div class="title">' .$title. '</div>
          <div class="body">' .$text. '</div>
          </div>
          </div>
          <div class="promo-link-container">
          <div class="enter-hotel-btn">
          <div class="open enter-btn">
          <a href="' .$url. '" target="a02ce3581bfb74fd6b4865171ed64cf3aaccc80e" onclick="HabboClient.openOrFocus(this); return false;">' .$url_text. '<i></i></a>
          <b></b>
          </div>
          </div>
          </div>
          </div>
         ';
}
?>

Here is the the SQL.

---- Database: `superdb`
--


-- --------------------------------------------------------


--
-- Table structure for table `news_promo`
--


CREATE TABLE IF NOT EXISTS `news_promo` (
  `id` int(11) NOT NULL,
  `title` text NOT NULL,
  `text` text NOT NULL,
  `image_url` text NOT NULL,
  `url` text NOT NULL,
  `url_text` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


--
-- Dumping data for table `news_promo`
--


INSERT INTO `news_promo` (`id`, `order_id`, `title`, `text`, `image_url`, `url`, `url_text`) VALUES
(1, 1, 'Promo #1!', 'text here', '%url%/web-gallery/v2/images/web_promo/diamond_vip.png', 'urlhere', 'Check it out!'),
(2, 2, 'Promo #2', 'txt here', '%url%/web-gallery/v2/images/web_promo/promo_frontPage_pockethabbo_1.png', 'urlhere', 'OMG!'),
(3, 3, 'Promo #3', 'text here', '%url%/web-gallery/v2/images/web_promo/web_promo_02.png', 'urlhere', 'Find out more');

 

[Glee]

It works but it glitches

You must be registered to see links

 

[Doctorate]

Let me help you a bit.
I've no idea what you exactly want, this will get the last inserted news article.
You will have to change some fields.

// Now you have the results from the last inserted news article
$query = mysql_query("select * from news order by id desc limit 1");
$results = mysql_fetch_assoc($query);

You can use the results by doing this:

<php echo $results['newsarticlename']; ?>

Thats wrong syntax.

// Now you have the results from the last inserted news article
$query = mysql_query("SELECT * FROM news ORDER BY id DESC LIMIT 1");
$results = mysql_fetch_assoc($query);

 

[Jubatus]

It works but it glitches

You must be registered to see links

Like I said, you may need to edit some parts for it to work for PhoenixPHP, as it works perfectly on my CMS. I would help you but I'm not familiar with PhoenixPHP.

I'm glad I helped a little bit, though.