View Single Post
Old 09-30-2006, 07:51 AM  
TMM_John
Confirmed User
 
TMM_John's Avatar
 
Industry Role:
Join Date: May 2004
Posts: 6,664
Do you have the table created? If you do then just run that sql you have against it and then run this on the server.

Code:
<?

  mysql_connect("host","username","password");
  mysql_select_db("yourdbname");
  
  $query = "select * from L;";
 
  $result = mysql_query($query);

  while( $row = mysql_fetch_assoc($result)){

    print $row["url"].",".$row["title"].",,,,".$row["description"]."\n";


  }
?>
Then view source as HTML won't interpret the line break.

If you need the table structure created or need info on how to get the SQL inserts you have put into it let me know.
TMM_John is online now   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote