PHP Developers Network

Thanks for the advice!

Its kinda what I thought, but I'm some what new at areas of this as I've had no formal training, so I learn in patches and often miss bits of info.

Thanks again!

I'm not sure if this should go under PHP Theory, but as that says advanced only and I'm sure this is far from advanced, I'll put it here. :arrow: I have the option of making a series of pages dynamically generated from one file, content from an sql database. Or I could split it to several pages each...

Ahh Ofcourse!!! Thank you both so very much! I wonder why, after spending hours looking through code for mistakes, it always ends up being something simple. :lol: Solution mysql_select_db($database_lexicon, $lexicon); $query_Characters = "SELECT * FROM `character` WHERE (CNameL like '$LetterID%...

:?: I have a script that demands a bit of filtering from an sql database. $GBookID = $HTTP_GET_VARSї'GBookID']; $GChapterID = $HTTP_GET_VARSї'GChapterID']; $LetterID = $HTTP_GET_VARSї'LetterID']; mysql_select_db($database_lexicon, $lexicon); $query_Characters = "SE...

Ok, well that works, Odd, I tried what you suggested, then I plugged it in as the following: $query_Characters = "SELECT * FROM `character` WHERE CNameL like '$LetterID%' AND (BookID < '$GBookID') OR (BookID = '$GBookID' AND ChapterID <= '$GChapterID') ORDER BY `CNameL` ASC"; And everythin...

Hey thanks for the quick reply, I tried this and did not get any change. it is still displaying all the entries from the database rather than only the ones beginning with the letter I enter. mysql_select_db($database_lexicon, $lexicon); $query_Characters = "SELECT * FROM `character` WHERE (Book...

Hi, I'm not very familure with splitting text strings, and though I have searched all over for a solution, I cannot seem to find one to fit what I am attempting. I have a my_sql search query that looks like this: mysql_select_db($database_lexicon, $lexicon); $query_Characters = "SELECT * FROM `...

Excellent. I didn't know about substr and I couldn't figure out what cutting characters short might be called to look it up.

What I can't find is a way to add "..." at the end of only the characters cut short. Any ideas?

Hi, I'm wondering, is there any easy way to limit the amount of characters that display in a text string and add ... at the end? example: I went to the store today I went to the stor... How it will be used: I have an array, built from a database, that is being used to fill a drop down menu. The menu...

Ofcourse! Thanks a lot Jam! Dunno how I missed that. I have been rather brain dead today. For anyone wondering, the WHERE (CharID = '$GCharID' AND BookID < '$GBookID') or (BookID = '$GBookID' AND ChapterID <= '$GChapterID') is correct, It groups the search character with the previous books then adds...

Heres the entire Loop. Ignore the If Statements, Needed to convert the Book Numbers to Abreviations. <?php $GCharID = $row_Characters&#1111;'ID']; mysql_select_db($database_lexicon, $lexicon); $query_Descriptions = "SELECT * FROM description WHERE (CharID = '$GCharID') AND (BookID < '$GBook...

Almost forgot. The weirdness: With details, it seems to work alright for the first person, displaying the details according to the book/chapter variables. The next character down however doesn't have any of his/her details displayed, insted it displays the last detail of the first character. Every c...

Jam - I am creating a read along guide to a series of books. The characters in the books are loaded into a database along with the book number and chapter number they appear in. This way when a reader visits the page they input which book they're on and which chapter they've read up to. The webpage ...

Yeah I have PHP 4 installed. Thanks again! I have two other areas I need to apply this bit of code to to make sure that the correct information from those tables is filtered correctly. When I try I get a big slowdown from the server and the page is showing up oddly. Such as the page is displaying bu...

JAM
Thanks for the advice, I tested that out and it seems to be working. The characters that dissapeared when they should have been there no longer dissapears!

Thanks a lot!


Thanks