update table set answer3=5 where id=2;
miguel
On Fri, 17 May 2002, Jule wrote:
> 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 |
> | __________________________ |
> |/\/ \/\|
>
> -------------------------------------------------------
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
