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 Wanet Telecoms Ltd 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

    ...simple way I could add this to my code below. $page = (!isset($_GET['page']))? 1 : $_GET['page']; $prev = ($page - 1); $next = ($page + 1); /* Max results per page */ $max_results = 10; /* Calculate the offset */ $from = (($page * $max_results) - $max_results); $getresults =...
  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

    ..."$row[1] $row[2]"; $resemail = $row[3]; $company = $row[4]; $ismember=""; $buttonname = "Add"; ##get contact name $sql2 = "select * from $sugardb.MAILAPP_groupxref where contact = '$contactid' and groupid = '$groupid'"; $result2 = mysql_query( $sql2); echo mysql_error()...
  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