# PHP to MySQL commands help

**URL:** https://forum.kirupa.com/t/php-to-mysql-commands-help/311001
**Category:** programming
**Created:** [June 24, 2010, 10:07pm UTC](https://forum.kirupa.com/t/php-to-mysql-commands-help/311001 "2010-06-24T22:07:49Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![jany](https://avatars.discourse-cdn.com/v4/letter/j/ce7236/32.png) [@jany](https://forum.kirupa.com/u/jany)
#### Post date: [June 24, 2010, 10:07pm UTC](https://forum.kirupa.com/t/php-to-mysql-commands-help/311001/1 "2010-06-24T22:07:49Z")

</div>

I need help with calling particulars in MySQL.

If you look at the picture I attached, you see a few columns/rows/fields. How, in PHP would I do this?

I want to select the entire row from the ProductID “dda11”. At the same time, some of the “Text” fields are going to be empty so I need to grab everything on the row that is not null. Any field at any time may be empty, so I basically don’t want to select from those fields. Also, I might have an “ID” preceding the “ProductID” field, and I don’t want the ID being fetched either.

So basically how would I select from product id “dda11”, not select the regular “ID”, and not select anything that is null?

Hope that makes sense :love\_heart:

tyty