Forums

This topic is locked

Help, problem with SQL

Posted 12 Jun 2001 10:26:02
1
has voted
12 Jun 2001 10:26:02 vu the anh posted:
Hello everybody,
I use PHAkt 0.82 and have problem with SQL, could you show me what's wrong here?

Thanks a lot
<?php
$banghi1__MMColParam = "-1";
if (isset($protype))
{$banghi1__MMColParam = $protype;}
?><?php
$banghi1=$ketnoi->Execute("SELECT * FROM Projects WHERE "Project Type" like " . ($banghi1__MMColParam) . "" or DIE($ketnoi->ErrorMsg());
$banghi1_numRows=0;
$banghi1__totalRows=$banghi1->RecordCount();
?>

Replies

Replied 12 Jun 2001 10:38:26
12 Jun 2001 10:38:26 vu the anh replied:
AND this line alway appear in screen <img src=icon_smile_dissapprove.gif border=0 align=middle>
Note: I test in Recordset - that's OK, but when I upload it, I receive error message

Parse error: parse error in c:\inetpub\wwwroot\php\oda directory\test4action.php on line 15

Replied 14 Jun 2001 06:00:38
14 Jun 2001 06:00:38 vu the anh replied:
that sound crazy, but I solve this problem by myself after 2 day hard working,
PHAkt 0.83 creat SQL with "" and that's not good for parsing any from previous form, I change it into ',


Reply to this topic