Re: SQL question

2005-07-11 Thread Smelly Socks
Hi All! I have a MySQL database (I have them using MySql at work for more stuff now!), and the definition is as follows: uid mediumint(6) NOT NULL auto_increment, ym varchar(6) default NULL, fileid varchar(8) default NULL, off char(3) default NULL, PRIMARY KEY (`uid`) TYPE=MyISAM uid is not re

Re: loading an array

2005-04-30 Thread Smelly Socks
Sorry to all - but I realised that the string in a variable called $pattern is, in fact, an array, so I don't need to load an array as it is already there. My apologies! -Warren -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.

Re: loading an array

2005-04-30 Thread Smelly Socks
Hi All! I am having a heck of a time figuring out how to get a string taken from a MySql table into an array. I happen to be using PHP but I would appreciate any pointers whatever in how to do this. I tried this: $array[] = $pattern; but it put the entire pattern into $array[1]. I want each

Re: Counting string sequences in row(s)

2005-04-30 Thread Smelly Socks
Hi! I am struggling with trying to count how many string patterns of a given kind occur in any given row of a mysql table. My table looks like this: Pattern varchar(200) HowMany varchar(3) The patterns that appear in the Pattern field can be aphabetic chars only, but spaces can appear at the be

Re: Python related MySQL question

2005-04-25 Thread Smelly Socks
Hi! I am porting a function library app I wrote in PHP to Python. At work they only use Python. I've researched how to connect to a MySql database using Python, and how to retrieve rows. However, I am wondering how to do the following: I can do this in Python => $da=MYSQL_QUERY("select * fro