Re^4: Explain SQL statement

Tried and ruturned nothing

$sql ="SELECT * FROM app_admin WHERE day = '$d' AND month = '$m_num' A
+ND year = '$y' AND NUMALL ='?' AND status= '2' ";
[download]

Tks...

Comment on Re^4: Explain SQL statement Download Code

Replies are listed 'Best First'.
Re^5: Explain SQL statement by herveus (Prior) on May 26, 2004 at 14:08 UTC
Howdy! You quoted the question mark. Don't do that. Read my previous note carefully. The naked ? gets replaced by the value you pass to the execute command, and DBI makes sure it is properly quoted. You want `NUMALL = ?`, not `NUMALL = '?'`. yours, Michael	[reply] [d/l] [select]
Re^6: Explain SQL statement by Anonymous Monk on May 26, 2004 at 14:58 UTC
Tried that to, this is a wierd problem....	[reply]