chriscloyd Posted December 3, 2006 Share Posted December 3, 2006 is there a way to get all the rows from a table cept one row that is = to your session[code]<?php$email = $_SESSION['firefight'];$getcity = mysql_query("SELECT * FROM users WHERE cityname != '$email' ORDER by id ASC");$city = mysql_fetch_assoc($getcity)?>[/code] Quote Link to comment Share on other sites More sharing options...
chiprivers Posted December 3, 2006 Share Posted December 3, 2006 try using <> instead of != Quote Link to comment Share on other sites More sharing options...
chriscloyd Posted December 3, 2006 Author Share Posted December 3, 2006 lol sorry but that doesnt work Quote Link to comment Share on other sites More sharing options...
chiprivers Posted December 3, 2006 Share Posted December 3, 2006 what is happening? Quote Link to comment Share on other sites More sharing options...
keeB Posted December 3, 2006 Share Posted December 3, 2006 [code]<?php$email = $_SESSION['firefight'];$getcity = mysql_query("SELECT * FROM users WHERE cityname NOT '$email' ORDER by id ASC");$city = mysql_fetch_assoc($getcity)?>[/code] Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.