Code:
-- phpMyAdmin SQL Dump
-- version 2.8.0.3
-- http://www.phpmyadmin.net
--
-- Host: ******
-- Generation Time: Apr 12, 2007 at 12:12 AM
-- Server version: 5.0.27
-- PHP Version: 5.2.0
--
-- Database: `******`
--
-- --------------------------------------------------------
--
-- Table structure for table `blogs`
--
CREATE TABLE `blogs` (
`blog_num` int(10) unsigned NOT NULL auto_increment,
`username` varchar(32) NOT NULL,
`password` varchar(40) NOT NULL,
`blog_name` varchar(32) NOT NULL,
`blog_descript` text NOT NULL,
`email` text NOT NULL,
PRIMARY KEY (`blog_num`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `blogs`
--
INSERT INTO `blogs` (`blog_num`, `username`, `password`, `blog_name`, `blog_descript`, `email`) VALUES (1, '68674ee5a02f7e90114f6176d1ca7685', 'c54f8a9785eee6505e3a6b0f5bd0bb3cd9315c15', 'Test', 'Test2', 'admin@arenblogs.com');
-- --------------------------------------------------------
--
-- Table structure for table `posts`
--
CREATE TABLE `posts` (
`post_num` bigint(20) unsigned NOT NULL auto_increment,
`blog_num` int(11) NOT NULL default '0',
`post_date` datetime NOT NULL default '0000-00-00 00:00:00',
`post_title` text NOT NULL,
`post_data` longtext NOT NULL,
PRIMARY KEY (`post_num`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
--
-- Dumping data for table `posts`
--
INSERT INTO `posts` (`post_num`, `blog_num`, `post_date`, `post_title`, `post_data`) VALUES (1, 1, '2007-03-22 20:44:39', 'Example Post', 'This is an example post, delete or edit.'),
(2, 1, '2007-03-22 23:01:11', 'Test Post', 'This is just a test post to see how things go. It is long and long and long and mainly full of air. Air and air and more air and yet more air and even more air. Fluff is a word. My friends all prefer jailbait don''t know why. My female friends prefer BEING jailbait, don''t know why that either. This should be long enough to wrap so I can see what it looks like, but if not then I''ll have to add more later on.'),
(3, 1, '2007-04-10 07:23:13', 'Another Test', 'Mess with Canadians, play with them too, get to have lots of fun. Have fun with the other one too. Hehehe all secret of mine and mine alone. Seriously, not telling.');
mysql_data_seek($tsil); failed to produce any results at all, Errors are not turned on though.
$mfa also seems to have made you interested in a clearer meaning, mfa stands for none other than mysql_fetch_array. Bet you didn't see THAT one coming.
I'll try just pulling two queries.