chery

Can anyone help me - I'm desperate? [attachment deleted by admin]

I've written a php page that extracts random info from the db (it works perfectly). My next step is to display it on my index page - I'm using phpbb 2 which is tpl based and I'm not sure how to call the php file. Any help would be much appreciated.

Changed $sql = "SELECT * FROM phpbb_iNA; To $sql = "SELECT * FROM " . $table_prefix . "ina_data"; and it worked.

It began throwing these errors when I had to change the original code from $build_array = array(); $sql = "SELECT * FROM " . iNA; to $build_array = array(); $sql = "SELECT * FROM phpbb_iNA;

Warning: Invalid argument supplied for foreach() in /home/worldwid/public_html/admin/admin_arcade.php on line 45 Parse error: syntax error, unexpected '[', expecting ']' in /home/worldwid/public_html/admin/admin_arcade_log.php on line 37

Your suggestion gave this error: Parse error: syntax error, unexpected '"', expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/worldwid/public_html/admin/admin_arcade.php on line 47

Your suggestion gave this error: Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/worldwid/public_html/admin/admin_arcade.php on line 47

Parse error: syntax error, unexpected '[', expecting ']' in /home/worldwid/public_html/admin/admin_arcade.php on line 47 Can anyone see the error and how to fix it? // // Load DB // $build_array = array(); $sql = "SELECT * FROM FROM phpbb_iNA; $result = $db->sql_query($sql); $ina_info = $db->sql_fetchrowset($result); foreach ($ina_info as $key => $value) { $build_array[$value['config_name']] = $value['config_value']; } unset($ina_info); $arcade_config = $build_array; // line 47 is

Hi there, I created a simple php file which extracts data from a field in one of my tables: <?php $sql = "SELECT * FROM phpbb_ina_games ORDER BY game_desc ASC"; $query = mysql_query($sql); while($row = mysql_fetch_array($query)) { echo "<tr>"; echo "<td align=center bgcolor=#DAE4EC border=1><font size=2>".$row['game_desc']."</td>"; echo "</tr>"; } ?> I want to create an rss feed from this page or from the data at least - does anyone have any idea on how this could be accomplished? Any help would be much appreciated as it has me stumped.

Does anyone know how to do this please?

SQL result Host: localhost Database: worldwid_worldwide Generation Time: May 13, 2007 at 02:24 PM Generated by: phpMyAdmin 2.9.0.2 / MySQL 4.1.21-standard SQL query: SELECT * FROM `phpbb_ina_games` WHERE `game_name` LIKE CONVERT( _utf8 'ninjaturtles1' USING latin1 ) COLLATE latin1_swedish_ci LIMIT 0, 30 ; Rows: 1 game_id 799 game_name ninjaturtles1 game_path games/ninjaturtles1/ game_desc Ninja Turtles game_charge 1 game_reward 100 game_bonus 1000 game_use_gl 0 game_flash 1 game_show_score 1 win_width 800 win_height 400 highscore_limit 5 reverse_list 0 played 8 instructions game_avail 1 allow_guest 0 image_path games/ninjaturtles1/ninjaturtles11.gif cat_id 6 at_highscore_limit 5 at_game_bonus 1000 score_type 2 game_autosize 0 date_added 1170757468 rank_required 0 level_required 0 group_required 0 game_control 1 highscore_id 346 at_highscore_id 346

SQL result Host: localhost Database: worldwid_worldwide Generation Time: May 13, 2007 at 02:24 PM Generated by: phpMyAdmin 2.9.0.2 / MySQL 4.1.21-standard SQL query: SELECT * FROM `phpbb_ina_at_scores` WHERE `game_name` LIKE CONVERT( _utf8 'ninjaturtles1' USING latin1 ) COLLATE latin1_swedish_ci LIMIT 0, 30 ; Rows: 3 game_name ninjaturtles1 ninjaturtles1 ninjaturtles1 player NULL NULL NULL player_id 346 295 2 player_name DerringDo DerringDo DerringDo score 930.0000 770.0000 660.0000 date 1171454231 1170996621 1170818411 player_ip 124.120.182.153 laddis chery time_taken 118 155 119

copy the phpbb_ina_at_scores/score for the game_name to phpbb_ina_games/game_reward for the same game_name and update if different.

Please tell me exactly what you need - I only want to run the cron once per day to cut doen on server queries. PHP version 4.4.4 MySQL version 4.1.21-standard Server: localhost Database: worldwid_worldwide Table: phpbb_ina_games Field Type Collation Attributes Null Default game_reward int(11) UNSIGNED No 100 Table: phpbb_ina_at_scores Field Type Collation Attributes Null Default score double(14,4) No 0.0000

Thank you so much that would be FANTASTIC !!!