![]() |
|
Welcome to the Computer Webmaster Gaming Console Graphics Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
| |||||||
| PHP PHP for some can be one of the hardest website programming codes, so do you need help on your PHP script, if it is php4, php5 or lower this is the place for you for any PHP help. |
![]() |
| | LinkBack | Thread Tools | Display Modes |
| | #1 | ||
| In the report.php, my record set I have following as hyperlinked word 'EDIT' with following assigned to it: SELECT * FROM mdbTable WHERE username = 'colname' ORDER BY AlbumID ASC name value RT value colname 1 $HTTP_SESSION_VARS['username'] When I select the record to be edited I get the very last record displayed in the following mdbedit.php page. ..why ? ---------------------------------------------------------------------------- ------ In the file mdbedit.php, my record set I have following: SELECT * FROM mdbTable WHERE username = 'colname' ORDER BY AlbumID DESC name value RT value colname 1 $HTTP_SESSION_VARS['username'] OK now i have get rid of the URL parameters. This page (mdbedit.php) now displaying the user's records in DESC order and only displaying the very last record (Ok due to DESC) . All the information as far as displaying the current user's name and the 'last' record IS correctly displayed. My question is how can I display only the selected record to be edited by the user. I can do this with URL parameters but , I don't want to display users name nor the record ID in the URL in case some users might change the record ID and edit someone elses record. Can anyone simply explain please ? M/E. | |||
| Featured Websites | ||||
|
![]() |
| Tags: call, now, records, sql, statements, unique, user, wrong |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| control sql statements that get logged? | Ken Williams | Database | 0 | 06-10-2007 12:26 AM |
| Display top N records with a group | Ted | Database | 0 | 06-10-2007 12:25 AM |
| how to get records from stored procedure using ASP | Bill | Database | 0 | 06-10-2007 12:19 AM |
| HELP: SELECT only last last few records that were created within last 5 minutes | Neeper | Database | 0 | 05-31-2007 8:39 PM |
| Featured Websites | ||||
|