Selecting only certain Rows from a SQL DB

[Jamez]

Hi,

Im trying to select only certain rows from a sql DB,

say i have 100 rows, every row has a field called "category" and theres 4 different categories. lets say i want to select all the rows from just category "widgets"

What is the php command for this?

Also, if i want to display all the categories, only once on a page how would i select all unique categories, but display them only once?

Thanks so much for any help!!

(note, im not asking how to connect, select db, select table, etc., just need the command for selecting particular things)

Thanx

[Jamez]

Heres the code i tried using, and the error that followed:

<table>
<?
include 'connect.php';

mysql_select_db("vita1_vita");
$query = "SELECT product FROM vitamins WHERE type == widgets";

$result = mysql_query($query);

$i = 0;
while ($row = mysql_fetch_array($result))
{
  $id=$row["id"];
  $i ++;
echo "<tr><td>Product: ".($row["product"])."</td></tr>";}

echo "</table>";
?>

error:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/vita1/public_html/display.php on line 24

[LarsLai]

hi!
try this:

$query = "SELECT product FROM vitamins WHERE type = 'widgets'"; 

your second question... i am not sure what you mean by

Also, if i want to display all the categories, only once on a page how would i select all unique categories, but display them only once?

you want to select the different categories and display them? then try:

$query = "SELECT DISTINCT categories FROM vitamins";

this will give you every category once. if this does not match your problem, feel free to ask again..

[Jamez]

Worked Great 🙂

Thanx