Re: opening a server to generalized queries but not "too" far

2010-06-16 Thread Adam Alkins
in the PHP script itself (which would be rather weak security imho). -- Adam Alkins || http://www.rasadam.com On 16 June 2010 14:48, Don Cohen wrote: > Adam Alkins writes: > > Sounds like you just want to GRANT access to specific tables (and with > > limited commands), which is ex

Re: list rows with no recent updates

2010-06-16 Thread Adam Alkins
. -- Adam Alkins || http://www.rasadam.com On 14 June 2010 16:02, MadTh wrote: > Hi, > > > I ran a update command on around 2700 rows inside a mysql database table > which has around 3000 table rows to change the ( say) price of each item ( > with unique ID. unique product code). &

Re: opening a server to generalized queries but not "too" far

2010-06-16 Thread Adam Alkins
only SELECT privileges to a specific table for a specific user. -- Adam Alkins || http://www.rasadam.com On 16 June 2010 14:17, Don Cohen wrote: > > This seems like a topic that must have been studied, but I'm having > trouble figuring out what to search for in Google, since the

Re: setting the data directory.

2006-01-31 Thread Adam Alkins
nson > [EMAIL PROTECTED] > Tel.: (514) 917-4922 > Fax: (514) 673-0011 > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- Adam Alkins http://www.rasadam.co

Re: Math Computations

2002-04-11 Thread Adam Alkins
Something like "; while ($row = mysql_fetch_row($result)){ $subtotal=$row[0]*$row[2]; $total+=$subtotal; echo "$row[0] | $row[1] | $row[2] | $subtotal"; $comptotal+=$row[0];} } echo "$comptotal $total"; ?> Obviously format it into a table would make sense, e.t.c. Adam - Or