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.....!!!! Quote Link to comment 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. Quote Link to comment 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. 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.