jacob

Hello everyone, I currently working on a project to show price estimation which requires me to sum a value from two tables in mysql. Ok, below are the tables and values that I have. in example, From these table, I need to get sum price value for car in table1 with price value of india in table2. What would be the mysql syntax? thank you in advance for your help. table1 follow_by price car | 500 foot | 1000 table2 location price china | 10000 india | 15000 thailand | 20000

Hello, currenly I am working on a query page and need help in fixing my query code. My php query scripts are located before html file so I put an echo command at the html table but what happen was that the data that shown up is only the last data in the database table (I think I should modify the query or put a loop inside echo command but I do not know how to do it). So can someone help me with the query? As you can see below is the original code but I need to move the echo into dreamweaver table and keep it looping and showing the woled data in query and not only the last one. pleae help thanks <? session_start(); if (!isset($_SESSION['login'])) { header('Location:http://localhost/wip/index.html'); } $conn=odbc_connect('jascon','root','admin'); if (!$conn) {exit("Connection Failed: " . $conn);} $sql="SELECT * FROM user_case_data"; $rs=odbc_exec($conn,$sql); if (!$rs) {exit("Error in SQL");} while (odbc_fetch_row($rs)) { $compname=odbc_result($rs,"case_num"); $conname=odbc_result($rs,"case_outcome"); echo "$compname"; echo "$conname"; } odbc_close($conn); echo "</table>"; session_destroy(); ?>