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 dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by solepixel

  1. solepixel

    New to CGI: Couple of questions

    Wow thank you so much for helping me with this information. thanks for being so detailed in your response. I will check out the UNIX and web server forums to hopefully come up with a solution to my situation.
  2. solepixel

    New to CGI: Couple of questions

    Hi. I am new to CGI and am just starting out trying a few things. I am a PHP/MySQL developer and am comfortable writing XHTML, XML, CSS, JavaScript, and ASP.NET VB. I know pretty much nothing of CGI and would like to learn a bit more. Here are a couple of questions I have to start out with: In...
  3. solepixel

    Help extracting section of text

    Ok. I was doing something wrong (as usual). Let me know if you ever try to get the pre_match version working. honestly, though, I wouldn't worry about it, this way works fine. Thanks again.
  4. solepixel

    Help extracting section of text

    ok, one last question about this topic. Would a comma (,) cause this to fail for some reason? I've tried searching for lastname, firstname and get weird results. Does this need to be modified to allow for a comma?
  5. solepixel

    Better Highlight Function

    Rock n Roll! That is awesome. Thanks jpadie! Way to go!
  6. solepixel

    Better Highlight Function

    ok, wow, i did try this all by itself and it seemed to work great. what am I doing wrong? maybe the needle/haystack are opposite in your function as they are mine. lemme check that.
  7. solepixel

    Better Highlight Function

    Hey, i got a chance to try this out today. It seems to replace all the text in the haystack with the needle.
  8. solepixel

    Best way to join table

    I just reversed the relationship. Now each domain has a referenced client_id.
  9. solepixel

    Best way to join table

    Ok, what I ended up doing is referencing the client_id from the client_list table as a column in the client_domain table. Now I guess my question is, how do I setup a query to display: all rows in the client_list table all rows in the client_domain table client_list connects to client_company...
  10. solepixel

    Best way to join table

    I think the client_list table serves as a "middle man". The only column which holds multiple values is client_dom (in the client_list table). The client_list table connects to the client_company table via client_comp field. That only holds 1 value, the PK of the corresponding row in the...
  11. solepixel

    Best way to join table

    Here are the 3 tables I'm trying to "Mash up" into 1 display result CREATE TABLE `client_company` ( `comp_id` varchar(25) NOT NULL default '', `comp_name` varchar(255) default NULL, `comp_addr` varchar(255) default NULL, `comp_phone` varchar(25) default NULL, `comp_city` varchar(255)...
  12. solepixel

    Best way to join table

    Can you suggest an alternate design? I'm completely willing to modify this.
  13. solepixel

    Best way to join table

    I have a query where I'm trying to match 1 table's primary key to field in another table that holds multiple entries. For example, the field may have 1 value in it, and allows this to work:LEFT JOIN client_list ON client_domain.dom_id = client_list.client_dom however sometimes the field has...
  14. solepixel

    Better Highlight Function

    yes, but in addition, all individual words. so if the needle has a space, then explode it and highlight all occurances of each individual word. But I think the entire phrase should be done first, so the words don't look broken up.
  15. solepixel

    Better Highlight Function

    Can someone take a look at this highlight function? It works pretty good, but I'd like to know how to tweak it so that it: 1. highlights an entire phrase (it already does this) 2. highlights each individual word 3. does not mess up words inside <html> tags function...

Part and Inventory Search

Back
Top