hmm...
1) are you sure there is an ID field in your database?
2) after setting $query, echo it back out and make sure it is ok
3) i dunno...
Split mysql results into pages?????
Moderator: General Moderators
-
mikegotnaild
- Forum Contributor
- Posts: 173
- Joined: Sat Feb 14, 2004 5:59 pm
-
Illusionist
- Forum Regular
- Posts: 903
- Joined: Mon Jan 12, 2004 9:32 pm
-
mikegotnaild
- Forum Contributor
- Posts: 173
- Joined: Sat Feb 14, 2004 5:59 pm
-
Illusionist
- Forum Regular
- Posts: 903
- Joined: Mon Jan 12, 2004 9:32 pm
-
mikegotnaild
- Forum Contributor
- Posts: 173
- Joined: Sat Feb 14, 2004 5:59 pm
go here. http://naild.com/localmm Click on Bands showcase than go to Acoustic.. Thats the page im lookin at. Its acoustic.php. Its the first page. Ok in the select statement i put ' ' around like this . SELECT * FROM Acoustic WHERE ID='$id'"; and the error went away. but there isnt no query results.. just my $query echo But when i echo the $query it shows this "Query: SELECT * FROM Acoustic WHERE ID='' " $id isnt putting out anything. I have a question though.. what is 'band' in this $id = $_GET['band'];? I am very lost now.
-
Illusionist
- Forum Regular
- Posts: 903
- Joined: Mon Jan 12, 2004 9:32 pm