[SOLVED] sql query not working....

[Zeradin]

I have an id=1 being returned to this. I know that isn't the problem because i echo'd the id before the query:

 

else {
// create query
$query = 'SELECT type FROM reviews WHERE id = '.$id.'';
// execute query
$result = mysql_query($query) or die ("Error in query: $query. ".mysql_error());

switch ($result) {
			case show:
			include('reviews/show.php');
			break;
			case album:
			include('reviews/album.php');
			break;
			case venue:
			include('reviews/venue.php');
			break;
			}
}

 

now when i echo out $result I get "Resource id #5" that's not right. i am looking at my reviews table and there is an id one and the type is show, but it's not getting that value. please help, i'm almost done with this thing.

[pocobueno1388]

Try

 

<?php

else {
// create query
$query = 'SELECT type FROM reviews WHERE id = '.$id.'';
// execute query
$result = mysql_query($query) or die ("Error in query: $query. ".mysql_error());
        $row = mysql_fetch_assoc($result);

switch ($row['type']) {
			case show:
			include('reviews/show.php');
			break;
			case album:
			include('reviews/album.php');
			break;
			case venue:
			include('reviews/venue.php');
			break;
			}
}

[Zeradin]

amazing thank you!

 

just curious so i actually learn what's going on here why wasn't what i was doing working?

 

THANKS!

[pocobueno1388]

You were trying to use the $result variable, which is just the query handle. You need to extract the fields from the database by doing

$row = mysql_fetch_assoc($result);

 

Does that make sense?

[Zeradin]

yes makes perfect sense.

 

but

 

i tried $type=$result['type'] and then switched on $type and i also tried selecting all and then setting $type

why didn't those work?

[pocobueno1388]

yes makes perfect sense.

 

but

 

i tried $type=$result['type'] and then switched on $type and i also tried selecting all and then setting $type

why didn't those work?

 

You don't use $result['type']...you have to use $row['type'].

 

So do

$type = $row['type'];

[Zeradin]

gotcha. Thanks for all the help. I'm getting this stuff... slowly... but i am getting it.=)