[prog] more php

[Anthony Gorecki]

The problem is with the SQL query assembley.

> $query_Recordset1 = "SELECT term, year FROM term WHERE
> s_code=193497764;";
> $query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1,
> $startRow_Recordset1, $maxRows_Recordset1);

Will give you a query of:
SELECT term, year FROM term WHERE s_code=193497764; LIMIT <snip>

To fix it, remove the semicolon from the end of $query_Recordset1. Hope that 
helps.


On Tuesday 16 September 2003 5:04 pm, Saint-Wolfe wrote:
> Okay I'm trying this using the php plug ins via dreamweaver : ) but I
> am still receiving an error, can
> anyone out there see what the syntax error might be?
>
> the error message:
>
> You have an error in your SQL syntax near '; LIMIT 0, 1' at line 1
<snip>

-- 
Best Regards,

Anthony Gorecki
VSD Technologies