Go Back   CodingForums.com > Search Forums
Reload this Page Search Results

Before you post, read our: Rules & Posting Guidelines

Showing results 1 to 15 of 15
Search took 0.25 seconds. Search: Posts Made By: Mike1963
Forum: MySQL 12-12-2012, 04:40 PM
Replies: 8
Views: 828
Posted By Mike1963
got it all figured out including the company_name...

got it all figured out including the company_name in the drop down box. TY so very much for your help!
Forum: MySQL 12-12-2012, 03:55 PM
Replies: 8
Views: 828
Posted By Mike1963
when i tried that earlier it wouldnt give any...

when i tried that earlier it wouldnt give any results but just tried it again and now it works!! ty so much, now to figure out how to get the company_name to show up in a drop down. lol always...
Forum: MySQL 12-12-2012, 03:31 PM
Replies: 8
Views: 828
Posted By Mike1963
when i use c1.company_id or the * i get either...

when i use c1.company_id or the * i get either ALL the id`s from the company table or ALL the id`s that do match. this is using either the LEFT JOIN or RIGHT JOIN, doesnt matter which one i use. i...
Forum: MySQL 12-12-2012, 04:34 AM
Replies: 8
Views: 828
Posted By Mike1963
all i`m wanting is the company_id`s in the...

all i`m wanting is the company_id`s in the company table that dont match the messages table
Forum: MySQL 12-12-2012, 02:38 AM
Replies: 8
Views: 828
Posted By Mike1963
compare 2 db tables

hi everyone, i am trying to compare 2 tables and return the difference, i can join the tables (no problem there), but can`t get the difference in the 2. to clarify my problem, table1 has company_id...
Forum: MySQL 10-17-2012, 02:21 PM
Replies: 8
Views: 594
Posted By Mike1963
thank you both for the input, you both eased my...

thank you both for the input, you both eased my mind about the size of the table.
Forum: MySQL 10-16-2012, 07:49 PM
Replies: 8
Views: 594
Posted By Mike1963
what i`m thinking is say the 2500 members login...

what i`m thinking is say the 2500 members login 100 times each, that makes the login table 250,000 rows. Thats a pretty big table don`t you think?
Forum: MySQL 10-16-2012, 05:31 PM
Replies: 8
Views: 594
Posted By Mike1963
the problem with that is theres well over 2500...

the problem with that is theres well over 2500 members, would create a huge db
Forum: MySQL 10-16-2012, 05:05 PM
Replies: 8
Views: 594
Posted By Mike1963
unique visits

I have a customer who wants to view how many times members log in between different dates.

Is there any way to count how many times a member logs in within a certain time frame without making a...
Forum: MySQL 09-24-2012, 08:28 PM
Replies: 0
Views: 311
Posted By Mike1963
double data insertion

Hi guys (and gals),

i am having a very strange problem with an insertion query in wordpress, i am trying to track how many times members click on links from a certain page but every time a link is...
Forum: MySQL 05-17-2012, 02:46 PM
Replies: 8
Views: 493
Posted By Mike1963
prepopulating checkboxes

I am trying to prepopulate some checkboxes from two tables, the first one holds the already chosen items, the second holds ALL existing items available. Now, the first tables items consist of values...
Forum: MySQL 05-19-2011, 02:07 PM
Replies: 6
Views: 1,264
Posted By Mike1963
so from what i`m gathering is theres no way to...

so from what i`m gathering is theres no way to join several different tables unless theres a common field?
Forum: MySQL 05-16-2011, 07:33 PM
Replies: 6
Views: 1,264
Posted By Mike1963
heres what i am trying to accomplish: ...

heres what i am trying to accomplish:

http://classify.kellywebserv.com/3tables.php


<?php

include ('.global.php');
Forum: MySQL 05-16-2011, 04:12 PM
Replies: 6
Views: 1,264
Posted By Mike1963
I tried UNION and UNION all and it does put out...

I tried UNION and UNION all and it does put out the data from all 3 tables but does not bring them together as a total count or separate the result by amount per month
Forum: MySQL 05-16-2011, 03:45 PM
Replies: 6
Views: 1,264
Posted By Mike1963
joining multiple tables

how would i go about joining more then 1 table that have nothing in common? I am wanting to get a total count from several different tables then sort the results by month and amount per month
Showing results 1 to 15 of 15

 
Forum Jump

All times are GMT +1. The time now is 07:37 AM.