Jump to content

Using one table's row's as a variable to match similar entries in a 2nd table


manhattes
Go to solution Solved by Barand,

Recommended Posts

Hi All,

I am having trouble getting my script to work.

 

I have two tables. 

Stocks

Calendar

 

The stocks table only has two fields, Company and Symbol

 

The Calendar table has a field with the same title SName.

 

I would like to return the matching rows in the calendar that contain the company name from the Stocks Table along with a date field.

 

I think utilizing the LIKE command is best.

$query = "SELECT * FROM Stocks"; 
$query2 = "SELECT * FROM Calendar"; 
	 
$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_assoc($result)){
	echo $row['SName'] ," ", $row['Symbol'] ;
	echo "<br />";

 }
 $result2 = mysql_query($query2) or die(mysql_error());

while($row2 = mysql_fetch_assoc($result2)){
	echo $row2['SName'] ," ", $row2[''] ;
	echo "<br />";
	
 }
 ?>
 
    <tr>
    <td><p><?php echo $row['Symbol']; ?></p></td>
    <td><p><?php echo $row['SName']; ?></p></td>
    <td><p><?php echo $row['Primary Completion Date']; ?></p></td>
    </tr>
 
</table>

</body>
</html>

Link to comment
Share on other sites

It is not recommended to run two separate queries. If you have data stored in both tables which relates then you should use a join. Example

SELECT s.SName, s.Symbol,
       c.`Primary Completion Date`
FROM Stocks s
LEFT JOIN Calendar as c USING(SName)

Also try not to have spaces in table names, either use camelcase or underscores.

Link to comment
Share on other sites

$query = "SELECT s.SName, s.Symbol, c.`Primary Completion Date` FROM Stocks s LEFT JOIN Calendar as c LIKE %(SName)"; 
	 
$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_assoc($result)){
	echo $row['SName'] ," ", $row['Symbol'] ;
	echo "<br />";


Again, I have two tables. I basically want the script to only return the values in the calendar that have the same company in my stock list. 

Maybe I need to have the script create a 3rd table that creates a row for every match that is in the calendar?

Link to comment
Share on other sites

@guru it says Lost connection to MySQL server during query

 

$query = "SELECT s.SName, s.Symbol,

c.`Primary Completion Date`
FROM Stocks s
LEFT JOIN Calendar as c ON c.SName LIKE CONCAT('%', s.SName, '%')"; 
 
$result = mysql_query($query) or die(mysql_error());
 
while($row = mysql_fetch_assoc($result)){
echo $row['SName'] ," ", $row['Symbol'] ;
echo "<br />";
 
 }
Edited by manhattes
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.