Originally Posted by Will Green
|
Yay, TehUpload =] My site.
Originally Posted by VernonK
That's pretty much what we've been doing... Do this...
PHP Code:
<?php echo $s; //echo the query out ?>
Then take that query string and go to phpMyAdmin. Click on the SQL tab at the top and then paste the query string in and hit go. What happens?
I would really love to see what the actual query string looks like. There isn't anything wrong with the sample query structure's we've given... that's the strange thing.
One thing I did notice just now... you don't have a Primary Key set on the settings table. Each table should have a primary key field.
|
Not every table needs a primary key,
In relational database design, a unique key or primary key is a candidate key to uniquely identify each row in a table
|
If there is just one row, I do believe that you do not need a primary key. As that just organizes it and identifies the row, otherwise it would just be like finding a needle in a haystack?
The problem may have been you didn't have a row in the first place, which would mean it would not update anything, and just display blank fields.
Did you end up creating a row inside of that table?