[Resolved] Query issues

AndrewWest

It's been a long productive day... not many problems, and have slammed the door shut on a lot of issues that are now fixed.

Now, my brain is not thinking, so I'll hope someone who's fresh can help me with this..

$query = "UPDATE configs SET option='".$_POST['board_status']."' WHERE name=board_status";
      mysql_query($query) or die('Invalid query: ' . mysql_error());

$query2 = "UPDATE configs SET option='".$_POST['board_offline_messages']."' WHERE name=board_offline_message";
      mysql_query($query2) or die('Invalid query: ' . mysql_error());

I've error handled, and even printed to look at the query right, and nothing is helping me.

jordy

Hmz maybe you should post the error aswell.. but try changing:

WHERE name=board_status

in:

WHERE name = 'board_status'

Jordy

AndrewWest

Ok, the code is

$query = "UPDATE configs SET option='".$_POST['board_status']."' WHERE name = 'board_status'";
  mysql_query($query) or die('Invalid query: ' . mysql_error());

And the error is

Invalid query: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'option='rr' WHERE name = 'board_status'' at line 1

AndrewWest

I was just looking at that error again.. and look at this..

Code:

= 'board_status'";

Error:
= 'board_status''

What could cause that?

jordy

The query must be correct now.. are you sure that the table name and field names are correct?

AndrewWest

Yes they exist, and are 100% correct. The query is throwing errors still so it can't be correct. It has to be wrong somewhere.

It's still throwing the You have an error in your SQL syntax error, so my coding is wrong evidentally.. o-O

jordy

owww check.. option is a reserved word...

try: option= '".$_POST['board_offline_messages']."'

AndrewWest

WOW all that and the coding was correct. I didn't realize that option was reserved o-O..

Thanks!! Works. Now..

Now here's a question..that just hit me.

I'm trying to make forms have some default data in them already.. generated by php

Template

    <form method='post' action="index.php?page=admin_boardonoff">
    <tr>
    <td class='forumcell' width='20%'>Board Status</td>
    <td class='forumcell' width='80%'><input name="board_status" MAXLENGTH="3" value="<? echo($config['board_status']); ?>">&nbsp; Change this to off or on.</td>
    </tr>
    <tr>
    <td class='forumcell' width='20%'>Board Offline Message</td>
    <td class='forumcell' width='80%'><input name="board_offline_message" value="<?  echo($config['board_offline_message']); ?>">&nbsp; Change your away meesage if your board is offline.</td>
    </tr>
    <tr>
    <td colspan='2' class='forumcell' width='100%' align='center'><input type='submit' name='submit' value='Update Board'></td>
    </tr>
    </form>

Now here's my code for it.

 $configs = mysql_query("SELECT * FROM configs");
 $config = mysql_fetch_array($configs);

Now, any reason why this wouldn't show correctly?

jordy

try:

  $configs = mysql_query("SELECT * FROM configs"); 
  $config = mysql_fetch_array($configs, MYSQL_ASSOC);
  $rows = mysql_num_rows($configs);
  echo "<pre>";
  echo "containing $rows rows \n ";
  print_r($config);

if you fetch zero rows there is no data fetched.. now you should see the content of the array recursivly..
if the html template is another file you include you need to make the config variable a global variable.. <? global $config ?>

AndrewWest

This is doing what I'd pictured it would.

Here maybe this will help.

My database is setup like this.

id name option
1 name blah blah blah
2 name2 blah2 blah2 blah2

and so on..

It seems like they code you exampled for me only give me the id,name, and option from row one.

How should I setup my database to select it as

$config['board_status'];

and then I'd like to show that as a default value in the form.

Thanks

AndrewWest

Nevermind 🙂 I got everthing under control lol thanks!!