A "create" SQL statement is just an SQL statement.
Send it the same way you would send "Select"
You'll have to have the permissions set up right, so use mysql_error() until
you figure out what's going on.
--
WARNING [EMAIL PROTECTED] address is an endangered species -- Use
[EMAIL PROTECTED]
Wan
The timestamp data type is a special MySQL type that automatically updates
whenever you add or update a row in a table.
If you want timestamp to work when you add a row but not when you update a
row, you need to write your update statements like this:
UPDATE tbl_name SET vartochange="newvalue",
>You cant use a select statement withoug using a table name.
>check out this
>$query = "insert into classification(customername) (select customername
from username >where username='$username')";
Incorrect in mySQL you can do
mysql> select 3+5;
returns 8
plus a whole lot of other functions that
You cant use a select statement withoug using a table name.
check out this
$query = "insert into classification(customername) (select customername from username
where username='$username')";
i cant answer ur second question, since i dont the
structure of your table
/sagar
original message
Nope,
MySql doesn't allow select within select...
try making two seperate queries...
"Lizlynch" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
i have two tables here, i want to insert the customername from the Username
table and insert it into the Classification
adding an "@" sign in front of the mysql functions ($db =
@mysql_connect(...)) will switch the function "silent", meaning PHP won't
display any error messages if the function fails. did you try that?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
Fo
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] (Niklas lampén) wrote:
> Can it cause any problems if mySQL query is very long? I have to compare
> many words to many fields in my DB and I've done it like
> "Field LIKE '%searchword%' || Field LIKE '%searchword%' || Field LIKE
> '%searchwor
This would probably be a better question for a MySQL newsgroup...
Anyway, I am just talking off the top of myhead since I never did
anything like this, but i don't think copying DB files is the proper way
to move databases. I believe there is some MySQL dump utility you need
to create one tra
Hi Niklas,
You can use || or OR.
Secondly, huge list of values you say? Can this list be exploded by a
common denominator, like a space or comma? If so, consider this:
$list = // Huge list of words (array), separated by a comma.
$words = explode(",", $list);
$query = "SELECT * FROM table WHER
Sorry Emilio, this should have gone to Dave.
- Original Message -
From: Hugh Danaher <[EMAIL PROTECTED]>
To: Emilio Panighetti <[EMAIL PROTECTED]>
Cc: Php-General <[EMAIL PROTECTED]>
Sent: Saturday, August 18, 2001 5:16 PM
Subject: Re: [PHP] Re: MySql or flat database us
o.
Oh, and by the way, the only software writing experience I've had, was a
course in BASIC 23 years ago. Good luck.
- Original Message -
From: Emilio Panighetti <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, August 18, 2001 2:06 PM
Subject: [PHP] Re: MySql
It depends... if you have a handful of records, you might start with a flat
file. but if you think you'll get to hundreds of records, go with a
database.
Even if all you want is a small array of data, go with a database.
If all you want is a simple array, you might consider use DBM files (Look
at
It all depends on you, I basically get used on using mysql_fetch_array which
returns an associative array.
example:
$result = mysql_query("SELECT name, lastname, age FROM table");
$ra = mysql_fetch_array($result);
or
$ro = mysql_fetch_object($result);
or
$rr = mysql_fetch_row($result);
now:
echo
"Charles Williams" <[EMAIL PROTECTED]> wrote in
message 008801c12588$80bc7960$fe0aa8c0@chucks">news:008801c12588$80bc7960$fe0aa8c0@chucks...
> Hey folks,
>
> if you go to http://www.acnsnet.com/czc/show.php?state=Bayern You can see
> my problem with this query. This thing is killin me so if you
On Wed, 8 Aug 2001 09:28, hassan el forkani wrote:
> thanks everybody for your help, i actually had the solution before
> posting :))
>
>
> my question was not a 'how to' but why do we need to escape single
> quotes on unix systems and not on windows using the same version of php
> and mysql?
Yo
thanks everybody for your help, i actually had the solution before posting :))
my question was not a 'how to' but why do we need to escape single quotes
on unix systems and not on windows using the same version of php and mysql?
At 21:44 07/08/01, you wrote:
>Dear PHP-General (bit of strange,
> select tableA.*, tableB.* from tableA,
> left join tableB ON tableA.keyfield = tableB.keyfield
>
> When I then try to access the column "keyfield", after using
select tableA.keyfield as mykeyfield, tableA.*, tableB.* ...
Unless you actually need *EVERY* field, do *NOT* use tableA.*, tableB.*
Maybe you run out of diskspace??
Greets, Leon
Elias wrote:
> Table is full?
>
> did you try searching MySql.com for "Table is full" error message?
>
> "Andreas )" <[EMAIL PROTECTED]> wrote in message
> 000c01c10b81$c765aa60$8d0a@devel01">news:000c01c10b81$c765aa60$8d0a@devel01...
> hi a
Table is full?
did you try searching MySql.com for "Table is full" error message?
"Andreas )" <[EMAIL PROTECTED]> wrote in message
000c01c10b81$c765aa60$8d0a@devel01">news:000c01c10b81$c765aa60$8d0a@devel01...
hi all,
my script was now working for month but now
suddenly get this error:
Correct, SET must be before WHERE.
Joseph
CollegeSucks.com
-Original Message-
From: Tyler Longren [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 22, 2001 4:04 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] mysql error, dont see why.. please help
Shouldn't it be:
m
301 - 320 of 320 matches
Mail list logo