[When inserting allot of text into a record breaks are not showing]

invoking the class

$values = array("$title","$img","$post","$aurthor_id","$category_id","$date_posted");
$fields = array('title,','img,','post,','aurthor_id,','category_id,','date_posted'); 
$obj= new DatabaseInsert;
$obj->DatabaseConnectionRequire();
$obj->ArticleInsert($values,$fields,$table); 

 

The Insert Class

class DatabaseInsert {

	function DatabaseConnectionRequire() {
		include("../scrips/php/database.connection.class.php");
		include("../scrips/php/database.settings.php");	
		include("../scrips/php/database.connection.class.invoke.php");	

	}

	function ArticleInsert($values,$fields,$table) {

		$values_imploded = implode("   ",$values);
		$fields_imploded = implode("   ",$fields);
		$i = "INSERT INTO $table ($fields_imploded) VALUES ($values_imploded)";
		//mysql_query($i) or die (mysql_error());
		//Uncomment ^ this to check the query for errors.

		if (!(mysql_query($i))) {

	    	echo "Sorry, something whent wrong there...";
		}

		else {
			echo "<strong><p style='color:green;'>Content added sucessfully!!!</p></strong>";
		}

	}
}

 

The View point

if(isset($_GET['id'])) {
// Get the id and select it's corresponding record 
$id = $_GET['id']; 
$query = "SELECT * FROM blog_posts  INNER JOIN post_categories ON blog_posts.category_id=post_categories.id WHERE blog_posts.id = $id";
$get_results = mysql_query($query) or die (mysql_error());
$results = mysql_fetch_array($get_results);
}

<?php echo $results['post']; ?> // the main body of the article

 

[When inserting allot of text into a record breaks are not showing]

Am adding text with paragraphs into my database but when i view that data on another page it's just one big block of text. :S Anyone no how i can stop this?

[Calling a javascript function with a select option?]

Can this me done guys?

[Creating a function that add a string into a text box]

This obv seems simple from the title, hoverever i dont want to just had text into a text area i want to be able to add in addition to what the user has already input.

 

example when you like the code button on this form the '[ code ][ /code ]' text comes up. this is exacly what i want. any one have any idea's?

 

[This is a long shot...but here it goes]

it's not realy the form i have an issue this it's when the article is viewed i want to be able to check the article body for something like [ quote ] [ /quote ] and if it finds it wrap it in a tag with a class so i can have a difrent style applied to it

[This is a long shot...but here it goes]

I would like to apply some addition functionality to a form which add news records into the database. Basicaly what i want is similar to what this forum does with the [ code ] [ /code ] but what i want for the user to be able to add [ quote ] [ /quote ] and when the post is viewed then that specific area of the acticle body will be formated diffrently. I hope this makes sence.

[selecting the records by the heighest values]

Thanks man. Silly question i guess just wanted to make sure.

[selecting the records by the heighest values]

I want to query the five heighest values in a coloum but the coloum is not the primarykey.

 

i.e: i have a coloum on the end of my table (articles) called views which get updated when ever an article is viewed by adding 1. On anther page i want to be able to view the 5 most viewed articles.

[Page view count]

Thanks man i shall get to work then 

[Page view count]

Alright guys i have an idea on what am going to do here, although i am unsure that it's the best way to go about it.

 

I am creating a blog and i need to count how many views an article gets in order to display the top 10 most viewed articles. Here is my plan...

 

1. Add an additional field to my blog posts table called viewed

2. On the view article page have an update method that adds one to the current number on the the coloum viewed

3. When displaying the 10 most viewed articles query it by the heightest number and limet to 5

[Couting how many records have the same id.]

Wow your a bell end!

[Couting how many records have the same id.]

Finally it works, thank you guys! hahaha sorry for the poor explanations!

[Couting how many records have the same id.]

Getting an error now.

 

this is my code

$a = mysql_query("SELECT COUNT(*) FROM blog_posts WHERE category_id = 1")or die(mysql_error());
$b = mysql_fetch_assoc($a);
echo $b['0'];

[Couting how many records have the same id.]

I tryied the first one and i kept getting "Resource id #7 " thats returned

 

i dont no how to put Pikachu's one in as i dont under stand it i want to specify a number my self to check you see

[Couting how many records have the same id.]

how many items share that category_id

[Couting how many records have the same id.]

Sorry man.

 

Table

id

title

body

category_id    <<<<< i want to see how many records in this coloum have the same value

date

[Couting how many records have the same id.]

I really dont have a clue about this right now. I need to be able to say how many records in this colum have the value of 2. then i need to get that number by it's self into a var.

[Couting how many records have the same id.]

I dont think you understand me. It doesnt matter how many tables are laid out i am only querying one table. I want to count the amount of rows that have the same category_id.

[Couting how many records have the same id.]

this is helpful fo course but it's not what am trying to do. I dont want to show the relation between two tables even though they are. All i want to do if to be able to count how many records have the same content.

 

for example if you have category_id which can have more then one record with the same id in. I want to be able to say how many records in the table have the same category id. Hope this makes sence

[Couting how many records have the same id.]

have you an exaplme with out the join?

[Couting how many records have the same id.]

Is there a php method/function that can count how many records in a table have the same id. For example you have two tables relating to one another there for there is reason for a coloum to have the same id as another.

[Check to see if a field is empty before continuing the script]

YES! I have it working at last . I cant thank you enough for you help this has been head fucking my head all night!

 

if(isset($_POST['sub'])){
     if (!empty($_FILES['image']['name'])) {

this is what i used in the end!

[Check to see if a field is empty before continuing the script]

It works fine but it's displaying the error on the initial loading of the page before anything has been submited

[Check to see if a field is empty before continuing the script]

Firstly I would like to thank you for that it did work, however i want to be able to provide an error when the file form is empty. It has canceled out the the class error but i don't how to apply a new one. Sorry if i am not making to much sense  here i am quite new at this.

[Check to see if a field is empty before continuing the script]

Yes. The form works fine it's just if i submit it with no file in the FILE form object then it uses a error handler from the class. I don't mind the actual error that the class creates but oddly enough everything else on my page vanishes. That's why i want it to be checked and handed in the view point before the class is included to prevent it generating an error.