Try
$result_insert = @mysql_query ($query_insert) or die(mysql_error);
-Original Message-
From: Dan Bowkley [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 04, 2004 08:37
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] lamer noob with repeat question
Anyone?
- Original Message -
From:
Anyone?
- Original Message -
From: "Dan Bowkley" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, May 02, 2004 1:21 AM
Subject: [PHP-DB] lamer noob with repeat question
> Hello everyone,
>
> I've been working on (read:tearing my hair out over) my mom's website for
> some time no
Thanx for this enlightening insight about cron jobs...
just a question.. when i run Optimize.php, i realise that you will echo some
statements. where will these statements be shown? since you put " >
/dev/null " instead of " > /dev/null 2>&1 ", does it mean that your echo
statements will be ref
Rafi --
...and then Rafi Sheikh said...
%
% Hi List. A quick question. I have some categories that are really long
% and I would like to re-word or re-format them when I am bring data in from a
% DB. Now which would be better:
Can you describe an algorithm for doing so? Your example appears
Hey.
I have these tables.
Users ( id,name,etc )
Coments : ( id , comment )
How do I do this kind of query:
I thought in one thing like this but I cant figure it out.
Example: Select * from users order by id desc in (select count (id) from
comments)
Expected result:
List
I have these tables.
Users ( id,name,etc )
Coments : ( id , comment )
How do I do this kind of query:
I thought in one thing like this but I cant figure it out.
Example: Select * from users order by id desc in (select count (id)
from
comments)
Expected result:
List of users:
* User1
See comments
What you wrote will give you the list of users who also happen to have
comments. What you really want is more like this:
SELECT Users.ID, Users.UserName, Comments.Description
FROM Users LEFT JOIN Comments
ON Users.ID = Comments.UserID;
(note that you'll need to have the UserID foreign key in you
Heh, yeah, I didn't read far enough-- and boy do I feel like a troll
now. My apologies, case inconsistencies probably are causing his
problem-- but he'll also have a problem with the SQL statement when it
gets that far, if he doesn't tell it what to delete (i.e., wildcard),
simply b/c that's t
The PHP manual (a useful read btw !) states that === tests for equality and
*exact* equivalence, that is:
If you test for ==='1' then $var must be a string for the result to be true
if you test for ===1 then $var must be an integer or double type for the
result to be true
Usually its used in te
From: "Bruno Braga" <[EMAIL PROTECTED]>
> == means equality and what does the === means ?!
It matches the variable type, too.
$a = 1;
if($a == '1') => TRUE
if($a === '1') => FALSE
Most often used for function that can return a number including zero and
FALSE. If you're expecting a number to b
If your ID is an autoincremented field, try not including it in your
insert statement.
I.E.:
$sql = "INSERT INTO underskrifter (type, navn, epost, tid, ip, domain,
sted) " . " VALUES ('$_POST[type]', '$_POST[navn]', '$_POST[epost]',
'$tid', '$ip', '$host', '$_POST[sted]' );"
-Mike Forbes
Ma
[EMAIL PROTECTED] wrote :
>
> Fatal error: Call to undefined function: open() in
> D:\Inetpub\webs\metagenonlinecom\canc.php on line 11
>
I assume the error is match case in open function...
Should be $db->Open... etc.
-Original Message-
From: Michael Forbes [mailto:[EMAIL PROTECTED]
Nope.
Access' version of SQL is a slight bit different from ANSI SQL. All he
needs to do in his statement is change it to this:
$query="DELETE * FROM Test_Table WHERE name='franco';";
(notice the wildcard in there-- Access isn't smart enough to realize
that the deletion of any information in
Hello Bruno,
Monday, May 3, 2004, 2:16:29 PM, you wrote:
BB> Wich is the diference between if ($var == '1') or if ($var === '1')
BB> == means equality and what does the === means ?!
Forced-type equality. I.e. it checks that $var is not only equal to 1,
but is an integer also (as opposed to a s
Hi guys..
Wich is the diference between if ($var == '1') or if ($var === '1')
== means equality and what does the === means ?!
Thanks!
Bruno
Am Montag, 3. Mai 2004 11:50 schrieb Ng Hwee Hwee:
> sorry, what do you mean by _cron_ job?
unix-operating-system offers you a great thing called "cron-job`s"
like "sheduled-tasks" under windows.
4 more information follow this link
http://weather.ou.edu/~billston/crontab/
sebastian
>
> I'm hop
sorry, what do you mean by _cron_ job?
I'm hoping to optimise my tables, for example on, every Monday 9.30am.
by the way, is there a problem if I optimise my tables too frequently? i
mean, i was told not to defragment or format my harddisk too often cos it
will cause wear and tear to the hardwar
Use a cron job
Like:
0 0 * * * php Optimize.php > /dev/null
This is an example for optimizing every table in all databases on your mysql
server.
Optimize.php :
-Original Message-
From: Ng Hwee Hwee [mailto:[EMAIL PROTECTED]
Sent: Monday, May 03,
You could set up a PHP cron job to do this.
Regards, Torsten
"Ng Hwee Hwee" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
Hi,
Is there a way to create a schedule to optimise my MySQL tables
automatically? The overhead of some of my tables can reach 355,548 bytes
over 3 working day
yep, check http://www.phpclasses.org/browse/package/1527.html
And you can run this using a cron job, so it just fit with your needs.
Regards,
Hatem
- Original Message -
From: "Ng Hwee Hwee" <[EMAIL PROTECTED]>
To: "DBList" <[EMAIL PROTECTED]>
Sent: Monday, May 03, 2004 11:19 AM
Subject:
Hi,
Is there a way to create a schedule to optimise my MySQL tables automatically? The
overhead of some of my tables can reach 355,548 bytes over 3 working days!
Please help me!
Thanks.
Hwee
21 matches
Mail list logo