i'm certainly no expert, but here are my thoughts: the variable $tbn2 probabyl has no value inside of your function. so the query is really just "select name from". i'd suggest you pass the $tbn2 value to the function. also, it is generally a bad idea to have a echo statements in function. rather you should return the results. hope that helps. -rob -----Original Message----- From: Dave Carrera [mailto:dave@davecarrera.com] Sent: Friday, October 18, 2002 10:52 AM To: php-db@lists.php.net Subject: MySql Statement inside a function? Hi All I have created a function and insde that function it dose a standard select, fetch_arry, while loop. I get a error from mysql saying not a vaild resource but if I take the statemnet out of the function all works fine and dandy. Are there things I should be aware of when trying to include mysql statements inside a function? I have include my code here if it helps. function getnames(){ $gnlistsql = "select name from $tbn2"; $gnlistres = mysql_query($gnlistsql); while($nlist = mysql_fetch_array($gnlistres)){ $nlistop = "<option value=\"$nlist[name]\">$nlist[name]</option>"; $nlistsel = "<select name=\"getname\">$nlistop</select>"; echo $nlistsel; } } There error is reported back in the while line... Any help or advice is appreciated as always. P.S reason for the fuction is that I will call the select a name list a few times so I thought of making it a function then calling it when needed. Thank You Dave C -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
