On Wed, Jan 7, 2009 at 4:13 PM, Terion Miller <webdev.terion@xxxxxxxxx>wrote: > > > On Wed, Jan 7, 2009 at 4:10 PM, Frank Stanovcak <blindspotpro@xxxxxxxxxxx>wrote: > >> >> ""Terion Miller"" <webdev.terion@xxxxxxxxx> wrote in message >> news:37405f850901071354p7abd0aa8i7c96cf69c81fadb5@xxxxxxxxxxxxxxxxx >> >> >> > $result=mysql_query($query) or die('Queryproblem: ' . >> mysql_error() >> >> > . >> >> > '<br />Executed query: ' . $query); >> >> > if (mysql_num_rows($result) >= '1'){ >> >> > while ($row = mysql_fetch_assoc($result)){ >> >> > echo $row['AddEditAdmin']; //to print out the value of >> >> > column >> >> > 'var1' for each record >> >> > } >> >> > }else{ >> >> > echo 'No records found.'; >> >> > } >> >> > ?> >> >> > >> >> > anyone have ideas for me, the session user is working, and I need to >> >> > use >> >> > it >> >> > in the query to pull only that users data I also on the login page >> >> > where >> >> I >> >> > set that session all set it to = $UserName but when I try and use >> that >> >> > in >> >> > the query UserName = $UserName I get an undefined variable error... >> >> > >> >> > Really trying but not quite getting it... >> >> > >> >> >> >> >> >> >> >> -- >> >> PHP General Mailing List (http://www.php.net/) >> >> To unsubscribe, visit: http://www.php.net/unsub.php >> >> >> >> Well I am def. further along, the query is working, I can echo fields >> in >> > the $row and get the results but when I try and use this: >> > >> > <?php >> > if ($row['AddEditAdmin'] == 'YES') { >> > ?> >> > to sort out what menu items to load it just doesn't do its job. >> > >> >> I would say do this to see if what is in the return is what you are >> expecting >> >> foreach($row as $key=>$value){ >> echo $key , ': ' , $value , '<br>'; >> }; >> >> just to make sure that the value is "yes", and not 1 or true or something >> like that. >> >> Frank >> >> >> >> -- >> PHP General Mailing List (http://www.php.net/) >> To unsubscribe, visit: http://www.php.net/unsub.php >> >> I will try that, thanks, I did just try to echo the $row['AddEditAdmin'] > results, as I do in the query section and in that it does return YES or NO > like I expect, but when I tried to echo it down in the page where I need to > use it.... guess what..no echo... am I cutting my query off somewhere? could > it be the while statement .... > > Ok tried that and got "*Warning*: Invalid argument supplied for foreach()"
