a question:

if i have this:

for ($n = 1; $n <= $quiz[number_answers]; $n++) {
        $table = $qcode."_answers";
        $value = $answers["answer".$n];
        $value2 = "answer".$n;

        $query_alter_table = "ALTER TABLE $table ADD $value2 TEXT NOT NULL";
        $query_add_answers = "INSERT INTO $table ($value2) VALUES('$value')";
        if (mysql_db_query($database_glob, $query_alter_table, $link_glob)) {
                if (mysql_db_query($database_glob, $query_add_answers, $link_glob)) {
                        echo "Answer $n: $value has successfully been added to the 
Quiz<br>\n";
                } else {
                        echo mysql_error() ." 1<br>";
                }
        } else {
                echo mysql_error()." 2<br>";
        }
}

How do I get the $value to be in the same row as the preceding one?
now it comes like this:
+----+---------+---------+---------+---------+

| id | answer1 | answer2 | answer3 | answer4 |

+----+---------+---------+---------+---------+

|  1 | answer1 |         |         |         |
|  2 |         | answer2 |         |         |
|  3 |         |         | answer3 |         |
|  4 |         |         |         | answer4 |

+----+---------+---------+---------+---------+

so it's like this?
+----+---------+---------+---------+---------+

| id | answer1 | answer2 | answer3 | answer4 |

+----+---------+---------+---------+---------+

|  1 | answer1 | answer2 | answer3 | answer4 |

+----+---------+---------+---------+---------+

thanks,

Jule

On Friday 17 May 2002 19:17, you wrote:
> Hello,
>
> Try using "NOT NULL".  As weird as MySQL can be, don't think it is that
> NUTty.  =)
>
> Harrison
>
> ----- Original Message -----
> From: "Jule" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, May 17, 2002 7:00 PM
> Subject: "ALTER TABLE $table ADD $value2 TEXT NUT NULL"
>
>
> Hey i'm getting this error:
>
> You have an error in your SQL syntax near 'NUT NULL' at line 1
>
> when i run this query,
>
> "ALTER TABLE $table ADD $value2 TEXT NUT NULL"
>
> from the documentation i understood that this was the correct notation.
>
> any ideas?
> thanks
> Jule
> --
>
> |\/\__________________________/\/|
> |   Jule Slootbeek |
> |   [EMAIL PROTECTED] |
> |   http://blindtheory.cjb.net |
> |   __________________________ |
> |/\/       \/\|
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]> Trouble
> unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

--

|\/\__________________________/\/|
|   Jule Slootbeek               |
|   [EMAIL PROTECTED]        |
|   http://blindtheory.cjb.net   |
|   __________________________   |
|/\/                          \/\|

-------------------------------------------------------

-- 
|\/\__________________________/\/|
|   Jule Slootbeek               |
|   [EMAIL PROTECTED]        |
|   http://blindtheory.cjb.net   |
|   __________________________   |
|/\/                          \/\|

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to