liamloveslearning Posted May 18, 2010 Share Posted May 18, 2010 Hi everyone, I have a page where im currently creating a list which isnt outputting anything, Can anybody cast there eye over it and notice whats wrong? <?php virtual('/Connections/intra_conn.php'); ?> <?php if (!function_exists("GetSQLValueString")) { function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { if (PHP_VERSION < 6) { $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; } $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue); switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? doubleval($theValue) : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue; } } mysql_select_db($database_intra_conn, $intra_conn); $query_getorders = "SELECT * FROM worksorders WHERE worksorders.intradelete != 1"; $getorders = mysql_query($query_getorders, $intra_conn) or die(mysql_error()); $row_getorders = mysql_fetch_assoc($getorders); $totalRows_getorders = mysql_num_rows($getorders); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <title>Untitled Document</title> </head> <body> <table width="175%" border="0" cellspacing="0" cellpadding="0"> <?php do { ?> <tr> <th scope="col"><?php echo $row_getorders['id']; ?></th> <th scope="col"><?php echo $row_getorders['intrajobno']; ?></th> <th scope="col"><?php echo $row_getorders['intratype']; ?></th> <th scope="col"><?php echo $row_getorders['intrastatus']; ?></th> <th scope="col"><?php echo $row_getorders['intracustomer']; ?></th> <th scope="col"><?php echo $row_getorders['intradescription']; ?></th> <th scope="col"><?php echo $row_getorders['intraorder']; ?></th> <th scope="col"><?php echo $row_getorders['intraartapproval']; ?></th> <th scope="col"><?php echo $row_getorders['intraestimatedinstall']; ?></th> <th scope="col"><?php echo $row_getorders['intraprio']; ?></th> <th scope="col"><?php echo $row_getorders['intrajobvalue']; ?></th> <th scope="col"><?php echo $row_getorders['intraterms']; ?></th> <th scope="col"><?php echo $row_getorders['intrajobref']; ?></th> <th scope="col">update/delete</th> </tr> <?php } while ($row_getorders = mysql_fetch_assoc($getorders)); ?> </table> </body> </html> <?php mysql_free_result($getorders); ?> Link to comment https://forums.phpfreaks.com/topic/202155-php-not-outputting-error/ Share on other sites More sharing options...
liamloveslearning Posted May 18, 2010 Author Share Posted May 18, 2010 is there an alternative to or die(mysql_error()) so i can possibly see if it flags anything up? Link to comment https://forums.phpfreaks.com/topic/202155-php-not-outputting-error/#findComment-1060081 Share on other sites More sharing options...
liamloveslearning Posted May 18, 2010 Author Share Posted May 18, 2010 sorted it, Ive no idea why but I had no require for one of my variables Link to comment https://forums.phpfreaks.com/topic/202155-php-not-outputting-error/#findComment-1060087 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.