Hi folks
Just looking for some advice as to what is the most efficient way to do the following, there are several ways but some expertise on efficiency would be great!? Thanks for advice in advance!
There is a MySQL table which contains 'Products' which is outside of my control. There are...
Hi all
Bit of Sunday morning coding for a PHP newbie, been working with SQL for years. I can't figure the following out despite spending hours trawling google.
I have a PHP site which the user logs onto. Once logged on they have access to the rest of the site. These secure PHP pages display...
Hi there
I am a little new to php having been working in the dark world of databases for many years. I am in the process of creating my first website but whilst the php and the database stuff work great I cannot get the two to talk. The error is: DB connection failed: Access denied for user...
Hi there,
To many of you this will seem like a really simple problem (new to this, old hat with SQL) but I have been trying to get this to work for almost all of my spare time over the last two nights and now am like David Hasselhoff in a russian vodka silo!!!
I am simply trying to achieve the...
Hi there
I am relatively new to php finding it a powerful and useful language, quick question about the include statement. Can I use it to include some generic code within the middle of a php function? Several of my pages access the same switch statement with a small set of core data in it. To...
Ok, think we might be getting somewhere
Remou - That is what i did (paste the SQL into the query design view and run it, I could not edit the fields)
Fneily - those are not the actual field names, I have simplified the code for brevity and I understand your comments about relational design but...
Remou - as requested
1. Yes I can edit the tables
2. No it is not possible to edit a query using the same SQL as this is a select query
3. The controls are not locked and not disabled
4. The form allows edits but not additions or deletions
I agree that the problem might be that the form is...
Hi there
I have a relatively simple form which is populated by a record source. The record source is an SQL statement defined in code in the Open event (see code below). The form loads all the records nicely but I cannot edit any of the fields!!
All the fields are enabled and not locked, the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.