Posted by Jerry Stuckle on 05/13/07 03:07

Mike P2 wrote:
> On May 11, 10:28 pm, Jerry Stuckle <jstuck...@attglobal.net> wrote:
>> Mike,
>>
>> Actually, he is using the OO mysqli code. But he has multiple problem,
>> including:
>>
>> 1) he never issued a SELECT statement.
>> 2) $db is out of scope where it is used
>> 3) he's trying to mix mysql commands and mysqli objects
>>
>> And once he gets these problems fixed he'll have more. He needs a new
>> book...
>>
>> --
>> ==================
>> Remove the "x" from my email address
>> Jerry Stuckle
>> JDS Computer Training Corp.
>> jstuck...@attglobal.net
>> ==================
>
> I realize that. I fixed those things in my example. The DB being out
> of scope doesn't really matter, he's not passing $db to the MySQL
> functions anyway. The connection is open, and PHP will find it.
>
> I think that after looking at my example of how it should be, he
> should be able to do some more research and/or figure out what he
> needs to be doing.
>
> -Mike PII
>

Mike,

But what you're doing is even worse - mixing OO and non-OO calls to the
database. Your mysql() calls will not update the variables in the
mysqli objects for instance.

You shouldn't try to mix and match mysql and mysqli code in the same
page - it's just asking for trouble.


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

[Back to original message]