Jerim79 wrote:
> Very weird problem here. We have an HTML form/PHP script which writes
> comany listings to a database. Everything was working fine. One of my
> coworkers who is not in today, setup a new user. This new user can
> enter listings into the database. The PHP script also has the option to
> search the database and display the results. The new user can search
> for the company she just entered and it shows up on the PHP page.
>
> However, a search of the database itself doesn't show the company that
> was just added. I have to do a very specific search for one of the
> columns before the listing will show up. But it doesn't show up in any
> "SELECT * FROM table()" or "SELECT * FROM table() WHERE
> company="company name" statements. I am just wondering if there is some
> sort of "Hide" option for a row that would cause it not to be a part of
> a normal query. Or has anyone run into this problem before. I am using
> MySQL 5.
>
> Again, the only query that will find the company, is if you define the
> specific value in a column called reserved_1. I can look on the PHP
> form to see what that value is for the company and then search in SQL
> using "SELECT * FROM table() WHERE reserved_1="some number". That is
> the only way to find the company in the database.
>

No, there isn't any way to "hide" information like this. A SELECT *
statement will return all rows in the table.

Are you sure you aren't maybe selecting from a view? And have you tried
it from a MySQL command line prompt, just to make sure?

Also, SELECT * FROM table() is invalid syntax, but I suspect that was
just a typo on your part.

This one is strange.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================