Re: Sql SELECT statement to get all dates between 7:00am yesterday an d 7:00am today

At 08:22 25/04/02 -0500, you wrote: >Hi Everyone, > >I am very new to database programming, and am working on an application >where I need to select all records between yesterday at 7:00am and today at >7:00am. Obviously this can be run at any time or day. This has to be a very >common sql SELECT

Re: MySQLAdmin

At this 04:57 16/04/02 +0100 [EMAIL PROTECTED] told us all something interesting :- > >>Where can I d/load phpMyAdmin from ?<< > >http://sourceforge.net/projects/phpmyadmin/ Thanks... Hmm - Ive d/loaded it, but having problems after problems When i go to :- http://kwister.dns2go.com/phpad

MySQLAdmin

At this 12:09 15/04/02 -0400 Gurhan Ozen told us all something interesting :- >Or else, if you are using phpMyAdmin , you can do it with a mouse click. Hi, Im using WinMySQLadmin - Which seems quite useless... (No buttons to dso much, except look at what databases/tables youve got..) Where can

Unique column ?

This is NOT needed as of now.. (just future-thinking on my part), Hi there... Im just experimenting with a new database, & i'm wondering.. Is there a way in which I can create a column in a mysql table to be a unique number/reference.. - & once set, I dont need to keep maintaining it.. (or s

Updated file - Speed ?

6:35 a.m. (writing this on the web)MYSQL :-) Hi - in my first PHP file, :- - earlier this week, Ive posted a few messages about my PHP webpage which Roger Baklund was able to help me start off.. Anyway, - Ive been to some MySql Help sites & found some useful commands, which ive been able to

Attachments & Variables....

5:40 a.m. MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL (is that enough, to get past the filter ?) (sent this via the website, & got a reply re the filter...) Original #2 message

RE: Newbie - Different commands....?

At this 09:33 2/04/02 +0200 Roger Baklund told us all something interesting :- >* Gordon Stewart >[...] > > http://homepages.slingshot.co.nz/~gordon52/3.txt >[...] > >while ( $row = mysql_fetch_array($result) ) { > > echo("" . $row["JokeText

PS: RE: Newbie - Different commands....?

> Ive uploaded it to one of my sites (doesnt have PHP - (I dont think..)) as a text file... http://homepages.slingshot.co.nz/~gordon52/3.txt I just 'viewed source' & I saw all the correct source-code.. < Ive changed some text of my PHP script :- New lines are :- (see above URL - view source.

RE: Newbie - Different commands....?

At this 14:31 1/04/02 +0200 Roger Baklund told us all something interesting :- > > From the build4-5 web-page above, I'll assume that > > $result = @mysql_query("show databases"); would be the correct code to > > SHOW the databases available.. > >That is correct. > > > However its not going &

PS: Re: Newbie - Different commands....?

At this 14:24 1/04/02 +1200 Gordon Stewart told us all something interesting :- >I've been following the website of :- > >http://www.wdvl.com/Authoring/DB/SQL/Build/ > >And its the best ive seen - so far... > >Im up to this page :- > >http://www.wdvl.com/Auth

Newbie - Different commands....?

Hi there, Im a newbie... Ive installed PHP/MySQL 2 nights ago & have been Surfing various websites re installing & setting up MySqld using CGi/Perl.. I can do most things online _ in a DOS window - But i want to do them online - PHP file / CGI.. I've been following the website of :- http://

User privs in mysql

hi List I have a database in mysql that has to be used as root user. When I try and use it as normal user (gordon) it complains. I have inserted the user gordon into the mysql database and it has all privs but it still has the problem. I can not even create a database as the user gordon. I ha

location of mysql.sock

hi When I run the command shell> /usr/local/mysql/bin/safe_mysqld --user=mysql & it creates the file /tmp/mysql.sock the problem is that when i run the command shell> mysql it gives me this error: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.so

Error 2002

Hi I have installed Mysql from the latest tar file and followed these steps. shell> groupadd mysql shell> useradd -g mysql mysql shell> gunzip < mysql-VERSION.tar.gz | tar -xvf - shell> cd mysql-VERSION shell> ./configure --prefix=/usr/local/mysql shell> make shell> make install shell> scripts/m

Mysql and Perl DBI

I am running Redhat 7 and mysql and I have tried to install Msql-Mysql DBI module But I get errors when I do a make I have enclosed a screen dump of the output I get. I seams to be getting stuck with dbimon. I have installed DBI-1-14.tar.gz. User name for connecting to database test? [undef] P

Mysql and Perl DBI

I am running Redhat 7 and mysql and I have tried to install Msql-Mysql DBI module But I get errors when I do a make. I have enclosed a screen dump of the output I get. I seams to be getting stuck with dbimon. I have installed DBI-1-13.tar.gz. Can any one help Gordon [gordon@fido gordon]

Mysql and Perl DBI

I am running Redhat 7 and mysql and I have tried to install Msql-Mysql DBI module But I get errors when I do a make. Can any one help Gordon - Before posting, please check: http://www.mysql.com/manual.php (the manual)