On Monday 10 February 2003 06:57, Barrie Matthews wrote:
I am using the query below in attempting to control access to a web site.
The idea is that today's date must be between 1 month before the start date
and 1 month after the finish date.
$query1 = SELECT VFT_name FROM `vft` WHERE
Hello everybody,
I am pulling out several values out of a mysqldb. Those come with different
tables and different criterias, thats why I cant sort them inside the sql
statement. I need to make 3 of those statements.
All the different results have an associated timestamp. How could I sort
them
Hi list!
How can I Order By in MySQL a column asceding and an other column desceding?
Qbit
- Gatsis Nikos
Web developer
tel.: 2108256721 - 2108256722
fax: 2108256712
email: [EMAIL PROTECTED]
http://www.qbit.gr
order by col1 asc col2 desc
nikos wrote:
Hi list!
How can I Order By in MySQL a column asceding and an other column desceding?
Qbit
- Gatsis Nikos
Web developer
tel.: 2108256721 - 2108256722
fax: 2108256712
Merlin:
You might find it easiest to CREATE a temporary table.
You can use an INSERT .. SELECT query to extract the values from your
data tables and insert them in the temp table.
Then you can SELECT from the temporary table and use all of the SQL
functions for ordering, grouping, etc.
Doug
On
On Monday 10 February 2003 01:23, Rich Hutchins wrote:
Beyond inspecting the posted code, are there any quality FREE tools that
can monitor MySQL resource usage? I searched Google using mysql resource
tools and came up with a number of tools, but all required payment.
I'm figuring that if you
I'd like to get some opinions from the list.
We run php/mysql on our linux servers located behind a firewall. Many
of our clients have scripts that access their databases via php running
on the hosting server, and the general access is set up as:
$hostname = localhost;
$database =
If your client's friend wants to do learning/development, let him load
PHPTriad, FoxServ, or one of the other trinity setups onto his
computer.
It is truly remarkable that you/your company would even consider such a
request for longer than it takes to say: Never in a million years.
Also, if I
Try this:
I use it so that I can add variable names to a db table, then access them
throughout the script.
## Get the report_conf variables
$sql = SELECT *
FROM report_conf;
$prefs = get_rowset($conn_id,$sql);
foreach($prefs as $pref){
$foo = $pref['name'];
Folks,
I'd like to use Microsoft SQL Server 2000 XML capabilities for generating
query results in XML. It is very easy, just say for xml auto at the end of
your query.
The problem is that I cannot seem to retrieve the results back into PHP.
Anyone ever accomplish this?
Daniel
--
PHP
10 matches
Mail list logo