Re: [PHP] Help with MySQL

2009-02-13 Thread Waynn Lue
You can type "show create table " to see the datatypes. Waynn On 2/13/09, James Colannino wrote: > Hey everyone. I've been reading the list for a long time, but have only > really posted to the mailing list a few times. I just had a quick > question about MySQL. I'm not sure if this is exactl

Re: [PHP] help with mysql

2004-01-26 Thread Renan G. Galang
could you send the line 16 the parser was pointing out? (B (BIt could be you have the wrong number of parameters for the call to (Bmysql_connect(), or your PHP wasn't compiled with mysql functionality (Benabled. (This is doubtful since mysql functionality is ON by default). (B (B (B- Ori

RE: [PHP] help with mysql query / logic

2002-10-10 Thread Pablo Oliva
Please disregard, I think that I figured it out. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] help with mysql query / logic

2002-10-10 Thread Marco Tabini
Can you perhaps post the structure of your tables? That would make it easier to help (at least for me) On Thu, 2002-10-10 at 15:40, Pablo Oliva wrote: > I have 2 tables, one with job ad information, and a second one with the > locations that this ad applies to. > > When a person queries the jo

RE: Re: [PHP] Help with MySQL.

2002-03-05 Thread Dan Vande More
nt: Tuesday, March 05, 2002 8:13 PM To: [EMAIL PROTECTED] Subject: RE: Re: [PHP] Help with MySQL. For one of my servers I get " 3.23.34-log3REu?zk*+;," And another I get " 4.0.1-alpha,ZaXs]W{," That means that is most certainly running on it, if not you would get something lik

Re: Re: Re: [PHP] Help with MySQL.

2002-03-05 Thread GENESiS DESiGNS
Dan, Running on what? I need to know the host name address. Thanks, -GENESiS DESiGNS -Sean Kennedy -http://www.gdesigns.vcn.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: Re: [PHP] Help with MySQL.

2002-03-05 Thread Dan Vande More
p does not know anything about their mysql server, they may not know the password. Dan -Original Message- From: GENESiS DESiGNS [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 8:12 PM To: [EMAIL PROTECTED] Subject: Re: Re: [PHP] Help with MySQL. Dan, What do you mean by : If you

Re: Re: [PHP] Help with MySQL.

2002-03-05 Thread GENESiS DESiGNS
Dan, What do you mean by : If you get some weird characters(most likely the version and some other chars) then the server is itself, is the mysql host. Because thats what happens. Thanks, -GENESiS DESiGNS -Sean Kennedy -http://www.gdesigns.vcn.com -- PHP General Mailing List (http://www.ph

RE: [PHP] Help with MySQL.

2002-03-05 Thread Dan Vande More
Once in your telnet session, from the command line type 'telnet localhost 3306' or 'telnet 127.0.0.1 3306' Keep in mind this only proves the host is there, it doesn't disprove. The machine may not know itself as localhost(unlikely) or the mysql server may not be living on 3306. If you get some wei

Re: [PHP] Help with mysql query

2001-12-11 Thread Kevin Stone
Daniel, Try this. Still sort of a brute force method but just 10 query strings instead of 50 but nothing MySQL is going to balk at. Then you an print out the results stored in the $num_vals list using a similar for loop. -Kevin Stone - Original Message - From: "Daniel Alsén" <[EMAI

Re: [PHP] help with Mysql Query...

2001-09-24 Thread Steve Werby
"Christian Dechery" <[EMAIL PROTECTED]> wrote: > I have a table A and a table B... I want all occurences from A there are > not in B... > > in ANSI SQL... it's nothing more than: > > select a.id, a.name from table_a a, table_b b where a.id NOT IN (select id > from table_b) > > and that's it... but