Web Hosting Talk : Web Hosting Main Forums : Programming Discussion : Mysql Problem: How to only view some text of a file

[Barti1987]

just like some news.

they only show you a little start and then you will have to click here to get all the text..

on more thing, the selct based on the date is not working..

i made this query:

SELECT * FROM news WHERE `group_id`='1' AND `start` >= '2004-06-03' AND `stop` <= '2004-06-03' AND `status`='Active'

I have 2 fileds like this:

1 - 1 - New Airplanes Inventory! We just recireved a great new airplanes from amana... - 2004-06-01 - 2005-06-03  - Active 
2 - 1 - the Other Sample Inventory We just recireved a great new airplanes from amana... - 2004-06-13 - 2005-06-13 - Active

The - separates each field...

first date is the start, the seoncd is the date, all fields are in date format xxxx-xx-xx

thnx for any help

peace,

[Barti1987]

Lol....

I should always think before doing soemthine

I did this :p

PHP Code:

$all_length = strlen($get_news_line[3]);
$half_length = ceil($all_length / 2);
$new_show = explode(' ',$get_news_line[3]);

$the_len = 0;
$i = 0;

while($the_len < $half_length){
        echo $new_show[$i] . ' ';
        $the_len = $the_len + strlen($new_show[$i]);
        $i++;
} 


was I slick :p

[Barti1987]

But hay guys..

im still having problem on the date thing??

I cant keep on getting them between those dates

tnx

[w3needs]

At first glance, it looks like your query is not looking for ayear ahead. Instead, it is still listed as '2004', not 2005.

I personally use a unix timestamp for easier alts later on. Then, I slip it into a formatting function. For php, I use mktime() to store the timestamp, then date("Y-M-d",$stored_time) for retrieval...jsut a little extra that I'm sure you are aware of.

But, like I said, it looks like your year is a little off.

Also, I usually do this for my concatated strings...

PHP Code:

$maxlength = 255;
$short_str = substr($string,0,$maxlength);
$string = $short_str ."..."; 


You could also...

PHP Code:

$string = substr($str,0,255) . "..."; 


I would also throw in checcks to see how long the news items is compared to what you want the max length of the news item to be displayed in the preview state.

Anyhow, babbling right now. We just got back from a graduation of my brother's and everyone is still rev'ved!

Later, and I hope something in post helps!

Night,
Jim

[Barti1987]

Originally posted by w3needs
At first glance, it looks like your query is not looking for ayear ahead. Instead, it is still listed as '2004', not 2005.

I personally use a unix timestamp for easier alts later on. Then, I slip it into a formatting function. For php, I use mktime() to store the timestamp, then date("Y-M-d",$stored_time) for retrieval...jsut a little extra that I'm sure you are aware of.

But, like I said, it looks like your year is a little off.

Also, I usually do this for my concatated strings...

PHP Code:

$maxlength = 255;
$short_str = substr($string,0,$maxlength);
$string = $short_str ."..."; 


You could also...

PHP Code:

$string = substr($str,0,255) . "..."; 


I would also throw in checcks to see how long the news items is compared to what you want the max length of the news item to be displayed in the preview state.

Anyhow, babbling right now. We just got back from a graduation of my brother's and everyone is still rev'ved!

Later, and I hope something in post helps!

Night,
Jim

Hay thank you for answering..

It did work....

Thanks alot..

About the unix time stamp I will try to get into it more details hopefully on my next project..

I just started with this date, man I use to use varchar to hold off date (it use to be hell amount of work)

I seem to be evolving to the best thou..

Thanks again, I am going home will look into what you said in more detalis tommorow..

Also say happy graduation to your brother, hope you guys have a great time

Peace,