I have changed a column in my database from the primary Key to Index, as i need to allow the same reference in the column for multiple entries with different dates against them, but now i need to adjust my queries. how do i do this?
morrisproject
0
Junior Poster in Training
Recommended Answers
Jump to PostWhich queries do you need to adjust? In which queries do you refer explicitly to the primary key?
Jump to PostThe query does not change, regardless of the index structure of the table. As long as you do not explicitly refer to the index in your query, the index structure does not matter to the query statement. The index helps the database engine to answer queries more efficiently, but this …
Jump to PostYou are confusing PHP errors with mysql messages.
Your line of code$query_Recordset1 = "SELECT * FROM conveyor_number WHERE conveyor_number.`Conveyor Number` = '$id'
is just a PHP operation and has only semantical links to MySQL but does not execute any MySQL code. $id may be undefined because …
All 11 Replies
smantscheff
265
Veteran Poster
morrisproject
0
Junior Poster in Training
smantscheff
265
Veteran Poster
morrisproject
0
Junior Poster in Training
smantscheff
265
Veteran Poster
morrisproject
0
Junior Poster in Training
smantscheff
265
Veteran Poster
morrisproject
0
Junior Poster in Training
smantscheff
265
Veteran Poster
morrisproject
0
Junior Poster in Training
smantscheff
265
Veteran Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.