Search results for query: *

thanks a million code works great

I am running Mandrake linux and I have libcurl2-7.10.3 installed on it. I want to use the curl functions to read a html file from the web into a string. I currently have this #include <stdio.h> #include <curl/curl.h> int main(void) { CURL *curl; CURLcode res; curl =...

i installed mysql using an rpm for the client and server but i cant find where everything is installed to in the documentation it keeps telling me to go to the installation directory and go to the scripts folder and run various scripts i did a file search and i cant find it. Im running...

Ok it looks like i found my problem apparently when i uninstalled apache previously it left some shell scripts in my sbin.

I am running mandrake 9.1 and have apache 2 installed. I modified the config files and tried to start it with apachectl but it wouldnt start. I then tried to start it with ./httpd and it looks like its running because i can access htdocs through my web browser at 0.0.0.0:80 However when i...

Well i decided to just store the row's info into another variable. Using data_seek is just too darn inefficent. upon looking at the C code it will go to the start of the linked list and then move through it. So if im at row 10,000 to go back one would take at least 9999 iterations

I want to set back the internal result pointer from a mysql_query by one. I looked at the code behind mysql_data_seek and it seems that when you do a select in a mysql_query it returns a linked list of some sort. when you call mysql_data_seek it traverses the linked list x times where x is the...

Never mind i was mistaken. INNER JOINS work fine The post i have above uses indexs efficently.

Ok i am very close to resolving this, I did an EXPLAIN on the query above and found that the index was only applying to 1 column which is why my join speed was so slow. The index is on the left-side of the table and is set to primary. I changed the above query to do RIGHT JOINS instead of...

Sorry for posting in the wrong forum. I figured a way to do it with out subquerys. SELECT * FROM post_table t1 INNER JOIN post_table t2 ON (t1.post=t2.post) INNER JOIN post_table t3 ON (t2.post=t3.post) WHERE t1.index BETWEEN 294 AND 1318 AND t2.index BETWEEN 2210 AND 3379 AND t3.index...

Also I think my host uses mysql 4.0.1 which is a version before subquery support is there a way to do it without subquerys?

there are two tables. The first has precaculated ranges in 2 columns min and max. These ranges are used for selects on the second table. The second table has 2 columns index and post. index being the unique identifier and post being the numerical data. The example you gave me pretty much...

Ok let me start with what i have so far, I am using a self join but the way i am accomplishing this is innefficient in both space and operation time. I generate sql code with php 'SELECT * FROM post_table t1,post_table t2 WHERE t1.post = t2.post AND t1.index <='.$max1.' AND t1.index >=...

Ok first of i would like to do this with out a temporary table but if thats the only way then i'll survive. I have single column table of integers. I want to compare one part of the column with a different part and return every match that it has in common. So lets say i have the column 1 3 6...