z databáze do array

<?php
$MySQL_server="localhost";
$MySQL_user="uzivatel";
$MySQL_user_password="heslo";
$MySQL_db="jmeno";
$spojeni=mysql_connect($MySQL_server,$MySQL_user,$MySQL_user_password);
$spojenidb=mysql_select_db($MySQL_db);


$dotaz="SELECT * FROM ps_product WHERE supplier_reference";
$vysledek = MySQL_Query($dotaz); 
while ($zaznam = MySQL_Fetch_Array($vysledek)){
$supplier_reference=$zaznam["supplier_reference"];
            
            echo $supplier_reference;
            
                        }
    
?>