PHP和mysql帮助SELECT,INSERT和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

展开 | 选择 | Wrap | 行号

equid确实有效已经测试过了。这段代码虽然没有提升,但是
equid does work i have tested it. This code is not picking up the simparentid though

展开 | 选择 | Wrap | 行号


由于itequip.equid是一个字符字段,请将其括起来引号中的值。
Since itequip.equid is a character field, enclose the value in quotes.
展开 | 选择 | Wrap | 行号


我改变了这个但没有区别:S
I have changed this but no difference :S