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 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!
-
WHERE field = XXX vs WHERE field != XXX : Performance the same?
Hi everyone, is there any performance difference btw the following WHERE criteria. WHERE abcfield = 'XXXX' vs WHERE abcfield <> 'XXXX' A)There are same number of records that for each of the above criteria B) abcfield is indexed. This has been puzzling me. At first i thought that WHERE... -
Google Maps API: How to grab the domain of the html that loads script
Hi everyone, in order to insert a Googlemap into my php script, I have to insert the following <script> </script> from google. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head>...- jpo245
- Thread
- Replies: 1
- Forum: Javascript
-
Possible to restrict usage of an RSS FEED?
Hi, im planning to allow certain users to use some of my rss feeds on their blogs (blogger.com), they'll be inserting it in via feed2js. My question: Is it possible to restrict the users who do this? I don't want just ANYONE to be able to publish my feeds, only those that i allow to. I was... -
Form contains AJAX inserted values: How to POST??
Hi everyone, I have 2 Select Boxes (Select A, and Select B) in a form. Depending on what option the user selects in A, Select B is then populated via ajax. Now my problem is that because the options in B are dynamically inserted via AJAX, the form doesnt seem to detect those values, and doesnt...- jpo245
- Thread
- Replies: 1
- Forum: Javascript
-
How does browser know if its XML or not?
Kindly take a look at these 2 docs: http://openrico.org/rico/getPersonInfo.do?firstName=Pat&lastName=Barnes http://niftis.rathernifty.com/niftis/getPersonInfo.do?firstName=Pat&lastName=Barnes Why is one viewed as an XML doc, while the other is not? This is puzzling me... And my code can't... -
AJAX: Filling a select box with response text: Problem! Help?
Hi there everyone, just started fiddling around with AJAX. Am using ajaxtoolbox. Two files: testajax.php [contains a selectbox with ID: TESTCOMBO <select id="testcombo" size="10"> <option value='nothinghereyet'>nothing here yet</option> </select> options.php [file that ajax "GETS"] <option...- jpo245
- Thread
- Replies: 2
- Forum: Javascript
-
Spent 8 hours.. works in FF, not in IE.
Im new to CSS, and designed a page from scratch. http://old.rathernifty.com/nustyle.html In FF, it looks reasonable, with the exception of the little tiled boxes on the lower half of the screen. How does one put a really long word inside with out it spilling out of the box? In IE, it looks...- jpo245
- Thread
- Replies: 2
- Forum: HTML, XHTML & CSS
-
Bookmarklet: adds top frame to current page (w/o reload)
Hi everyone, been puzzling over this for awhile. Is there anyway i can click a bookmarklet, that dynamically adds a banner style top frame that slides out over the current page I am viewing. I hope to be able to do this, WITHOUT reloading the current page I am viewing. So for example...- jpo245
- Thread
- Replies: 12
- Forum: Javascript
-
Union woes.....
Hi there, I'm having problems with this slightly more complex union query. 1. Users can be members of groups (via usergroupmap mapping table) 2. Groups can have zero users. 3. Users can be members of zero groups. I'd like a record set that displays the follwing: |groupname|username|... -
DISTINCT + Order By together = slow query
Hi everyone, I have a table that has about 500000 rows. Ok so there is a ITEM table and a TAG table, and an ITEM-TAG mapping table. Tags and Items have an M:N relationship. My Problem right now: When i do a select item.id, item.name, item.owner, item.datecreated, from the tables, it is... -
1 index Per table per query = SLOW QUERY!! Pls help
Hi everyone I have a query on 4 tables (via various joins). MYSQL automatically uses uses primary keys for the joins, so that part is superb. So for example, TABLE A uses A.id primary key as index for the join. However, because of this, if I do an ORDER BY DATE on table A, MYSQL resorts to... -
Universal getDATA() function that allows input of unlimited WHERE case
Hi everyone, I have a database with about 18 related tables, and i realize that I will be retrieving data with a LOT of different where statements. For example, initially i was thinking of programming separate functions that retrieve data specifically according to hard coded SQL "WHERE" i put... -
Optimisation: One LARGE query with many joins, or many single queries
Hi, I'm starting to write functions that return data from my db. Im wondering in general if its faster to: 1. have a single query to retrieve all data once, with multiple joins to 5 tables, and then display data. 2. have multiple queries, each of which only grab data from a single table each... -
any good WORKING scheme editor/updater?
Hi everyone, So i designed my first database (~15 tables, many many many relationships). Was working fine, but decided to fine tune it a bit, normalize it a bit more, rename all the table/field names to more meaningful ones etc. Is there any GOOD software that is able to extract the current... -
while($row=mysql_fetch_array($result)): Peek into next iteration?
I have a page that displays results from a query in a grouped manner. In my instance, the query returns a list of members in some clubs. I have the results "Grouped" according to the club, so it a single Table Header for a club, and then the rows below that table header are its members. A new... -
Code to display results "grouped" by a certain field?
I have tables: Users UserSubscriptions Mailing Lists. I hope to display in a html table all the Mailing lists that each user subscribes to. I would like a new header for each user, and with all the subcriptions listed below the header. Does anyone know of the most efficient way to accomplish... -
Best editor to print PHP code?
Hi there, im looking for an editor that allows me to print (color coded too!) my php code in customizable font size. right now, i can print in color, but the code is always in that ugly courier font (too large a size!!) which wraps and makes it super hard to read. i hope to print everything... -
MYSQL query editor, whats with the single quotes?
Hi, I'm having problems with single quotes that are output by my graphical query editor. This code WORKS: $query= "SELECT userlevelid, userlevelname FROM userlevel"; $result=mysql_query($query,$connect) or die(mysql_error()); while($row=mysql_fetch_array($result)) {... -
Best design for Hierachical User Subscription to manydifferent things?
Hi everyone, I have a db design issue im hoping someone could give me advice on. Currently: Message system allows users to "subscribe" to messages that other users submit. So User1 can subscribe to User2's submitted messages. These messages will appear in User1's inbox. Groups also exist... -
Extracting query string based on URL directory string?
Hi everyone, I've been puzzling over this, and can't seem to find the correct key words to do a search on google for answers. Basically, how do i extract query string based on a "Directory" that a user types in the URL? For example, if the user types in: http://mysite.com/php+editor I want my...
