fabiez
-
Posts
25 -
Joined
-
Last visited
Everything posted by fabiez
-
problem solved.
-
I Can't find the problem. The code: mysql_query("insert into games(week, fight, league_id)values($_REQUEST['week'],'$_REQUEST[home_team]-$_REQUEST[guest_team]',$_REQUEST['home_league'])", $Link); The error message: Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING
-
thank you
-
what am i doing wrong? I can't see it... I want to catch the rand variable but it doesn't. So I print an extra print at the bottom. So there should be two rand prints. Here's the code. <html> <head><title></title> </head> <body> <form action='random.php' method='post'> <?php if(isset($_REQUEST['rand'])){ $rand = $_REQUEST['rand']; print $rand . "<br /><br />"; } else { print "rand: empty<br /><br />"; } $rand = rand(1,1000); print $rand."<br /><br />"; print "<input type='hidden' value='$rand' />"; ?> <input type='submit' value='scramble' /> </form> </body> </html> I forgot to tell ya that the if statement returns rand: empty. Help...
-
It's cause you chose to get ugroup instead of what you named the select field. Wich is group
-
I found the problem, I didn't close it with the slash. But your right it can be an open tag.
-
for($i=1; $i<=$round; $i++){ print "<tr><td align='left' valign='top'><input type='text' name='number$i' maxlength='2' size='2' /></td>\n "; print "<td align='left' valign='top'><input type='text' name='score$i' maxlength='1' size='1' /></td>\n "; print "<td align='left' valign='top'><select name='team$i'>\n"; print "<option value='-'>-<option>\n"; print "<option value='Home'>Home<option>\n"; print "<option value='Away'>Away<option>\n"; print "</select></td></tr>"; } What I'm having trouble with is that for every option tag there is an empty option tag added. How do I get rid of those empty option tags? Thankful for any help.
-
thanks
-
I'm trying to create a trigger that checks intries in a table. CREATE TRIGGER check_stored_stars BEFORE INSERT ON stored_stars FOR EACH ROW BEGIN IF NEW.user_id = OLD.user_id AND NEW.star_id = OLD.star_id ELSE INSERT INTO stored_stars(user_id, star_id) VALUES(NEW.user_id, NEW.star_id); END IF; END; But I get an error saying: #1363 - There is no OLD row in on INSERT trigger How do I solve this?
-
it said that there were too many icons. What are you looking for? cause they're all varchar.
-
Field Type Null Default Ändra Redigera Kopiera Radera n6 varchar(200) NO NULL
-
dte|n1|n2|n3|n4|n5|n6|comment1|ad1|ad2|ad3|ad4|ad5|ad6|comment2|ks1|ks2|ks3|ks4|ks5|ks6|comment3|ss1|ss2|ss3|ss4|ss5|ss6|comment4|comment5|comment6
-
Hi, I can write in my .xls file but 'n6' doesn't return anything. Help please? <?php require "config.php"; $date = time(); $domain = date('Y_m', $date); $datecase = date('m', $date); $file = $domain . ".xls"; /*datum*/ switch ($datecase) { case 1: $data = "Januari\n"; break; case 2: $data = "Februari\n"; break; case 3: $data = "Mars\n"; break; case 4: $data = "April\n"; break; case 5: $data = "Maj\n"; break; case 6: $data = "Juni\n"; break; case 7: $data = "Juli\n"; break; case 8: $data = "Augusti\n"; break; case 9: $data = "September\n"; break; case 10: $data = "Oktober\n"; break; case 11: $data = "November\n"; break; case 12: $data = "December\n"; break; } $data .= "\n\tNärvaro\t\tAktivt deltagande\t\tKognitivt stöd\t\tSocial samvaro\t\tKommentar\n"; $data .= "1\t\t1\t\t1\t\t1\t\t1\n"; $Result = mysql_query("select n6 from cards where dte='01 2013'", $Link); $Result = mysql_fetch_array($Result); data .= "$Result[n6]\n"; $data .= "2\t\t2\t\t2\t\t2\t\t2\n"; $data .= "3\t\t3\t\t3\t\t3\t\t3\n"; $data .= "4\t\t4\t\t4\t\t4\t\t4\n"; $data .= "5\t\t5\t\t5\t\t5\t\t5\n"; $data .= "6\t\t6\t\t6\t\t6\t\t6\n"; header("Content-Type: application/ms-excel"); header("Content-Disposition: attachment; filename=" . $file); header("Pragma: no-cache"); header("Expires: 0"); print $data; ?>