Re: updating multi row after fetch...include my query script

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 _

Re: updating multi row after fetch...include my query script

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

Re: updating multi row after fetch...include my query script

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

Re: updating multi row after fetch...include my query script

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)

Re: updating multi row after fetch

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

Re: updating multi row after fetch

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

updating multi row after fetch

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

Newbie :create table multi, index

hi seniors, I'm trying to create a table, here my table properties, create table user ( UserID int primary, Password varchar (20), User_stats int multi ); i'm still confuse in User_stats properti's that is multi, what really use 'multi' is ? and what the conection between primary ke

newbie question create table

hi seniors, I'm trying to create a table, here my table properties, create table user ( UserID int primary, Password varchar (20), User_stats int multi ); i'm still confuse in User_stats properti's that is multi, what really use 'multi' is ? Thx before the guide, Aji

query problem in num_row

here a syntax $query=&$conn->Execute("select * from itemlocation where id limit 1 - 50"); $result=mysql_query($query); $num_result=mysql_num_rows($result); and error message are syntax error in $num_result=mysql_num_rows($result); object unknown can someone please give a direction all I want to

Re: adding automatic alert

--- Roger Baklund <[EMAIL PROTECTED]> wrote: > Aji Andri wrote: > > Hi all, > > I'm make an inventory goods database, in one of my > > table I need to make an automatic alert when my > stock > > reach it's limit (say for tires it's limit is 4),

adding automatic alert

Hi all, I'm make an inventory goods database, in one of my table I need to make an automatic alert when my stock reach it's limit (say for tires it's limit is 4), can I make an automatic alert for it so when it reach it limit I can have an alert may be a beep ? Thanks