undefined variables again..please help......

guyz...maybe u already bored with this kind of question..but i really don't know where i get it wrong...
this is my php script :

<?php
include 'koneksi.inc.php';
$select = "select * 
	from zodiak tb 
	where tb.zodiak='$z'";
?>

in my databases, i have one table named zodiak, and it's field are zodiak (i know it's not really recommended..)
and i have this error :

                                              [FONT="Courier New"] Undefined variable: z[/FONT]

why z is undefined??

i really confused...
please help me........
thankz..

Where is "z" coming from ?

From que query string ($GET) or is it posted through a form ($GET or $_POST) ?

If yes, if the request method is get, then you'll access it with this : $GET['z'], if it is post, then $POST['z']

Also, always sanitanize user-entered data sent to a database...

In this case...

<?php
include 'koneksi.inc.php';
$select = "select *
    from zodiak tb
    where tb.zodiak='" . mysql_real_escape_string($_GET['z']) . "'";
?>

(or $_POST['z'] ...)

hmm..i already try to use $_POST['z];

but it also results the same error...
undefined z

but thankz..
please help.......

You didn't answer the important question posed by suntra:

suntra wrote:
Where is "z" coming from ?