Re: Warning suppression?

2003-03-04 Thread databarn
> this is more a php question then mysql, but if you put a @ before the > commands that are giving you warnings, it should cause it to not show them Didn't start happening until the provider upgraded the MySQL engine, and the _show warnings_ is a MySQL configuration, according to the MySQL docs.

Warning suppression?

2003-03-04 Thread databarn
Folk, I'm not having a lot of success with my provider, so I'll ask here. Is there any way to turn _show warnings_ off from script? I cant seem to find anything relevant. I'm getting a warning that, "Supplied argument is not a valid MySQL result resource . . .". I don't see any way to test

Is there a way to time queries?

2003-02-25 Thread databarn
Folk, Two or three years ago, I was using ASP to access SQL Server 7 and MS Access databases. There was a stopwatch dll made by CapRock Software that allowed me to time various elements of my ASP scripts, particularly the database queries. I found several SQL problems that way, and made my qu

Anyone have MySQL/PHP running from CD?

2002-12-29 Thread databarn
Folk, A friend has asked me to help her to create some business card CDs (with her web on them) that she can use to promote her business. The web uses PHP, with MySQL for the database engine . . . it hasn't been published yet, still in the throes [up] of creation. I've found MicroWeb, which p

How to use LAST_INSERT_ID() or mysql_insert_id() ?

2002-07-28 Thread databarn
Folk, I know this is an old query, but still, problems . . . I've tried these both, but something is amiss - probably my interpretation. Every time I try to use LAST_INSERT_ID() I get a complaint that the query has a problem. E.G., $qry=$qry.";select LAST_INSERT_ID();" will blow up on me ever

RE: Soliciting best approach for storing passwords . . .

2002-06-30 Thread databarn
Thanks, Peter, Yeah, I had looked at ENCODE()/DECODE() and ABS_ENCRYPT()/ABS_DECRYPT() as possible tools, as well as some inherent PHP functionality. My real question is more about database design than about the mechanics of encryption. But I do appreciate the feedback. Make a good day . .

RE: Soliciting best approach for storing passwords . . .

2002-06-30 Thread databarn
Thanks, César, But this is not an option that is negotiable for me. The client mandate is very clear, and the reason behind it has a strong business case from their standpoint. I'm not about to get them to change their minds . . . they and I have been over this way too many times already.

Soliciting best approach for storing passwords . . .

2002-06-30 Thread databarn
Folk, I need some input on how best to store username/password combinations online. My preference would be to store a one-way encrypted value, but that is not possible in this situation. The constraint is that we have to make provision for giving the user's password back to the user after a "

Remote MySQL administration problem . . .

2002-06-18 Thread databarn
. . . Folk, Is there a good PHP product that allows for remote MySQL administration? I'm trying to use phpMyAdmin v2.2.26, but it keeps throwing up errors ab. functions not being available. I'm new to this venue, so I'm probably missing something, likely in great chunks, but I've yet to fin