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!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: benrob82
  • Order by date
  1. benrob82

    PHP MySQL insert

    I've read a number of threads to try and solve this problem, I have a query string link the one below $insert = "insert into accounts values ('$accountid',NOW(),'','','','website','$company_name','','Student: Student/Graduate Member','','$turnover','$tel3','$home_address1...
  2. benrob82

    Advanced Pagination

    Hi I have setup a nice little paging system to allow the page numbers to be displayed. The problem is I want to be able to show 10 pages at a time i.e. page 1.....10 then when page 2 is clicked it shows 2.....11 etc etc, does anyone know how to do this or is there a simple way I could add this...
  3. benrob82

    MySQL PHP Left join help!!

    I've tried on the mysql forum but no one seemed to have an answer with the PHP included so I thought I'd give it a try here. I'll give the second option a try.
  4. benrob82

    MySQL PHP Left join help!!

    Hi can anyone help me with this query $getcampaign = mysql_query("select * from prospect_list_campaigns"); while ($gotcampaign = mysql_fetch_row($getcampaign)) { $getprospect = mysql_query("select id,contact_id from prospect_lists_prospects where prospect_list_id = '$gotcampaign[2]'")...
  5. benrob82

    Left Join help!!

    Hi can anyone help me with this query $getcampaign = mysql_query("select * from prospect_list_campaigns"); while ($gotcampaign = mysql_fetch_row($getcampaign)) { $getprospect = mysql_query("select id,contact_id from prospect_lists_prospects where prospect_list_id = '$gotcampaign[2]'")...
  6. benrob82

    toggle with table

    hey thanks that worked great, think i need to start studying some javascript.
  7. benrob82

    toggle with table

    sorry I here is the code I need to be able to toggle a certain part of the table to hide certain search fields. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html> <head> <script type="text/javascript"> function toggle_box(id) { var identity =...
  8. benrob82

    toggle with table

    Hi I'm trying to use the toggle function inside of a table but it will not allow me to do this any ideas why?
  9. benrob82

    Passing sql query to another page

    i said thank you
  10. benrob82

    Passing sql query to another page

    thank you missed the obvious and it worked
  11. benrob82

    Passing sql query to another page

    no that doesnt seem to work
  12. benrob82

    Passing sql query to another page

    Hi I have created the following search script which works great. I need to be able to export the results of the search to a excel spreadsheet which I can do with normal pages but as this page brings up a lot of different results its not that straight forward. Does anyone know how I would pass...
  13. benrob82

    Javascript newbie question

    thanks for pointing me in the right direction, found a great article on this http://www.walterzorn.com/tooltip/tooltip_e.htm cheers
  14. benrob82

    Javascript newbie question

    hi, the image will display when the user mouses over the link and will appear at the point of the mouse
  15. benrob82

    Javascript newbie question

    Hi I want to be able to roll over a link but also display an image when the link is rolled over. does anyone know how to do this? thanks
  16. benrob82

    How to split a search term

    Hi, I need to be able to split a search terms and then use it to query the database. If i enter one search term it works fine but I when two are enetered it doesnt work. Do I use explode() or preg_match() can someone please help.
  17. benrob82

    substr() question

    hi I am trying to remove the last two digits from a postcode obviously this can be xxxx xxx or xxx xxx is the best way to remove the last two digits using substr() function and if so how do i do it to remove the last two digits? Thanks in advance
  18. benrob82

    Unknown reason for error

    Hi I'm getting the following error from a PHP page which updates MySQL database You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mailto:student@codeworksconnect.net">student@codeworksconnect.net " where id'...
  19. benrob82

    todays date plus 6 months

    Hi does anyone know how to get the result 6 months from today? thanks
  20. benrob82

    Auto email sent every 6 months

    thanks for your help but I have it sorted now.

Part and Inventory Search

Back
Top