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

[PHP] Help with MySQL

2009-02-13 Thread James Colannino
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 exactly relevant to PHP, but it is for a PHP application I'm writing, so hopefully that makes this question

Re: [PHP] help with mysql

2004-01-26 Thread Renan G. Galang
B (B- Original Message - (BFrom: "Tom Flood" <[EMAIL PROTECTED]> (BTo: <[EMAIL PROTECTED]> (BSent: Tuesday, January 27, 2004 2:27 PM (BSubject: [PHP] help with mysql (B (B (B> Hello, (B> (B> I am just beginning my learning of php and its uses with mysql.

[PHP] help with mysql

2004-01-26 Thread Tom Flood
Hello, I am just beginning my learning of php and its uses with mysql. I wrote a small program to add information into a mysql database. However my script returns the following error: Fatal error: Call to undefined function: mysql_connect() in /var/www/html/ephi/mysql.php on line 16 what is th

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

[PHP] help with mysql query / logic

2002-10-10 Thread Pablo Oliva
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 job ad table with their criteria, I would also have to query the location table to see if the location that they chose applies to this ad. I am not sure how to co

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
on 3306. If you get some weird characters(most likely the version and some other chars) then the server is itself, is the mysql host. Dan -Original Message- From: GENESiS DESiGNS [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 05, 2002 7:24 PM To: [EMAIL PROTECTED] Subject: [PHP] Help with M

[PHP] Help with MySQL.

2002-03-05 Thread GENESiS DESiGNS
Hello everyone, I need some help with telneting to my web host and figuring out what the host name address is to mysql. My web host (which is my ISP) knows that they have MySQL but they don't know the host name address. I want to know if there is a sentence I can type into the telnet box to

Re: [PHP] Help with mysql query

2001-12-11 Thread Kevin Stone
Alsén" <[EMAIL PROTECTED]> To: "PHP" <[EMAIL PROTECTED]> Sent: Tuesday, December 11, 2001 4:09 PM Subject: [PHP] Help with mysql query > Even if this isn´t a mysql forum i hope to get some help on this: > > I have a table with 5 columns (named one to five) which con

[PHP] Help with mysql query

2001-12-11 Thread Daniel Alsén
Even if this isn´t a mysql forum i hope to get some help on this: I have a table with 5 columns (named one to five) which contains numerical values between 1 and 10. I am trying to construct a query that gives me the count of the representation of each numerical value (ie how many fives that are

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

[PHP] help with Mysql Query...

2001-09-24 Thread Christian Dechery
I'm having trouble puting up a query in Mysql because of his lack of SQL syntax. 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