Multi query help..ASAP

jray214

What is happeing here is that the second SELECT is not returning values when a record is found.

It does test positive for a rcound found, but it does not get the record.

Thank you for the help.

Jim

$employee_vendor = $stuff[employee];
$cube_vendor = $stuff[cube];

<head>
<title>Copswest Floor Plan</title>
<meta http-equiv='Content-Type' content='text/html; charset=iso-8859-1'>
</head>

require("common.php");

Connect();

// create connection

$connection = mysql_connect("$DBHost","$DBUser","$DBPass")
or die("Couldn't make connection.");

// select database
$db = mysql_select_db("production", $connection)
or die("Couldn't select database.");

#mysql_connect("$DBHost","$DBUser","$DBPass");
#mysql_select_db("$DB");

$sql = "SELECT employee,cube FROM floorplan ORDER BY employee ASC";
// execute SQL query and get result
$sql_result = mysql_query($sql,$connection)
or die("Couldn't execute query.");

while ($row = mysql_fetch_array($sql_result)) {
$cube = $row[cube];
$employee = $row[employee];

$sql_vendor = "SELECT employee,cube FROM vendor WHERE employee LIKE trim('$employee')"; 	    	
$sql_result_vendor = mysql_query($sql_vendor,$connection); 		
$stuff = mysql_fetch_row($sql_result_vendor);

This is the spot where it does do return the employee name
**************
$employee_vendor = $stuff[employee];
$cube_vendor = $stuff[cube];

if (!$stuff) {	
 	echo "Not Found - $stuff <br>";			
	$sql_insert = "INSERT INTO vendor (employee,cube) VALUES (\"$employee\", \"$cube\")";

// execute SQL query and get result

	 $sql_result_add = mysql_query($sql_insert,$connection)
 		or die("Couldn't Add Record."); 	 	
}else{
	echo "cube - $employee, $cube and $cube_vendor<br>";

	$addcube = $cube . ',' . $cube_vendor;
	#echo 	"--Updating $employee with $addboot<br>";
	$sql_upd = "UPDATE vendor SET cube = '$addcube' WHERE employee LIKE trim('$employee')";
	$sql_result_upd = mysql_query($sql_upd,$connection)
		or die("Couldn't execute Update squery.");		

}

}
?>

</body>

neuromancer

I suggest reading your SQL documentation before proceeding with this, specificly the JOIN section.

jray214

Thank you for responding. Doing a JOIN would not accomplish what I need. I need to populate a new table with concat data.

Example

Company XYZ has booths 1,2,4,6. In the main table there are 4 entries.

XYZ 1
XYZ 2
XYZ 4
XYZ 6

The new table information is to look like this:

XYZ 1,2,4,6

So you see a JOIN not give me this results.

Thanks again.

Jim

neuromancer

You might want to reconsider your design then