I'm sorry.
the method that I use is post that each value is
define by a variable, but the looping proses make it
only there only one variable for each row and each
column.
so..still a dead and for me
>>> please refer to the web page view
_
Aji Andri <[EMAIL PROTECTED]> wrote on 04/15/2005 03:49:52
PM:
> this is my prosedure
> 1st. I'm, selecting base on std_nis=111 in
> STY_RANK_200501
> 2nd. looping and fetching echoing
> looping and fetching echoing
>while ($nline = mysql_fetch_array($result)) {
>echo $nl
this is my prosedure
1st. I'm, selecting base on std_nis=111 in
STY_RANK_200501
2nd. looping and fetching echoing
looping and fetching echoing
while ($nline = mysql_fetch_array($result)) {
echo $nline["std_value"]
echo $nline["std_item"]
}
- end looping and fetch
my looping in my first script, from table
STY_REPORT_200501 I'm including the value
-1st query (looping)-
$query = "select a.*, b.sty_descr as styname from
STY_REPORT_200501 a left join STY_ITEM b on
a.std_item=b.sty_code where a.std_nis=111
-end looping
the result is
(You always need to include the list on all responses. In this case, I do
not work in PHP enough to be able to help with this particular problem but
I know there are several PHP experts on the list.) -- SG
- Forwarded by Shawn Green/Unimin on 04/15/2005 02:38 PM -
Aji Andri <[EMAIL PROTE
I'm sorry if I didn't make it so clear, here is what
I'm doing,
---script start here---
$query = "select a.*, b.sty_descr as styname from
STY_REPORT_200501 a left join STY_ITEM b on
a.std_item=b.sty_code where a.std_nis=" . $stid;
$result = mysql_query($query)
Aji Andri <[EMAIL PROTECTED]> wrote on 04/15/2005 12:34:23
PM:
> STY REPORT
>
> std_nis std_class std_item std_value
> 1111 1 8
> 111 1 2 7
> 111 1 5 6
> 111 1 4 9
> 222 3 1 6
> 222
STY REPORT
std_nis std_class std_item std_value
111 1 1 8
111 1 2 7
111 1 5 6
111 1 4 9
222 3 1 6
222 3 2 5
222 3 3 6
my fet
Aji Andri <[EMAIL PROTECTED]> wrote on 04/15/2005 09:01:40
AM:
> Yes, I want to update all row in one query
> --- Michael Stassen <[EMAIL PROTECTED]>
> wrote:
> > Aji Andri wrote:
> >
> > > my table properties
> > >
> > > `STY_REPORT_200501` (
> > > `std_nis` int(10) NOT NULL default '0',
> >
Yes, I want to update all row in one query
--- Michael Stassen <[EMAIL PROTECTED]>
wrote:
> Aji Andri wrote:
>
> > my table properties
> >
> > `STY_REPORT_200501` (
> > `std_nis` int(10) NOT NULL default '0',
> > `std_class` varchar(10) default NULL,
> > `std_item` int(2) default NULL,
> >
Aji Andri wrote:
my table properties
`STY_REPORT_200501` (
`std_nis` int(10) NOT NULL default '0',
`std_class` varchar(10) default NULL,
`std_item` int(2) default NULL,
`std_value` float default NULL,
`std_letter` char(2) default NULL,
`std_entusr` varchar(10) NOT NULL default '',
KEY
my table properties
`STY_REPORT_200501` (
`std_nis` int(10) NOT NULL default '0',
`std_class` varchar(10) default NULL,
`std_item` int(2) default NULL,
`std_value` float default NULL,
`std_letter` char(2) default NULL,
`std_entusr` varchar(10) NOT NULL default '',
KEY `std_class` (`s
12 matches
Mail list logo
