brem13 Posted March 23, 2009 Share Posted March 23, 2009 hey, im writing a script to check to see if a table has a certain value in a table and i know the value isnt there but the script isnt working the way i want it $result = mysql_db_query($database, "select * from $table WHERE username = '$username1'") or die (mysql_error()); //echo $result; if($result != null) { echo 'You cannot view this members profile'; } else when i echo the result, i get resource id#5 meaning its not null, how do i do an if statement like this? im lost??? Link to comment https://forums.phpfreaks.com/topic/150642-solved-check-mysql-table-if-field-doesnt-exist/ Share on other sites More sharing options...
Maq Posted March 23, 2009 Share Posted March 23, 2009 You need to use mysql_fetch_assoc and then select a field like: $result = mysql_db_query($database, "select * from $table WHERE username = '$username1'") or die (mysql_error()); //echo $result; $row = mysql_fetch_assoc($result); echo $resul['field']; Link to comment https://forums.phpfreaks.com/topic/150642-solved-check-mysql-table-if-field-doesnt-exist/#findComment-791392 Share on other sites More sharing options...
trq Posted March 23, 2009 Share Posted March 23, 2009 if ($result = mysql_db_query($database, "select * from $table WHERE username = '$username1'")) { if (mysql_num_rows($result)) { // username exists. } else { // username does not exist. } } else { // query failed. handle error } Link to comment https://forums.phpfreaks.com/topic/150642-solved-check-mysql-table-if-field-doesnt-exist/#findComment-791393 Share on other sites More sharing options...
brem13 Posted March 23, 2009 Author Share Posted March 23, 2009 thank you both very much! im headed in the right direction now Link to comment https://forums.phpfreaks.com/topic/150642-solved-check-mysql-table-if-field-doesnt-exist/#findComment-791394 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.