On Sat, 27 Oct 2001 13:36:57 +1000
"Andrew Duck" <[EMAIL PROTECTED]> wrote:
> Error
> SQL-query :
>
> CREATE TABLE mail (
> from int(32) NOT NULL default '0',
> to int(32) NOT NULL default '0',
> subject varchar(80) NOT NULL default '',
> message text NOT NULL
> ) TYPE=MyISAM
>
>
>
Error
SQL-query :
CREATE TABLE mail (
from int(32) NOT NULL default '0',
to int(32) NOT NULL default '0',
subject varchar(80) NOT NULL default '',
message text NOT NULL
) TYPE=MyISAM
MySQL said:
You have an error in your SQL syntax near 'from int(32) NOT NULL default '0',
to int
I'm trying to read a record from a dbase data base so I've previously
opened it successfully. The problem is that I call the function
dbase_get_record, but it returns no records. The database is ok because I
call the funcion dbase_numfields and dbase_numrecords and they give me
correct information
>
>
> Source code- CÛdigo fuente:
>
> $based="articulo.dbf";
> if (($descriptor=dbase_open ($based, 0))==0){
>printf ("Error al abrir la base de datos");
> }else{
>printf ("Base de datos abierta");
>$num_registros=dbase_numrecords($descriptor);
>$num_campos=dbase_numfields($descr
I'm trying to read a record from a dbase data base so I've previously
opened it successfully. The problem is that I call the function
dbase_get_record, but it returns no records. The database is ok because I
call the funcion dbase_numfields and dbase_numrecords and they give me
correct informa
> if ($row = mysql_fetch_array($result)) {
>
> /* Change all instances of db_table to match your db table structure */
> do {
> PRINT "Your search results: ";
> PRINT "db_table: ";
> print $row["db_table"];
> print ("");
> .
> [ NUMEROUS REPETITIONS WERE HERE ]
> .
> P
Well I would like to thank everyone that helped me create php script to
search a MySQL database using a form to pass the contents of the textbox to
the php script as a variable in the search string. Here is the final script
if anyone wants to use it, update, enhance feel free just send me a copy
I would actually recommend running the built in MSSQL functions in PHP, I
have a stored procedure on a MSSQL server that updates and returns
information, and PHP handles it fine. You will have to enable the
PHP_MSSQL.dll library (if on Windows) in the php.ini file. Here's an
example of the store
Hi, I'm new to this newsgroup, and I can't seem to find this anywhere else,
so I thought I would ask.
I have a problem getting output from stored procedures through PHP. I am
connecting to an MS-SQL server through odbc (easysoft OOB), however this is
a flexible environment. What I really need t
I had the same problem, and it seems to be tied to very specific releases of
IE. Unfortunately one of them is released with Win98 SE, so it could be
widespread. My version is 5.00.2614.3500
It also affects some static pages, so it may be an IE/Apache issue.
Disabling SSL3 support in IE fixed it,
I'm programming a credit card payment form using PHP and I have been getting
some strange feedback from test groups. The groups are varied as much as
possible, and it seems as though some of the ones using MSIE 5.x are having
trouble connecting to the secure page while others using MSIE 5.x CAN
co
Hi,
I've read the bug report regarding the -lsybtcl errors (as I got them
myself, and did a search through the mailing lists). There's a patch
available for php 4.0.3pl1, however I'm looking for one that patches php
4.0.6. Is there any out there? Or can I use the patch for 4.0.3pl1 with a
litt
Yes, PHP is nice. But the more we force MySQL to perform, the less is
required of PHP and the script writer.
-Original Message-
From: Steve Cayford [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 26, 2001 9:49 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] date
Check out the date fun
Check out the date functions in php, they're very nice. mktime(),
date(), strftime(), and setlocale()
-Steve
On Friday, October 26, 2001, at 08:47 AM, Rick Emery wrote:
> Assume the following table:
> create mytable (
> mydate date );
>
> Assume the following inserts:
> INSERT INTO mytable
User inserts date as a select menu for day, month and year: $day, $month, $year
You swap it around for an insert: $dateinsert = $year . $month . $day
Then query the DB: Select blah from blah where blah=blah order by datefield (Let MySQL
do the rest)
Good luck!
Russ
On Fri, 26 Oct 2001 12:10:51
Assume the following table:
create mytable (
mydate date );
Assume the following inserts:
INSERT INTO mytable VALUES( "2003-02-20");
INSERT INTO mytable VALUES( "2004-12-25");
INSERT INTO mytable VALUES( "1999-01-01");
The following will order this table, assuming precedence of
year->month->da
David:
I had this same problem and found several approaches to solving the problem
in the user contributed notes section of
http://www.php.net/manual/en/function.ocilogon.php.
They all boil down to:
1. Is the Listener started? In your case, it appears so because you can
TNSPing the Oracle serve
I think you want this.
$sql = "INSERT INTO table (cod, nome, email) VALUES ('', '$nome',
'$email')";
$result = mysql_query($sql);
$cod = mysql_insert_id();
The $cod is the primery key.
Hope it helps.
Bruno Gimenes Pereti.
- Original Message -
From: "Matt Stewart" <[EMAIL PROTECTED]>
To
What i'm after is getting the primary key for a record that's just been
added - I have an image file upload accompanying a database addition, and
the image gets renamed $unique_ID.jpeg
only problem is that the current method inserts the information, which auto
produces the primary key, but the onl
If your php-script runs on the same server as mysql, you should try
'localhost' as the hostname.
That worked for me in most cases.
"Russ Michell" <[EMAIL PROTECTED]> schreef in bericht
news:SIMEON.10110260917.B@k1c. anglia.ac.uk...
> >Of course, it works perfectly fine on my home computer, so I g
how would i enter european format date into mysql (dd/mm/) ... and how
would i make the query sort by date if i am using this format ??
ax
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To con
For developement reasons (oracle realted) I hadto abandone mod_php.tgz (php
4.0.5) package delivered with slackware 8.0 and use php 4.0.6 so I.m
currently working with:
php 4.0.6 and apache 1.3.20 ona a slackware 8.0 (with kernel 2.2.19).
At first I recompiled php 4.0.6 with exact same options of
I am new to MySQL (I am more used to Microsoft SQL), but it seems to me that
if I provide "username" string as the username parameter, that's what MySQL
should use to login into the database. Why is "@lsh101.siteprotect.com "
being appended to it? The "username" was provided by the webhost, and
a
>Of course, it works perfectly fine on my home computer, so I guess it musthave
>something to do
>with the configuration of PHP (or, possibly, MySQL?)
How do you connect to MySQl from home?
It sounds as if the user trying to connect to MySQL doesn't have the right privileges
to connect
top th
I cannot connect to MySQL database located at the webhost. The command:
$link = mysql_connect('hostname:3306','username','password') or die ("Could
not connect");
(with the proper hostname of course) returns this error message:
MySQL Connection Failed: Access denied for user:
'[EMAIL PROTECTED]'
25 matches
Mail list logo
