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: ERuiz
- Order by date
-
-
How to execute this query?
Ok, DRJ478, I played around a bit and got this query working na displaying only the user with the highest profile_current_hours, using the ORDER BY command and LIMIT 1 to display just the top user. $query="SELECT * FROM `smf_members` AS a LEFT JOIN smf_themes AS b ON a.id_member =... -
How to execute this query?
Ditto! Worked perfectly! And believe me, DRJ478, I am a quick learner. Just need a few examples of how to get things accomplished, and I figure out how to build on that. :-) But prepare, as I need yet another query! -
How to execute this query?
Ahhhhhh I see. :-) I didn't know that! hahahah Gonna give it a try now. -
How to execute this query?
Thanks for your help, and believe me, even though I have no programming knowledge, I enjoy trying to learn little by little. Nonetheless, here is my next try at it but it still won't give me a result. $query="SELECT count(a.id_member) FROM `smf_themes` AS a LEFT JOIN smf_themes AS b LEFT... -
How to execute this query?
DRJ478, using the code I posted above, it will not display a result. I think it's missing something in the ON a.id_member = b.id_member part. Have no idea what to do. -
How to execute this query?
Like this? SELECT count(a.id_member) FROM `smf_themes` AS a LEFT JOIN smf_themes AS b LEFT JOIN smf_themes AS c ON a.id_member = b.id_member WHERE a.variable='profile_domicile' AND a.value='KMIA' AND b.variable='profile_division' AND b.value='APR' AND c.variable='profile_rank' AND... -
How to execute this query?
To make it a bit clearer, now I need the query to give me the total amount of users that have profile_domicile = KMIA profile_division = APR profile_rank = Trainee Hope this is a bit clearer. -
How to execute this query?
Ok, I have yet another question! Using the query supplied by DRJ478: SELECT count(a.id_member) FROM `smf_themes` AS a LEFT JOIN smf_themes AS b ON a.id_member = b.id_member WHERE a.variable='profile_domicile' AND a.value='KMIA' AND b.variable='profile_division' AND b.value='APR' How would... -
How to execute this query?
DRJ478, your query WORKED LIKE A CHARM!!! WOW! I thought it would never be accomplished! I must say that this forum is simply INCREDIBLE! I have had a couple of problems resolved here where they were not been able to anywhere else. Amazing. Thanks a million to you and EVERYONE who chipped in... -
How to execute this query?
karver, what I meant by saying that the result would be 1, I was referring to the piece of code I posted here. I didn't want to post here all 700+ rows that this table has. -
How to execute this query?
ok, I will try it out in a couple of hours when I get home. :-) Thanks! -
How to execute this query?
Hi DRJ478, That is exactly what I desperately need. Here is the info you requested: PHP 4.4.1 MySQL 4.1.13 thanks for your help, my friend. I'm on my Treo 650, so I will be monitoring this on the road! :-) Gotta love these cel phones! hahahah -
How to execute this query?
Ok, that query is not giving the result I am looking for. The problem is the way the database fields are arranged, it makes it extremely difficult to perform these queries. Intead of recored being arranges by rows, they are arranaged by columns... it's as if you take a regular database and... -
How to execute this query?
Ok, tried that and still returns "0". Here is a small sample of table along with some data, so you can perhaps check it out and see how it would be best to accomplish what I am trying to do. CREATE TABLE `smf_themes` ( `ID_MEMBER` mediumint(8) NOT NULL default '0', `ID_THEME` tinyint(4)... -
How to execute this query?
I am trying to ececute this query on a php file but just can't get it to work. I'm a newbie, so please don't laugh at my attempt! hahahahaha What I need is to get the total amount of fields from a table named JOS_THEMES, where VARIABLE = PROFILE_DOMICILE and VALUE = KMIA and VARIABLE =... -
How can I send an email using input from form?
Nop, the above didn't work. The echo returns empty values. -
How can I send an email using input from form?
I have a question. Can the form be made so that it sends the info to the page as it is right now AND send the info to a SECOND page? I would put the code on this second file and have the form page submit the data to this second file. In other words, can the form be sent to 2 different files at... -
How can I send an email using input from form?
Ok, so that means there is no way to get this done from the form page itself? I will paste the code on the other page like you stated. Thanks! -
