>> CREATE TABLE log ( idlog int auto_increment not null, imepriimek
>> varchar(50), clock timestamp, action varchar(30), onfile
>> varchar(100), filesize float(6,2),
uniqueid(idlog) ); -- here is your mistake
the syntax for that should be 'unique key(idlog)' if you only wanted
to specify a
On Thu, May 5, 2011 at 10:29, Grega Leskovšek wrote:
> Can smbd please look at this sentence - I got an error and do not
> know how to fix it - I am still very unfamiliar with MYSQL:
>
> CREATE TABLE log ( idlog int auto_increment not null, imepriimek
> varchar(50), clock timestamp, action va
This is the general list. If your problem is with MySQL and queries, let us
know.
Best regards.
--
WB
2010/11/29 Daniel P. Brown
> On Mon, Nov 29, 2010 at 14:35, Don Wieland
> wrote:
> > Hi all,
> >
> > Is there a list/form to get some help on compiling mySQL queries? I am
> > executing them
On Mon, Nov 29, 2010 at 14:35, Don Wieland wrote:
> Hi all,
>
> Is there a list/form to get some help on compiling mySQL queries? I am
> executing them via PHP, but do not want to ask for help here if it is no the
> appropriate forum. Thanks ;-)
Yes.
For MySQL queries, write to the MySQL
On Mon, 19 Jul 2010 10:36:40 -0600
"Ashley M. Kirchner" wrote:
> mysql> select * from table where id='1';
> +---+-+-+---+
> | 1 | 123 | 0.0 | C |
> | 1 | 234 | 0.1 | D |
> | 1 | 345 | 0.0 | D |
> | 1 | 456 | 0.1 | C |
> | 1 | 567 | 0.1 | G |
> +---+-+-
On Thu, Jul 23, 2009 at 08:47:41AM -0500, Johnny Withers wrote:
> Are you sure MySQL is running?
> Can you connect with any other MySQL client?
>
Turns out the php.ini was not set properly.
> On Wed, Jul 22, 2009 at 1:55 PM, Dave Shariff Yadallee - System
> Administrator a.k.a. The Root of the P
Are you sure MySQL is running?
Can you connect with any other MySQL client?
On Wed, Jul 22, 2009 at 1:55 PM, Dave Shariff Yadallee - System
Administrator a.k.a. The Root of the Problem wrote:
> Trying the latest phpMYAdmin on Mac OS X.
>
> Everything is set up correct but I get
>
> #2002 - The s
rds,
Gavin Towey
-Original Message-
From: paras...@gmail.com [mailto:paras...@gmail.com] On Behalf Of Daniel Brown
Sent: Friday, July 10, 2009 9:37 AM
To: workerho...@studysite.eu
Cc: PHP; MYSQL General List
Subject: Re: [PHP] mysql cache query as xml
Chris;
From my understandi
Chris;
From my understanding of your question, your message (included
below in its entirety) is better sent to the MySQL General list, which
I've CC'd on this reply. If you haven't yet, please subscribe there
at mysql-subscr...@lists.mysql.com to follow the thread for responses.
If I
index and it returned successful. So that was
the problem all along.
Thanks for your suggestions.
Best regards
Alugo Abdulazeez.
> From: defati...@hotmail.com
> To: spa...@googlemail.com
> CC: mysql@lists.mysql.com
> Subject: RE: PHP-MYSQL Question
> Date: Tue, 7 Apr 2009 15:32
I've done that but it still gives the same error message.
Date: Tue, 7 Apr 2009 16:25:15 +0200
Subject: Re: PHP-MYSQL Question
From: spa...@googlemail.com
To: defati...@hotmail.com
CC: mysql@lists.mysql.com
it is not the ENGINE as Eugene mentioned above, is that you need to use
UNS
ble2
> remains unsuccessful.
>
> > Date: Tue, 7 Apr 2009 17:56:49 +0400
> > From: evge...@kosov.su
> > To: defati...@hotmail.com
> > CC: mysql@lists.mysql.com
> > Subject: Re: PHP-MYSQL Question
> >
> > I suppose the problem is that table1.table1_id and tab
l@lists.mysql.com
> Subject: Re: PHP-MYSQL Question
>
> I suppose the problem is that table1.table1_id and table2.table1_id are
> of different types. The first one is INT UNSIGNED and the second is just
> INT.
>
>
> abdulazeez alugo wrote:
> > Table1 is as below:
>
mail.com
> CC: mysql@lists.mysql.com
> Subject: Re: PHP-MYSQL Question
>
> # perror 150
> MySQL error code 150: Foreign key constraint is incorrectly formed
>
> What does table1 look like?
>
> abdulazeez alugo wrote:
> >
> > Yeah I used the mysql_error
that be the problem?
> Date: Tue, 7 Apr 2009 17:48:16 +0400
> From: evge...@kosov.su
> To: defati...@hotmail.com
> CC: mysql@lists.mysql.com
> Subject: Re: PHP-MYSQL Question
>
> # perror 150
> MySQL error code 150: Foreign key constraint is incorrectly formed
&g
Apr 2009 17:38:59 +0400
From: evge...@kosov.su
To: defati...@hotmail.com
CC: mysql@lists.mysql.com
Subject: Re: PHP-MYSQL Question
Perhaps you don't have permissions to create tables?
It would have been much clearer if your script was like this:
$result=mysql_query($your_create_table_st
Yeah I used the mysql_error and it returned Can't create table
'.\website\table2.frm' (errno: 150). So what does that say?
> Date: Tue, 7 Apr 2009 17:38:59 +0400
> From: evge...@kosov.su
> To: defati...@hotmail.com
> CC: mysql@lists.mysql.com
> S
Perhaps you don't have permissions to create tables?
It would have been much clearer if your script was like this:
$result=mysql_query($your_create_table_statement);
if($result){ print"Successful";}
else {print "Unsuccessful: ".mysql_error()}
abdulazeez alugo wrote:
Hi guys,
Please can anyo
VeeJay wrote:
Hi there
I am going to make 2 Webserver at my work going to handle 50 mil hits per
month... They are using Linux already. But being a FreeBSD fan, I have
proposed MySQL and FreeBSD to my Boss convincing him that MySQL and FreeBSD
is more Fast and Secure solution for his needs... An
Hi Chaim
Contents are going to be dynamic...
I will go with Apache 2.2.9 and also PHP with ACP (accelator)
Any suggestions?
Regards
VJ
On Tue, Jul 22, 2008 at 10:18 PM, Chaim Rieger <[EMAIL PROTECTED]>
wrote:
> VeeJay wrote:
>
>> Hi there
>>
>> I am going to make 2 Webserver at my work going
Me, too. One thing that's a plus for my clients is to tell them that is
will cost them less if I develop in php/mysql as opposed to ASP/MSSQL.
Hosting is cheaper and I can do things in PHP that takes 5 lines as opposed
to ASP/MSSQL which takes 20. heh
Jenifer
- Original Message -
I have used both and I prefer php/mysql
:-)
On 11/4/05, Peter Brawley <[EMAIL PROTECTED]> wrote:
> Marc,
>
> >I've been using ASP for years but I have to work on a bigger project
> involving many
> >users and data so of course, Access is not an option anymore. Since
> it's a project requiring
>
Marc,
>I've been using ASP for years but I have to work on a bigger project
involving many
>users and data so of course, Access is not an option anymore. Since
it's a project requiring
>thousand of files and several applications all linked together, I
can't create it once and change
>it later.
Jigal van Hemert <[EMAIL PROTECTED]> wrote on 11/04/2005 03:09:58 AM:
> Marc Pidoux wrote:
> > I've been using ASP for years but I have to work on a bigger project
> > involving many users and data so of course, Access is not an option
> > anymore. Since it's a project requiring thousand of file
Jigal van Hemert wrote:
Hi Joerg (and other list readers),
Joerg Bruehe wrote:
Jigal van Hemert wrote:
Win/IIS/ASP/MSSQL might need a bit more hardware to run on compared
to Linux/Apache/MySQL/PHP (aka LAMP).
You could always run MySQL on Windows Server along with your IIS and
ASP. You don
riginal Message-
From: Pooly [mailto:[EMAIL PROTECTED]
Sent: Friday, November 04, 2005 7:37 AM
To: MySQL General
Subject: Re: PHP/MySQL vs ASP/MSSQL?
2005/11/4, Marc Pidoux <[EMAIL PROTECTED]>:
> I've been using ASP for years but I have to work on a bigger project
> inv
2005/11/4, Marc Pidoux <[EMAIL PROTECTED]>:
> I've been using ASP for years but I have to work on a bigger project
> involving many users and data so of course, Access is not an option
> anymore. Since it's a project requiring thousand of files and several
> applications all linked together, I can'
Hi Joerg (and other list readers),
Joerg Bruehe wrote:
Jigal van Hemert wrote:
Win/IIS/ASP/MSSQL might need a bit more hardware to run on compared to
Linux/Apache/MySQL/PHP (aka LAMP). The license costs for a LAMP setup
will probably be higher. Both will be able to do the job.
mysql@lists.mysql.com
Subject: Re: PHP/MySQL vs ASP/MSSQL?
Hi Jigal, all!
Jigal van Hemert wrote:
[[...]]
Win/IIS/ASP/MSSQL might need a bit more hardware to run on compared to
Linux/Apache/MySQL/PHP (aka LAMP). The license costs for a LAMP setup
will probably be higher. Both will be able to do t
Hi Jigal, all!
Jigal van Hemert wrote:
[[...]]
Win/IIS/ASP/MSSQL might need a bit more hardware to run on compared to
Linux/Apache/MySQL/PHP (aka LAMP). The license costs for a LAMP setup
will probably be higher. Both will be able to do the job.
^^
No flame war intend
Marc Pidoux wrote:
I've been using ASP for years but I have to work on a bigger project
involving many users and data so of course, Access is not an option
anymore. Since it's a project requiring thousand of files and several
applications all linked together, I can't create it once and change i
On 6/10/05, Andre Matos <[EMAIL PROTECTED]> wrote:
> I am getting slow connections between php4 and MySQL 4.1.9.
>
> There are some connections that are very fast, but others can take from 5 to
> 20 second or more (usually it takes less than 0.1 second to create a new
> connection). I tried to
mysql_connect('localhost', 'my_user', 'my_pass')
or die(mysql_error()):
On Tue, 8 Mar 2005 11:28:47 -0600, Jay Blanchard
<[EMAIL PROTECTED]> wrote:
> [snip]
> I am a new mysql user. I installed a MySQL, PHP and Apache on my
> computer with Windows XP.
> All my php scripts run fine unless I try
[snip]
I am a new mysql user. I installed a MySQL, PHP and Apache on my
computer with Windows XP.
All my php scripts run fine unless I try to connect to mysql
I don't get any response even error message and page source looks like
Untitled Document
start here
I guess that I am doing
Are you running the 2 queries at the same time? they should be run 1 at
a time. What does mysql_error() say? use it when you are checking the
result set (if (!$result) { echo "Error: " . mysql_error();}Are the
result sets being sent to 2 different identifiers? Just a few
possibilities.
Re
Hi.
How did you check that Query 2 has been executed?
You may add to your php.ini file
mysql.trace_mode = On
to see some warnings and errors.
Yahoo Default User <[EMAIL PROTECTED]> wrote:
> Hi Guys,
>
> I have a problem with MySQL in conjunction with PHP so
> I also decided to post h
when asking a question, it always helpful to post you code/queries so we
can see what is happening.
but tbh, this sounds like it's a php code problem.
you have established that both queries work, on there own
I'm don't know anything about php, but it sounds like you are not
executing the first quer
Dear Friends,
I have installed MySQL-devel RPM (Standard - gcc) and used it for
compiling PHP. MySQL Server remains the same intel build. It is working
perfectly although this may not be the desired solution.. please post if u
find any results.
Special Thanks to Mr.Egor Egorov for giving me a good
"Santhanam" <[EMAIL PROTECTED]> wrote:
> Dear Friends,
>I am trying to compile PHP with MySQL support in an HP DL380
> server (Xeon Processors). The MySQL is build with Intel Compiler.
> I am getting the following problem / error :
You have to link the client applications with some intel
ich has caused the "read
> the manual" bar to
> be pushed somewhat higher.]
>
>
> -- Original Message --
> > From: Stuart Felenstein <[EMAIL PROTECTED]>
> > To: [EMAIL PROTECTED], [EMAIL PROTECTED]
> > Date: Thursday, August 26, 20
First let me say thank you for all the responses.
Now, let me say I'm not sure what exactly I need to
do. Explanation - Primarily I have absolutely no
experience with PHP , but I can learn, so that's
helpful :)
The thing I'm trying to figure out is what I need to
learn, because currently I'm develo
Hi,
First mysql_fetch_row() returns an array so it doesn't make much sense to
compare it to 5. If you want to check tne number of records the query has
returned you should use mysql_num_rows() - like this
if(mysql_num_rows($result)>=5){ }
or if you want to check the value returned by the query
Thought earlier that I could get by on just plain SQL.
> Php needed. I'm getting a parse error on the "if"
> line.
> This is supposed to be a trigger then before
> transaction counts the number of rows , id already
> inserted, if exceeded , kick back error message , halt
> transaction.
> Not s
[EMAIL PROTECTED] wrote:
> I'm installing the php-mysql-4.3.6-1.3.i386.rpm and it's complaining about a
> dependency libmysqlclient.so.10. My mysql server version is 4.0.20.
>
> Can anyone tell me where I can get libmysqlclient.so.10.
Download MySQL RPMs from http://dev.mysql.com/
The package co
you can get that on the mysql-client package
On Wed, 30 Jun 2004 00:35:13 -0500, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I'm installing the php-mysql-4.3.6-1.3.i386.rpm and it's complaining about a
> dependency libmysqlclient.so.10. My mysql server version is 4.0.20.
>
> Can an
Dear Mark,
Please set your from address to [EMAIL PROTECTED], and don't
use my email address.
Thanks,
Mike
> -Original Message-
> From: Michael McTernan
> Sent: 16 April 2004 10:21
> To: Joseph A. Nagy, Jr.; MySQL General
> Subject: Re: PHP + MySQL Not Playing Nice
From: Jianping Zhu [mailto:[EMAIL PROTECTED]
>but i got error message with:
>http://coopunit.forestry.uga.edu:8080/testdb.php
>the error is:
>Fatal error: Call to undefined function:
>mysql_connect() in /var/www/html/testdb.php on line 13
>
>How can Fix this problem? Thank
The PHP page that was being reported at being in error wasn't the one in
error.
Sorry for wasting everyone's bandwidth and time.
--
Joseph A. Nagy, Jr. http://joseph-a-nagy-jr.homelinux.org
Political Activist Extraordinaire Peace, Life, Liberty
"The only fallacy is the inaction on our pa
Okay, I got phpmyadmin back but
http://logd-test.joseph-a-nagy-jr.homelinux.org still is having problems
(click the link to see the problem) and I've gone through and commented out
the lines it refers to but then all I get is a blank page. So I copy a
fresh, untouched copy of dbwrapper.php to / for
The only thing that changed in the environment was the creation of a script
that temporarily introduces a variable ($MP3) to be created and then
accessed by the script in question but the script doesn't touch mysql at
all. What could have changed so drastically as to kill access to the db so
comple
On Fri, Apr 16, 2004 at 12:07:39AM -0400, Mark Susol | Ultimate Creative Media wrote
the following:
> On 4/15/04 11:46 PM, "Joseph A. Nagy, Jr."
> <[EMAIL PROTECTED]> wrote:
>
> > So I'm using PHP and MySQL to serve up a game and all is going well until
> > today. The first problem came when for
On 4/15/04 11:46 PM, "Joseph A. Nagy, Jr."
<[EMAIL PROTECTED]> wrote:
> So I'm using PHP and MySQL to serve up a game and all is going well until
> today. The first problem came when for some reason the game was sending
> apache as the username to access the db (which is not what I have in the
>
At 16:43 -0400 10/1/03, [EMAIL PROTECTED] wrote:
I need to know the syntax to link two tables together that are in two
seperate DB's using the ODBC drivers in PHP. Can anyone help with an
example?
Depends on what you mean by "link two tables together." if you're trying
to perform a join, you can
Hi ,
u can try this one out
http://www.zend.com/zend/tut/tutorial-delin4.php
Regards
Eric
===
Kamara Eric Rukidi Mpuuga
Computer Frontiers International
Plot 32 Lumumba Avenue
P.O Box 12510,Kampala
Tel :256-41-340417/71
Mob :256-71-190856
Email:[EMAIL PROTECTED]
Web
You need to create a cookie session using start_session() and something like
that. I'm actually reading up on it on this book
PHP & MySQL Web development - luke welling & Laura thomson (i think)
Cheers,
Mun Heng, Ow
H/M Engineering
Western Digital M'sia
DID : 03-7870 5168
-Origin
ecoming Digital [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 14, 2003 2:58 AM
To: [EMAIL PROTECTED]
Subject: Re: PHP, MySQL and Apache
If PHP was built without MySQL support, you need to recompile it. It should
be
in there, though, so check the php.ini file.
Edward Dudlik
Becoming Digital
www.beco
Use sessions in PHP (super simple, just call session_start() at the top
of every page i.e. like in an include file) and use
$_SESSION['loginname']
I would strongly recommend using mod_auth_mysql for your authentication.
It's easy and probably more secure than anything you can write ;-) Plus
it let
actually, its worse. upon re-reading you need to compile in the mysql
drivers for mysql.
configure --with-mysql=
Curtis
Subscriptions said:
> The httpd.conf connects PHP to Apache. What connects PHP to MySQL?
>
>
> I've looked through google and I can't find anything that makes since
> to me.
You need to recompile PHP against the 4.0.nn headers.
Curtis
Subscriptions said:
> The httpd.conf connects PHP to Apache. What connects PHP to MySQL?
>
>
> I've looked through google and I can't find anything that makes since
> to me. Can someone point me in a direction as to where I can find t
Peter Burden wrote:
Subscriptions wrote:
The httpd.conf connects PHP to Apache. What connects PHP to MySQL?
I've looked through google and I can't find anything that makes since
to me.
Can someone point me in a direction as to where I can find this out?
The problem I'm having is I have PHP 4.3
Peter,
When you get everything working please let me know how you did it. I have been trying for days without any luck.
Regards,
Jay
---Original Message---
From: Peter Burden
Date: vrijdag 13 juni 2003 22:46:20
To: Subscriptions
Cc: [EMAIL PROTECTED]
Subject: Re: PHP
Subscriptions wrote:
The httpd.conf connects PHP to Apache. What connects PHP to MySQL?
I've looked through google and I can't find anything that makes since to me.
Can someone point me in a direction as to where I can find this out?
The problem I'm having is I have PHP 4.3.2, MySQL 4.0.13 and A
If PHP was built without MySQL support, you need to recompile it. It should be
in there, though, so check the php.ini file.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Subscriptions" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, 13 June
This type of presentation must be produced by code - either your application
(i.e. in your PHP code) or by a report generator.
SQL statements always return data in a tabular format, i.e.
(Topic, Question)
1,1
1,2
1,3
1,4
2,1
2,2
...etc.
In your presentation loop (PHP), remember the "previous" va
> On Wednesday 22 January 2003 18:52, 1LT John W. Holmes wrote:
>
> > There's really no change from the PHP side. PHP just sends the data
and
> > receives something back The only change in PHP is that
mysql_connect()
> now
> > supports additional flags to connect over SSL.
>
> Nope, I only forgot
On Wednesday 22 January 2003 18:52, 1LT John W. Holmes wrote:
> There's really no change from the PHP side. PHP just sends the data and
> receives something back The only change in PHP is that mysql_connect() now
> supports additional flags to connect over SSL.
Nope, I only forgot to remove a con
> Anyone out there have anything to share as to using PHP4+MySQL4. I've been
> hearing good things on the MySQL list about v4.0 and I'm thinking of
> upgrading, since I run a rather small server.
There's really no change from the PHP side. PHP just sends the data and
receives something back The on
in
Regards Bob
-Original Message-
From: jeff e [mailto:mylist@;workingtitle.net]
Sent: Wednesday, November 06, 2002 4:04 PM
To: Bob G; [EMAIL PROTECTED]
Subject: Re: PHP & mysql
So did you find the window with all the extension mappings?
Here's what you need to do -
Right click
- Original Message -
From: "Bob G" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, November 06, 2002 3:38 AM
Subject: RE: PHP & mysql
> Hi Jeff, many thanks for your reply.
>
> I have checked my installation and
n
settings.
Any other Ideas please?
Regards Bob
-Original Message-
From: jeff [mailto:mylist@;workingtitle.net]
Sent: Tuesday, November 05, 2002 5:47 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: PHP & mysql
From: http://www.dynamic-webpages.de/php/install.iis.php
---
> I'm trying to get the total matched rows when I'm using "LIMIT 0, 10",
> but I only get the number 10, when the total should be around 100. So,
> can I get total matched rows without doing a separate query using
> count()?
You first have to get the whole result set without the limit OR make use
The mysql_num_rows() function returns the number of rows returned in your
record set, which when limited is 10 (not 100). Thus you will have to do
another query.
--Joe
--
Joe Stump
Affordable Computers, Inc.
800-864-2345 x113
- Original Message -
From: "SED" <[EMAIL PROTECTED]>
To: <[EMAI
From: http://www.dynamic-webpages.de/php/install.iis.php
-
"If you want to use the CGI binary, do the following:
Under 'Home Directory', 'Virtual Directory', or 'Directory', click on the
'Configuration' button, and then enter the App Mappings tab.
Click Add, and in the Executable box, t
"Shaun Bramley" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hello all,
>
> I am using mySQL and PHP, how can I use PHP to display the length of time
> used by a query?
Shaun,
HTH.
-
This is more of a php question. explode $string on " " (space) which will
give you an array. Loop through the array first with $sql.="WHERE
whatevercolumn LIKE '%$val%'" then for every other entry change WHERE to
AND.
Serge.
- Original Message -
From: "Paul Maine" <[EMAIL PROTECTED]>
T
Pada Sat, 27 Jul 2002 21:32:48 -0500
"Paul Maine" <[EMAIL PROTECTED]> menulis :
> $string ="1972 Ford Mustang"
>
> Using the following SQL statement:
> SELECT * FROM whatevertable WHERE whatevercolumn LIKE '%$search%
> I want to return all records that have Mustang AND 1972 AND Ford.
my sugges
t;cristian ditoiu" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Monday, June 10, 2002 10:53 PM
Subject: Re: php+mysql+multiple lines qry
> Why not just use something like:
> insert into questions (field1,field2,...) select...
>
> You don't need to create tem
Why not just use something like:
insert into questions (field1,field2,...) select...
You don't need to create temp tables for your data and all the other
complicated stuff.
> hello .
> i use php 4.12 + mysql 3.23.49 on linux .
> i've developed a online testing(quiz) -aplication that now is expe
Luie,
> Wouldn't replace change all the entries in your table row, same effect as update?
> I believe the question is how to test which entry in a form has a new value and
>replace/update only that value
in the table.
> If I have a form...
>
> __
> |Employee Reco
Wouldn't replace change all the entries in your table row, same effect as update?
I believe the question is how to test which entry in a form has a new value and
replace/update only that value in the table.
If I have a form...
__
|Employee Record Update|
|
What about REPLACE?
http://www.mysql.com/doc/R/E/REPLACE.html
'REPLACE works exactly like INSERT, except that if an old record in the
table has the same value as a new record on a unique index, the old record
is deleted before the new record is inserted'
Regards,
Dan
> -Original Message---
Bob,
I've posted this back onto the list because there are others here who will be much
more able to assist.
> Clarification:
>
> I currently have 22 NT workstation that send data to various tables in a
> SQL7 database running on a NT sever. The visual basic front end organizes
> this data in t
Hi Bob,
> Hi, I currently have a very large MS SQL7 database that I need to put on the
> web. My plan is to use PHP and MySQL to accomplish this. Currently I have a
> Visual Basic front end on the MS SQL7 Server. I would like to have my VB
> program write The MS SQL7 server data to a MYSql databa
Hi bob,
I have do everything you need but may be a little diff. I have MS
SQL 6.5 on NT, MySQL 3.23.47 on Linux and using PHP / VB 6 for client. The
first thing you must define some role of usage and other, how to manipulate
your data. I have PHP update routing in some project (tran
Bob,
I've posted this back onto the list because there are others here who will be much
more able to assist.
> Clarification:
>
> I currently have 22 NT workstation that send data to various tables in a
> SQL7 database running on a NT sever. The visual basic front end organizes
> this data in t
Hi Bob,
> Hi, I currently have a very large MS SQL7 database that I need to put on the
> web. My plan is to use PHP and MySQL to accomplish this. Currently I have a
> Visual Basic front end on the MS SQL7 Server. I would like to have my VB
> program write The MS SQL7 server data to a MYSql databa
irish
--
www.girishnath.co.uk
- Original Message -
From: "Ben Clumeck" <[EMAIL PROTECTED]>
To: "Girish Nath" <[EMAIL PROTECTED]>
Sent: Tuesday, January 29, 2002 1:51 AM
Subject: RE: [PHP] MySQL Newbie
I am under the understanding that anyone who has shel
If you're looking for php. suft on over to the PHP homeworld:
http://php.net current version is 4.1.1
David
> Does anyone have the location of a php-mysql-4.0.3 version that I could
> download?
>
> Tobe
>
>
> -
> Before posti
Hi Josep
We have to be clear about definitions.
You seem to be making a couple of mistakes here:
1 - guestbook.sql is not the db, but probably a script to create the db (you
can check by opening it in a text-editor - it will probably have a CREATE
TABLE statement at the top, then the field defin
Hi.
First, please avoid cross-posting.
Try to narrow down the problem by trying from the command line client
(i.e. try to rule out PHP as source of the problem). If that doesn't
work, try the PHP list.
If you are successful, it belongs to the MySQL list (as PHP is no
longer part of the problem)
One of three issues:
1 - the db is not set up correctly;
2 - the user is not set up correctly;
3 - the PHP script is not calling the db properly - this could be due to
wrong syntax, misnaming of the db table, or incorrect username parameters.
You would need to post some more info, in particular
I've had a few queries that worked strangely worked in Mysql monitor,
but did not work from PHP.
I was able to solve every one of them by ensure that the query in PHP did
not have any line breaks in it. It normally doesn't matter if there are
line breaks in the code, but on occassion, a line
sorry Todd, i meant into my own users table that i have created.
- Original Message -
From: "Todd Williamsen" <[EMAIL PROTECTED]>
To: "'Anthony Evans'" <[EMAIL PROTECTED]>; "'MYSQL help'"
<[EMAIL PROTECTED]>
Sent: Thurs
What do you mean accept new users?
Via adding new people to the MySQL user list or to a web application?
Please specify..
Thank you,
Todd Williamsen, MCSE
home: 847.265.4692
Cell: 847.867.9427
-Original Message-
From: Anthony Evans [mailto:[EMAIL PROTECTED]]
Sent: Thursday, Novembe
On 30-Oct-2001 Matthew Walker wrote:
> Does anyone see anything wrong with the following code/query syntax? I'm
> using the PEAR DB class for PHP. When this runs, it correctly inserts
> the row to the table, but is failing to retrieve the last_insert_id().
>
> function StartOrder()
> {
> globa
rd PHP functions won't work. (And yes, I did just test it.)
>
> -Original Message-
> From: rc [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 30, 2001 1:58 PM
> To: Matthew Walker
> Cc: [EMAIL PROTECTED]
> Subject: Re: PHP/MySQL Problem
>
> Mysql_Inse
rc wrote:
> Mysql_Insert_ID($dbhandle->connection);
>
> gets the last id of the last insert statement -
> if you do any db activity
> after the insert, this won't work.
In other words:
> $res = $dbhandle->query("select
last_insert_id()");
> $dbhandle->query("UNLOCK TABLES");
> $res
s, I did just test it.)
>
> -Original Message-
> From: rc [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 30, 2001 1:58 PM
> To: Matthew Walker
> Cc: [EMAIL PROTECTED]
> Subject: Re: PHP/MySQL Problem
>
> Mysql_Insert_ID($dbhandle->connection);
>
> gets th
PROTECTED]
Subject: Re: PHP/MySQL Problem
Mysql_Insert_ID($dbhandle->connection);
gets the last id of the last insert statement - if you do any db
activity
after the insert, this won't work.
On Tue, 30 Oct 2001, Matthew Walker wrote:
> Does anyone see anything wrong with the following c
Mysql_Insert_ID($dbhandle->connection);
gets the last id of the last insert statement - if you do any db activity
after the insert, this won't work.
On Tue, 30 Oct 2001, Matthew Walker wrote:
> Does anyone see anything wrong with the following code/query syntax? I'm
> using the PEAR DB class f
1 - 100 of 123 matches
Mail list logo
