Suresh R. Soni wrote:
Hi All,
I have good Sybase experience and I have installed
MySQL in a Linux box. Can u please answer my following
queries:
[Sammy] I like Sybase very much as well. =)
1. When I run safe_mysqld I get Starting mysqld
daemon with database from /var/lib/mysql 020314
On Friday, 15. March 2002 09:32, Sammy Lau wrote:
2. How to check if mysql server is up ?
[Sammy] trying to connect the mysqlserver is the best way to do the job.
Try: ps -ax | grep mysqld
or mysqladmin ping
Regards
Georg
hi all,
i've got a mysql server running around 100 queries per sec for most of
the time.
i got only 1 table in MyISAM format.
i got only around 6000 updates to this table per day.
max_connection is set to 600
thread_cache is set to 600
table_cache is set to 600 (there is NO join operation)
I can't connect to mysql remotely. I have added my hostname to the host
table, i have the correct entries in user table,for localhost, my hostname,
my ip, and even %. i can login locally through the shell, and the uname and
pass is same for all entries. What else could be wrong. I'm using a php
On Friday, 15. March 2002 09:41, Mike Estes wrote:
I can't connect to mysql remotely. I have added my hostname to the host
table, i have the correct entries in user table,for localhost, my hostname,
my ip, and even %. i can login locally through the shell, and the uname and
pass is same for
Please endulge me,
On wich machine is PHP running.
- Original Message -
From: Mike Estes [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, March 15, 2002 9:41 AM
Subject: remote connect
I can't connect to mysql remotely. I have added my hostname to the host
table, i have the
Sergei,
thank you for clarifying this. I was misinterpreting the manual where it
says:
`FULLTEXT' indexes can be created from `VARCHAR' and
`TEXT' columns at `CREATE TABLE' time ...
Regards, Thomas Spahni
On Wed, 13 Mar 2002, Sergei Golubchik wrote:
Hi!
On Mar 13, Thomas Spahni wrote:
Hi all.
I'm using MySQL server 3.23.47 (client 3.23.44) on Windows 98 (...sorry)
accessing to database via ODBC (MySQL ODBC release 3.5.01.01) and VC++6.0 MFC
(CRecordset).
I have noticed that queries are really slow... with a simple SELECT like this:
SELECT
ID_Field, Text_Field,
1.
I' am using mysql-max-3.23.49 for Windows and y have a problem to insert a
tuple with the char ñ. Anyone can tell me how solve this problem ?
2.
I'm developing an aplication with Power Builder 7.0. What is the compatibily
of MySQL with Power Builder 7.0 ?
Thanks.
Hi,
I'm still using Mysql 3.23.46 because, as far as I remember, in .47 was reintroduced
the limit of 500 chars max in Innodb primary keys (limit that would break my
application). Is it still present ?
Is it present in Mysql 4 ?
I also need to know if Innodb is reliable in replication
I downloaded the AIX binary distribution of mysql 3.23.49.
Unpacks OK, apart from camplaints about @LongLink:
402 % tar -xf mysql-3.23.49-ibm-aix4.3.3.0-rs6000.tar
tar: can't create ././@LongLink: Permission denied
tar: can't create ././@LongLink: Permission denied
... (repeated many times)
Hi, I've really interresting topic this time:
our application stopped getting data. It turned out these queries were
unexpectedly slow while operating on MyISAM tables:
I m running a mysql-server 3.23.49 under suse 6.4 (kernel 2.2.14) and
myodbc 3,51 .. I have an mdb file and want to export the tables from
access 2002 to the mysqldb .. I can connect to the db and read the
tables .. but when I want to export them .. I get a syntax error ???
What is wrong
Hi!
Mike == Mike Wexler [EMAIL PROTECTED] writes:
Description:
Mike SELECT fullTextMatches.realname, fullTextMatches.address,
MikefullTextMatches.address2, fullTextMatches.city,
Mike fullTextMatches.state,
MikefullTextMatches.zip, fullTextMatches.country,
Mike
Hello,
Now i am struck up with one problem...When i am trying to create a
table in the mysql database it is giving this error...Can anyone plese
help me how to rectify this problem..
ERROR 1: Can't create/write to file './dbase/rr.frm' (Errcode: 13)
My mysql database name is dbase and my
Hello,
Now i am struck up with one problem...When i am trying to create a
table in the mysql database it is giving this error...Can anyone plese
help me how to rectify this problem..
ERROR 1: Can't create/write to file './dbase/rr.frm' (Errcode: 13)
My mysql database name is dbase and my
:::... pjs ... writes:
is anyone getting errors when trying to install mysql++, after
installing the patch for gcc3?
i've gotten a flood of errors which i've fixed, step by step, by adding
std:: to various
variables. manip.cc is spitting out error messages like this one:
Hello all.
I am running mysql 3.x on Redhat Linux, and Solaris 2.6 and 8
Most of the development work is done on these servers.
I do have a couple of windows developers using tools like mysqlfront
Is there way with mysql to print out table structure in a useable text format or maybe
even a
Sanjay,
Thursday, March 14, 2002, 11:23:27 PM, you wrote:
SC We have Mysql standard distribution (ver 3.23.32) for
SC Solaris and we just realised that we needed InnoDB
SC support. What would be the easiest way to add InnoDB
SC table type? Is it possible to do it without affecting
SC the tables
Georg,
Friday, March 15, 2002, 11:05:19 AM, you wrote:
I can't connect to mysql remotely. I have added my hostname to the host
table, i have the correct entries in user table,for localhost, my hostname,
my ip, and even %. i can login locally through the shell, and the uname and
pass is same
Kemp,
Thursday, March 14, 2002, 8:37:00 PM, you wrote:
KRW What is the default table engine used in the binary version of mysql-max --
KRW innodb or Berkeley? If not innodb, how do I get the innodb to be the default?
KRW Can someone point me to the manual section?
The default table type of
Mike,
Thursday, March 14, 2002, 7:27:32 PM, you wrote:
MH I have just recieved a request to build a database using mySQL and I have a
MH bit of a dilemma.
MH The database is to be used for relations between
MH politicians and their constituents,
MH and I have to have tables for constituents
Rob,
Thursday, March 14, 2002, 10:15:54 PM, you wrote:
Show me the output of the following:
SHOW GRANTS FOR 'username'@'hostname';
RQ output:
RQ mysql show grants for 'root@localhost';
RQ ERROR 1064: You have an error in your SQL syntax near
RQ 'grants for 'root@localhost'' at line 1
RQ
David,
Thursday, March 14, 2002, 9:30:24 PM, you wrote:
DMP ok, more specific:
DMP here is a table:
DMP CREATE TABLE FOO (foo1 int NOT NULL, foo2 int NOT NULL Default 1)
DMP If I do an insert into the FOO table with the following:
DMP INSERT INTO FOO (foo1,foo2) VALUES (1,1)
DMP Everything
Uma,
Friday, March 15, 2002, 2:10:50 PM, you wrote:
USTNow i am struck up with one problem...When i am trying to create a
UST table in the mysql database it is giving this error...Can anyone plese
UST help me how to rectify this problem..
UST ERROR 1: Can't create/write to file
We have the same problem as Victoria, and the --default-table-type option
does not work.
- Original Message -
From: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, March 15, 2002 1:38 PM
Subject: innodb or Berkeley DB default for mysql max
Kemp,
Thursday,
Stupid newbie question, but why in the hell can't I get this damned TEXT
column added? I've specified it as size 254 and cannot get it to
work Someone please give me an example of a working create table
statement with a TEXT or LONGTEXT column? I've read through my book
(MySQL) and checked
Hello mysql,
Some time ago I wrote about slow down of mysql with large number of
threads, which is quite common in Linux-Apache-Mysql-PHP enviroment.
The test was simulating the worst case of concurrency - all the
threads are modified global variable in a loop 500 times in
total,
:::... pjs ... writes:
has anyone had trouble applying the patch to mysql++-1.7.9
tx,
paul
This is simple.
cd to directory immediately above mysql++ and do :
patch -p1 ...
There is a better patch for GNU 3..., but not fully tested yet. I am
sending it to you directly, so that you can
MadProfessor,
Friday, March 15, 2002, 2:51:07 PM, you wrote:
M Stupid newbie question, but why in the hell can't I get this damned TEXT
M column added? I've specified it as size 254 and cannot get it to
M work Someone please give me an example of a working create table
M statement with a
Hi GEORGE,
I would like to ask a simple question about the way
MySQL handles string variabels. Say i have a variable
whose value is foo and I want to change it to foobar.
Instead of doing it the 'typical' way, I would like to
ask whether there is any mysql command that will allow
me to
Peter Zaitsev writes:
Hello mysql,
Some time ago I wrote about slow down of mysql with large number of
threads, which is quite common in Linux-Apache-Mysql-PHP enviroment.
The test was simulating the worst case of concurrency - all the
threads are modified global variable in a
hii all,
I want to knowledge about blob.
how can write or read blob to/from MYSQL database by using Visual C++.
Can any body help me.
Ibrahim Kivanc Cihan
Anadolu University - Turkey
-
Before posting, please check:
I don't believe you specify a size for a column of type TEXT. Only types
CHAR and VARCHAR take a size.
http://www.mysql.com/doc/B/L/BLOB.html says:
A BLOB is a binary large object that can hold a variable amount of data.
The four BLOB types TINYBLOB, BLOB, MEDIUMBLOB, and LONGBLOB differ only in
Hi,
First of all, download MySQL++ for VC++ at:
http://www.mysql.com/downloads/download.php?file=Downloads/mysql++/mysql++-1
.7.1-1-win32-vc++.zip
And there are working examples on how to load and retrieve binary data from
blob columns using MySQL++ at:
I've been watching this thread and wonder if not following instructions may be
contributing to the present confusion.
On Fri, 15 Mar 2002 14:38:02 +0200, Egor Egorov wrote:
Show me the output of the following:
SHOW GRANTS FOR 'username'@'hostname';
RQ output:
RQ mysql show grants for
well i can do the select that way, but i was wondering how the following
delete command would only pick up the rows in the select. isn't there a way
of imbedding delete in the select statement?
can anyone else help as well please?
thanks
sunny
At 19:46 14/03/02 -0500, Jim Philips wrote:
To
Is there someway I can force a Grant to take if the database table doesn't
exist yet?
I have the database created, awaiting the data that is being dropped into
it, but I want to set up privileges to it before it exists so its ready to
go live in an instant
mysql GRANT DELETE,SELECT,UPDATE on
From: Martin MOKREJ [EMAIL PROTECTED]
OK, my question is:
could someone imagine a way how such a thing could happen? The information
about
KEY's is set when the table is created. I suspect more end-user problem
then
mysqld problem, but could it happen that the whole information in Key
Found a strange problem with a system here I'm wondering if anyone can help
with.
Got a v3.23.41 installation (source build) on RedHat 6.2 using BDB tables.
A front end program
uses this database via the C API. gcc on this system is egcs-2.91.66
19990314/Linux (egcs-1.1.2 release)
At one point
Hi Luc,
I don't know if this will help you but you can do:
GRANT DELETE,SELECT,UPDATE on qbslive.* TO .
But this will give permission to ALL tables in qbslive database...
Gurhan
-Original Message-
From: Luc Foisy [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 15, 2002 10:45 AM
I am trying to download mysql for my windows XP but this url site:
http://www.mysql.com/downloads/mysql-3.23.html
has been unaccessible for over two weeks. I just could not initiate the download. My
provider is Comcast Cable.
What is the problem?
hi,
i'm working on a project for managing used motorcycles. for security reasons
i setup two identical tables. both with the same attributes.
ID,UNIID,Manufacurer... one of the tables is named Com and the other
Prv.
till now i used to search either Com or Prv. but i want to look for a
match in
I have database with table and 1 milions random characters. Key for
searching each character is a counter from 1 to milion.
when I execute statement:
SELECT count, character FROM table_name WHERE count=ROUND(rand()*10);
Example:
count ||character ||
1 dasarewr
2
You should have been sent to another page that lists many of the mirrors to
download from. Did this happen?
http://www.mysql.com/downloads/download.php?file=Downloads/MySQL-3.23/mysql-3.23.49-win.zip
Somewhere on the page it says that you can also download from sourceforge.net
Van == Van [EMAIL PROTECTED] writes:
Van This means you need to re-initialize the slave; i.e. stop the
Van master and slave; copy the data dir to the slave; start the
Van slave (ensure the perms on the slave are correct first);
Van start the master. If the error above had been
I have spend three days try to get jdbc for mysql work, but failed. I am
very frustrated. I will
be appreciated if somebody can help me out.
I have redhat 7.2 OS, I download the sever and client mysql .rpm files and
instaled it, i believe succssfully. i use command like 'mysqladmin
version' to
Compiler - MSVC 6.0
OS - Windows 2K
MySQL++ 1.7.1
Whenever I perform a build of my project and link against the static
mysql++.lib library, I often get the following warnings. Because I don't
want to disturb the mysql++ source code, is there anything I can do to
resolve the dllexport implicit
Hi,
Jianping Zhu wrote:
I have spend three days try to get jdbc for mysql work, but failed. I am
very frustrated. I will
be appreciated if somebody can help me out.
snip
} catch (Exception e) {
System.out.println("StocksMy: JDBC exception");
System.exit(1);
Your problem, I _think_, is that your query works as follows:
for i = 0 to table_name.rows {
row -- table_name.row[i]
if row.count = ROUND(rand() * 10) then result += row
}
NOTE: ROUND(rand() * 10) is performed FOR EACH ROW in your table. You
actually mean for it to
Hi,
i'm setting up a rather simple replication setup but i'm not
able to understand the behaviour of mysql (3.23.44)
- one server is master, all update are on master
- some of the databases on master should be replicated
to some slaves; the others should not
- create/drop database/table
- Original Message -
From: [EMAIL PROTECTED]
To: Stefaan Contreras [EMAIL PROTECTED]
Sent: Friday, March 15, 2002 5:58 PM
Subject: Re: cannot create Tables with MysqlGUI 1.7.5
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To
Thi Cao writes:
Compiler - MSVC 6.0
OS - Windows 2K
MySQL++ 1.7.1
Whenever I perform a build of my project and link against the static
mysql++.lib library, I often get the following warnings. Because I don't
want to disturb the mysql++ source code, is there anything I can do to
resolve
From what you are writing here it looks as though you are porting a database
to the slave that has already been bin logging.
If your master has been logging the database in question, and you are
copying that database over to the slave, then of course when it reads the
bin logs from the master
I would like to know how work transactions!! are there is mysql 3.23.49??
If there is, how can I use transaction with rollback and commit? I read
about transaction, and exist other way to use. How can I use?
Regards
Alexander
Curitiba/Pr/Brazil
I think you misunderstood how this is going to work. The expression
ROUND(rand()*100) is not a constant, so it is going to re-evaluate it
and generate a *different* random number for each line in the table. Apart
from anything else, this is going to be slow because it will have to scan
the
Sinisa,
I downloaded and am currently using the binary version of 3.23.49. Are you
saying I should download the source version and build the
libmysqlclient.dll? Please clarify. Thanks for the quick response before.
Thi
-Original Message-
From: Sinisa Milivojevic [mailto:[EMAIL
I just had the brilliant idea of using a password for mysql root with
semi-colons:
password is blahblah;;
this appears to have not worked in some way and now I'm stuck. I don't
want to restart since that isn't very graceful (on a production
machine). I've tried blahblah;;; and blahblah and
Luc,
I think you have to do the manual inserts to make this work before the
tables are there. I wrestled with this problem briefly, before writing a
quick script.
Scott Helms
Director of Technology, ZCorum
- Original Message -
From: Luc Foisy [EMAIL PROTECTED]
To: MYSQL-List
Hello,
How can I increase the size of the tablespace for innodb tables? Can you
say if this is a correct procedure:
1. Dumping the database;
2. Stopping it;
3. Deleting innodb log files (ib_logfile0, ...) and innodb data file
specified in innodb_data_file_path;
4. Changing size of data file in
Thi Cao writes:
Sinisa,
I downloaded and am currently using the binary version of 3.23.49. Are you
saying I should download the source version and build the
libmysqlclient.dll? Please clarify. Thanks for the quick response before.
Thi
No, you are OK.
All you have to do is change
Thanks again.
-Original Message-
From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 15, 2002 11:37 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: MySQL++ dll linkage warnings
Thi Cao writes:
Sinisa,
I downloaded and am currently using the binary
Hi GEORGE,
The typical way refers to the update syntax. Ideally,
I would like to be able to do something like that:
- read the value of the variable through a read
statement.
-Specify the value to be appended.
-Do the task.
Could you please help me out with that?
I would like to ask
Perhaps the ; is not getting escaped correctly ( though it should if it is
contained in the quotes ('blahblah;;;'). The ; is the end of line token.
maybe it got confused. or maybe its a matter of the client acception the ;'s
you changed your root password? does that mean you are unable to connect
Heya,
I am quite new to all this intriguing stuff.
I use mysql-3.23.47-win with MySqlGUI 1.7.5
I see my mysql database, but cannot create tables in it.
Any ideas?
Kind regards,
Stefaan
___
http://www.vitamine-z.com/esse/
Hi Christian,
i'm working on a project for managing used motorcycles. for security
reasons
i setup two identical tables. both with the same attributes.
ID,UNIID,Manufacurer... one of the tables is named Com and the other
Prv.
till now i used to search either Com or Prv. but i want to look
Hello:
I never received an answer to the first try, so I thought I might try again.
Has anyone out there been able to successfully compile a UDF for Win32 and
if so, do they have a simple example? I looked in the archives and there
are plenty of questions, but no answers to this.
Thanks,
Hi Christian,
You can create a temporary table (see manual
http://www.mysql.com/doc/C/R/CREATE_TABLE.html) with the same structure as
prv or com and populate it with prv's and com's data by using
INSERT INTO SELECT ... syntax (see manual
http://www.mysql.com/doc/I/N/INSERT_SELECT.html)
Hi !!
-Original Message-
From: m.colurcio@ [mailto:[EMAIL PROTECTED]]On Behalf Of Massimo
Colurcio
Sent: Friday, March 15, 2002 1:59 AM
To: [EMAIL PROTECTED]
Subject: Slow query
Hi all.
I'm using MySQL server 3.23.47 (client 3.23.44) on Windows 98 (...sorry)
accessing to
I don't see how to submit 'blahblah;;' using the quotes.
I've tried
mysql -u root
and then typed all the conceivable combinations for password
and
mysql -u root --password=blahblah;;
and
mysql -u root --password='blahblah;;'
What's worse is that I've looked at the raw table file and
I can access the client using other users, but none have mysql database
access (ie. everything is fine except that I can't add users). If
nobody knows the answer, I will restart with skip-grant-tables during
off-hours.
-
Thanks for your advices.
After I modified my code according to your advice i get following error
message.
Invalid authorization specification: Access denied for user:
'jianping@chambleea' (Using password: YES)
java.sql.SQLException: Invalid authorization specification: Access denied
for user:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I've got a small database (16 tables, a few thousand rows total) running
3.23.48-max w/ 3 of the tables Berkeley DB (for transactions) on Solaris
7/SPARC. One of these tables (the largest of the 3) has a little over
1,000 rows and occasionally
The eWeek article http://www.eweek.com/article/0,3658,s=708a=23115,00.asp
that benchmark the various databases including MySQL stated:
MySQL's great performance was due mostly to our use of an in-memory query
results cache that is new in MySQL 4.0.1. When we tested without this
cache, MySQL's
Found the fix!
What happened to me is I had used Winzip to unzip and untar the
files on a Win2000 machine, then copied those files to the
server. However, I found GNU tar, installed it, deleted my old
mysql directory, and used GNU tar to untar the file in
/usr/local. After that mysql_install_db
On Fri, 15 Mar 2002, Jianping Zhu wrote:
I have spend three days try to get jdbc for mysql work, but failed. I am
very frustrated. I will
be appreciated if somebody can help me out.
I have redhat 7.2 OS, I download the sever and client mysql .rpm files and
instaled it, i believe
I am having a heck of a time getting a simple c program up and running using mingw and
the mysql c api.
My makefile is simple enough I'm not sure what the -lm switch on the search compile
line is for but I saw it in someone's makefile on the web so I through it in hoping it
would work):
#
I read your article and found it to be interesting and overall, quite
accurate.
I do have one bone to pick with you however.
I know the MySQL staffer who worked the MySQL portion of the test. I had
occasion to meet him and talk briefly about the PC Magazine test in Houston
the week following
I have a fairly decent server who is handling lots of connections, but very
simple SQL and I am looking for tuning advice. I have a pretty high number
of simultaneous connections and the box is showing a few signs of stress,
that I want to address before they become a problem. Any help will be
Hi,
For some reason I get a 404 error when I click on 'search' in the Quick
links section at http://www.mysql.com/documentation/mysql/bychapter/.
It looks like it does some type of redirect so my browser could be broken
too, but usually not so much with a 404. :)
Steve
Hi!
I want to access various databases on a MySQL server remotely. I've set up
an entry in the mysql.user table to allow access to mysql for all hosts
in subnet 10.2.107.0/255.255.255.0. First this worked fine. Then my server
moved from address 10.2.107.24 to 10.2.107.204. Now I do not have
Description:
Tru64 5.1a is more strict than other versions of Tru64 when
compiling a threaded program.
extract of pthreads.h file on Tru64 5.1:
/*
* Enable reentrant errno.h. HOWEVER: this is here only to avoid breaking old
* (and incorrect) code that assumes
Description:
Tru64 5.1a is more strict than other versions of Tru64 when
compiling a threaded program.
extract of pthreads.h file on Tru64 5.1:
/*
* Enable reentrant errno.h. HOWEVER: this is here only to avoid breaking old
* (and incorrect) code that assumes
Hi:
Can anyone help about how can I create stored procedure to mysql? I took a
look to mylua but it is just to Linux. My server is Windows 2000. In the
MySql documentation I just see some examples in C, but I don't know how can
I do it, and if I done it in C, how I would call it from php?
Thanks
Hello,
I am trying to build a drop down list using php and mysql. Does anyone
have any examples of this?
Regards,
Adrian
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hi:
how i can insert and select information at the same time.
first i want to insert the information relative to the client and after
that i need to select the same information on the same query.
that is possible
_
Do You Yahoo!?
Hi All,
I've been through the list archives and the documentation and have found no
good discussion of getting ssl connetions working with mysql 4. My main
question is how does one provide mysqld with a private key and certificate?
Also, how is the --des-key-file command line arg used. I am
Hi
No you can't.
if you are using and AUTO_INCREMENT field as a key you could follow the
INSERT with a select statement like:
SELECT * FROM tablename WHERE keyfield = LAST_INSERT_ID()
See the manual: LAST_INSERT_ID()
Hi,
I'm using php form to update mysql database, the form has several drop down
menus to choose from. What would the best way of updating information in the
database, update, as a function? Any help will be greatly appericated.
Thanks.
root login failing??? why? anonymus failing too??
I just installed the following on Win2k Server:
Ver 8.23 Distrib 3.23.47, for Win95/Win98 on i32
Server version 3.23.47-max-nt
Install goes seemingly ok. I test whether or not MySQL is working and have
problem with this command
Hi,
This type of qustion should be forwarded to PHP-DB list. Its adres is:
[EMAIL PROTECTED] .
As for the answer to your question.. IF you'd like to create a dynamic
drop-down menu.. You can just just query the table for the options to be
displayed and loop through the result set and print them
A correction... for line has the greater sign wrong:) It has to be :
for ($i=0; $numresult $i; $i++)
Sorry about that:)
Gurhan
-Original Message-
From: Gurhan Ozen [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 15, 2002 6:01 PM
To: mailing list; [EMAIL PROTECTED]
Subject: RE: drop
Hi,
didn't really understand what you are asking.. Can you please be more
specific? What exactly you are asking?
Gurhan
-Original Message-
From: Valerie Brooks [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 15, 2002 5:28 PM
To: [EMAIL PROTECTED]
Subject: update mysql database via php
You could also bypass the num_rows entirely...
?php
$query=select field from table;
$result=mysql_query($query) or exit(mysql_error().BR.$query);
echo 'select name=categories';
for ($i=0; $row = mysql_fetch_assoc($result); $i++) {
echo 'option'.($row[field]).'';
}
Dear Mad,
Don't give a szie just this;
ALTER TABLE tablename ADD fieldname LONGTEXT
Hope this helps,
Richard
MadProfessor wrote:
Stupid newbie question, but why in the hell can't I get this damned TEXT
column added? I've specified it as size 254 and cannot get it to
work Someone please
I'm working on a form that queries by selection in PHP, where a user
selects a subject and an optional selection of geographic region to get
information. Each database entry will have 2 subject fields, Subject 1
being the main subject and Subject 2 being the cross-subject, and a
geographic field,
Yup Yup , you sure could.. Or you could also use
while ($array_name=mysql_fetch_Array($result)) {..}but for some reason
i always write at least a couple extra lines and use number of rows.. I
guess it is because thats how i learned it first :))
Gurhan
-Original Message-
From:
Hi,
Since you are using a form to query the table i assume the subject1, subject
and geographic will be variables. So, you could do something like:
SELECT * FROM links WHERE (subject1='$sub1' OR subject2='$sub2') AND
GEOGRAPHIC like '$geo%'
In this way, if the user enters no value for the
Thank you for the hint.
I've tried further, and still came up short. This time, if I use the % -
it returns nothing.
Here's the sample code I'm using:
?php
if (!subject) {
header(Location: nowhere.html);
exit;
}
// Connects to database
include(cnx_db.inc);
// First
Hi :)
Rewrite your query statement as:
$sql = SELECT * FROM links WHERE (SUBJECT1='$formatted_subject' OR
SUBJECT2='$formatted_subject') AND GEOGRAPHIC='.$geographic.%'
ORDER BY ORGANIZATION ASC;
I think it looks like a $geographic% variable:) Let me know if it does or
does not
1 - 100 of 110 matches
Mail list logo
