help understand database row fetching

[Availor]

I've started learning php since not being able to fix a minor problem is annoying...

I started from the very basic, trying to pull the first image from the gallery module from it's database:

Code:

<?php
$result = mysql_query("SELECT title FROM mod_gallery_images WHERE image_id='4'", $database);
$myrow = mysql_fetch_array($result);

echo $myrow['title']
?>

The idea (eventually) is to pull the latest (anything) from a specific module, like recent images, recent news etc...

Eventhough it works fine on my local server (wamp) id doesn't work on WebsiteBaker database.

If anyone can help me understand how to fetch rows (in this example title)...
I've opened some of the modules like anynews and anytopics but they had too much code with too many variables so I got confused.

It seems to be like an easy task fetching some data from a certain table...

[DarkViper]

Code: (try this)

<?php

$title = $database->get_one( 'SELECT `title` FROM `'.TABLE_PREFIX.'mod_gallery_images` WHERE `image_id` = 4' );

echo ( !is_null($title) ? $title : '' );

?>

For all other problems: RTFM

[crnogorac081]

Hi,

First, you did not define $database...

Take a look at this examples:

Code:

if($res = $database->query("SELECT link FROM ".TABLE_PREFIX."pages WHERE page_id = '$page_id'")) {
    if($res->numRows() > 0) {
        $page = $res->fetchRow();
         echo $page['link'];
   }
}

if($res = $database->query("SELECT * FROM ".TABLE_PREFIX."mod_news_posts WHERE active = '1'")) {
    if($res->numRows() > 0) {
        while($post = $res->fetchRow()) {
            echo $post['title'];
        }
    }
}

cheers

[Availor]

@DarkViper: Thanks it worked. I already went through the developer guide didn't understand it....

@crnogorac081:
It seems to give the page path, as a loop (?) - to fetchrow() while the table is more than 0... ?

Anyway thanks for the support I'll try figuring this out, I have some more php turorials to learn from