Original Message
Subject: Re: [PHP-DB] MySQL Conditional Trigger
From: Chris
To: OKi98
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 playi
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 5.2.
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.
Original Message
Subject: Re: [PHP-DB] Manipulating Blob Fields
From: julian <[EMAIL PROTECTED]>
To: php-db@lists.php.net
Date: 14.2.2008 11:24
After some research I found a workaround, not a solution. Diggin in
www.php.net I found the following (potential) bug apparently res
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 ther
Original Message
Subject: [PHP-DB] Looking for specific data
From: DeadTOm <[EMAIL PROTECTED]>
To: php-db@lists.php.net
Date: 22.11.2007 3:22
There has to be an easier way to do this. I have a page with a list of
29 options utilizing checkboxes. The options that are checked get
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.
-Origi
is he got an
email back with "Undefined variable" errors wherever the database was
supposed to send back info, and no record was created.
I guess you are using get method of http request which is limited by
"maximum URL Length" (2083 chars in IE). Force the browser to us
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 have
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 peop
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 mysql_error(mysql_connect($ho
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
http://www.php.net/manual/cs/ref.
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
ows is not that much, 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
l is that somewhere between using mysql_query() and
mysql_fetch_row(), things got messed up. Is this a bug? Is there
something I'm missing? Any clues? Help!
do you have
**
header in your script?
OKi98
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
ion);
$tmp=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
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
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
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 D
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).
I
able 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 = mysql_real_esca
at's wrong 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);
OKi9
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
askinput WHERE user_id=u.user_id AND jobtype =
'Tickets') AS 'Tickets',
(SELECT COUNT(jobtype) FROM taskinput WHERE user_id=u.user_id) 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
query_count);
>$totalrows = mysql_num_rows($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://
I use CalcDateDiff.php class and it works pretty good!
Why use classes for such a simple calculation? It's the matter of 2 rows of code
$dif_sec=mktime(0,0,0,10,6,2006)-mktime(0,0,0,10,5,2006);
echo("diff is ".($dif_sec/(24*60*60))." days");
OKi98
--
PHP Da
data 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
Hi,
this is not a php but javascript. Next time write to a proper forum. You
need to transfer the full path into other variable.
onchange="document.getElementById('id_full_path').value=this.value;">
OKi98
35 matches
Mail list logo