[!Unreal]

I have this code:

PHP Code:

<?php

mysql_connect ("localhost", "unrealme_divx","password")  or die (mysql_error());

mysql_select_db ("unrealme_divx");



$id = $_GET['id'];



$sql = mysql_query("select * from divx where id like '$id'");



while ($row = mysql_fetch_array($sql)){

        }

        

echo '<object classid="clsid:67DABFBF-D0AB-41fa-9C46-CC0F21721616" width="720" height="360" codebase="http://go.divx.com/plugin/DivXBrowserPlugin.cab">



 <param name="custommode" value="none" />



  <param name="previewImage" value="http://www.tld.com/image.jpg" />

  <param name="autoPlay" value="false" />

  <param name="src" value="$row[\'url\']" />



<embed type="video/divx" src="$row[\'url\']" custommode="none" width="720" height="360" autoPlay="false"  previewImage="http://www.tld.com/image.jpg"  pluginspage="http://go.divx.com/plugin/download/">

</embed>

</object>';

    





?>

But the functions wont work. I don't know what I am doing wrong.

Please could someone 'debug' my code. That would be awesome. Ive been trying for hours and I just can't do it.

Thanks again, Unreal

[job0107]

Your not putting the echo statement in the while loop and you have some syntax errors in your echo statement.

Try it like this:

PHP Code:

<?php
mysql_connect ("localhost", "unrealme_divx","password")  or die (mysql_error());
mysql_select_db ("unrealme_divx");
$id = empty($_GET['id']) ? "" : $_GET['id'];
$sql = mysql_query("select * from divx where id like '$id'");
if(mysql_num_rows($sql) > 0)
{
 while($row = mysql_fetch_assoc($sql))
 {
  echo '<object classid="clsid:67DABFBF-D0AB-41fa-9C46-CC0F21721616" width="720" height="360" codebase="http://go.divx.com/plugin/DivXBrowserPlugin.cab">
         <param name="custommode" value="none" />
         <param name="previewImage" value="http://www.tld.com/image.jpg" />
         <param name="autoPlay" value="false" />
         <param name="src" value="'.$row["url"].'" />
         <embed type="video/divx" src="'.$row["url"].'" custommode="none" width="720" height="360" autoPlay="false"  previewImage="http://www.tld.com/image.jpg"  pluginspage="http://go.divx.com/plugin/download/"></embed>
        </object>';
  }
 }
?>

[!Unreal]

Originally Posted by job0107

Your not putting the echo statement in the while loop and you have some syntax errors in your echo statement.

Try it like this:

PHP Code:

<?php

mysql_connect ("localhost", "unrealme_divx","password")  or die (mysql_error());

mysql_select_db ("unrealme_divx");

$id = empty($_GET['id']) ? "" : $_GET['id'];

$sql = mysql_query("select * from divx where id like '$id'");

if(mysql_num_rows($sql) > 0)

{

 while($row = mysql_fetch_assoc($sql))

 {

  echo '<object classid="clsid:67DABFBF-D0AB-41fa-9C46-CC0F21721616" width="720" height="360" codebase="http://go.divx.com/plugin/DivXBrowserPlugin.cab">

         <param name="custommode" value="none" />

         <param name="previewImage" value="http://www.tld.com/image.jpg" />

         <param name="autoPlay" value="false" />

         <param name="src" value="'.$row["url"].'" />

         <embed type="video/divx" src="'.$row["url"].'" custommode="none" width="720" height="360" autoPlay="false"  previewImage="http://www.tld.com/image.jpg"  pluginspage="http://go.divx.com/plugin/download/"></embed>

        </object>';

  }

 }

?>

Thanks for cleaning that up. It works perfectly now

[job0107]

Your welcome.