SQL query gone bad?

mw-dnb

if ($listtype) {
	$result = mysql_query("SELECT id, profile_type, artist, city, state, points, image, bio, views, enabled FROM artist_profiles WHERE profile_type='$listtype' ORDER BY points DESC",$db); //
} else {
	$result = mysql_query("SELECT id, profile_type, artist, city, state, points, image, bio, views, enabled FROM artist_profiles ORDER BY points DESC",$db); // 
}

I'm getting an error on this line:

$result = mysql_query("SELECT id, profile_type, artist, city, state, points, image, bio, views, enabled FROM artist_profiles WHERE profile_type='$listtype' ORDER BY points DESC",$db);

i basicly want to retrieve the needed fields from artist_profiles where the profile_type is equal to the type submitted.

bastien

if you echo out the $listtype ...does it have a value?

if you have a newer version of php you may need to use $POST or $GET to access variables posted from a form

if (isset($_POST['listtype'])) {

see

http://www.php.net/manual/en/reserved.variables.php

mw-dnb

when i added the isset it seemed to work properly. However it didn't retrieve the variable with post ? (strange)

It may be because i'm submitting it from a URL like index.php?listtype=value

Weedpacket

Not strange at all; like bastien said, "... or $_GET".