while($im_stuck = mysql_query($HELP))

wit

Ok.. well i have hit yet another brick wall and could use some help getting over it...

I am fairly new at php and dont quite have everything down as to what you can and cant do with certain things..

Heres my problem code:

 $result1=mysql_query("SELECT * FROM photos WHERE albumid='$album'",$server);
  $result2=mysql_query("SELECT * FROM urls WHERE urlid='$urlid'",$server);

  $count=0;
  while($row = mysql_fetch_array($result1) $row2 = mysql_fetch_array($result2))

Now i dont know if you can have the while func the way i have it and if you can i dont know if the syntax is correct.. i need that to work or have something else that will give me the same effect.

wit

leatherback

Hi,

It is a bit unclear what you actually try to do here. Could you please give a bit more info?

in general:

$result1=mysql_query("SELECT * FROM photos WHERE albumid='$album'",$server);
while($row = mysql_fetch_array($result1) )
{
echo $row[album];
}

Would give you a list of all the albums in photos where albumid = $album

wit

i guess i put to much code in there and my actual question was unclear.. fair enough.. lets try again shall we?..lol

all i want to know is it possible for there to be 2 variables being declared in one while() function?:

while($row = mysql_fetch_array($result1) $row2 = mysql_fetch_array($result2))

if not how would i do it.. if it is possible whats the proper syntax.

leatherback

Hm, still I am not completely sure.

What you could try to do is; You need a set of data from one table, and based on that set you build a new query. Then you'd nest the while's

while($row1 = mysql_fetch_array($result1) )
{
// any output you'd want
while($row2 = mysql_fetch_array($result2) )
{
// Output based on query 2
}
}

It would be a bit easier to try to answer the question if I could understand what output you try to reach...
I am not sure whether you could combine the two outputs: The output arrays could (and most likely are!0 be of different length, which would cause conflicts.

But again: Explain the output you try to get, and maybe I have some ideas. I see url's and images.. Links to images??

wit

LOL.. Thanks for your time in trying to help me but I looked at my code real good about 2 min ago and found out what i was trying to do with the while() funtion was not needed.. and i dont have the problem anymore.. Thanks again..

wit

ozzythaman

OUCH,

betcha figured out to use && between arguments in while..

HEY EVERYBODY LOOK WHAT A SILLY MISTAKE!! 😉

leatherback

< No mistake is silly: We are all humans >
< no question is silly: How can you know everything? >
< Thinking you know best .. now that's silly >

We can all learn someting!? <