(mysql) Select 5 random houseid's without calling the query 5 times?
#6

ah, i see. that worked perfectly too! thanks.

pawn Код:
mysql_query("SELECT `Houseid` FROM `Houses` WHERE `Owner` != 'Unbought' ORDER BY RAND() LIMIT 7");
    mysql_store_result();
    new Query[8], m_Houseid[7];
    while(mysql_fetch_row_format(Query))
    {
        static c_House = 0;
        m_Houseid[c_House] = strval(Query);
        c_House++;
    }
    printf("H1: %d - H2: %d - H3: %d - H4: %d - H5: %d - H6: %d - H7: %d", m_Houseid[0], m_Houseid[1], m_Houseid[2], m_Houseid[3], m_Houseid[4], m_Houseid[5], m_Houseid[6]);
Reply


Messages In This Thread

Forum Jump:


Users browsing this thread: 1 Guest(s)