Hi,
I try to display the result of a mysql request but first element misses !
here is my code:
$sql-Query(select marque, reference from base );
$sql-afficheResultatRequete($sql-result,$sql-nbreChamps);
function Query ($query) {
$this-result = @mysql_query($query, $this-id) or
I'm looking for a mysql select statement that does the
following:
- Check if the value of each expert.id on the table
experts matches a value expt.id in the table
apliexpert.
- For those values where this is true check whether
the softID value for that row matches the variable
$softId.
- return
;
--
Beverly Steiner
[EMAIL PROTECTED]
-Original Message-
From: Jason End [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 06, 2003 8:52 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] mysql statement: two tables, two comparisons
I'm looking for a mysql select statement that does the
following
Hello to all,
I have a new project where i need show pages of report on demmand. That
reports are created in the batch process, and the whole file size is about 5
Gb. (thats includes all the reports in a month, I need save about 12 month).
I think in two alternatives :
1. I save
I have a new project where i need show pages of report on demmand.
That
reports are created in the batch process, and the whole file size is about
5
Gb. (thats includes all the reports in a month, I need save about 12
month).
I think in two alternatives :
1. I save the links in
PROTECTED]
Sent: Friday, February 21, 2003 8:59 PM
Subject: [PHP-DB] mysql to cvs file to excel
hello,
does anybody know if it's possible (without php)
to export data from mysql to a cvs file, so i can import it in excel???
so is it possible, and if yes.. how?
thanks kinds regards
hello,
does anybody know if it's possible (without php)
to export data from mysql to a cvs file, so i can import it in excel???
so is it possible, and if yes.. how?
thanks kinds regards,
Mark Snijders
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
:[EMAIL PROTECTED]]
Sent: sexta-feira, 21 de Fevereiro de 2003 9:59
To: [EMAIL PROTECTED]
Subject: [PHP-DB] mysql to cvs file to excel
hello,
does anybody know if it's possible (without php)
to export data from mysql to a cvs file, so i can import it in excel???
so is it possible, and if yes.. how
Hi I was wonder if any knows how 2 display sound clips held in a mysql
database using a php page ? I have stored the urls of the clips in
mysql database and I belive I need some like to (below) to display them
but its not quite working.
while ($row= mysql_fetch_row($result)) //retrieve a row
while ($row= mysql_fetch_array($result)) //retrieve a row and store in
echo A HREF= .$row['UrlColumnName'].;
That's how I'd do it.
Ryan
-Original Message-
From: G [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 17, 2003 8:16 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] mysql +php
: RE: [PHP-DB] mysql +php
while ($row= mysql_fetch_array($result)) //retrieve a row and store in
echo A HREF= .$row['UrlColumnName'].;
That's how I'd do it.
Ryan
-Original Message-
From: G [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 17, 2003 8:16 PM
To: [EMAIL PROTECTED
Thanks got it working
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Thanks for all the help everyone sent me on this. However, nothing seems to
make any difference whatsoever (except putting the 'localhost' part in
quotes). I am still getting permission denied errors based on the user
credentials.
I have entered a user into the user table with host='localhost',
On Fri, 14 Feb 2003 11:30:03 +0200
[EMAIL PROTECTED] (Evan Morris) wrote:
Thanks for all the help everyone sent me on this. However, nothing
seems to make any difference whatsoever (except putting the
'localhost' part in quotes). I am still getting permission denied
errors based on the user
Hi all
I am new to PHP (just basically started yesterday). I am currently having a
problem connecting to a MySQL database.
My sample code is:
--
?php
mysql_connect(localhost,username,password) or die (Unable to connect to
MySQL server.);
$db =
PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 13 February 2003 13:20
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL problem -- new to PHP
Hi all
I am new to PHP (just basically started yesterday). I am currently having a
problem connecting to a MySQL database.
My sample code
:[EMAIL PROTECTED]]
Sent: 13 February 2003 14:01
To: Clarkson, Nick
Subject: Re: [PHP-DB] MySQL problem -- new to PHP
Well you opened up my question! Do you know where to learn PHPMyAdmin?
Thanks in advance,
Mark
Clarkson, Nick wrote:
Looks like is to do with MySQL permissions. Check your host's
: Thursday, February 13, 2003 7:20 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL problem -- new to PHP
Hi all
I am new to PHP (just basically started yesterday). I am currently having a
problem connecting to a MySQL database.
My sample code is:
--
?php
When changing/adding permissions to the mysql db for specific users,
dont forget to do 'flush privileges'...
my 2 cents
On Thu, 2003-02-13 at 07:19, Evan Morris wrote:
Hi all
I am new to PHP (just basically started yesterday). I am currently having a
problem connecting to a MySQL database.
Helloo people,
I have a question about MySQL, i use MySQL 3.23.55 together with PHP
4.3.0 on my windows XP system. Does the version of MySQL supports InnoDB
tables? And how do i do it i have noticed that in PhpMyAdmin i
cannot choose this table format..., but i gues that has more to do
I have a question about MySQL, i use MySQL 3.23.55 together with PHP
4.3.0 on my windows XP system. Does the version of MySQL supports
InnoDB
tables? And how do i do it i have noticed that in PhpMyAdmin i
cannot choose this table format..., but i gues that has more to do
with
the
]
Subject: [PHP-DB] MySQL result resource
hello,
i have a new issue... :-)
i am getting:
Warning: Supplied argument is not a valid MySQL result resource in
/users/infoserv/web/register/ca/admin/catads.php on line 54
from:
?
while($row = mysql_fetch_object($obj))
{
$scobj
hello,
i have a new issue... :-)
i am getting:
Warning: Supplied argument is not a valid MySQL result resource in
/users/infoserv/web/register/ca/admin/catads.php on line 54
from:
?
while($row = mysql_fetch_object($obj))
{
$scobj = mysql_db_query($dbname,select * from
...
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/
-Original Message-
From: Addison Ellis [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 29, 2003 10:02 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL result resource
hello
January 2003 04:37
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL Error
I'm getting this error message when I try the following code:
$link = mysql_connect(localhost)
or die(Could not connect);
print (Connected successfully);
mysql_close($link);
The scripts outputs:
Warning: Can't
Just a shot in the dark, but be sure the socket and port settings are
correct for your setup (whatever that might be since you did not include
that info in your post) and that mysql is actually running.
Be sure to scour
http://www.mysql.com/documentation/mysql/bychapter/index.html
especially
I'm getting this error message when I try the following code:
$link = mysql_connect(localhost)
or die(Could not connect);
print (Connected successfully);
mysql_close($link);
The scripts outputs:
Warning: Can't create TCP/IP socket (10106) in
C:\Projects\WebServer\admin.php on
Hello,
I need some help from you MySQL gurus out there. This is pure SQL by the
way..no front-end.
Lets say you have a table that has 2columns.columnA,
ColumnB and columnC
I have something like this
if (columnA'7', (columnB/columnC) + 52, columnB/ColumnC) as Number
however i need to test
Jeremy,
This question probably should be posted to the MySql mailing list but here
goes.
Take a look at this link:
http://www.mysql.com/doc/en/Where_optimisations.html
Your example was not very explicit so I am not sure, but I believe you are
in need of a
WHERE clause. For example;
Select a,
]
To: [EMAIL PROTECTED]
Sent: Thursday, January 23, 2003 10:29 PM
Subject: [PHP-DB] MySQL Query Question
Hello,
I need some help from you MySQL gurus out there. This is pure SQL by the
way..no front-end.
Lets say you have a table that has 2columns.columnA,
ColumnB and columnC
I have
I need some help from you MySQL gurus out there. This is pure SQL by
the
way..no front-end.
Lets say you have a table that has 2columns.columnA,
ColumnB and columnC
I have something like this
Oh CRAP! You lost me... you said two columns but listed 3! ;)
if (columnA'7',
SQL-query :
CREATE TABLE `staff` (
`StaffId` INT( 4 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`Name` VARCHAR( 30 ) NOT NULL ,
`Surname` VARCHAR( 30 ) NOT NULL ,
`Address` TEXT( 225 ) NOT NULL ,
`JobId` SMALLINT( 2 ) NOT NULL ,
`PermissionId` SMALLINT( 2 ) NOT NULL ,
`HomePhone` INT( 11 ) NOT NULL
and you can GROUP BY or ORDER BY on the VARCHAR without any conversion.
-Original Message-
From: David Rice [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 21, 2003 10:11 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySql DB, help, sql error and i don't know why
SQL-query
Hi!
I'm trying to connect to my mysql database using something like
mysql_connect( 'localhost', 'root', 'thepassword' )
or die ( 'Unable to connect to server.' );
But I get the error message:
Fatal error: Call to undefined function: mysql_connect() in
I'm trying to place a text from a textfield into a database and displaying
it on another page. All works fine and well but my problem is:
If i place newline characters (press enter) in the forms textfield they
don't show up on my display page. This is logical because newlines are not
br codes. So
in a browse like the above.
Aaron
-Original Message-
From: Ro Stonemountain [mailto:[EMAIL PROTECTED]]
Sent: January 9, 2003 10:53 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] [mysql - php] Newline to BR problem
I'm trying to place a text from a textfield into a database and
displaying
I have an query:
select * from offtime where type='$type'
then I just pass the type variable to the page. Is there a wildcard in
mysql like there is in sqlserver that I can use to grab all the records?
such as select * from offtime where type='%' would grab all.
Thanks,
Eddie
--
PHP
If you want all records, remove the where clause.
select * from mytable
Jim
---Original Message---
From: Edward Peloke
Date: Wednesday, January 08, 2003 02:03:04 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] mysql wildcard
I have an query:
select * from offtime where
Well, if that is your only condition, why not use:
'select * from offtime' as your query?
I believe the % as a wildcard is standard SQL, so I would *think* it should
work in mysql, have you tried it?
-Brad
Edward Peloke wrote:
I have an query:
select * from offtime where type='$type'
then
You probably want something like:
select * from offtime where type like '{$type}%'
As a side note, are you making sure that $type does not contain any
malicious code?
Cheers,
Marco
--
php|architect - The Monthly Magazine for PHP Professionals
Come check us out on the web at
In a message dated 1/8/03 2:48:15 PM Pacific Standard
Time, [EMAIL PROTECTED] writes:
I have an query:
select * from offtime where type='$type'
then I just pass the type variable to the page. Is
there a wildcard in mysql like there is in sqlserver
that I can use to grab all the records? such
on 1/6/03 8:24 PM, David Chamberlin at [EMAIL PROTECTED] appended the
following bits to my mbox:
Is there any way to set the time format so that any time values in my
SELECT call are in a speicified format (e.g., HH:MM instead of HH:MM:SS).
Basically I've got a table of a variety of
Paul Burney wrote:
Why not add the TIME_FORMAT calls to the original query rather than
performing all the extra queries? Is your first select something like the
following?
That's what I'd like to do, but not sure how to do that in this context.
SELECT
hi All,
how can i connect to mysql via SSL connection using mysql_connect() in php 4.3.0? i
have generated all the certificates necessary and i was able to connect to mysql
server via the bin/mysql command line options (below).
bin/mysql -h localhost --ssl-cert=host.crt --ssl-key=host.key -u
This is a bit of a newbie question, but I couldn't find what I wanted
in
the documentation.
Is there any way to set the time format so that any time values in my
SELECT call are in a speicified format (e.g., HH:MM instead of
HH:MM:SS).
Basically I've got a table of a variety of different
Hello can someone give me some possible reasons this error happens when
I use the mysql client to add a tabe to a database.
mysql create table home (id int not null, heading blob not null,
- primary key (id), unique id (id));
ERROR 3: Error writing file './nrlug/home.frm' (Errcode: 28)
Any
Hi,
Does mysql user has rights to write in this directory or permissions over
this file?
Andrey
- Original Message -
From: conbud [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, January 03, 2003 11:00 AM
Subject: [PHP-DB] MySQL Database connection Problem
Hello can someone
On Friday 03 January 2003 17:00, conbud wrote:
Hello can someone give me some possible reasons this error happens when
I use the mysql client to add a tabe to a database.
mysql create table home (id int not null, heading blob not null,
- primary key (id), unique id (id));
ERROR 3: Error
Jason Wong wrote:
On Friday 03 January 2003 17:00, conbud wrote:
Hello can someone give me some possible reasons this error happens when
I use the mysql client to add a tabe to a database.
mysql create table home (id int not null, heading blob not null,
- primary key (id), unique id (id));
- Original Message -
From: conbud [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, January 03, 2003 11:11 AM
Subject: Re: [PHP-DB] MySQL Database connection Problem
Jason Wong wrote:
On Friday 03 January 2003 17:00, conbud wrote:
Hello can someone give me some
Hristov
- Original Message -
From: conbud [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, January 03, 2003 11:11 AM
Subject: Re: [PHP-DB] MySQL Database connection Problem
Jason Wong wrote:
On Friday 03 January 2003 17:00, conbud wrote:
Hello can someone give
what about the permissions? are they ok?
Andrey
- Original Message -
From: conbud [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, January 03, 2003 11:30 AM
Subject: Re: [PHP-DB] MySQL Database connection Problem
Andrey thanks, but I seen that already and theres over 80 gig left
On Friday 03 January 2003 17:11, conbud wrote:
Jason Wong wrote:
On Friday 03 January 2003 17:00, conbud wrote:
Hello can someone give me some possible reasons this error happens when
I use the mysql client to add a tabe to a database.
mysql create table home (id int not null, heading blob
SELECT * from table where
passwordfield=PASSWORD('$variablewithpassword') and
username='$usernametocheck' limit 1
Sabina Alejandr Schneider wrote:
Hello to everybody!! I'm writing to know if somebody knows how can I
validate a password that has been encrypted with the PASSWORD() mysql
Check this resource: http://www.mysql.com/doc/en/Passwords.html
Rich
-Original Message-
From: Sabina Alejandr Schneider [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 03, 2003 8:48 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Mysql Passwprd validation
Hello to everybody!! I'm writing
Hello,
I'm using a product called Squirrelmail for my web based email. In it, it
uses a database for user preferences and address books. (I posted to that
list, and it was suggested to check here) I created the database squirrel. I
created two tables, one called addresses and one called prefs.
Does the user that the script runs as have full CRUD access to the
new tables? Have you set any restrictions on what that user can do to
the table(s)?
--- Jody Cleveland [EMAIL PROTECTED] wrote:
Hello,
I'm using a product called Squirrelmail for my web based email. In
it, it
uses a database
Does the user that the script runs as have full CRUD access to the
new tables? Have you set any restrictions on what that user can do to
the table(s)?
Boy, do I feel lost...
How would I check that?
Thanks!
Jody
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
Sorry. Stupid technospeak on my part.
When you connect to the database, you tell it to use a particular
username and password. When these new tables were created, did you
change the permissions in the mysql table for the user, or does that
account have access to all the tables/databases?
Sorry. Stupid technospeak on my part.
No problem, much ignorance on my part.
When you connect to the database, you tell it to use a particular
username and password. When these new tables were created, did you
change the permissions in the mysql table for the user, or does that
account have
--- Jody Cleveland [EMAIL PROTECTED] wrote:
Sorry. Stupid technospeak on my part.
No problem, much ignorance on my part.
When you connect to the database, you tell it to use a particular
username and password. When these new tables were created, did
you
change the permissions in the
I'm trying to convert an ASP/Access tutorial to PHP/MySQL and have a
question regarding MySQL.
In Access one can create a date field and set the default to Date() to get
the current date but according to the mysql manual:
http://www.mysql.com/doc/en/CREATE_TABLE.html
Default values must be
This can be done using the 'timestamp' type for your column. Note that
this field will be updated to the current time any time the row is
modified (including when it is created).
An alternative is to do it on the scripting side with the MySQL NOW()
command like so:
INSERT INTO your_table
I'm trying to convert an ASP/Access tutorial to PHP/MySQL and have a
question regarding MySQL.
In Access one can create a date field and set the default to Date()
to
get
the current date but according to the mysql manual:
http://www.mysql.com/doc/en/CREATE_TABLE.html
Default values
:
Subject: [PHP-DB] mysql-windows xp
12/13/2002
]
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] mysql-windows xp
turn off the xp firewall as well.
Jason
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 13, 2002 7:29 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] mysql
]
jason.selph@h cc: [EMAIL PROTECTED]
p.com Subject: RE: [PHP-DB] mysql-windows xp
:[EMAIL PROTECTED]]
Sent: Friday, December 13, 2002 8:54 AM
To: SELPH,JASON (HP-Richardson,ex1)
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] mysql-windows xp
that didn't cause me any issues on my install. why do you have to turn
that off. i'm not doubting you, just curious
the option to Protect my
computer or network.
Jason
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 13, 2002 7:54 AM
To: SELPH,JASON (HP-Richardson,ex1)
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] mysql-windows xp
that didn't
]
Cc: SELPH,JASON (HP-Richardson,ex1)
Subject: RE: [PHP-DB] mysql-windows xp
by default on a new xp install the firewall is enabled. stops everything on
your network from getting thru. if port 3306 is blocked then accessing
mysql thru ip would be denied.
To disable internet connection firewall
Thanks for all the help. I finally got it running by running winmysqladmin
Eddie
-Original Message-
From: SELPH,JASON (HP-Richardson,ex1) [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 13, 2002 9:29 AM
To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] mysql-windows xp
-Richardson,ex1) [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, December 13, 2002 6:28 AM
Subject: RE: [PHP-DB] mysql-windows xp
I honestly can't give you an answer on that as I haven't installed mysql
on
XP. On linux there are 2 ways to connect to your server, socket
Does anyone know what the maximum is for a FULTEXT Index in MySQL?
John
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
(/trtr);
}
}
-Original Message-
From: 1LT John W. Holmes [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 05, 2002 3:26 PM
To: Ryan Jameson (USA); Art Chevalier; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MySQL Array
I think he meant that he is only pulling one
-
From: 1LT John W. Holmes [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 05, 2002 3:26 PM
To: Ryan Jameson (USA); Art Chevalier; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MySQL Array
I think he meant that he is only pulling one column, i.e. field1
with each
mysql_fetch_array and he wants
nt(/trtr);
}
}
-Original Message-
From: 1LT John W. Holmes [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 05, 2002 3:26 PM
To: Ryan Jameson (USA); Art Chevalier; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MySQL Array
I think he meant that he is only pulling one column, i.e
Hi,
I want to insert the upper case of the strings written in the forn, so I put
on the php file called these lines
$NOME=strtoupper($nome);
mysql_query (INSERT INTO anagrafe (codice,nome, cognome, codicefiscale)
VALUES
Message -
From: Antonio Bernabei [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, December 06, 2002 7:12 PM
Subject: Re: [PHP-DB] MySQL Array
Hi,
I want to insert the upper case of the strings written in the forn, so I
put
on the php file called these lines
$NOME=strtoupper($nome
Hi all,
I have a little problem i know that you can help me with...
I have a mysql table
+--+
| year | id |
+
| 2002 | 11 |
| 2003 | 11 |
| 2004 | 11 |
| 2005 | 11 |
| 2001 | 12 |
| 2002 | 12 |
+-+-+
And then i have a loop that takes the year and value
Hello,
I am pulling one column out of a MySQL table in an array. I want to place
each element into a HTML table 4 rows across. I am currently doing this
with the mysql_fetch_array() function. How can I pull out 4 array elements
in one pass through a while loop?
Thanks
Art Chevalier
--
PHP
while ($ar = mysql_fetch_array($rs))
echo trtd. $ar['field1']./tdtd.$ar['field2']./td/tr;
Make sense?
-Original Message-
From: Art Chevalier [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 05, 2002 12:44 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL Array
Hello,
I am pulling
rray($rs))
echo trtd. $ar['field1']./tdtd.$ar['field2']./td/tr;
Make sense?
-Original Message-
From: Art Chevalier [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 05, 2002 12:44 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL Array
Hello,
I am pulling one column out of a MyS
]
Subject: Re: [PHP-DB] MySQL Array
Yes that makes sense, but it is pretty much the same thing I was doing
and
it's producing the same results. Its basically putting the first
element in
all 4 table cells. The thing is...I am only selecting from one field.
Im
trying to get the 4 elements
and clean up the output, but
hopefully that gives you an idea.
---John Holmes...
- Original Message -
From: Ryan Jameson (USA) [EMAIL PROTECTED]
To: Art Chevalier [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, December 05, 2002 3:05 PM
Subject: RE: [PHP-DB] MySQL Array
while ($ar
Hi,
is it possible to get all possible values of an enum-field from a
mysql-table in php?
The values might be changed in the database. Now I've got an
select-field in my php-app where the user can select each value of the
enum-field for a new record befor saving...
Thanks for any reply,
Bastian
DESCRIBE tbl_name col_name
Ignatius
- Original Message -
From: Bastian Vogt [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, December 02, 2002 1:41 PM
Subject: [PHP-DB] mysql - enum
Hi,
is it possible to get all possible values
This is what I use:
SHOW COLUMNS FROM table LIKE field
I use the query result for a select field in HTML table.
Ruth
- Original Message -
From: Bastian Vogt [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, December 02, 2002 11:41 PM
Subject: [PHP-DB] mysql - enum
Hi
Hello all! I am new to php and I am trying to update a mySQL table using
php v4.2.3 for Windows. I am using the command:
mysql_query(insert into tblquotehits
(qoption,referer,browser,remoteaddr,dt) values
($quotetype,$referer,$browser,$remoteaddress,$currentdtstring),$db);
I have read the
22:56
To: [EMAIL PROTECTED]
Subject: [PHP-DB] mysql problem
Hello all! I am new to php and I am trying to update a mySQL table using
php v4.2.3 for Windows. I am using the command:
mysql_query(insert into tblquotehits
(qoption,referer,browser,remoteaddr,dt) values
($quotetype,$referer,$browser
PROTECTED]
Subject: [PHP-DB] mysql problem
Hello all! I am new to php and I am trying to update a mySQL table
using
php v4.2.3 for Windows. I am using the command:
mysql_query(insert into tblquotehits
(qoption,referer,browser,remoteaddr,dt) values
($quotetype,$referer,$browser,$remoteaddress
Hi
How can i change default charset for mysql database.
I want to change default charset on cp1251 just for one database
'dblibrary'. I have seen something like
mysql --default-character-set=cp1251, but i dont know does it work?
Thanks
--
PHP Database Mailing List (http://www.php.net/)
To
Ok, I've been racking my brain trying to figure this one out, so
I thought I'd post the question here and see who bytes. =)
I have a table:
id INTEGER, PRIMARY KEY
parentid INTEGER DEFAULT (0)
name VARCHAR(32) NOT NULL
Ok, and I am using this structure to make a kind of drill down
structure, so
$SQL = SELECT AU,ST,BT,AT,id FROM ccl.ccl_main
WHERE MATCH (AU)
AGAINST ('\Margaret Atwood\' IN BOOLEAN MODE)
ORDER BY id desc;
When I enclose Margaret Atwood in double quotes, it's like having no quotes at all.
Therefore, it searches for all occurences of Margaret and Atwood.
Any inspiration?
Hello all,
I'm new to PHP and would like to start using mySQL (or postgresql) but I keep having
one problem.
In a php file i have a simple call to the function
mysql_connect()
but i constantly get the error
Fatal error: Call to undefined function: mysql_connect()
MySQL support was installed
-Original Message-
From: Jeremy Wood [mailto:[EMAIL PROTECTED]]
Sent: sexta-feira, 22 de Novembro de 2002 18:35
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL connectiviy
Hello all,
I'm new to PHP and would like to start using mySQL (or postgresql) but I
keep having one problem.
In a php file i
On Saturday 23 November 2002 02:34, Jeremy Wood wrote:
Hello all,
I'm new to PHP and would like to start using mySQL (or postgresql) but I
keep having one problem. In a php file i have a simple call to the function
mysql_connect()
but i constantly get the error
Fatal error: Call to
No, I was unable to find a new version of it. Is there a version for php 4.2
?
Jeremy
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi,
I have a problem with an MySQL statement that is driving me mad, I'm using php to
connect to the database. this is it : -
SELECT LINE,SUM(IF(MONTH=2,WB.TEU,0)) AS '2' ,SUM(IF(MONTH=3,WB.TEU,0)) AS '3'
,SUM(IF(MONTH=4,WB.TEU,0)) AS '4' ,SUM(IF(MONTH=5,WB.TEU,0)) AS '5'
Maybe I'm missing something - but the MySQL statement looks right ...
How are you displaying the results?
-Original Message-
From: Griffiths, Daniel [mailto:[EMAIL PROTECTED]]
Sent: 21 November 2002 16:37
To: PHP List
Subject: [PHP-DB] MySQL Problem
Hi,
I have a problem with an MySQL
: 21 November 2002 16:41
To: Griffiths, Daniel; PHP List
Subject: RE: [PHP-DB] MySQL Problem
Maybe I'm missing something - but the MySQL statement looks right ...
How are you displaying the results?
-Original Message-
From: Griffiths, Daniel [mailto:[EMAIL PROTECTED]]
Sent: 21 November
801 - 900 of 1362 matches
Mail list logo