Code Forums - View Single Post

EdB · 09-09-2004, 04:22 AM

Hi,

I have inherited some code that does not work, but I am no SQL programmer. Please could someone help me?

Code:

<?php require_once('Connections/connect.php'); ?>
<?php
mysql_select_db($database_connect, $connect);
$query_cases = "SELECT *, date_format(date, '%D %M %Y') as formatted_casesdate FROM cases WHERE cases.case_id=$cid";
$cases = mysql_query($query_cases, $connect) or die(mysql_error());
$row_cases = mysql_fetch_assoc($cases);
$totalRows_cases = mysql_num_rows($cases);
$prepath="http://www.abcdefghij.com/docs/case/";
?>

Ok, if I load this page I get:
You have an error in your SQL syntax near '' at line 1

If I remove this part of the code:

Code:

or die(mysql_error());

The page loads, it does not work as it supposed to but at least I get something on the page. Can someone explain to me please what this code is doing?

Thanks in advance.

09-09-2004, 04:22 AM	#1 (permalink)
EdB Registered User Join Date: Sep 2004 Posts: 1	Help neded with SQL please Hi, I have inherited some code that does not work, but I am no SQL programmer. Please could someone help me? Code: <?php require_once('Connections/connect.php'); ?> <?php mysql_select_db($database_connect, $connect); $query_cases = "SELECT *, date_format(date, '%D %M %Y') as formatted_casesdate FROM cases WHERE cases.case_id=$cid"; $cases = mysql_query($query_cases, $connect) or die(mysql_error()); $row_cases = mysql_fetch_assoc($cases); $totalRows_cases = mysql_num_rows($cases); $prepath="http://www.abcdefghij.com/docs/case/"; ?> Ok, if I load this page I get: You have an error in your SQL syntax near '' at line 1 If I remove this part of the code: Code: or die(mysql_error()); The page loads, it does not work as it supposed to but at least I get something on the page. Can someone explain to me please what this code is doing? Thanks in advance.