[Resolved] Problems getting info out of MySQL..

[poverdrive]

Ok I create the table using this query below:

CREATE TABLE tutorials (
id INT(11) NOT NULL AUTO_INCREMENT,
picture TEXT NOT NULL,
type TEXT NOT NULL,
author VARCHAR(20) NOT NULL,
webiste VARCHAR(30) NOT NULL,
source VARCHAR(30) NOT NULL ,
description VARCHAR(150) NOT NULL ,
tutorial LONGTEXT NOT NULL ,
PRIMARY KEY (id))

This works great.. everything's fine.
But I want the page to display data/tutorials of the same $type ($type = "php" for example) only.. so it would output only PHP tutorials, not all tutorials in the db.

Basically, I need a code/mysql_query that would either:
1. select only tutorials where $type = "php" ;
OR
2. select all tutorials from mysql and then filter out any tuts that don't containg the value "php" as their type.

Anyone? 🙂

[misteraven]

I'm kind of a newbie myself, but I think the query would be something like...

$type = "php";

$query = "SELECT * FROM tutorials WHERE type = $type";

$result = mysql_query($query);

and then you echo out the results.

[poverdrive]

Thx a lot m8!

$result = mysql_query('SELECT * FROM tutorials WHERE type = "php"');

Works like a charm now..