PHP和mysql帮助SELECT，INSERT和UPDATE [英] PHP and mysql help SELECT, INSERT and UPDATE
问题描述
你好，如果有人可以提供帮助就会很棒
在这个项目中，我有2个项目的移动和simcard，这些是在一个表中作为两个记录，并有一个独特的equid每。 simcard也在另一个名为siminfo的表中，并且有一个用于创建链接的parentid（与移动设备相同）。在设备表中还有用户ID
我已经有单独传输这些项目的代码，但我希望能够在我转移SIM卡时将它们都传输。我目前有跟随但由于某种原因它不起作用。变量$ equid确实有效，我测试了它。这段代码虽然没有提升，但是
hello, if anyone can help would be great
On this project I have got 2 items a mobile and simcard, these are in one table as two records and have a unique equid each. the simcard is also in another table called siminfo and has a parentid (which is the same equid as the mobile) to create the link. In the equipment table there is also userid
I already have code that transfers these items individually, but i want to be able to transfer them both when i transfer the sim card. I currently have the followin but its not working for some reason. the variable $equid does work i have tested it. This code is not picking up the simparentid though
推荐答案
equid确实有效已经测试过了。这段代码虽然没有提升，但是
equid does work i have tested it. This code is not picking up the simparentid though
由于itequip.equid是一个字符字段，请将其括起来引号中的值。
Since itequip.equid is a character field, enclose the value in quotes.
我改变了这个但没有区别：S
I have changed this but no difference :S
这篇关于PHP和mysql帮助SELECT，INSERT和UPDATE的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
