Question about mySQL SELECT query and '*'
#4

How exactly do you execute your querys?

I mostly do it like this when I'm required to get a big amount of columns:
Код:
mysql_query("SELECT * FROM `users`");
mysql_store_result();

while(mysql_retrieve_row()) {
    mysql_fetch_field_row(variable, "name");
    /*
     * more code
     */
}

mysql_free_result();
This never crashed my server even though my users table
has something between 50 and 100 columns.


It would be good if you posted the relevant part of your code,
because the error maybe is hidden somewhere else.
Reply


Messages In This Thread
Question about mySQL SELECT query and '*' - by MP2 - 10.01.2012, 10:42
Re: Question about mySQL SELECT query and '*' - by Vince - 10.01.2012, 11:41
Re: Question about mySQL SELECT query and '*' - by MP2 - 10.01.2012, 13:17
AW: Question about mySQL SELECT query and '*' - by Blowfish - 10.01.2012, 14:34
Re: Question about mySQL SELECT query and '*' - by AndreT - 10.01.2012, 14:38

Forum Jump:


Users browsing this thread: 1 Guest(s)