how to merge two sql queries with PHP

Question

Is it possible to create 2 "mysql_query" and merge them together before I'm using: mysql_fetch_array ?

$mainQuery_one = mysql_query("SELECT....");
$mainQuery_two = mysql_query("SELECT....");

possible duplicate of stackoverflow.com/questions/24934471/merge-two-sql-queries stackoverflow.com/questions/38258576/… stackoverflow.com/questions/9757824/merging-two-sql-queries — Amit Ray
– Amit Ray, Commented Jul 11, 2016 at 10:40

Community · Accepted Answer · 2023-11-17 20:16:56Z

0

You can use multi_query function which for this exact requirement. The manual has all the relevant explanation with the sample snippet for your understanding.

To summarize, concatenate the two query string in a single variable and call the function with this variable as a parameter.

edited Nov 17, 2023 at 20:16

CommunityBot

11 silver badge

answered Jul 11, 2016 at 10:42

Sujeet Sinha

2,4332 gold badges20 silver badges27 bronze badges

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

Collectives™ on Stack Overflow

how to merge two sql queries with PHP

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related