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] Link to comment https://forums.phpfreaks.com/topic/29325-mysql_query/ Share on other sites More sharing options...
chiprivers Posted December 3, 2006 Share Posted December 3, 2006 try using <> instead of != Link to comment https://forums.phpfreaks.com/topic/29325-mysql_query/#findComment-134430 Share on other sites More sharing options...
chriscloyd Posted December 3, 2006 Author Share Posted December 3, 2006 lol sorry but that doesnt work Link to comment https://forums.phpfreaks.com/topic/29325-mysql_query/#findComment-134431 Share on other sites More sharing options...
chiprivers Posted December 3, 2006 Share Posted December 3, 2006 what is happening? Link to comment https://forums.phpfreaks.com/topic/29325-mysql_query/#findComment-134434 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] Link to comment https://forums.phpfreaks.com/topic/29325-mysql_query/#findComment-134515 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.