Select statement
Moderator: General Moderators
Select statement
Hi All,
I have 2 tables producst and products_description
I want to use select statement to select products.Productname,products.URL,products_description.description where products.products_id=products_description.products_id
There is something wrong with my statemnet in PHP , can anyone reply with correct syntax. I'm using PHP 5 and mysql 5
Thanks
I have 2 tables producst and products_description
I want to use select statement to select products.Productname,products.URL,products_description.description where products.products_id=products_description.products_id
There is something wrong with my statemnet in PHP , can anyone reply with correct syntax. I'm using PHP 5 and mysql 5
Thanks
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
Code: Select all
<?php
$sql = "SELECT products.Productname, products.URL, products_description.description
FROM products, products_description
WHERE products.products_id = products_description.products_id";
?>Thanks I see where my mistake wasEverah wrote:Code: Select all
<?php $sql = "SELECT products.Productname, products.URL, products_description.description FROM products, products_description WHERE products.products_id = products_description.products_id"; ?>
What if I do not want to include all the products where product name is empty ?Everah wrote:Code: Select all
<?php $sql = "SELECT products.Productname, products.URL, products_description.description FROM products, products_description WHERE products.products_id = products_description.products_id"; ?>
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
Lets use some logic...faris10 wrote:What if I do not want to include all the products where product name is empty ?
Code: Select all
<?php
// Get all products
$sql = "SELECT products.Productname, products.URL, products_description.description
FROM products, products_description
WHERE products.products_id = products_description.products_id";
?>Code: Select all
<?php
$sql = "SELECT products.Productname, products.URL, products_description.description
FROM products, products_description
WHERE products.products_id = products_description.products_id
AND products_description.description <> ''
# or you can use...
#AND products_description.description IS NOT NULL";
?>Now lets say we want only products whose description has something in it
Can you apply this logic to other criteria?[/quote]
AND products_description.description <> ''
This works, the other one no. I will go back and read more in book to get more familiar with what's happening.
Code: Select all
<?php
$sql = "SELECT products.Productname, products.URL, products_description.description
FROM products, products_description
WHERE products.products_id = products_description.products_id
AND products_description.description <> ''
# or you can use...
#AND products_description.description IS NOT NULL";
?>AND products_description.description <> ''
This works, the other one no. I will go back and read more in book to get more familiar with what's happening.
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA