acidglitter Posted November 22, 2006 Share Posted November 22, 2006 on one of my pages i have this..[code]mysql_query("INSERT INTO bulletin VALUES('','$referal','',NOW(),'1')");[/code]it inserts into the table but I can't figure out why its not putting the time. This is a pretty simple question but does anyone know whats wrong? Link to comment https://forums.phpfreaks.com/topic/28127-another-stupid-question/ Share on other sites More sharing options...
mb81 Posted November 22, 2006 Share Posted November 22, 2006 This is a mysql question, but what variable type is that field, is it datetime? Link to comment https://forums.phpfreaks.com/topic/28127-another-stupid-question/#findComment-128633 Share on other sites More sharing options...
acidglitter Posted November 22, 2006 Author Share Posted November 22, 2006 no its just date Link to comment https://forums.phpfreaks.com/topic/28127-another-stupid-question/#findComment-128639 Share on other sites More sharing options...
DeathStar Posted November 22, 2006 Share Posted November 22, 2006 For an time script use[code]?php $color = "greenyellow"; /* Default color */ if(isset($_REQUEST['color'])) { /* If color form submitted */ $color = $_REQUEST['color']; }?><html> <head> <title>ColoringPage</title> </head> <body bgcolor="<?php echo $color; ?>"> <h1>Chooze your background color:</h1> <form action="coloringPage.php" method='post'> <ul> <li><input type="radio" name="color" value="chocolate">chocolate</input></li> <li><input type="radio" name="color" value="burlywood">burlywood</input></li> <li><input type="radio" name="color" value="dodgerblue">dodgerblue</input></li> <?php /* and so on */ ?> </ul> <input type="submit" value="Change Color" /> </form> </form> </body></html>[/code] Link to comment https://forums.phpfreaks.com/topic/28127-another-stupid-question/#findComment-128663 Share on other sites More sharing options...
acidglitter Posted November 22, 2006 Author Share Posted November 22, 2006 [quote author=DeathStar link=topic=115927.msg472145#msg472145 date=1164216591]For an time script use[code]?php $color = "greenyellow"; /* Default color */ if(isset($_REQUEST['color'])) { /* If color form submitted */ $color = $_REQUEST['color']; }?><html> <head> <title>ColoringPage</title> </head> <body bgcolor="<?php echo $color; ?>"> <h1>Chooze your background color:</h1> <form action="coloringPage.php" method='post'> <ul> <li><input type="radio" name="color" value="chocolate">chocolate</input></li> <li><input type="radio" name="color" value="burlywood">burlywood</input></li> <li><input type="radio" name="color" value="dodgerblue">dodgerblue</input></li> <?php /* and so on */ ?> </ul> <input type="submit" value="Change Color" /> </form> </form> </body></html>[/code][/quote]umm....i already have everything, i'm just wondering whats wrong with it Link to comment https://forums.phpfreaks.com/topic/28127-another-stupid-question/#findComment-128691 Share on other sites More sharing options...
DeathStar Posted November 22, 2006 Share Posted November 22, 2006 Ok..But that is one that works fine already!Just letting you know. :D Link to comment https://forums.phpfreaks.com/topic/28127-another-stupid-question/#findComment-128696 Share on other sites More sharing options...
mansuang Posted November 22, 2006 Share Posted November 22, 2006 [quote author=acidglitter link=topic=115927.msg472174#msg472174 date=1164219839][quote author=DeathStar link=topic=115927.msg472145#msg472145 date=1164216591]For an time script use[code]?php $color = "greenyellow"; /* Default color */ if(isset($_REQUEST['color'])) { /* If color form submitted */ $color = $_REQUEST['color']; }?><html> <head> <title>ColoringPage</title> </head> <body bgcolor="<?php echo $color; ?>"> <h1>Chooze your background color:</h1> <form action="coloringPage.php" method='post'> <ul> <li><input type="radio" name="color" value="chocolate">chocolate</input></li> <li><input type="radio" name="color" value="burlywood">burlywood</input></li> <li><input type="radio" name="color" value="dodgerblue">dodgerblue</input></li> <?php /* and so on */ ?> </ul> <input type="submit" value="Change Color" /> </form> </form> </body></html>[/code][/quote]umm....i already have everything, i'm just wondering whats wrong with it[/quote]I confirm it works fine Link to comment https://forums.phpfreaks.com/topic/28127-another-stupid-question/#findComment-128697 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.