mysql to print php output file

hi yeah reading back on my post i see what you mean not very clear


well all i really want to do is be able to pull some info from the a mysql database and output it in a
php file or even a xml file

so it reads like this

<ratings>
<video file="11.flv">
<title>The title of my video</title>
<runtime>00:30</runtime>
<author>pete</author>
<rating>5</rating>
<views>20</views>
<key>aa6e02c990b0a82652dc</key>
<link>www.somesite.com</link>
</video>
</ratings>


so in the php file the info for the link would be
 $video  =$config['BASE_URL']."/view_video.php?viewkey=".$results['vkey'];

and that would put the link in the link tags

hope you understand what i mean

thanks
pete

Ummm... that still didn't say what works and what doesn't.  And the original code is a mess.  But I'll take a quick shot at it.

Towards the end, you'll see:

print "  </description>\n";

AFTER that line, try adding:

print "  <link>\n";
print $video;
print "  </link>\n";

As an example.  You can easily add other fields, or wrap the whole thing in <ratings>, or wrap each item in <video> or something, if you want a custom format.  Obviously, the main code there is trying to output an RSS feed, so I'm not sure if you want an RSS feed, or a completely custom format that isn't a feed.

-d

hi
the code works fine for the rss feed
i just thought it might help show how i was getting the info from the database


right it does not need to be a xml or a rss feed

i tried what you said and yes it will print out the video link but i need to actually see when i look at the page it formated like the example in my last post at the minute  it just prints out the link

ie

http://www.mysite.com/home/view_video.php?viewkey=d5072bb1864cdee4d3d6

but when i look at the page i need to see

<link>http://www.mysite.com/home/view_video.php?viewkey=d5072bb1864cdee4d3d6</link>


if i look at the source to the page i can see it says that but i need it to be visible when its viewed with a browser

thanks

pete

this  was the code i used to make it print out the link

<?php


include("include/dbconfig.php");
include("include/config.php");


if ($_GET[type] == "new")
{
  $query = "SELECT A.*,B.UID,B.username FROM media A, signup B WHERE A.UID=B.UID AND A.type = 'public' ORDER BY A.VID desc LIMIT 10";
  $titel = "[20 Newest videos on ".$config['site_name']."]";
  $url   = $config['BASE_URL']."";
}


else
{
  $query = "SELECT A.*,B.UID,B.username FROM media A, signup B WHERE A.UID=B.UID AND A.type = 'public' ORDER BY A.VID desc LIMIT 20";
  $titel = "[20 Newest videos on ".$config['site_name']."]";
  $url   = $config['BASE_URL']."";
}

 
$db=mysql_connect ($DBHOST,$DBUSER,$DBPASSWORD) or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ($DBNAME);
 
$num_rows = mysql_num_rows(mysql_query("select * from media"));
 
$result = mysql_query($query) or die ('Query Error: ' . mysql_error());
while ($results = mysql_fetch_array($result))
{
  $photo       = $config['BASE_URL']."/thumb/1_".$results['VID'].".jpg";
  $video       = $config['BASE_URL']."/view_video.php?viewkey=".$results['vkey'];
  $description = $results['description'];
  $description = str_replace ("&amp","",htmlspecialchars(stripslashes($description)));
  $photo       = str_replace ("&amp","&amp",htmlspecialchars(stripslashes($photo)));



print "<link>\n";
print $video;
print "</link>\n";



}

mysql_close();



?>

hi

ok i have come up with another way of doing it so it writes the information to a xml file
which works fine but only prints the first results instead of the first 20

how would i change this so it writes the first 20 results to the xml file and not just one


<?php

//include("include/dbconfig.php");
include("include/config.php");

if ($_GET[type] == "new")
{
  $query = "SELECT A.*,B.UID,B.username FROM media A, signup B WHERE A.UID=B.UID AND A.type = 'public' ORDER BY A.VID desc LIMIT 10";
  $titel = "[20 Newest videos on ".$config['site_name']."]";
  $url   = $config['BASE_URL']."/rss/new/";
}
elseif ($_GET[type] == "views")
{
  $query = "SELECT A.*,B.UID,B.username FROM media A, signup B WHERE A.UID=B.UID AND A.type = 'public' ORDER BY A.viewnumber desc LIMIT 10";
  $titel = "[20 Most Viewed videos on ".$config['site_name']."]";
  $url   = $config['BASE_URL']."/rss/views/";
}
elseif ($_GET[type] == "comments")
{
  $query = "SELECT A.*,B.UID,B.username FROM media A, signup B WHERE A.UID=B.UID AND A.type = 'public' ORDER BY A.com_num desc LIMIT 10";
  $titel = "[20 Most Commented videos on ".$config['site_name']."]";
  $url   = $config['BASE_URL']."/rss/comments/";
}

else
{
  $query = "SELECT A.*,B.UID,B.username FROM media A, signup B WHERE A.UID=B.UID AND A.type = 'public' ORDER BY A.VID desc LIMIT 20";
  $titel = "[20 Newest videos on ".$config['site_name']."]";
  $url   = $config['BASE_URL']."/rss/new/";
}



$db=mysql_connect ($DBHOST,$DBUSER,$DBPASSWORD) or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ($DBNAME);
 
$num_rows = mysql_num_rows(mysql_query("select * from media"));
 
$result = mysql_query($query) or die ('Query Error: ' . mysql_error());
while ($results = mysql_fetch_array($result))
{

  $photo       = $config['BASE_URL']."/thumb/1_".$results['VID'].".jpg";
  $video       = $config['BASE_URL']."/view_video.php?viewkey=".$results['vkey'];
  $Key         = $results['vkey'];
  $description = $results['description'];
  $description = str_replace ("&amp","",htmlspecialchars(stripslashes($description)));
  $photo       = str_replace ("&amp","&amp",htmlspecialchars(stripslashes($photo)));
  $filename1   = "file1";
  $Runtime     = "00.30";
  $videofile   = "<video file='11.flv'>";
  $author      = $results['username'];      
  $rating      = "4";
  $views       = "2";
  $xmlfileName = $filename1;
  $Title1      = $description;
  $key1        = $Key;
  $xml_dec     = "<?xml version=\"1.0\" encoding=\"UTF-8\" ?>";


        $rootELementStart = "<ratings>";
        $rootElementEnd = "</ratings>";

        $xml_doc=    $xml_dec;

        $xml_doc .=  $rootELementStart;
      
      $xml_doc .=  "$videofile";
      
        $xml_doc .=  "<title>";
        $xml_doc .=  $Title1;
        $xml_doc .=  "</title>";

      $xml_doc .=  "<runtime>";
      $xml_doc .=   $Runtime;      
      $xml_doc .=  "</runtime>";

      $xml_doc .=  "<author>";
      $xml_doc .=   $author;
      $xml_doc .=  "</author>";

      $xml_doc .=  "<rating>";
      $xml_doc .=   $rating;
      $xml_doc .=  "</rating>";

      $xml_doc .=  "<views>";
      $xml_doc .=  $views;
      $xml_doc .=  "</views>";

        $xml_doc .=  "<key>";
        $xml_doc .=  $key1;
        $xml_doc .=  "</key>";      

        $xml_doc .=  "</video>";
      

        $xml_doc .=  $rootElementEnd;

        $default_dir1 = "xml_files/";

        $default_dir1 .= $xmlfileName .".xml";


}
mysql_close();

$fp = fopen($default_dir1,'w');

            $write = fwrite($fp,$xml_doc);



?>

regards

pete

admin could you refund my points please as i have just about sorted it

thanks

and you can close question