[SOLVED] While Statement question

[acctman]

I have a While statement below that echos the results from my DB but i also need the mp3_id number it grabs from the DB to use in my javascript below that. how can I get it to output $en['mp3_id'] after the While process has ended?

 

<?
$mp3user = mysql_query("SELECT `mp3_id`,`mp3_userid`,`mp3_title` FROM `rate_mp3s` WHERE `mp3_userid` = '".$en['m_id']."'");

echo "<ul style=\"margin-left: 210px;\">\n";
$counter = 1;
while($en = mysql_fetch_array($mp3user)) {
echo "<li>MP3 " .$counter. " : <span id=\"mp3title-".$counter."\">".$en['mp3_title']. "</span> | <a href=\"process_mp3.php?user=" .$en['mp3_userid']. "&mp3=" .$en['mp3_id']. "\">Delete</a></li>\n";
$counter++;

}
echo "</ul>\n";

echo	"\n";
echo	"<script type=\"text/javascript\">\n";
echo	"\n";	

// This section needs to retrieve mp3_id from $en = mysql_fetch_array($mp3user)
echo	"new Ajax.InPlaceEditor('mp3title-1', '/process_mp3.php?mp3=" .$en['mp3_id']. "');\n";
echo	"new Ajax.InPlaceEditor('mp3title-2', '/process_mp3.php?mp3=" .$en['mp3_id']. "');\n";
echo	"new Ajax.InPlaceEditor('mp3title-3', '/process_mp3.php?mp3=" .$en['mp3_id']. "');\n";

echo	"\n";
echo	"</script>\n";

?>

[Jessica]

Save them into an array.

while($en = mysql_fetch_array($mp3user)) {
$mp3IDs[] = $en['mp3_id'];
echo "<li>MP3 " .$counter. " : <span id=\"mp3title-".$counter."\">".$en['mp3_title']. "</span> | <a href=\"process_mp3.php?user=" .$en['mp3_userid']. "&mp3=" .$en['mp3_id']. "\">Delete</a></li>\n";
$counter++;
}
...
foreach($mp3IDs AS $mp3ID){
   echo "new Ajax.InPlaceEditor('mp3title-1', '/process_mp3.php?mp3=" .$en['mp3_id']. "');\n";
}

 

etc.

 

Or you could make a big string of the Ajax code in the while loop and print it later.

[acctman]

Save them into an array.

while($en = mysql_fetch_array($mp3user)) {
$mp3IDs[] = $en['mp3_id'];
echo "<li>MP3 " .$counter. " : <span id=\"mp3title-".$counter."\">".$en['mp3_title']. "</span> | <a href=\"process_mp3.php?user=" .$en['mp3_userid']. "&mp3=" .$en['mp3_id']. "\">Delete</a></li>\n";
$counter++;
}
...
foreach($mp3IDs AS $mp3ID){
   echo "new Ajax.InPlaceEditor('mp3title-1', '/process_mp3.php?mp3=" .$en['mp3_id']. "');\n";
}

 

etc.

 

Or you could make a big string of the Ajax code in the while loop and print it later.

 

$en['mp3_id'] is blank when echo'ing on the Ajax line at the bottom

[Jessica]

Sorry, that should have been:

foreach($mp3IDs AS $mp3ID){
   echo "new Ajax.InPlaceEditor('mp3title-1', '/process_mp3.php?mp3=".$mp3ID."');\n";
}

[acctman]

jesirose thanks for all the help one more small fix

 

 

since the Ajax line is not being looped... the mp3title-1,2, and 3 needs to be created. I tried using the counter like I did above but that didn't work.

 

foreach($mp3IDs AS $mp3ID){
$counter = 1;
echo	"new Ajax.InPlaceEditor('mp3title-".$counter."', '/process_mp3.php?mp3=".$mp3ID."');\n";
$counter++;
}

[darkfreaks]

Try adding

 

<?php while($counter<=2) ?> 

 

before your ajax echo

[Jessica]

You set $counter = 1 in each loop.

Use:

foreach($mp3IDs AS $counter=>$mp3ID){
echo "new Ajax.InPlaceEditor('mp3title-".$counter."', '/process_mp3.php?mp3=".$mp3ID."');\n";
}

[darkfreaks]

she is correct it will loop only once unless you change the number *nod*

[Jessica]

Not quite...it will loop as many times as there are values in the array. However, $counter would always be 1.

[acctman]

thanks =) coding works perfect