Hello Ryan. I am more of a developer than a MySQL administrator. Hence, I
would always favour applications logging query errors rather than being
dependent on MySQL to generate a log for me. Of course, I may be wrong.
You could write a query execution function, say exec_mysql_query(...) in one
of
[EMAIL PROTECTED] wrote:
looks a bit strange to me.
$result = mysql_query($query) or die('Query couldn\'t
executed:'.mysql_error());
please try something like this:
Why? There's nothing wrong with the above statement.
// build the query - (that's OK)
$query = "UPDATE members SET email_ve
fbsd_user wrote:
> Using this code I get this error message.
>
> Warning: mysql_num_rows(): supplied argument is not a valid MySQL
> result resource in /usr/local/www/data/mls_verifyemail.php on line 49
>
> What code should I use to check if the update worked or not?
Your second line does just th
Maybe I have the overall logic wrong.
I don't do a select query first to see if that record is there.
I just try to update it.
If the logonid key in the update request is on the table, the record
does get updated. I can verify that using phpmyadmin.
When the logonid key in the update request is
David,
Who was the ISP? Maybe they'd like some free advertising. :)Ha! I'd
better wait until April 1, when I hope to have a new home.
I've actually been promoting this webhost since I've been with them. They
just flaked out very badly all of a sudden. Coincidentally, they had a ma
At 04:27 PM 3/12/2006, David Blomstrom wrote:
I recently discovered that all my websites were wrecked. I spent several
hours trying to troubleshoot it, until I finally discovered that my
database was missing. I asked my webhost about it, and they told me they
deactivated it because it was "o
[EMAIL PROTECTED] wrote:
Is this a free hosting package David B?
That's a bit naughty I think - just removing your database
without warning you about it first. At least you would have
had time to make a backup copy.
* * * * *
I'm paying $50 a month, and I was blown away when they s
Is this a free hosting package David B?
That's a bit naughty I think - just removing your database
without warning you about it first. At least you would have
had time to make a backup copy.
Keith
In theory, theory and practice are the same;
In practice they are not.
On Sun, 12 Mar 2006, Da
Maybe I need to read the copy of php pocket reference I have
to David - LOL.
Keith
On Sun, 12 Mar 2006 [EMAIL PROTECTED] wrote:
> To: mysql@lists.mysql.com
> From: [EMAIL PROTECTED]
> Subject: Re: Checking for good update
>
>
> looks a bit strange to me.
>
> > $result = mysql_query($query) o
I recently discovered that all my websites were wrecked. I spent several hours
trying to troubleshoot it, until I finally discovered that my database was
missing. I asked my webhost about it, and they told me they deactivated it
because it was "overwhelming the server."
Someone told me a
looks a bit strange to me.
> $result = mysql_query($query) or die('Query couldn\'t
> executed:'.mysql_error());
please try something like this:
// build the query - (that's OK)
$query = "UPDATE members SET email_verified='X' WHERE
logon_id='" .$logonid. "'";
// send the query to the server -
All ready read that and its clear as mud.
It tells you update is different but gives no example.
I asked in my post what should I code for checking the result of a
update.
-Original Message-
From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 12, 2006 4:5
Perhaps reading the manual would be a good start at
http://us3.php.net/manual/en/function.mysql-num-rows.php
It clearly states
Retrieves the number of rows from a result set. This command is only
valid for SELECT statements. To retrieve the number of rows affected by
a INSERT, UPDATE, or DELETE
Using this code I get this error message.
Warning: mysql_num_rows(): supplied argument is not a valid MySQL
result resource in /usr/local/www/data/mls_verifyemail.php on line
49
What code should I use to check if the update worked or not?
$query = "UPDATE members SET email_verified='X' WHERE
lo
Thanks Michael, that' s the problem. Syntactically my attempt was
correct. Only I had the *value '1' in the only row that table
`friends`contains, whereas table `category`was still empty*. (I was
about creating the database for sample purposes.) When I tried to create
the FOREIGN KEY out of fri
OKAN ARI wrote:
I have 3 tables
Table 1: user(id, name, surname)
Table 2: crime(id, detail)
Table 3: user_crime(id, user_id, crime_id)
Table 1
1, OKAN, ARI
Table 2
1, "detail 1"
2, "Detail 2"
Table 3
1, 1, 1
1, 1, 2
So user 1 takes 2 crime from crime table...
I want to receive info with 1 qu
Hi, we have a db with myisam and a single innodb table. 2 separate
processes are inserting data into the myisam tables and the innodb table at
the same time. We have noticed an issue where commits to the innodb table
appear to be delayed until the process inserting into the myisam tables is
finis
Andreas Krüger wrote:
1) Sorry for not giving you the version:
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
*mysql> SELECT VERSION();
+---+
| VERSION() |
+---+
| 5.0.17-nt |
+---+*
1 row in set (0.00 sec)
InnoDB Status after failing i
I have 3 tables
Table 1: user(id, name, surname)
Table 2: crime(id, detail)
Table 3: user_crime(id, user_id, crime_id)
Table 1
1, OKAN, ARI
Table 2
1, "detail 1"
2, "Detail 2"
Table 3
1, 1, 1
1, 1, 2
So user 1 takes 2 crime from crime table...
I want to receive info with 1 query: I need name
1) Sorry for not giving you the version:
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
*mysql> SELECT VERSION();
+---+
| VERSION() |
+---+
| 5.0.17-nt |
+---+*
1 row in set (0.00 sec)
2) Further, please note that the following output, of
Hello Andreas,
You're not telling us what version of MySQL you're using,
so I'll have to give it a shot in the dark ...
> mysql> SHOW CREATE TABLE friends\G
> *** 1. row ***
>Table: friends
> Create Table: CREATE TABLE `friends` (
> `id`
This is a question onto defining foreign keys in a relational database.
Foreign keys are featured by the InnoDB engine and therefore all three
tables of the database use it:
1. `friends` main table
2. `relation` deploys a simple relation between rows of the main table,
'1-2' means '1 is friend
yes.
on linux it is possible to convert shp files you have to use libmygis
avaliable at http://jcole.us/software/libmygis/
shann
___
Halloween Humour: Why did Dracula divorce his wife after 800 years?
postmaster.co.uk
http://www.
Hi all,
Is there any possibility to convert and store a shape file into the
mysql database like postgis feature in postgres.If there any please give me
the steps how to convert or the link that consists of this documentation.
Thanks in advance,
Regards,
venu.
On Wed, 8 Mar 2006 10:12:22 - <[EMAIL PROTECTED]> wrote:
> but I have two other filters which may or may not be chosen. (area, and
> interest).
>
> $query = "SELECT * FROM $table_name WHERE sname LIKE '$search_string%' AND
> area='area' AND interest='interest' ORDER BY fname $type";
>
>
Hi,
as you know, MD5 and SHA1 are more or less broken so I guess it is time
to think about including other hash-functions in MySQL. First of all it
would be sensible to include SHA256 / SHA512, because they are designed
a bit different to SHA1 and though are more safe. Another issue is to
include
26 matches
Mail list logo
