Search found 96 matches

by gjb79
Fri Apr 15, 2005 12:14 pm
Forum: PHP - Code
Topic: Question on speed/efficency
Replies: 4
Views: 871

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!
by gjb79
Fri Apr 15, 2005 9:56 am
Forum: PHP - Code
Topic: Question on speed/efficency
Replies: 4
Views: 871

Question on speed/efficency

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...
by gjb79
Thu Feb 24, 2005 9:59 pm
Forum: Databases
Topic: Odd behavior for tricky select sql query
Replies: 3
Views: 1289

Well....

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%...
by gjb79
Thu Feb 24, 2005 9:47 pm
Forum: Databases
Topic: Odd behavior for tricky select sql query
Replies: 3
Views: 1289

Odd behavior for tricky select sql query

:?: 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...
by gjb79
Mon Feb 21, 2005 12:18 pm
Forum: Databases
Topic: Search SQL by first letter
Replies: 5
Views: 2464

ok - SOLVED

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...
by gjb79
Mon Feb 21, 2005 11:59 am
Forum: Databases
Topic: Search SQL by first letter
Replies: 5
Views: 2464

THanks but...

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...
by gjb79
Mon Feb 21, 2005 9:34 am
Forum: Databases
Topic: Search SQL by first letter
Replies: 5
Views: 2464

Search SQL by first letter

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 `...
by gjb79
Tue Jan 25, 2005 3:08 pm
Forum: PHP - Code
Topic: Limiting Characters in a Text String
Replies: 3
Views: 859

Brilliant!

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?

:D
by gjb79
Tue Jan 25, 2005 2:56 pm
Forum: PHP - Code
Topic: Limiting Characters in a Text String
Replies: 3
Views: 859

Limiting Characters in a Text String

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...
by gjb79
Wed Jan 19, 2005 3:17 pm
Forum: Databases
Topic: Database Query Problem with Sorting.
Replies: 15
Views: 2745

Finally Solved

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...
by gjb79
Wed Jan 19, 2005 2:42 pm
Forum: Databases
Topic: Database Query Problem with Sorting.
Replies: 15
Views: 2745

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...
by gjb79
Wed Jan 19, 2005 2:28 pm
Forum: Databases
Topic: Database Query Problem with Sorting.
Replies: 15
Views: 2745

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...
by gjb79
Wed Jan 19, 2005 2:12 pm
Forum: Databases
Topic: Database Query Problem with Sorting.
Replies: 15
Views: 2745

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 ...
by gjb79
Wed Jan 19, 2005 1:56 pm
Forum: Databases
Topic: Database Query Problem with Sorting.
Replies: 15
Views: 2745

SOLVED

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...
by gjb79
Wed Jan 19, 2005 1:46 pm
Forum: Databases
Topic: Database Query Problem with Sorting.
Replies: 15
Views: 2745

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