expecting T_STRING !!!

Anon

Could someone please tell me why I get a "expecting 'T_STRING' ... on line 11". This script is sent $equip_desc from a web form.

<?php
require 'common.inc' ;
require 'functions.php' ;
$link = mysql_pconnect($DB_SERVER, $DB_LOGIN, $DB_PASSWORD);
$result_stock = mysql_db_query($DB, "select * from master, equip, stock WHERE master.mid = equip.RELmid AND equip.eid = stock.RELeid AND master.desc = $equip_desc LIMIT 1");

echo $equip_desc;

while(($stock_details = mysql_fetch_array($result_stock)))
{
$result_stock_details = mysql_db_query($DB, "INSERT INTO loan (lid, RELeid, 'RELmid') VALUES ('', '$stock_details["RELeid"]', '$stock_details["RELmid"]')";
};

Thanks,
Hereward

Anon

It looks like your problem is with $stock_details["RELeid"] in the SQL statement -- I think the double quote is the problem, remember, your entire SQL statement is double quoted. In that situation you might also need to use the complex syntax {}. Perhaps the easiest solution in this case would be to concatenate those varaibles into the SQL statement string.

Anon

Ok now rather than having an array in the mysql statement, I've made them a normal variable by defineing them before had. But now I just get a lovley "Supplied argument is not a valid MySQL result resource on line 25", the 'while' line.

<?php
require 'common.inc' ;
require 'functions.php' ;
$link = mysql_pconnect($DB_SERVER, $DB_LOGIN, $DB_PASSWORD);
echo $master_desc;
$query_stock = mysql_db_query($DB, "select * from master, equip, stock WHERE master.mid = equip.RELmid AND equip.eid = stock.RELeid AND master.desc = $equip_desc LIMIT 1");
while(($stock_details = mysql_fetch_array($query_stock))) {
$RELeid = $stock_details["RELeid"];
$RELmid = $stock_details["RELmid"];
$copy_stock_details = mysql_db_query($DB, "INSERT INTO loan (lid, RELeid, RELmid) VALUES ('', $RELeid, $RELmid)");
}
?>

Thanks,

Hereward

[deleted]

Print the query before you execute it.
Use errorchecking, print mysql_error() when the query fails.

psr540

from the error msg, you should try to check $query_stock first, if anything is wrong in you first query, $query_stock will be false rather then a "valid sql source"