[SOLVED] Invalid MySQL result set..

[ww_mar]

Hello everybody,

 

I am seeking help with a mysql/php issue.. (i think this is the best forum, if not please move!). The Issue is described here: http://www.phpbb.com/community/viewtopic.php?f=71&t=1712665 and http://www.phpbb.com/community/viewtopic.php?f=74&t=1717035

 

Here is the create of the table under scrutiny

 

CREATE TABLE  `phpbb_medals_awarded` (
  `id` int(10) NOT NULL auto_increment,
  `medal_id` bigint(20) NOT NULL default '0',
  `user_id` bigint(20) NOT NULL default '0',
  `awarder_id` bigint(20) NOT NULL default '0',
  `awarder_un` varchar(255) character set utf8 collate utf8_bin NOT NULL default '',
  `awarder_color` varchar(6) character set utf8 collate utf8_bin NOT NULL default '',
  `time` int(11) NOT NULL default '0',
  `nominated` tinyint(1) NOT NULL default '0',
  `nominated_reason` text character set utf8 collate utf8_bin NOT NULL,
  `points` smallint(4) NOT NULL default '0',
  `bbuid` varchar(255) character set utf8 collate utf8_bin NOT NULL default '',
  `bitfield` varchar(255) character set utf8 collate utf8_bin NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `time` (`time`)
) ENGINE=MyISAM AUTO_INCREMENT=84 DEFAULT CHARSET=utf8;

 

I have been echoing my query and it is as it is supposed to be and pasting the output of echo into mysqladmin does not give me any problem.

 

Could any of you please ID the problem? Thank you very much..

Best Regards

ww_mar

[abazoskib]

if you are simply echoing the query then of course it will not work. You need to connect to your database with PHP and then use

mysql_query($queryString);

 

where $queryString is equal to your query.

 

Check out the PHP manual.

[ww_mar]

Are you joking? 

 

Please read the links I posted..

[Philip]

It is unlikely you're going to get a reply here since you are messing with phpBB's functions. Their forum is the best place to place your question, and patiently wait for a reply.

[ww_mar]

they say to ask you, you say to ask them 

Thanks, anyway.

Best Regards

[abazoskib]

Are you joking? 

 

Please read the links I posted..

 

oopsies. well, what is the query(im not sure if you meant the creation of that table is giving you a problem), and/or what warnings are you getting?

[PFMaBiSmAd]

Since -

 

$db->sql_query($sql)

 

does not trigger the or die() probably means that it does not return what you think it does and it apparently does not return a FALSE value when a query fails. It would take seeing or knowing what the ->sql_query() method is in order to help, which is why the phpbb forum would be the best place to get help.

 

try -

 

var_dump($result);

 

to see what exactly is in $result.

[ww_mar]

Thanks a lot for the advice..! This is the output of var_dump and after that there is an echo of the result.

 

object(mysqli_result)#11 (0) { } 
Object id #11

 

this happens no matter what the query is...all queries give this.. what is this object 11?

 

Thanks a lot for the support.

[ww_mar]

Thank you PFMaBiSmAd, thanks to your input I managed to solve the problem, indeed I did not know that sql_query was not a standard function..so I could not use mysql_num_rows. 

 

bye bye

[PFMaBiSmAd]

Edit: here is my reply even though you seem to have solved the problem while I was writing it -

 

The database interface you are using is mysqli and a successful query returns a mysqli result object.

 

The main problem in the code you are writing is that the mysql_ functions you are using won't work because the database interface is using mysqli. Since the type of database can be selected through phpbb configuration, you need to use phpbb's $db-> class functions for everything associated with a database. You cannot graft on direct database functions because they may not match what is currently selected for the database interface.