Original Message
Subject: Re: [PHP-DB] MySQL Conditional Trigger
From: Chris dmag...@gmail.com
To: OKi98 ok...@centrum.cz
Date: 8.12.2008 23:09
anything compared to NULL is always false
Actually it's null.
mysql select false = null;
+--+
| false = null
Original Message
Subject: [PHP-DB] MySQL Conditional Trigger
From: Dee Ayy [EMAIL PROTECTED]
To: php-db@lists.php.net
Date: 31.10.2008 17:09
I don't think my trigger likes a comparison with a variable which is
NULL. The docs seem to have a few interesting variations on
Original Message
Subject: [PHP-DB] Apache crashes every time I call mysqli_fetch_assoc()
From: Bonger O [EMAIL PROTECTED]
To: php-db@lists.php.net
Date: 9.7.2008 19:32
Hi,
I have set up an environment on my Vista laptop comprising of Apache 2.2,
MySQL Server 5.1 and Php
Hello,
yesterday I installed PHP 5.2.7 and whenever I use mysql_connect
function Apache (2.2.9) crashes. Mysqli functions work without problem.
Anybody knows why is this happening or has similar experience?
OKi98
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http
(i.e. stack_id 500 stack_id 601 vs where stack_id = 500 limit 100)
stack_id between 501 and 600 (stack_id 500 stack_id 601) is much
better
What I would like to know is if anybody has experience
implementing this sort of data structure in MySQL (linked list?) or
any advice.
tables:
Original Message
Subject: [PHP-DB] Select...
From: Miguel Guirao [EMAIL PROTECTED]
To: php-db@lists.php.net
Date: 15.1.2008 4:44
Hello List,
I'm having kind of trouble to get done this: Select data from a table,
except those data already in a second table. Actually, if there
.
OKi98
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
VanBuskirk, Patricia napsal(a):
It isn't sending to MySql, we use FileMaker Pro 9. A new record did not get made in the
d'base... the confirmation email went out, but wherever info was supposed to kick back
from the d'base (ie. Order number), it showed an undefined variable error.
Fahmi Basya napsal(a):
Hi, All,
I have problem to insert several data for one customer.
description:
the customer buy some product
example:
customer= jojo.
he buy= hat,coffee and milk
problem:
i confused for inserting data to mysql, because i just can insert only one
product to mysql, i
most likely you have a problem in your query but you dont understand how
to use mysql_error.
from http://www.php.net/manual/en/function.mysql-error.php :
string *mysql_error* ( [resource $link_identifier] )
Returns the error text from the last MySQL function
echo
TG napsal(a):
But what if the data being inserted isn't unique? What if it's a voting
form that says Do you like pie? Yes/No? True, it could record the
response and the userid or IP address so that would be a unique pairing but
what if the vote was anonymous and you allowed multiple
T K napsal(a):
I've learned that this is possible to make and send a unique id in
hidden input, and check if the id is used before database query is
issued. (PHP Cookbook [O'reilly]).
Why? You should always ensure that only unique data are inserted into
database. This is not just about multiple
Niel Archer napsal(a):
Your variable value is not being inserted because you have used single
quotes for the echo, not double quotes as the nabble example does.
Special characters and variables are only interpreted in double quotes,
they are treated literally in single quotes.
--
Niel Archer
ioannes napsal(a):
There is a lot of undefined index and undefined variables when I turn
on error reporting.
lol?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Chris Carter napsal(a):
Hi,
How to fix this in cPanel
Fatal error: Maximum execution time of 30 seconds exceeded in whatever the
URL
Or may be its not the right forum for this query.
Thanks
Chris
http://www.php.net/manual/cs/function.set-time-limit.php
to optimize the query so result is faster?
Thx
optimalisation requests should be supplied with result of explain and
table structure. Without that it is just guessing what may went wrong.
OKi98
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
, I have tables with 500k rows and queries are
running smoothly.
Anyway we cannot help you if you do not post:
1. show create table
2. result of explain query
3. the query itself
OKi98
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
. Is this a bug? Is there
something I'm missing? Any clues? Help!
do you have
*meta http-equiv=Content-Type content=text/html; charset=utf-8*
header in your script?
OKi98
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hello,
Why does anything compared to 0 return true?
I know it might seem to be a bit off-topic, but for me it is important
for detecting if NULL value in table has been changed (for example NULL
is changed to 0).
if (foo==0) echo(foo equals to 0);
OKi98
--
PHP Database Mailing List (http
Mike van Hoof wrote:
http://nl3.php.net/manual/en/language.operators.comparison.php
try using === (3x =) for comparison
- Mike
OKi98 schreef:
Hello,
Why does anything compared to 0 return true?
I know it might seem to be a bit off-topic, but for me it is
important for detecting if NULL
Ford, Mike wrote:
On 03 May 2007 12:30, OKi98 wrote:
I know about identity operator (===) but with == operator 0 is false
and foo is true
No, that's not correct.
, try this:
$foo=0;
$bar=bar;
if ($foo) echo($foo is true, );
else echo($foo is false, );
if ($bar) echo($bar
=mysql_fetch_array($result);
$foo=$tmp[value];
if (!isset($foo)) echo(\$foo is not set but does not produce warning
-$foo-);
OKi98
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Luchino - Samel wrote:
*Question No. 01*
there are some kind of foreign key in database
Some of them want give any error when you delete from the table where the
foreign key is in, this cause the remove is recursive and it delete
also
the ORDER linked to the CUSTOMER (CASCADE foreign key).
In
component
component_id
component_type (enum)
stuff_code
desc
Table pc_component
pc_id (fk)
component_id (fk)
OKi98
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Ron Piggott wrote:
I am creating a form where I am using
$web_site_#
for the various fields. At the present time there are 11 fields I am
asking the user to key in. I am wondering if there is a slick way to
use the mysql_real_escape_string command with this so
$web_site_1 =
with that. The reference can be used in the future - I
think thats why it doesnt produce any error message.
ie.
$array=array(1=a,3=c);
$ref=$array[2];
$array[2]=b;
echo($ref);
OKi98
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I think you also should read this
http://en.wikipedia.org/wiki/Database_normalization
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
marga wrote:
Is not possible to use mysql_insert_id() and assing it in a php variable,
because
mysql_insert_id() is executed after the COMMIT, I think.
wrong, it is possible to use mysql_insert_id() during the transaction.
the code should look like this:
mysql_query(start transaction);
if
) AS 'MegaTotals'
FROM
users u, taskinput t
WHERE
t.user_id = u.user_id
GROUP BY
u.user_id, t.user_id
ORDER BY COUNT DESC
OKi98
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
($result_count);
well, the result is always 1 (even if no students are present), you need
to use some mysql_fetch_* function to get the count of students
ie.
$tmp=mysql_fetch_row($result_count);
$totalrows=$tmp[0];
OKi98
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit
into another
table
do you use insert ... select syntax?
OKi98
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
31 matches
Mail list logo