Celebrity Institute [mailto:[EMAIL PROTECTED]
Sent: Friday, April 08, 2005 1:32 PM
To: mysql@lists.mysql.com
Subject: mysql_query Looping
Hi, just got intro to the list and i hope I can find some help here.
I'm trying to figure out the true syntax of a project im working on,
basicly theirs a me
Hi, just got intro to the list and i hope I can find some help here.
I'm trying to figure out the true syntax of a project im working on,
basicly theirs a menu on my site that has several catagoies and in those
catagories are secondary, and some times 3rd level and 4th level sub
lists, i want to
Hi Malka,
Kindly re-install the Calendar & DBD-mysql Perl Packages,
problem will be resolved.
-Aman.
ITSSG -Vetri Software, Lason Inc.,
Malka Cymbalista wrote:
We are running Apache 1.3.26 with mod perl 1.26, perl 5.6.1, and mysql
3.23.49 on a Sun Solaris machine. Every now and then, one of the
s
On Mon, Dec 22, 2003 at 11:05:23AM +0200, Malka Cymbalista wrote:
> We are running Apache 1.3.26 with mod perl 1.26, perl 5.6.1, and mysql
> 3.23.49 on a Sun Solaris machine. Every now and then, one of the
> scripts we are runing gives the following error message:
> null: DBD::mysql::st fetch fail
We are running Apache 1.3.26 with mod perl 1.26, perl 5.6.1, and mysql
3.23.49 on a Sun Solaris machine. Every now and then, one of the
scripts we are runing gives the following error message:
null: DBD::mysql::st fetch failed: fetch() without execute() at
/usr/local/lib/perl5/site_perl/local/Cale
results.
John Griffin
-Original Message-
From: Jakob Vedel Adeltoft [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 04, 2003 6:39 AM
To: [EMAIL PROTECTED]
Subject: Looping through parent and childs
I'm new to mySQL and would like to know how do a SELECT where I get all child re
group_list PGL1
JOIN project_group_list PGL2 ON PGL1.group_id = PGL2.parent_group_id
WHERE PGL1.group_id = 1
The reason for my subject contain "looping" is because I'm also interested in if mySQL
have any way of looping SQL queries? Below query is taken from MS-SQL newsgroup:
e a table with these values 1, 5 and 7
> is it possible to create an sql query that will "loop" through these values
> a certain amount of time for example if i wanted 8 rows I would get 1, 5,
> 7, 1, 5, 7, 1, 5 as output..
>
> I'm currently doing this looping in my app
example if i wanted 8 rows I would get 1, 5, 7,
1, 5, 7, 1, 5 as output..
I'm currently doing this looping in my application but it would speed things
up if mysql could do this for me..
since I could then do some joins and retrieve values from other tables
faster.
/Chri
