Query Two Columns

Dysan

Hi,

How do I query to columns from the same table at the same time?
For example: A column containing names, and a column containing gender's

laserlight

It would be along the lines of:

SELECT name, gender FROM tablename;

Dysan

how do I select data from to columns, where a value entered in a form is found in those two columns?

laserlight

What do you mean? Perhaps you should give an example.

My example was for selecting two columns from a table. If you want to select from a table where some criteria matches that in two columns, that's a different story.

Dysan

I trying to create a search script, that searches the name and gender columns contained in a database for keywords entered in a forms text box.

Why doesn't the following code work?

<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
  die(mysql_error());
}

mysql_select_db("db", $con);

$keywords = mysql_real_escape_string($_POST['keywords']);

$result = mysql_query("SELECT * FROM persons WHERE name, gender LIKE '%$keywords%'");

while($row = mysql_fetch_array($result))
{
  echo $row['name'];
  echo $row['gender'];
}

mysql_close($con);
?>

cgraz

Can you be more specific with what's not working? Errors, blank page, different output from what you expected...?

When you're debugging queries, the two best ways I've found to debug are to print out the query string (to see exactly what you're sending the db) and to use mysql_error().

Replace the relevant portions of your code with this:

$strSQL = "SELECT * FROM persons WHERE name, gender LIKE '%$keywords%'";
$result = mysql_query($strSQL) or die('Query String: ' . $strSQL . '<br />' . mysql_error());

Your code is also vulnerable to SQL Injection - be sure to use something like mysql_real_escape_string()