is this syntax correct?

lukeurtnowski

here's my php code, but its not doing anything. Is the syntac right?

$sql="Select * From COMPANY As C Inner Join ACTIVITY AS A On A.C_NUMBER = C.C_NUMBER
Where C.A_DATE = '$date'";
$result = mysql_query($sql); 
//$numofrows = mysql_num_rows($result); 
echo $result;

mrhappiness

$sql="Select * From COMPANY As C Inner Join ACTIVITY AS A On A.C_NUMBER = C.C_NUMBER
Where C.A_DATE = '$date'";
$result = mysql_query($sql) or die(mysql_error());

do you get an error message?

http://www.php.net/manual/ref.mysql.php will help you with working with mysql

lukeurtnowski

when this is run and I echo tha variable, I get "Resource id #2", and not three seperate numbers
?php
$hostname = "10.0.0.127";
$username = "lukeu";
$password = "blues7";
$database = "test";
$connection = mysql_connect($hostname , $username , $password)
or die("cannot make connection");
$db = mysql_selectdb($database , $connection)
or die("cannot find database");
$sql="Select * From COMPANY As C Inner Join ACTIVITY AS A On A.C_NUMBER = C.C_ID
Where A.A_DATE = '$date'";
$result = mysql_query($sql) or die(mysql_error());
//select a.A_fields, c.C_fields from activity a, company c
//where a.A_DATE in '$date'
//and a.C_number=c.C_number
//$numofrows = mysql_num_rows($result);
echo $result;
?>

mrhappiness

Originally posted by mrhappiness
http://www.php.net/manual/ref.mysql.php will help you with working with mysql

hth

lukeurtnowski

Ok, I shortened it a lot, Here's my php code.
<?php
$hostname = "10.0.0.127";
$username = "";
$password = "blues7";
$database = "test";
$connection = mysql_connect($hostname , $username , $password)
or die("cannot make connection");
$db = mysql_selectdb($database , $connection)
or die("cannot find database");
$sql="Select From COMPANY As C Inner Join ACTIVITY AS A On A.C_NUMBER = C.C_ID Where A.A_DATE ='".$date."'";
$result = mysql_query($sql) or die(mysql_error());
$numofrows = mysql_num_rows($result);
?>
heres some more to display the results of the query in a table..
while ($row = mysql_fetch_object($result)){
print "<TD>".$row->C_NAME."</TD>";
print "<TD>".$row->C_CITY.", ".$row->C_STATE."</TD>";
print "<TD>".$row->C_DESC."</TD>";
print "<TD>".$row->RATIONALE."</TD>";
print "<td>".$row->contact_NAME."</TD>";
print "<td>".$row->contact_PHONE."</td>";
print "<TD>".$row->A_DATE."</TD>";
print "<TD>".$row->A_DESC."</TD>";
print "<td>".$row->NEXT."</TD>";
print "<td>".$row->MEDIVAS."</td>";
print "</TR>\n";
}

for some reason, it returns only the results where C_NUMBER is equal in the ACTIVITY table, not where A_DATEs' are equal. Shouldn't the query return only instances where A_DATE's are equal.
thanks

mrhappiness

i don't know the value of $date

please do

echo $sql;

and post the result