php/sql - proba skrocenia dzialajacego kodu

Question

Mam dzialajacy kod (ponizej), ale wyglada tragicznie, na pewno mozna to napisac krocej, tylko nie umiem tego przerobic. Ponizej podalem probe rozwiazania, sprawdzi ktos ?

<?php
$query1 = "SELECT * from table1";
$result1 = mysqli_query ($connect, $query1); 
if (mysqli_row_numbers ($result1)>0){

if ($row["idformal"] ==1) {
$query2 = "SELECT * from table2 WHERE column=1";
$result2 = mysqli_query ($connect, $query2);
if (mysqli_row_numbers ($result2)>0){
Echo { 1}
Else { 2 }}

if ($row["idformal"] ==2) {
$query2 = "SELECT * from table2 WHERE column=2";
$result2 = mysqli_query ($connect, $query2);
if (mysqli_row_numbers ($result2)>0){
Echo { 1}
Else { 2 }}

if ($row["idformal"] ==3) {
$query2 = "SELECT * from table2 WHERE column=3";
$result2 = mysqli_query ($connect, $query2);
if (mysqli_row_numbers ($result2)>0){
Echo { 1}
Else { 2 }}}

etc...
?>

Ponizej kod ktory fajnie by bylo jakby dzialal. Na pewno cos jest nie tak z @number++

<?php
$query1 = "SELECT * from table1";
$result1 = mysqli_query ($connect, $query1); 
if (mysqli_row_numbers ($result1)>0){

$query2 = "DECLARE @number as INT
SET @number = 1
@number++
SELECT * from table2 WHERE column=@number";
$result2 = mysqli_query ($connect, $query2);
if (mysqli_row_numbers ($result2)>0){
Echo { 1}
Else { 2 }}
?>

dzieki