Jump to content

Help with database query


99naa

Recommended Posts

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 ;)
Link to comment
Share on other sites

[quote author=99naa link=topic=110127.msg444569#msg444569 date=1159686948]
I have inserted a text file into a database field. [/quote]

I assume you mean you have inserted [i]the contents[/i] of a text file ...

Where in your code does the value of $aboutus[$i] get set?
Link to comment
Share on other sites

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. 
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.