While Loops...

I'm having trouble w/ something...

I have a while loop that I'm using to create a table.

I have this in the middle of the page. But I want to have info pulled from the table above and below this while loop, and not that that information repeat, like the while loop does.

Kind of understand?

This is my query code

Can anybody help me?

I don't understand what your doing the while loop for... can you post what is in the 'age-calc.php' page to help me see the mysql query your running...


and does this

rely on the information in the age-calc.php ?

dont even pay attention to the age-calc.php i don't really need it.

I want to run a loop in the middle of a page pulling all of the info from the specified database. So I was running the while loop which did this fine.

I also wanted to have PHP info above and below the loop, but this info only is being pulled from a single row in the db, so I don't want it to loop.

You forgot to end the while.

Then you just use a separate query which will only get information from one row...

I don't really understand why you even need the while loop, if you don't rely on age-calc.php for anything. It looks like you could just use a query to pull information from one row. You may need to post more of the surrounding code, so that we can understand what you're trying to achieve.

Originally Posted by enigma You forgot to end the while.

Yes, your while loop needs a } on the end.

Beyond that, I don't really understand what you're getting at. Maybe a little more detail?

Hi Jako,

like Zeggy mentioned above, use two separate queries one after the other - unless the info from one query is used as input for the other query in which case you can do:

-- START --

// Define 1st query here - you can use 'limit 1' in your sql to force it to be only one row if you wish

$query1 = [ queries info from one row only ]

// The 'while' loop below will execute only once

while [ fetching info based on query1 ] {
[ get the data from query1 ]
// Define 2nd query here
$query2 = [ query to loop, populated with data from query1 ]
while [ fetching info based on query2 ] {
[get the data from query2 ]
}
}

-- END --

Hope this helps somewhat - PM me with more details if you need some more help (and I wish the indent would work )

Cheers,

Mike

please be more specific,i am not getting what exactly u r saying?