[SOLVED] Help: mysql_query()

[clown[NOR]]

I have one simple question.. why does this work:

 

<?php

function visSisteNyhet()
{
	c2db();
	$result = mysql_query("SELECT * FROM `news_article` WHERE authorized='1' ORDER BY `id` DESC LIMIT 1");
	if (!$result) { die(); }

	$dbRows = mysql_num_rows($result);
	if ($dbRows > 0) {
		$dbField = mysql_fetch_array($result);
		$id = $dbField['id'];
		$title = $dbField['title'];
		return '<a href="atikkel.php?id='.$id.'">'.$title.'</a>';
	}
}

?>

 

but this doesn't return anything:

<?php

function visSisteNyhet()
{
	c2db();
	$result = mysql_query("SELECT id,title FROM `news_article` WHERE authorized='1' ORDER BY `id` DESC LIMIT 1");
	if (!$result) { die(); }

	$dbRows = mysql_num_rows($result);
	if ($dbRows > 0) {
		$dbField = mysql_fetch_array($result);
		$id = $dbField['id'];
		$title = $dbField['title'];
		return '<a href="atikkel.php?id='.$id.'">'.$title.'</a>';
	}
}

?>

 

the change is in the $query line

 

Thanks In Advance

- Clown

[taith]

a) its the $result line not $query

b) try this... i've had issues with some names of columns left on their own... therefore go `!

 

[s]$result = mysql_query("SELECT id,title FROM `news_article` WHERE authorized='1' ORDER BY `id` DESC LIMIT 1");
if (!$result) { die(); }[/s]
$result = mysql_query("SELECT `id`,`title` FROM `news_article` WHERE `authorized`='1' ORDER BY `id` DESC LIMIT 1") or die();

[clown[NOR]]

haha... yeah about the $query ... my bad... I'm used to add the query into the $query and then run it trough the $result...hehehe... shit happens...

 

but for the problem... it still don't work... the output is nothing...

 

EDIT: I just tried adding mysql_error() inside die()... no errors

[iLLeLogicaL]

try using mysql_fetch_object instead of mysql_fetch_array. That should fix it

[clown[NOR]]

that returned this error:

 

Fatal error: Cannot use object of type stdClass as array in G:\www\dassrevyen\V2\includes\functions\nyheter.php on line 12

[iLLeLogicaL]

Woho

<?php

function visSisteNyhet()
{
	c2db();
	$result = mysql_query("SELECT id,title FROM `news_article` WHERE authorized='1' ORDER BY `id` DESC LIMIT 1");
	if (!$result) { die(); }

	$dbRows = mysql_num_rows($result);
	if ($dbRows > 0) {
		$dbField = mysql_fetch_array($result);
		$id = $dbField['id'];
		$title = $dbField['title'];
		return '<a href="atikkel.php?id='.$id.'">'.$title.'</a>';
	}
}

?>

Should then be

<?php

function visSisteNyhet()
{
	c2db();
	$result = mysql_query("SELECT id,title FROM `news_article` WHERE authorized='1' ORDER BY `id` DESC LIMIT 1");
	if (!$result) { die(); }

	$dbRows = mysql_num_rows($result);
	if ($dbRows > 0) {
                       
		while($dbField = mysql_fetch_object($result))
		{
                        $id = $dbField['id'];
		$title = $dbField['title'];
		return '<a href="atikkel.php?id='.$id.'">'.$title.'</a>';
                        }
	}
}

?>

[clown[NOR]]

ok..tried it.. and it still returns:

 

Fatal error: Cannot use object of type stdClass as array in G:\www\dassrevyen\V2\includes\functions\nyheter.php on line 12

[taith]

ahoy!

while($dbField = mysql_fetch_object($result))

you need array()/assoc()

[clown[NOR]]

thanks for your help guys... much appriciated