problem with next/prev code

Taneya

hey all,

Hoping once again somone can help 🙂

I had a friend of mine do a page for me that did next/prev links (b/c I didn't think i'd ever figure out how to do it myself!) but even her code doesn't work and I won't be able to get in touch with her for a few days.

Can someone look at this and see if they see anything obviously wrong?? The error message that I am getting is "unexpected T_variable on line 43. Here is a link to a Word doc that has the text of the file code.

http://www.taneya-kalonji.com/testing/testing.doc

This is the line that starts $result2 = mysql_query($query);

Any help would be greatly appreciated!

cgraz

In your code

	$query2="SELECT patterns.title, designers.name, patterns.stitchcount, patterns.picture, patterns.notes" .
       		" FROM patterns, designers, magname, magazines " .
       		" WHERE magazines.magnameid = 12 " .
       		"  AND patterns.designerid = designers.designerid " . 
       		"  AND magname.magnameid = magazines.magnameid ". 
       		"  AND magazines.magid = patterns.magid " .
			" ORDER BY title ASC";
       		" LIMIT $start, $rows "  // this is the syntax you

You have a semi-colon after ORDER BY title ASC then continue the query. You also have no semi-colon after the LIMIT part (which is where it should be). Try this

	$query2="SELECT patterns.title, designers.name, patterns.stitchcount, patterns.picture, patterns.notes" .
       		" FROM patterns, designers, magname, magazines " .
       		" WHERE magazines.magnameid = 12 " .
       		"  AND patterns.designerid = designers.designerid " . 
       		"  AND magname.magnameid = magazines.magnameid ". 
       		"  AND magazines.magid = patterns.magid " .
		" ORDER BY title ASC" .
       		" LIMIT $start, $rows";  // this is the syntax you

Cgraz