louis_coetzee Posted February 7, 2009 Share Posted February 7, 2009 $result = mysql_query("SELECT * FROM workinglife where id = '$record' and userid = '$userid'"); while ($row = mysql_fetch_array($result)) { the rest goes here......... } What i want is, when the person changes the www.whatever.co.za/?recno=234556 recno. and it doesnt belong to him, should give, record doesnt belong to you! error.... What is the query? Hope you want to help.....thanx.....!!!! Link to comment https://forums.phpfreaks.com/topic/144262-solved-please-help/ Share on other sites More sharing options...
peranha Posted February 7, 2009 Share Posted February 7, 2009 Assuming id is the recno in the url, then. <?php $result = mysql_query("SELECT * FROM workinglife where id = '$record' and userid = '$userid'"); // check to see if any rows match. if (mysql_num_rows($result) == 1) { while ($row = mysql_fetch_array($result)) { the rest goes here......... } } // if no rows, display the error. else { echo "There is no record!"; } ?> Try that and see what happens. Link to comment https://forums.phpfreaks.com/topic/144262-solved-please-help/#findComment-757079 Share on other sites More sharing options...
louis_coetzee Posted February 8, 2009 Author Share Posted February 8, 2009 Thanks that's what I wanted. Link to comment https://forums.phpfreaks.com/topic/144262-solved-please-help/#findComment-757312 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.