GroundZeroStudio Posted February 24, 2007 Share Posted February 24, 2007 <?php session_start(); $user="****"; $host="****"; $password="****"; $database="****"; $connection = mysql_connect($host, $user,$password) or die("Couldn't connect to a valid server."); $db = mysql_select_db($database, $connection) or die("Couldn't select a valid database"); $sql = "INSERT INTO ClientData2 (LoginName, Discount,ServiceCount,Service1,Service2,Service3,Service4,Service5,CourseCount,Course1, Course2,Course3,Course4,Course5,Title,Reviews,Admin) VALUES ('bob','none',none,null,null,null,null,null,none,null,null,null,null,null,'Client','none','no')"; $result = mysql_query($sql) or die("Unable to execute the Critical MySQL query #1"); header("login.php"); ?> I keep getting Unable to execute the Critical MySQL query #1 for no reason. All that should work Link to comment https://forums.phpfreaks.com/topic/39875-mysql-query-error/ Share on other sites More sharing options...
Barand Posted February 24, 2007 Share Posted February 24, 2007 When it dies, check the value of mysql_error() instead of your current message Link to comment https://forums.phpfreaks.com/topic/39875-mysql-query-error/#findComment-192694 Share on other sites More sharing options...
GroundZeroStudio Posted February 24, 2007 Author Share Posted February 24, 2007 how do i do that? Link to comment https://forums.phpfreaks.com/topic/39875-mysql-query-error/#findComment-192695 Share on other sites More sharing options...
Archadian Posted February 24, 2007 Share Posted February 24, 2007 die(mysql_error()); Link to comment https://forums.phpfreaks.com/topic/39875-mysql-query-error/#findComment-192700 Share on other sites More sharing options...
mmarif4u Posted February 24, 2007 Share Posted February 24, 2007 <?php session_start(); $user="****"; $host="****"; $password="****"; $database="****"; $connection = mysql_connect($host, $user,$password) or die("Couldn't connect to a valid server."); $db = mysql_select_db($database, $connection) or die("Couldn't select a valid database"); $sql = "INSERT INTO ClientData2 (LoginName, Discount,ServiceCount,Service1,Service2,Service3,Service4,Service5,CourseCount,Course1, Course2,Course3,Course4,Course5,Title,Reviews,Admin) VALUES ('bob','none',none,null,null,null,null,null,none,null,null,null,null,null,'Client','none','no')"; $result = mysql_query($sql) or die("Unable to execute the Critical MySQL query #1"); header("login.php"); ?> I keep getting Unable to execute the Critical MySQL query #1 for no reason. All that should work Change this: ('bob','none',none,null,null,null,null,null,none,null,null,null,null,null,'Client','none','no')"; To this: ('bob','none','none',null,null,null,null,null,'none',null,null,null,null,null,'Client','none','no')"; Link to comment https://forums.phpfreaks.com/topic/39875-mysql-query-error/#findComment-192713 Share on other sites More sharing options...
Jessica Posted February 24, 2007 Share Posted February 24, 2007 You can leave out all the null columns. Link to comment https://forums.phpfreaks.com/topic/39875-mysql-query-error/#findComment-192721 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.