Get info from db for month at a time

[eagle0921]

Hi,

I am new to PHP and MySql and I need a script where I Can go to one database and pull a Person's name out by their ID and then go to another database to get there monthly activity stats that has been posted from a form for any given month. I have 7 people in my database right now and more to be entered and each one files some stats throughout the month and I need this script to help minimize my time and workload.

Thank You very much,

Ron Sprinkel

[Anon]

Hi Ron

Try This

$sql = mysql_query("SELECT *
FROM $table1, table2
WHERE user_id ='$user_id'
AND table1.table1_id = table2_table1_id
AND date <= $from_date
AND date >= $to_date");

while($result = mysql_fetch_array($sql)) {
print "Stuff";
}

What you need is merge both table with a unique id so table1 and table2 should have a field that will nerge them together

Hope this helps

[eagle0921]

Hi Richie,

I tried this script and I keep getting this error "Warning: Supplied argument is not a valid MySQL result resource in /home/eagle/public_html/bmaf/getinfo.php on line 9". I switched the table names around to the real names of the table and I hope I did it right but anyways it didn't work. As stated I am real new to PHP and really having major problems.

Thanks,
Ron

[eagle0921]

Can I send someone an email with all the details that involves these 2 databases that I am trying to get the needed data out. Plus I have problems with 2 more scripts.

Thanks VERY much in advance,
Ron

[Anon]

Ok Ron it would help if I new the name of the table and fields

there is an error on that on the

WHERE user_id ='$user_id'
AND table1.table1_id = table2_table1_id

Sholud be
WHERE user_id = '$user_id'
AND table1.table1_id = table2.table1_id