selecting count query (newbie alert)

2003-08-14 Thread Ryan A
Hi, This is my first post here so forgive me if its too simple or not right. basically what i do is: SELECT COUNT(*) FROM table1 where cno=3; (and dumping it into a variable $theResult - I am using PHP) and it gives me the result, but now i need to do this in 5 tables... I can of course run 5 cou

Re: selecting count query (newbie alert)

2003-08-07 Thread Cybot
Ryan A wrote: Hi, This is my first post here so forgive me if its too simple or not right. basically what i do is: SELECT COUNT(*) FROM table1 where cno=3; (and dumping it into a variable $theResult - I am using PHP) and it gives me the result, but now i need to do this in 5 tables... I can of cou

Re: selecting count query (newbie alert)

2003-08-06 Thread Cybot
Ryan A wrote: Hi, This is my first post here so forgive me if its too simple or not right. basically what i do is: SELECT COUNT(*) FROM table1 where cno=3; (and dumping it into a variable $theResult - I am using PHP) and it gives me the result, but now i need to do this in 5 tables... I can of cou

Re: AW: How to run a script? Newbie alert..

2003-06-03 Thread Terry Riley
Vielen Dank, Mark Cheers Terry --Original Message- > Use "source " from the mysql command line > Start mysql in the bin directory, switch to the db in use via "use > " > and run the command "source " > > Or read the manual section "3.6 Using mysql in Batch Mode" > > Cheers

AW: How to run a script? Newbie alert..

2003-06-02 Thread Mark Vollmann
> Von: Terry Riley [mailto:[EMAIL PROTECTED] > Gesendet: Montag, 2. Juni 2003 11:38 > An: [EMAIL PROTECTED] > Betreff: How to run a script? Newbie alert.. > > > I've not been at this MySQL stuff too long, so bear with me.. > (4.0.13 running on Windows XP/Apache). > > Most

How to run a script? Newbie alert..

2003-06-02 Thread Terry Riley
I've not been at this MySQL stuff too long, so bear with me.. (4.0.13 running on Windows XP/Apache). Most of my work has been in Windows, and almost always with a GUI, so that when presented with the instruction to 'run mysql_fix_privilege_tables' script, I am totally clueless as to how to go a

RE: Newbie alert!

2002-02-18 Thread John Lodge
To: [EMAIL PROTECTED] Subject: Newbie alert! All, I am having difficulty compiling a piece of software. If I try compiling with the following: gcc dnd.cpp -o dnd3 -L /usr/local/lib/mysql -lmysqlclient as suggested in "Core MySQL by Leon Atkinson" on page 436, I get the error: /

Newbie alert!

2002-02-18 Thread Rick Runowski
All, I am having difficulty compiling a piece of software. If I try compiling with the following: gcc dnd.cpp -o dnd3 -L /usr/local/lib/mysql -lmysqlclient as suggested in "Core MySQL by Leon Atkinson" on page 436, I get the error: /usr/bin/ld: cannot find -lmysqlclient collect2: ld returne