sort sql query from metadata
-
Hi,
iam trying to gett all users with first, last name and the mobile/phone numbers. My sql query gives that all back but in thois form:
firstname
firstname
firstname
firstnamelastname
lastname
lastname
lastnamePhonenumber
Phonenumber
Phonenumber
PhonenumberI want: firstname, lastname, phonenumber
Importand: Not each user has a number.
Can Someone help? My query:
{global $wpdb;
$test1 = $wpdb->get_col(“SELECT meta_value FROM $wpdb->usermeta WHERE meta_key = ‘first_name'” );
$test2 = $wpdb->get_col(“SELECT meta_value FROM $wpdb->usermeta WHERE meta_key = ‘last_name'” );
$test3 = $wpdb->get_col(“SELECT meta_value FROM $wpdb->usermeta WHERE meta_key = ‘next_ad_int_mobile'” );
$test4 = $wpdb->get_col(“SELECT meta_value FROM $wpdb->usermeta WHERE meta_key = ‘next_ad_int_phone'” );$gefunden = $wpdb->num_rows;
foreach ($test1 as $fn)
{
print_r($fn);
echo “<br>”;
}
foreach ($test2 as $fn2)
{
print_r($fn2);
echo “<br>”;
}
foreach ($test3 as $fn3)
{
print_r($fn3);
echo “<br>”;
}foreach ($test4 as $fn4)
{
print_r($fn4);
echo “<br>”;
}echo “Gefundene Telefonnummern: “.$gefunden;
}
The topic ‘sort sql query from metadata’ is closed to new replies.