Quick little followup 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 |
| __________________________ |
|/\/ \/\|
---------------------------------------------------------------------
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
