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
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