I would like to use the result of a query in another query using PHP and mysql

Question

My first query should return a single result.

$query="select idtechnic from technic where idname='$technic' and setname='$set' and number='$number'";

I would like to use the result of the above query in a second query:

$result=mysql_query($query);
$row1=mysql_fetch_assoc($result)
$query1="select idtechnic, move from moves where idtechnic='$row1[0]' order by idmoves";

I also tried mysql_fetch_array($query) and mysql_result($query, 1)

Jacob · Accepted Answer · 2011-08-11 08:46:58Z

6

SELECT moves.idtechnic, moves.move 
FROM moves
INNER JOIN technic
        ON technic.idtechnic=moves.idtechnic
WHERE technic.idname='$technic' 
  AND technic.setname='$set' 
  AND technic.number='$number'
ORDER BY moves.idmoves

Combine the two queries with a INNER JOIN [MySQL Docs].

answered Aug 11, 2011 at 8:46

Jacob

43.6k6 gold badges81 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Yaron Buki Over a year ago

Impressive young cularis-walker.

Yaron Buki Over a year ago

Don't guess, it was a good answer. Kind of magical! I will accept when the minutes allow it.

J0HN · Accepted Answer · 2011-08-11 09:00:17Z

1

mysql_fetch_assoc fetches an associative array (aka hash or map). So, your idtechnic value reside in $row1['idtechnic']. But you'd better combine the queries like @cularis suggests, as it will result in faster and more readable code.

answered Aug 11, 2011 at 9:00

J0HN

27.1k5 gold badges59 silver badges88 bronze badges

Collectives™ on Stack Overflow

I would like to use the result of a query in another query using PHP and mysql

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related