472,976 Members | 1,417 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,976 software developers and data experts.

database info in forms

HI all

i am just wondering if this is at all possible

i know you can get data from mysql database and display it in a table format

what i would like to know is if it is possible to show the data in a text field so i could then change the data and submit it back to the database.

thanks in advance
Aug 14 '06 #1
4 1296
9,065 Expert Mod 8TB
Yes, just write it as the value of a text input or textarea and you will be able to edit it. You will need some more serverside script to write it back to the MySQL database.
Aug 14 '06 #2
i have tried putting it in where i think is the right place but i get a prse error
Expand|Select|Wrap|Line Numbers
  1. echo " <tr>
  2. <td align=\"center\">{$row['dr']}</td>
  3. <td align=\"center\">{$row['game']}</td>
  4. <td align=\"center\">{$row['time']}</td>
  5. <td align=\"center\">{$row['Channel']}</td>
  6. <td align=\"center\">{$row['home_score']}</td>
  7. <td align=\"center\"><input type="text" name="as" size="30" value="<?php echo {$row['away_score']}; ?>" /></td>
  8. </tr>\n";
can anyone help
the error i am getting is:
parse error: parse error, unexpected T_STRING, expecting ',' or ':' in the "file name" on line 87

the long line is 87

any help would be greatly appriciated
Aug 14 '06 #3
9,065 Expert Mod 8TB
You got confused, you where already inside an echo statement when suddenly you stop escaping " and issue another echo command on that line.
Aug 14 '06 #4
thanks for replying so quickly

so how do i get around this problem???

do i stop the first echo statement before the line??
Aug 14 '06 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

by: democratix | last post by:
Hi, I've only got a couple years experience developing for Access but have recently been experimenting with HTML/javascript for gui and client-side scripting, mysql for database and php for...
by: HolaGoogle | last post by:
hi all, can you please tell me what i should do to avoid session timeout when displaying my database info in my asp form (DisplayUserDatabase.asp)??? ** actualy it does load and display the...
by: Rosy Moss | last post by:
I am in the process of cleaning up a database that our company uses to track jobs, time and expense, and customer information. We are running Windows 2000 Server with approximately 20 terminals...
by: Karen | last post by:
As an Access novice, I have built a database that contains our company customer data, job info, and surveyor time and expense. I taught myself about tables, relationships, queries, etc., but feel...
by: James Armstrong | last post by:
Hi all, (warning - long post ahead) I have been tasked with designing a database for my company which will store trade information (it is a financial firm). It will need to export this info...
by: Pam Ammond | last post by:
I need the code to update the database when Save is clicked and a text field has changed. This should be very easy since I used Microsoft's wizards for the OleDBAdapter and OleDBConnection, and...
by: CM Manager via DotNetMonster.com | last post by:
I am very frustrated due to this exception error I am receiving. I've tried searching numerous user support groups, Microsoft Support Net, Google, etc. and haven't found exactly my situation....
by: nicolegw | last post by:
I've tried googling for the answer to my question, so my apologies if it's been asked before or is terribly obvious. I'm a volunteer doing data entry for research. My office has an Access...
by: rustyc | last post by:
Well, here's my first post in this forum (other than saying 'HI' over in the hi forum ;-) As I said over there: ... for a little side project at home, I'm writing a ham radio web site in...
by: bradman1861 | last post by:
hello i am getting a overflow error when I try to run this: here is the error: System.Data.OleDb.OleDbException was unhandled Message="Overflow" Source="Microsoft JET Database Engine" ...
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.