can this be done?

supafly · 12-07-2005

I'm redoing one of my websites as the layout bores me to death! But anyway I have a blog in www.crazymofo.info/blog i use wordpress for it is their a way by php that I can show half of the first post that changes when I post another and stuff

(sorry to be a pain but I just thought it would be a good idea and I hope you get what I mean as well)

ParaSnake · 12-07-2005

Quote:

that I can show half of the first post that changes when I post another

no no,i spent 5 minutes reading and still cannot get it,pls explain it again,sorry for my terrible E.skill ><

And for the ideas,you arer doing with string,check it here,the hero of every PHP coder

[ http://www.php.net/manual/en/ref.strings.php ]

supafly · 12-07-2005

Quote:

Originally Posted by ParaSnake

no no,i spent 5 minutes reading and still cannot get it,pls explain it again,sorry for my terrible E.skill ><

And for the ideas,you arer doing with string,check it here,the hero of every PHP coder

[ http://www.php.net/manual/en/ref.strings.php ]

well on wordpress you write something and press submit and it shows on the page well I just wanted to show like the top one

is that any better haha

scrowler · 12-07-2005

Quote:

Originally Posted by supafly

is their a way by php that I can show half of the first post

PHP Code:


			
<?php

$str = "your news article here...";

$length = strlen($str);

$cut_string = substr( $str, 0, round($length / 2) );

# $cut_string is half of $str

?>

reference:
strlen() - gets length of a string
substr() - returns part of a string according to start and length arguments
round() - rounds to the nth degree if given, otherwise the nearest whole number

supafly · 12-07-2005

hmm but how do i show the first artical on a diffrent page like my main index

hehe if i'm asking to much please tell me lol

scrowler · 12-08-2005

PHP Code:


			
<?php

$query = mysql_query("SELECT * FROM NewsTable LIMIT 1");

?>

?

ParaSnake · 12-08-2005

I`ve downloaded WordPress to see what you meant from the beginning of this thread lolz

supafly · 12-08-2005

hmm i dunno i'll give it a try Scrowler thanks for the help guys!

ParaSnake · 12-08-2005

Well,i`ve installed and running WordPress on my localhost,and here may this help you :
In my opinion,you want to display your newest entry of the blog to anywhere you want?so...

PHP Code:


			
//first,connect to mySQL using info stored in wp-config.php

$a = mysql_query("SELECT * FROM wp_posts WHERE ID = MAX(ID)") or die(mysql_error());

$b = mysql_fetch_assoc($b);

if the above query wont work,pls play around with "SELECT MAX(ID) FROM wp_posts".I`m going to sleep rite now,sorry if this doesnt help you

supafly · 12-08-2005

oooooh i'll give it a go thanks for the help you guys love you hehe

[edit] when using that ParaSnake i get Invalid use of group function and since I don't know anything really about php and mysql I don't know how to fix it

ParaSnake · 12-13-2005

ehhh,sorry to let you wait for 4 days,i was too busy at school that i forget this lolz

Here what i`ve tested,it works very well...

PHP Code:


			
//Connect to database

mysql_connect("localhost","username","password")or die(mysql_error());

mysql_select_db("wordpress");



//The currently max ID in ur database means your newest post

$a = mysql_query("SELECT MAX(ID) FROM wp_posts") or die(mysql_error());

$b = mysql_fetch_assoc($a);

$maxID = $b['MAX(ID)'];



$a = mysql_query("SELECT * FROM wp_posts WHERE ID ='".$maxID."' ") or die(mysql_error());

$b = mysql_fetch_assoc($a);



$date    = $b['post_date'];

$content = $b['post_content'];

$title   = $b['post_title'];

What you have to do is to echo the date,content and title anywhere you want,and it will output the nweest entry in ur blog.Hope it matched ur idea

scrowler · 12-14-2005

or shorter yet, to select the latest entry only:

PHP Code:


			
<?php

mysql_connect("localhost","username","password")or die(mysql_error());
mysql_select_db("wordpress"); 

$a = mysql_query("SELECT * FROM wp_posts ORDER BY ID DESC LIMIT 1");
$b = mysql_fetch_assoc($a);

$date    = $b['post_date'];
$content = $b['post_content'];
$title   = $b['post_title'];

?>

thus cutting down the need to run 2 seperate queries

ParaSnake · 12-15-2005

hey thats kool bro

supafly · 12-15-2005

thank you one and all it's now working and online w00ty

pipersdragon · 12-29-2005

sorry for semi-offtopic post, but I use grey matter and, Couldnt you just type part of the entry in the regular and then finish it in the extended entry box? then again, I dont know if word press supports this