CodingForums.com - View Single Post - SELECT data from one row IF another row = 1?

Keleth · 03-30-2012, 08:47 PM

You never use the data where you check if active = 1... you immediately do another query $data = mysql_query("SELECT * FROM mybb_forms") overwriting data with EVERYTHING. Whats the purpose of that second query now that you have the active data?

You'll also never see the first dataset, as you pull a row, then immediately pull another row without making use of the first one.

03-30-2012, 08:47 PM	PM User \| #10
Keleth Senior Coder Join Date: Jun 2008 Location: New Jersey Posts: 2,354 Thanks: 45 Thanked 247 Times in 244 Posts	You never use the data where you check if active = 1... you immediately do another query `$data = mysql_query("SELECT * FROM mybb_forms")` overwriting data with EVERYTHING. Whats the purpose of that second query now that you have the active data? You'll also never see the first dataset, as you pull a row, then immediately pull another row without making use of the first one.