MS SQL Query Failure

[uchacker11]

I am trying to run a Select statement that will return an int to then be fed into an insert statement but I keep getting the following error:

 

Warning: mssql_query() [function.mssql-query]: message: Conversion failed when converting the varchar value 'Resource id #3' to data type int. (severity 16) in C:\www\Rentals\Add\InsertRenter.php on line 33

 

$server = 'HomeServer';

$link = mssql_connect($server, 'username', 'password');

if(!$link)
{
    die('Failure to connect to Server');
}

$db = mssql_select_db('Rentals', $link) or die('Database Connection Failed');

$Last=$_POST['RenterLast'];
$First=$_POST['RenterFirst'];
$Temp=$_POST['RenterHouse'];
$Sec8ID=$_POST['RenterSec8ID'];
$MoveInDate=$_POST['RenterMoveInDate'];
$MoveOutDate=$_POST['RenterMoveOutDate'];
$Phone=$_POST['RenterPhone'];
$Deposit=$_POST['RenterDeposit'];
$Sec8Payment=$_POST['RenterSec8Payment'];
$RenterPayment=$_POST['RenterRenterPayment'];
$Comments=$_POST['RenterComments'];

$HouseIDLookup = "SELECT HouseID from Houses WHERE Alias LIKE '$Temp'";

$HouseID = mssql_query($HouseIDLookup, $link, 0);

$query= "INSERT INTO Renters ([LastName], [FirstName], [HouseID], [section8ID], [MoveInDate], [MoveOutDate], [Phone], [Deposit], [section8PaymentAmt], [RenterPaymentAmt], [Comments]) VALUES ('$Last', '$First', '$HouseID', '$Sec8ID', '$MoveInDate', '$MoveOutDate', '$Phone', '$Deposit', '$Sec8Payment', '$RenterPayment', '$Comments')";

$insert = mssql_query($query, $link, 0);
?>

 

Any help would be greatly appreciated!

[trq]

$HouseID is a result resource, you seem to be trying to insert it back into your database.

[uchacker11]

Yes i am trying to insert it into a different table within my database as a foreign key constraint.  I need to select the HouseID from Houses table using the Alias field in the Houses table, then insert the HouseID field into the Renters table.

[trq]

You need to pass your result resource ($HouseID) to mssql_fetch_assoc to actually get the data you want.

[uchacker11]

Thanks for the help but now i get a similar error:

 

Warning: mssql_query() [function.mssql-query]: message: Conversion failed when converting the varchar value 'Array' to data type int. (severity 16) in C:\www\Rentals\Add\InsertRenter.php on line 34

 

I added the line: $House = mssql_fetch_assoc($HouseID);

 

Did i mess up syntax or something

[trq]

So now your trying to insert $House? $House is an array.

 

Did you actually look at the examples in the manual page I pointed you too? Do so, your missing the absolute basics here.

[uchacker11]

Sorry I am very new to PHP but i figured it out using mssql_result().

[trq]

You could have used...

 

$House = mssql_fetch_assoc($HouseID);

 

then insert....

 

$House['HouseID']

 

into your query.