Please check my code it does not fetch any records!

sanjum · #1 08-Sep-2005, 08:23

Can someone help me with following code. It does not fetch any record. It is supposed to get bizID, bizName from businesses table by getting bizIDs from the lookup table(busCats)

PHP Code:


<?php require_once('Connections/connSasell.php'); ?>
<?php
$colname_Recordset1 = "1";
if (isset($_GET['catID'])) {
  $colname_Recordset1 = (get_magic_quotes_gpc()) ? $_GET['catID'] : addslashes($_GET['catID']);
}
mysql_select_db($database_connSasell, $connSasell);
$query_Recordset1 = "SELECT businesses.bizID, businesses.bizName FROM businesses, busCats WHERE businesses.bizID IN (' SELECT buscats.bizID FROM buscats WHERE buscats.catID = " . $colname_Recordset1 . "')";
$Recordset1 = mysql_query($query_Recordset1, $connSasell) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>

I am new to PHP aqnd trying to get help from Greamweaver code to create my own code. Your help will be very much appreciated.

dannybedor · #2 21-Sep-2005, 03:38

You should provide more detail about what you get in result, error or just blank page etc.

BTW, I notice this line:

Code:

$query_Recordset1 = "SELECT businesses.bizID, businesses.bizName FROM businesses, busCats WHERE businesses.bizID IN (' SELECT buscats.bizID FROM buscats WHERE buscats.catID = " . $colname_Recordset1 . "')";

Change it to below:

Code:

$query_Recordset1 = "SELECT businesses.bizID, businesses.bizName FROM businesses WHERE businesses.bizID IN (SELECT buscats.bizID FROM buscats WHERE buscats.catID = " . $colname_Recordset1 . ")";

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Re: Formatting C / C++ code	WaltP	C Programming Language	1	07-Jan-2008 00:59
Guidelines for posting requests for help - UPDATED!	WaltP	C++ Forum	0	21-Apr-2005 03:44
Problem with int mixed with char,...	leitz	C++ Forum	17	07-Dec-2004 21:56
Help! Some basal questions about MFC	xutingnjupt	MS Visual C++ / MFC Forum	1	05-Dec-2004 04:38

Please check my code it does not fetch any records!

Re: mysql query does not fetch records