Re: Mysql newbie show table question

2002-06-05 Thread Adam Hooper
Hrm. Closest I can think of is EXPLAIN SELECT * FROM demo WHERE name LIKE 'user_access'; I think this is what you mean. Adam Hooper [EMAIL PROTECTED] On Fri, 31 May 2002 08:44:49 -0700 marc malacarme <[EMAIL PROTECTED]> wrote: > I can¹t seem to make any of the describe o

Re: Mysql newbie show table question

2002-05-31 Thread Adam Hooper
Hrm. Closest I can think of is EXPLAIN SELECT * FROM demo WHERE name LIKE 'user_access'; I think this is what you mean. Adam Hooper [EMAIL PROTECTED] On Fri, 31 May 2002 08:44:49 -0700 marc malacarme <[EMAIL PROTECTED]> wrote: > I can¹t seem to make any of the describe o

Re: Multiple Queries

2002-05-31 Thread Adam Hooper
nect every time. Adam Hooper [EMAIL PROTECTED] On Fri, 31 May 2002 09:55:27 +0100 "Caspar Kennerdale" <[EMAIL PROTECTED]> wrote: > Sorry If this is the wrong list for this topic, I hope someone can shed some > light onto my problem. > > I am building a php/ Mysql web s

Re: Newbie question : Can't connect to database through a web interface

2002-05-31 Thread Adam Hooper
Try replacing that with this bit of code: $db = mysql_pconnect("localhost", "testdb", "test123") or exit(mysql_error()); It should give you a more descriptive error message. Note I didn't put the "@", which is used to suppress error messages in P

Re: C library vs PHP connection

2002-05-30 Thread Adam Hooper
You forgot to include your C code. :) Adam Hooper [EMAIL PROTECTED] On Thu, 30 May 2002 15:59:31 -0700 Bill Rausch <[EMAIL PROTECTED]> wrote: > I have a program prototyped in PHP that works fine, but when I > convert it to C using libmysqlclient the program fails inside the &

Re: Date and Select problem

2002-05-28 Thread Adam Hooper
And the conversion gives it a value of 0. So you're comparing 0 and 0, which results in 'true'. Anyway, that's why it happens :). Adam Hooper [EMAIL PROTECTED] On Tue, 28 May 2002 11:07:08 -0600 "I. TS" <[EMAIL PROTECTED]> wrote: > > My SQL query p

SELECT 'foobar' = 0

2002-05-27 Thread Adam Hooper
umble opinion, it isn't. But I don't have any standards in front of me, nor do I know how to get them... Below is a patch to sql/item.h that fixes this problem. It works for me, but I haven't tested it very extensively. Is this a valid problem? I'm basically relying on intuition al

Example UDF for anyone interested

2002-04-27 Thread Adam Hooper
h as "-" or "#"). It's all in the README linked there. Really it's more for example purposes than anything else -- I woulda liked having more than one example to refer to when I was coding it. Do whatever you want with it but sell it, and most of all have fun :