Why you are getting multiple results is because a JOIN attempts to find all the
possible combinations in the output. (It's called a Cartesian product, not that you
care at this very moment.) Also, when doing joins, it's a bad idea to do a select *
since you will have two fields with the same val
You cannot use javascript variables in php, nor php variables in
javascript, unless you write the variable to the page (for php ->
javascript) or post to a new page with querystring or form
(javascript -> php).
php -> javascript:
var jsVariable = "";
javascript -> php:
select substring_index(date_record,"-",1)+id as sum from test order by sum
--
Best regards,
George Nicolae
IT Manager
___
X-Playin - Professional Web Design
www.x-playin.f2s.com
"Thomas "Omega" Henning" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROT
My date is like -MM-DD
as to the select you posted that selects only those to i need it ordered by
the sum of these to fields
Thomas "omega" Henning
"George Nicolae" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I have some idea about your problem but to
I have some idea about your problem but to solve I need some information.
1. you have a datatime, data, timestamp,time or year column?
if you have a data type column with -mm-dd format you can use the
following query
select substring_index(date_record,"-",1)+id from test
date_record is a da
Sorry but I don't have the query done yet . But maybe later I will have it
done but I don't know how to use the substr command in mySQL . If you tell
me how to use it I will post it on the forum.
Thomas "omega" Henning
"George Nicolae" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:
and who looks the query with "substr the date so i get only the year"? Type
the exact query you make.
--
Best regards,
George Nicolae
IT Manager
___
X-Playin - Professional Web Design
www.x-playin.f2s.com
"Thomas "Omega" Henning" <[EMAIL PROTECTED]> wrote in message
[EMAIL PR
I forgot to type in something if i substr the date so i get only the year
from it then is it possible?
"George Nicolae" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> you can't make this query because type mismatches.
>
>
> --
>
>
> Best regards,
> George Nicol
you can't make this query because type mismatches.
--
Best regards,
George Nicolae
IT Manager
___
X-Playin - Professional Web Design
www.x-playin.f2s.com
"Thomas "Omega" Henning" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hello,
>
> I
"apt c"
$fields[4]="anytown"
$fields[5]="texas"
$fields[6]="12345-6789"
$fields[7]="972-123-4567"
the line $inputline would have been read from a text file.
-Original Message-
From: Jerry [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January
To retrieve data from a text file, I'm using:
$fp= file("textfile.txt","r"); foreach($fp as $line) echo "- $line -";
Jerry
"Arik Ashepa" <[EMAIL PROTECTED]> wrote:
> Can someone please tell me how can I add and retrive data from a text file
I
> know it has something to do with Spliting...???
>
11 matches
Mail list logo
