MySQL/PHP Query results

jennifer_ann

I am having trouble running a query to pull out certain results from my database.
Right now I have

$query = "SELECT * FROM `sperm`";
$query2= "SELECT * FROM `cperm`";
$result = mysql_query($query);
$result2 =mysql_query($query2);

//check to see if query worked
if (!$result)
{
echo "Query on Connection failed!";
// exit
}

However I want to pull up a country. So what I need is something like this

            $query = "SELECT * FROM `sperm` WHERE $country_origin = "country";

or something like that, but I am unable to get it to work. My table consists of Country_Origin, City_Origin, and Date_Left. Could someone please steer me in the right direction? 🙂

rincewind456

Maybe like this

$query = "SELECT * FROM `sperm` WHERE country_origin =".$country;

Houdini

This is what you have;

$query = "SELECT * FROM `sperm` WHERE $country_origin = "country";

Instead it should look like this.

$query = "SELECT * FROM `sperm` WHERE country_origin = '$country'";

Please when posting code use the tools the tilde symbol in the dogeared page right after the <> would be for posting code as it is presented here, it makes it easier for all of us to help you with your problem. Also if any suggestion or code helps you either mark this post Resolved using the Thread tools or at least make a response as to whether or not you got positive or negative results from you post...don't leave others hanging on your particular problem.

khendar

^ What he said.

Also avoid using shortened words for your table names. If you must - seperate them with underscores. Might help avoid having tables named things such as "sperm" XD

jennifer_ann

Thank you EVERYONE for your help! This particular query worked with everyone's input. I'm sorry about not using the <>, I'm still getting this forum format down. I will try to do so when I post again. Once again thanks so much for taking the time to help someone learn, because at the college I go to, many professors don't even do that and when someone does....it's nice.

dalecosp

khendar wrote:
^ What he said.

Also avoid using shortened words for your table names. If you must - seperate them with underscores. Might help avoid having tables named things such as "sperm" XD

Heh, glad you caught that. Myself, I was busy wondering what in the world young Jennifer_Ann was studying in college . . . :rolleyes: