blankextacy Posted October 18, 2006 Share Posted October 18, 2006 could some one tell me why this isnt working[code]<?phpif (!$view) { print "Fight movie selection<br><br> <table> <tr><td width=100><b><u>Name</td><td width=100><b><u>Picture</td><td width=50><b><u>Description</td><td><b><u>Submitted</td><td><b><u>Options</td></tr>"; $videos = mysql_query("select * from videos where type='fight' order by id"); while ($video = mysql_fetch_array($videos)) { print "<tr><td>$video[name]</td><td><p><img src=$video[pic]width="62" height="62"</p></td><td>$video[desc]</td><td>$video[submitted]</td><td>- <A href=fights.php?view=$video[id]>Play</a></td></tr>"; } print "</table>";}if ($view) { $video = mysql_fetch_array(mysql_query("select * from videos where id=$view")); if (empty ($video[id])) { print "No such video. Go back to the <a href=videos.php>videos</a>."; exit; } if ($video[type] != pranks || funny || stupid || animated) { print "That's not a fight video. Go back to the <a href=videos.php>videos</a>."; exit; } print "<embed src='$video[link]' type='application/x-mplayer2' width='300' height='300' ShowControls='1' ShowStatusBar='0' loop='true' EnableContextMenu='0' autostart='true' DisplaySize='0' pluginspage='http://www.microsoft.com/Windows/Downloads/Contents/Products/MediaPlayer/'></embed></div>"; mysql_query("update players set credits=credits-$arm[cost] where id=$stat[id]");}?>[/code]im not sure but the image part isnt working [code]<td><p><img src=$video[pic]width="62" height="62"</p></td>[/code]and the view part isnt working Quote Link to comment Share on other sites More sharing options...
AdRock Posted October 18, 2006 Share Posted October 18, 2006 try putting ' before and after [ and ] so you get ['pic'] Quote Link to comment Share on other sites More sharing options...
rab Posted October 18, 2006 Share Posted October 18, 2006 print "<img src=\"{$video['name']}\" />"; Quote Link to comment Share on other sites More sharing options...
blankextacy Posted October 18, 2006 Author Share Posted October 18, 2006 where does the width and height go? Quote Link to comment Share on other sites More sharing options...
blankextacy Posted October 18, 2006 Author Share Posted October 18, 2006 [code]if ($view) { $video = mysql_fetch_array(mysql_query("select * from videos where id=$view")); if (empty ($video[id])) { print "No such video. Go back to the <a href=videos.php>videos</a>."; exit; } if ($video[type] != pranks || funny || stupid || animated) { print "That's not a fight video. Go back to the <a href=videos.php>videos</a>."; exit; } print "<embed src='$video[link]' type='application/x-mplayer2' width='300' height='300' ShowControls='1' ShowStatusBar='0' loop='true' EnableContextMenu='0' autostart='true' DisplaySize='0' pluginspage='http://www.microsoft.com/Windows/Downloads/Contents/Products/MediaPlayer/'></embed></div>"; mysql_query("update players set credits=credits-$arm[cost] where id=$stat[id]");}?>[/code]that part also doesnt work the site is http://revo-online.net/gdmovies/fights.php as u can see when u click play ?view=1 comes up blank Quote Link to comment Share on other sites More sharing options...
rab Posted October 18, 2006 Share Posted October 18, 2006 [quote author=blankextacy link=topic=111847.msg453486#msg453486 date=1161131925][code]if ($view) { $video = mysql_fetch_array(mysql_query("select * from videos where id=$view")); if (empty ($video[id])) { print "No such video. Go back to the <a href=videos.php>videos</a>."; exit; } if ($video[type] != pranks || funny || stupid || animated) { print "That's not a fight video. Go back to the <a href=videos.php>videos</a>."; exit; } print "<embed src='$video[link]' type='application/x-mplayer2' width='300' height='300' ShowControls='1' ShowStatusBar='0' loop='true' EnableContextMenu='0' autostart='true' DisplaySize='0' pluginspage='http://www.microsoft.com/Windows/Downloads/Contents/Products/MediaPlayer/'></embed></div>"; mysql_query("update players set credits=credits-$arm[cost] where id=$stat[id]");}?>[/code]that part also doesnt work the site is http://revo-online.net/gdmovies/fights.php as u can see when u click play ?view=1 comes up blank[/quote]First off, your not supposed to run a function within another function example: mysql_fetch_array(mysql_query());. Your MySQL query is vulnerable to SQL injections, please secure your $_GET variables. Also with your array it should be $array['item'] or $array[3] not $array[video], And your if() statement is wrong. That was just after a glance at your code. Quote Link to comment Share on other sites More sharing options...
blankextacy Posted October 18, 2006 Author Share Posted October 18, 2006 theres something else wrong if u goto the site ull se that there no errors when u press play and goto ?view=1 its doest show any thing just stays at the same page Quote Link to comment Share on other sites More sharing options...
trq Posted October 18, 2006 Share Posted October 18, 2006 Post your current code. Quote Link to comment 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.