Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
tree navigation
Hi there i have a tree structure navigation for a web site i am building, each page has an id, a parent_id and name. i am looking for a way given one name that i can get the tree to the root page. a simple excample will help me explane better. page table id | parent_id | name 1... -
Cleaning up my database
Hi I am taking over a simple website database that has pages. Each page has a parent_id. I have just looked at the database table and it has thousands of entrys. I looked into it a little and basically when a page was being deleted its children were not getting deleted. I would like to clean... -
Previous / Next for alphabetical order
Hi I would like to get the next and previous records when i am ordering alphabetically. So i have the following id name 1 john 2 simon 3 luke I am on the record luke and i want to get the next one and the previous one in alphabetical order. So my sql query would give me back... -
syntax error
Hi i am getting a syntax error from this can anyone tell me where i am going wrong. Thanks in advance. syntax error var regexS = "[\\?&]"+name+"=([^&#]*)";- letimati
- Thread
- Replies: 3
- Forum: Javascript
-
format search results.
Hi I want to format the way I output search results by showing the string query inside <em></em> tags and cut it so shows this in the middle of 20 characters. So if i have $text = "this is the test text i have but i dont want to output it all so just want to output the important part of the... -
object and vars trace
Hi I am wondering if it is possible to output the objects used at the end of a page? SO id somehwere i declared $newsObj = new news; I could say print objects_used(); and it would print out 'news' Also is there other debug functions that would let me see what files are were included or... -
Search on multiple fields.
Is there a easy way to search on different fields for a entry of a text string. So if i had one table product that had name, code, description and I had a search string 'something' would i have to do select * from product where name = '%something%' OR code = '%something%' OR description =... -
explode <p>somtihng</p> into array
Hi I have a variable for content of a website i have and i want to break up the text into paragraphys in an array. So I have $content = '<p>text 1</p><p>text 2</p><p>text 3</p>'; and i want this $contentArray = array(1=>'<p>text 1</p>', 2=> '<p>text 2</p>', 3=><p>text 3</p>); I guess the... -
page names with child
Hi I am wanting to get one record from a table on the condition of two variables but there is a chance the two conditions will be met so i want to give one preference over the other, sorry that has not explaned it well. Example to help. I have a module table which has pages and parent/children... -
help with a select
Hi I have a table with peoples names in it like so. table name -------- John Smith Adam J Simpson Simon Alex 3rd of kingdom 2 Smith I want to select all the rows where the last word starts with 'S' i.e. an alphabet search on the last name. I was trying to use somthing like WHERE name REGEXP... -
ignoring html tags in ORDER BY
Hi I have a content table with text in it and i want to order the query by the first letter of the content. Problem is there are some html tags in the content. Is there a way I can ignore the html tags? thanks -
searching text starting with 'the '
Hi I am sure this is a common thing and got a simple answer but its friday and i am clearly not got the brain power for it today. I am wanting to do a alphabet search on a table but exclude the starting 'the '; so say i have entrys like this. name 'the world' 'transworld' So I have this...
