Using a while statement in an echo.

[Excellent1]

Not done this before but is it possible? Say if you wanted to show some select options from a specific table in your database, could you do it like this?

$query = mysql_query("SELECT * FROM `tablename` WHERE `selects`");
echo ("<form method='post' action='blahhhh'>
Selects:<br>
<select name='select' size='1'>
<option selected>Select one</select>
while ($cat = mysql_fetch_array($query)) {
<option value='$select[id]'>$select[name]</option>
}
</form>"); 

Probably confusing to some but would appreciate the advice

Closed by Invent (Forum Moderator): Thread closed due to prevent further arguments and going off-topic.

[Dentafrice]

Hell no.

Number one, echo isn't a function.. drop the ()'s.

And why do you have WHERE `selects`, what is selects?

[Delatory]

Nope that wouldn't work, If you did try that it wouldn't do the script it would just send it to the page.

$query = mysql_query("SELECT * FROM `tablename` WHERE `selects`");
echo ("<form method='post' action='blahhhh'>
Selects:<br>
<select name='select' size='1'>
<option selected>Select one</select>");
while ($select = mysql_fetch_array($query)) {
echo ("<option value='$select[id]'>$select[name]</option>");
}
echo ("</form>"); 

You'd have to stop the echo, do the query then have to echo the last bit of the form. It also wouldn't work with having $cat = mysql_fetch_array and then using $select

And fix the query

[Dentafrice]

Nope that wouldn't work, If you did try that it wouldn't do the script it would just send it to the page.

$query = mysql_query("SELECT * FROM `tablename` WHERE `selects`");
echo ("<form method='post' action='blahhhh'>
Selects:<br>
<select name='select' size='1'>
<option selected>Select one</select>");
while ($select = mysql_fetch_array($query)) {
echo ("<option value='$select[id]'>$select[name]</option>");
}
echo ("</form>"); 

You'd have to stop the echo, do the query then have to echo the last bit of the form. It also wouldn't work with having $cat = mysql_fetch_array and then using $select

And fix the query

Again, drop the ()'s, it is not a ******* function.

Also, for christ sakes, quit missing 's/"s on your variables.

It's $select["id"] and $select["name"], not $select[id], $select[name].

[Excellent1]

Hell no.

Number one, echo isn't a function.. drop the ()'s.

And why do you have WHERE `selects`, what is selects?

Oops, my bad! I had a silly thought about a table in the table, lol.

Nope that wouldn't work, If you did try that it wouldn't do the script it would just send it to the page.

$query = mysql_query("SELECT * FROM `tablename` WHERE `selects`");
echo ("<form method='post' action='blahhhh'>
Selects:<br>
<select name='select' size='1'>
<option selected>Select one</select>");
while ($select = mysql_fetch_array($query)) {
echo ("<option value='$select[id]'>$select[name]</option>");
}
echo ("</form>"); 

You'd have to stop the echo, do the query then have to echo the last bit of the form. It also wouldn't work with having $cat = mysql_fetch_array and then using $select

And fix the query

Yeah, that was the way I was going to do it, just didn't know if it could be done another way +REP though.
At denta, I use 's on personal scripts only, I use correct terms on client work.

[Dentafrice]

Well I really don't see how you could have client work with coding like this, and asking a question like this.

If you can't figure this out, how could you figure something 20x more complex out.. that doesn't have to do with echos :\

If you can't experiment and try things yourself, before asking.. then you shouldn't be asking at all.

[MrCraig]

need to close the </select> tag still..

and i use echo(" "); too, just a habbit lol ;p

[Excellent1]

Well I really don't see how you could have client work with coding like this, and asking a question like this.

If you can't figure this out, how could you figure something 20x more complex out.. that doesn't have to do with echos :\

If you can't experiment and try things yourself, before asking.. then you shouldn't be asking at all.

Read what I said above, my coding is not clean when I'm doing it for myself, client coding is clean and uses proper terms and syntax. Secondly I don't have access to my servers at the moment so I can't test out the outcome can I?

need to close the </select> tag still..

and i use echo(" "); too, just a habbit lol ;p

Yeah, I knew the proper way, just thought there may be another way Haha, (" ") is a bad bad habit I'm sure a lot of coders share

[kreechin]

Yeah same I've been usingg echo (" "); since I started coding, picked it up off Naresh's user system I think, so I assumed it was correct, although i do use " "; now and again when i'm in a rush to throw something together.

[Dentafrice]

""; and ''; are the proper ways, no use to make it into a method.

Naresh's user system was badly coded, as he now admits ;P