PHP/SQL Calculation Problem

Nokk

Hello Everybody,

First of all thanks for reading. I've a (small) problem with my calculation script. I know there's another possibility with another database set-up, but since I'm a starter with PHP and SQL combined I'd like to fix this script, but it didn't work out so far.

This is the script I'm currently working with:

      <?php
mysql_connect("<Removed>", "<Removed>", "<Removed>") or die(mysql_error());
mysql_select_db("<Removed>") or die(mysql_error());


$result3 = mysql_query("SELECT * FROM <Table1>") 
or die(mysql_error()); 
while($row3 = mysql_fetch_array( $result3 ))


$result2 = mysql_query("SELECT * FROM <Table2>") 
or die(mysql_error());
while($row = mysql_fetch_array( $result2 ))


{
	print $row3['week_19'] + $row['week_19'];
} 
?>

Does anyone know why he only calculates the results of Table2, and not the results of Table1?

Thanks in advance,

Jim

mwasif

Try this code, you were missing {} for first while.

<?php
mysql_connect("<Removed>", "<Removed>", "<Removed>") or die(mysql_error());
mysql_select_db("<Removed>") or die(mysql_error());


$result3 = mysql_query("SELECT * FROM <Table1>") 
or die(mysql_error()); 
while($row3 = mysql_fetch_array( $result3 ))
{

$result2 = mysql_query("SELECT * FROM <Table2>") 
or die(mysql_error());
while($row = mysql_fetch_array( $result2 ))


{
	print $row3['week_19'] + $row['week_19'];
} 

}
?>

Nokk

Thanks for the fast answer! I got this working, now another question; when the selected table does not have data in it, it does not display a number at all when calculating, is there a way to let the script count an empty table as 0?

Thanks,

Jim

mwasif

I don't know what you are trying to develop. It will be better to post your scenario here, that might be achievable with a single mysql query.

Nokk

I'm quite new to MySQL combined with PHP, and as a back-up system for my small company I'm developing a database that counts the hours worked per week.

Structure:

Database name: TestData

-> Name-of-person(TableName)
=> Week 19
=> Week 20

-> Name-of-person2(TableName)
=> Week 19
=> Week 20

With a script I want to calcuate the total hours worked in Week 19 for example. Hope that this makes it a bit more clear.

Thanks for the support,

Jim