99naa

yes, as far as I am certain, the field does contain data, when I do a query to show what is in that field I get 10 rows retuned.  The field is containing text regarding the company, what they are about.

Well The problem I think is that the content of the text file is not sitting in the database properly.  I have no idea where its being set. The file is stored as a .txt file.  In the database the field data type is longblob I am a very raw beginner at this and of course jumping in the deep end. 

I have as yet to use any of these, but you can try here http://www.opensourcecms.com/index.php?option=com_content&task=view&id=475 Or you could try a book called php and mysql web devlopment by welling and thomson best of luck.  99

Hi I have inserted a text file into a database field.  When I executed the following query I get absolutly no result in the web page.  The code is.... [code]<?php   //connect to the database   include ("connect.php");   echo "<tr><td width='846' height='651' valign='top'><div align='center'><br>";   //get the about us file from the database   $query = "select * from aboutus where aboutus ='$aboutus[$i]'";   $result = mysql_query($query) or die ("error");   //display the query results in a table   while ($row = mysql_fetch_array($result));   {     echo stripslashes($row['aboutus']);   }   mysql_close(); ?>[/code] the text file is called aboutus.txt, the table is called aboutus and the field is called aboutus. If anyone can put me onto the right track I would really appreciate it. Many thanks 99 ;)

[!--quoteo(post=102802:date=Apr 2 2004, 02:10 AM:name=MadDogSh)--][div class=\'quotetop\']QUOTE(MadDogSh @ Apr 2 2004, 02:10 AM) 102802[/snapback][/div][div class=\'quotemain\'][!--quotec--] You don't at the moment user types it in, you do it afterwards, either at point of control whether the password or md5 representation of it is identical with md5-ed password already stored in user table in database or at the point of insertion of that password into database record. Use input field of type password, md5 input, store it md5-ed into database. At next login, compare md5-ed users input with already md5-ed password stored in users record. Simple, isn't it? You can, of course use SHA1() too. If you're using MySQL as database server, use MySQL function password() which gives you 12 character representation of string entered as password. This raises a question: What happens if you have HTML login without any php code and you pass input via POST method into an php script where you perform autorization? I.e. what happens with entered password that comes into php script non-encripted? Example: - in HTML, say login.html: <input name="passw" type="password" /> - user's input is visible as ******, but still it's very readable string -HTML form is defined: <FORM name="form" method="POST" action="verify.php"> in verify.php: $pass_entered = md5('$_POST[passw]'); At that moment input is being encrypted, but what was going on with this input while browser invoked and opened "verify.php", variables made throuhg POST method in HTML should have been passed in some way, although no verify.php?passw weren't used? Isn't there some kind of security leak where unauthorized person can catch password user entered? Sorry for lenght of that post? That's something taht's on my mind for some time... Thanks for understanding. Please forgive a silly question but how do you get the md5 password into the mysql database? Do you insert it via a query? I tried adding it directly to the table but that didn't work. I have a script that I am trying to get working. It is an encrypted password login. I have the password being encrypted but it's not getting to the database. Any help would be gratefully received. Vonzie