help with querying all rows under certain columns

fearfx

what would my query and loop look like as I am not very good with loops and what not....

laserlight

What exactly are you trying to do, and what have you tried so far?

chasiv

$strSQL = "SELECT * FROM table where fieldname = condition";
$result = mysql_query($strSQL);
while($row = mysql_fetch_assoc($result)) {
    $array[] = $row;
}

Then the array named $array will contain all the rows that meet your criteria...

Then to loop through it:

for($counter=0; $counter<sizeof($array); $counter++) {
     Do something with each item....
}

That's as basic I can get it without more details on what you're trying to achieve.

fearfx

$result = mysql_query("SELECT adstack_accpt_$ct,menucon_$ct FROM sfb_pages WHERE adstack_$ct = 1");

$links = array_map("parse_output",mysql_fetch_array($result, MYSQL_ASSOC));

Ok the code above is my basic query....

now I would assume a for loop would work to go through the query 5 times. varialbe $ct would be the counter.and also point to which information to gather.

there are actually 5 columns each for
adstack 1
adstack 2
adstack 3
adstack 4
adstack_ 5

adstack_accpt_1
adstack_accpt_2
adstack_accpt_3
adstack_accpt_4
adstack_accpt_5

now what I am trying to achieve is this... adstack_accpt$ct either holds a value of 'y' or 'n' and the adstack$ct holds either of the 2 values '1' or '2'

now I want to echo menucon$ct where adstack$ct = 1 and adstack_accpt_$ct = y

I hope this helps better.. and Thank you!

laserlight

The problem is with your database schema design. Numbered columns are generally a Bad Thing and should be replaced by adding a new table. Read about Database Normalization and Design Techniques.

fearfx

so why is it a bad design???

laserlight

Adding or deleting an adstack requires table alteration. With a good design, it should only require a row insertion or row deletion.
You need to make otherwise unnecessary queries to get the information you want.
It is likely that you would end up with redundant data, thus allowing inconsistency.

fearfx

Thanks for the tip, I will change db design in final project... the query I need help with is this....

$limit = '5';

for ($ct = 0; $ct < $limit; $ct = $ct + 1)
	{
		$result = mysql_query("SELECT menucon_$ct FROM sfb_pages WHERE adstack_accpt_$ct ='y'");

	$links = array_map("parse_output",mysql_fetch_array($result, MYSQL_ASSOC));

	echo htmlspecialchars_decode($links["menucon_$ct"]) . "<br><br>";

}

This is by far not right, but this is what I have....

I want the query to run through the adstack_1,2,3,4,5 but quering every row...

How would I do that?

not just the first result of astack_accpt$ct.. I want all the adstack_accpt$ct =y to output mencon_$ct

...

laserlight

I want the query to run through the adstack_1,2,3,4,5 but quering every row...

What do you mean? What is your current database schema?

fearfx

there is a table called sfb_pages

then there are the colums with all the advertisment information...

1
2
3
4

1-4 is image captures of php my admin database layout for table sfb_pages in order

each row in this table is a new advertisment...

I don't know if this helps...

laserlight

All in one huge table?

Well, what are you trying to select/update/etc?

fearfx

when an advertisment is added, the admin system determines weather the advertisment image is 125 x 125 if so, a y is placed to the corresponding adstact_accpt_1-5

the second fucntion is the admin to turn the ad on or off for adstack viewing

via the check box next to the image.

so if the advertisment image is available for adstack viewing there will be these instances

adstack_1-5 = 1
adstack_accpt_1-5 = y

I want to find all the advertisments where that criteria above is met and then echo there corresponding menucon_1-5(holds image link code)

follow...

laserlight

when an advertisment is added, the admin system determines weather the advertisment image is 125 x 125 if so, a y is placed to the corresponding adstact_accpt_1-5

Why not just store the image dimensions?

the second fucntion is the admin to turn the ad on or off for adstack viewing

via the check box next to the image.

Use a single column. You do not need 5 different columns since the advertisement image cannot have more than one set of dimensions, and thus cannot be in more than one adstack category.

When this is done, the requirements would change to a much easier:
height = 125
width = 125
adstack_accept = y

Likewise, you only need a single column to hold the image link code.

fearfx

now the reason for 1-5 is this:

on the link above in the page you will see a tabbed content feature.

in the admin you can have up 2 five tabs....

now the adstack will be on the right side of a page like this to only show images that are 125 x 125

follow better....

laserlight

now the reason for 1-5 is this:

on the link above in the page you will see a tabbed content feature.

in the admin you can have up 2 five tabs....

now the adstack will be on the right side of a page like this to only show images that are 125 x 125

That is an implementation detail and has nothing to do with how you should model your data other than that your data model should support it. From what I see, doing it in the way I described does support this tab functionality.

fearfx

so where would I store the image dimensions? and how?

I guess the way you described it to me is confusing, at least for me...

laserlight

so where would I store the image dimensions? and how?

In the database table.

I guess the way you described it to me is confusing, at least for me...

Have you read the article I linked to?

fearfx

yea, but I still don't understand whats wrong with my db, first of all putting the image size into its own column? why would I do this, instead I put a y if it is and a n if it isn't....