pupsik Posted October 20, 2012 Share Posted October 20, 2012 Hi there. i have a php script that grabs information from database, but it does not. In my forum I gave users gifts as in small picture, it does write it to db, it also shows on profile 'Award:1" . but when I click on the award to see it, it states that there is no award. Here is the code on that page where awards should be display'd. Please help. <?php require "../conf_global.php"; $nawards = ""; $INFO['sql_driver'] = !$INFO['sql_driver'] ? 'mySQL' : $INFO['sql_driver']; $to_require = "../sources/Drivers/".$INFO['sql_driver'].".php"; require ($to_require); $DB = new db_driver; $DB->obj['sql_database'] = $INFO['sql_database']; $DB->obj['sql_user'] = $INFO['sql_user']; $DB->obj['sql_pass'] = $INFO['sql_pass']; $DB->obj['sql_host'] = $INFO['sql_host']; $DB->obj['sql_tbl_prefix'] = $INFO['sql_tbl_prefix']; // Get a DB connection $DB->connect(); if (isset($mid)) { $query=$DB->query("select * from ibf_awards where mid = '$mid'"); $nawards=mysql_num_rows($query); $userinfo=mysql_query("select * from ibf_members where id = '$mid'"); } ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>awards</title> <meta http-equiv="Content-Type" content="text/html; charset=windows-1251"> <link rel='stylesheet' href='../style_sheets/stylesheet_1.css' type='text/css'> </head> <body bgcolor="#FFFFFF" vlink='#000000' alink='#000000' leftmargin="0" topmargin="0" marginwidth="0" marginheight="0"> <center> <br> <? if ($nawards>"0") { ?> <table width="95%" border="0" bgcolor="#000000" cellspacing="0" cellpadding="1"> <tr> <td width="100%" bgcolor="#000000"> <table width="100%" border="0" cellspacing="0" cellpadding="1" background='../style_images/1/tile_back.gif' id='maintitleback'> <tr> <td width="100%" colspan="4" id="maintitle" align="center"><strong>Awards for <? echo mysql_result($userinfo, 0, 'name'); ?></strong></td> </tr> </table> <table width="100%" border="0" cellspacing="1" cellpadding="1" bgcolor="#999999"> <tr> <td width="20%" align="center" nowrap id='titlemedium' background='../style_images/1/tile_sub.gif'><strong>title</strong></td> <td width="25%" align="center" nowrap id='titlemedium' background='../style_images/1/tile_sub.gif'><strong>picture</strong></td> <td width="15%" align="center" nowrap id='titlemedium' background='../style_images/1/tile_sub.gif'><strong>from:</strong></td> <td width="40%" align="center" nowrap id='titlemedium' background='../style_images/1/tile_sub.gif'><strong>description</strong></td> </tr> <? for ($r=0; $r<$nawards; $r++) { ?> <tr> <td width="20%" id="forum2" align="center"><? echo mysql_result($query, $r, 'awardtitle'); ?></td> <td width="25%" id="forum2" align="center"><img src="../html/awards/<? echo mysql_result($query, $r, 'awardimg'); ?>" alt=""></td> <td width="15%" id="forum2" align="center"><? echo mysql_result($query, $r, 'cid'); ?></td> <td width="40%" id="forum2" align="center"><? echo mysql_result($query, $r, 'description'); ?></td> </tr> <? } ?> <tr> <td width="20%" id='mainfoot'> </td> <td width="25%" id='mainfoot'> </td> <td width="15%" id='mainfoot'> </td> <td width="40%" id='mainfoot'> </td> </tr> </table> </td></tr> </table> <? } else echo "<font size=\"2\" face=\"Tahoma, Verdana, Arial, sans-serif\"><strong>this user have no awards</strong></font>"; ?> <br> <font size="1" face="Tahoma, Verdana, Arial, sans-serif"><a href="javascript:close()">close window.</a></font> </center> </body> </html> <? $DB->close_db(); ?> Quote Link to comment https://forums.phpfreaks.com/topic/269719-cant-grab-information-from-db/ Share on other sites More sharing options...
fenway Posted October 21, 2012 Share Posted October 21, 2012 mysql_result() is less than ideal -- better to use a fetch call and get back a hash -- that will also make it clear what's going wrong. Also, you're completely open to SQL injection. Quote Link to comment https://forums.phpfreaks.com/topic/269719-cant-grab-information-from-db/#findComment-1386760 Share on other sites More sharing options...
pupsik Posted October 21, 2012 Author Share Posted October 21, 2012 Thank you, but i didn't get any of that. Quote Link to comment https://forums.phpfreaks.com/topic/269719-cant-grab-information-from-db/#findComment-1386808 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.