Jump to content

[SOLVED] Please help


louis_coetzee

Recommended Posts

$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

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.