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 Chriss Miller 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: BB101
  • Content: Threads
  • Order by date
  1. BB101

    Cookies

    Wasn't sure if this belonged here, in the javascript section or somewhere completely different, but you lot seem like a nice bunch, so here goes. I'm basically having the same problem as this chap: http://www.webhostingtalk.com/archive/thread/133249-1.html This problem is frustrating and...
  2. BB101

    Microphone not working

    I have a Sitecom modem, all seems to work fine, dials numbers, can hear the noise from the internal speaker and the headset, but I cannot send voice through the microphone. The mic is connected to the mic slot on the modem, next to the speaker one. Please help as I have run out of ideas...
  3. BB101

    Images within calculation fields

    Is it possible to insert an image into a calculation field? I'm having problems positioning the image as the text is fairly dynamic. Thanks in advance --BB
  4. BB101

    INSERT DELAYED, wheres the equivelent for UPDATE?

    I'm having fun doing a large scale UPDATE on a database table. I found I can do an INSERT DELAYED to do bulk inserts without blocking the apache thread, but there doesn't seem to be an equivelent for updating. Can anyone help? Thanks --BB
  5. BB101

    sending instant messages

    Im looking into sending messages via instant messangers, the common ones: MSN, ICQ, Yahoo, AOL. Does anyone know of a site that can show me how to do this? Google returns tripe when I try and search. Thanks in advance --BB
  6. BB101

    Problems sending emails

    I'm trying to send emails with Filemaker Pro 6 through outlook express 6, however, they are being bounced because they do not have a date in the header. The problem first became apparent when I unchecked the "Perform with no dialog" option in filemaker. Any help? --BB
  7. BB101

    Google index and adwords

    Interesting idea, I have a site with over 60k of pages and I'm desperate to get google round them as fast as possible. While museing I had a thought, google adwords deliver content specific adverts, this would imply google would have to spider the site before the adverts could be delivered. Is...
  8. BB101

    grouping and ordering

    SELECT q.q_id, q.user_id, IF (e.firstname IS NULL , q.name, e.firstname) AS name, t.town, e.type, e.trading_name, e.posts FROM qa_uk q LEFT JOIN ayn_experts e ON e.unique_id = q.user_id AND e.active = 1 LEFT JOIN ayn_towns t ON t.id = q.town_id WHERE q.active =1 AND t.town IS NOT NULL...
  9. BB101

    cartesian co-ordinates from a table

    got this: CREATE TABLE `dat_question` ( `q` int(11) NOT NULL auto_increment, `category_id` int(11) NOT NULL default '0', `user_id` int(11) default '0', `datetime` int(11) NOT NULL default '0', `x` int(11) NOT NULL default '0', `y` int(11) NOT NULL default '0', `x1` int(11)...
  10. BB101

    join lots of tables, optimisation problems

    I have a complex query that takes approx 1 second to run; this however, is not acceptable. Does anyone have any good resource sites or recommendations on how to optimised this query? I have indexes on all fields used in the joins/wheres/groups but I cant seem to get this below 1 second. Thanks...
  11. BB101

    Maximum String Length

    Im trying desperately to load data (6000-50000 records) into a select box, I have decided adding them in one at a time with new Option is just too slow so im compiling a large piece of HTML to use with outerHTML to re-render the entire select box at once. However, I seem to have a problem with...
  12. BB101

    low priority select

    I have an SQL query which takes around 2 seconds to run, it's part of an admin tool, and as such is not mission critical. Is there a way I can make these selects have a lower priority than the normal ones (i.e, the ones on the site). --BB
  13. BB101

    MySQL complex query optimisation

    I have a query which is taking 10 seconds to run with a relatively empty database. This is acceptable, but I expect it to take longer when there is more data. Dump of table structure: CREATE TABLE towns ( id int(11) NOT NULL auto_increment, town varchar(128) NOT NULL default '', area...
  14. BB101

    first form field problem

    I have a form, and this form has lots of fields, text, check and select boxes. This form normally posts fine and everything is great, but occasionally, a particular account will stop the first field on the form from being submitted with the rest of the data. Also, when I load the page, I have a...
  15. BB101

    Multiple queries at once

    I have a 2 part query which works fine when I paste it into phpMyAdmin, but when I go to use it in PHP, it error's after the semi-colon between the commands. Anyone? --BB
  16. BB101

    Multiple queries at once

    I have a 2 part query which works fine when I paste it into phpMyAdmin, but when I go to use it in PHP, it error's after the semi-colon between the commands. Anyone? --BB
  17. BB101

    counting from different tables

    I have a problem getting counts from 2 different tables, via joins from the parent table. At the moment, I am doing this: SELECT q.*, q.id as q_id, t.town, c.category, count(qa.id) AS answers FROM qq_local q LEFT JOIN qa_local qa ON q.id = qa.q_id AND qa.active = 1 LEFT JOIN...
  18. BB101

    Text Height with PHP

    I need to be able to get the height of some text in php dependant on font-family font-size and width, can anyone help? I don't really care if the height is in pixels or characters but it must be fast! The solution im trying to provide is this: I have two columns of text, data is pulled from a...
  19. BB101

    Resize a jpeg without GD or imagemagick

    Im doing some work for some people who have hosted web space. They want a the ability to resize jpegs, but unfortunatly their host doesn't support GD or Imagemagick. Anyone? --BB
  20. BB101

    PHP and MSSQL problem with query

    I am currently building a web application with PHP, MSSQL and a lot of javascript. I have a problem on one of my pages. The query: exec spCCH_ChapterAta_List 'Hercules01' Does not run in the PHP, no error is returned, just "Query failed", but it runs in query analyzer; however I can...

Part and Inventory Search

Back
Top