On Saturday 27 July 2002 15:03, Georgie Casey wrote:
> Can you d arithmetic division on two fields in an ORDER BY??
>
> eg
> SELECT * FROM table_name ORDER BY field1 / field2 DESC
>
> Can it be done?
Try:
SELECT *, (field1 / field2) AS doo FROM table_name ORDER BY doo DESC
--
Jason Wong -> G
Hi folks
Problem:
I'm trying to protect a heap of email addresses on lots of pages from
spammers. The pages are static pages on another site, (reason, they have to
be), but as some of them are generated on my site using PHP/MYSQL I thought
that the best way would be to redirect mail links to a p
I do my SQL in phpMyAdmin or at the command line and it works fine.
When I try and do my query through PHP I get this(Source to show there are
no etc in it):
Query failed: INSERT INTO article_keyword VALUES (3, 'earth', 8.94855);
INSERT INTO article_keyword VALUES (3, 'gases', 13.42282);
INSERT
Did you copy and paste the code?
There is no such function as mysql_numrows, it has to be mysql_num_rows.. I
don't know why you didn't get an error for it?
Gurhan
> "Jas" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > I am not sure how to resolve this
Hello, i don't use the cgi version i compile php with --with-apache :o)
and the connection seem to be exist with netstat
each time i use the web script, it reconnect and open a new tcp
and let the previous open ...
See you
Nicolas.
- Original Message -
From: "Andrew Hill" <[EMAIL PRO
I am not sure how to resolve this type of error, any help is appreciated.
TIA
Jas
/* Error message */
Column count doesn't match value count at row 1
/* Code to query db for username and password */
require '/home/bignickel.net/scripts/admin/db.php';
$db_table = 'auth_users';
$sql = "SELECT *
Salve,
I can't think that the .html extension would cause this behavior, but it
might cause your app to slow down a bit if it's lot lots of non-php code
on the .html pages on the server.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Univ
At 02:18 PM 7/26/02 -0400, Monty wrote:
>Anyone have any tips or links to tips about update multiple tables based on
>data received from a form?
If you use varchar fields the cost of empty fields is very small. The
decision on
using a separate table should be based in things like how many addre
Can you d arithmetic division on two fields in an ORDER BY??
eg
SELECT * FROM table_name ORDER BY field1 / field2 DESC
Can it be done?
--
Regards,
Georgie Casey
[EMAIL PROTECTED]
***
http://www.filmfind.tv
Online Film Production Directory
***