[SOLVED] mysql result from two tables problem

[cleary1981]

Below is a piece of code that I am using to query two tables at the same time. The problem I am having is that the company name doesnt appear in the result. What am I doing wrong?

 

<?php

require "config.php";

$selcomp = $_REQUEST['selcomp'];
$newprojname = $_REQUEST['newprojname'];
$newprojman= $_REQUEST['newprojman'];
$newprojdead= $_REQUEST['newprojdead'];

//check to see if a project already exists with this project name for this company
$q1 = mysql_query("SELECT * FROM project WHERE project_name = '$newprojname' AND company_name = '$selcomp'");
$count = mysql_num_rows($q1);
if ($count == 0) {
$q2 = mysql_query("INSERT INTO project (project_name, proj_manager, company_name, deadline) VALUES ('$newprojname', '$newprojman', '$selcomp', '$newprojdead')") or die (mysql_error()); 

$q3 = mysql_query("SELECT proj_id, project_name, project.company_name, acc_no FROM company, project WHERE company.company_name = project.company_name AND project_name = '$newprojname' AND project.company_name = '$selcomp'");
$r = mysql_fetch_assoc($q3);
}
$return = $count . "%%" . $r['proj_id'] . "%%" . $r['project_name'] . "%%" . $r['project.company_name'] . "%%" . $r['acc_no'];
echo $return;

?>

[rhodesa]

The JOIN syntax you are using seems off, try this:

 

$q1 = mysql_query("SELECT * FROM project WHERE project_name = '$newprojname' AND company_name = '$selcomp'");
$count = mysql_num_rows($q1);
if ($count == 0) {
   $q2 = mysql_query("INSERT INTO project (project_name, proj_manager, company_name, deadline) VALUES ('$newprojname', '$newprojman', '$selcomp', '$newprojdead')") or die (mysql_error()); 
   
   $q3 = mysql_query("SELECT p.proj_id, p.project_name, c.company_name, c.acc_no FROM company c, project p WHERE c.company_name = p.company_name AND p.project_name = '$newprojname' AND c.company_name = '$selcomp'");
   $r = mysql_fetch_assoc($q3);
}
$return = $count . "%%" . $r['proj_id'] . "%%" . $r['project_name'] . "%%" . $r['company_name'] . "%%" . $r['acc_no'];
echo $return;

[gevans]

<?php

require "config.php";

$selcomp = $_REQUEST['selcomp'];
$newprojname = $_REQUEST['newprojname'];
$newprojman= $_REQUEST['newprojman'];
$newprojdead= $_REQUEST['newprojdead'];

//check to see if a project already exists with this project name for this company
$q1 = mysql_query("SELECT * FROM project WHERE project_name = '$newprojname' AND company_name = '$selcomp'");
$count = mysql_num_rows($q1);
if ($count == 0) {
   $q2 = mysql_query("INSERT INTO project (project_name, proj_manager, company_name, deadline) VALUES ('$newprojname', '$newprojman', '$selcomp', '$newprojdead')") or die (mysql_error()); 
   
   $q3 = mysql_query("SELECT proj_id, project_name, project.company_name AS pcompname, acc_no FROM company, project WHERE company.company_name = project.company_name AND project_name = '$newprojname' AND project.company_name = '$selcomp'");
   $r = mysql_fetch_assoc($q3);
}
$return = $count . "%%" . $r['proj_id'] . "%%" . $r['project_name'] . "%%" . $r['pcompname'] . "%%" . $r['acc_no'];
echo $return;

?>

 

Give that a try