RE: mysql_query gives Resource id #3 error

2006-03-11 Thread Logan, David (SST - Adelaide)
t --- -Original Message- From: Pat Adams [mailto:[EMAIL PROTECTED] Sent: Sunday, 12 March 2006 4:45 PM To: Mysql Subject: Re: mysql_query gives Resource id #3 error On Sat, 2006-03-11 at 12:53 -0500, fbsd_user wrote: > $sql =

Re: mysql_query gives Resource id #3 error

2006-03-11 Thread Pat Adams
On Sat, 2006-03-11 at 12:53 -0500, fbsd_user wrote: > $sql = "SELECT logon_id > FROM members > WHERE logon_id = '$logonid' AND logon_pw = > '$logonpw'"; > > $result = mysql_query($sql) or die('Query failed. ' . > mysql_error()); > > print "$result";

RE: mysql_query Looping

2005-04-08 Thread gunmuse
We overcame that problem to infinite levels with our Blog Software. Instead of loops we use "Anchor Points" in the url to tell the navigation where it was at all times. This allows for a more dynamic navigation system as you can have Nav trees that not Expand with more subcatorgies but also colla

Re: mysql_query() crashes for certain statement

2005-02-27 Thread Eric Lilja
"Eric Lilja" wrote: > Hello, I'm using MySQL 4.1.10 on Windows XP Pro SP2 (+ all patches on > windowsupdate). I'm using the MySQL C api in a program compiled with > MSVC++ 7.1. > > My program crashes when I call mysql_query() with the following string: > "SELECT * FROM my_recipes WHERE enum_col=

Re: mysql_query memory

2004-03-10 Thread Sasha Pachev
Melanie Ware wrote: I am using mysql 4.0.17 on Red Hat Linux. I am using the C API to access mysql The application I am writing should parse a xml file and write details to the mysql database. The xml elements as they are read are fed into a simple data structure. On the completion of the str

Re: mysql_query to return immediately when connection lost

2003-03-26 Thread Pedro Alvarez-Tabío
> > To: <[EMAIL PROTECTED]> > Cc: "Gelu Gogancea" <[EMAIL PROTECTED]> > Sent: Tuesday, March 25, 2003 4:34 PM > Subject: Re: mysql_query to return immediately when connection lost > > > Hi, > > > > In this case I do have a DNS server. Any othe

Re: mysql_query to return immediately when connection lost

2003-03-25 Thread Gelu Gogancea
Message - From: "Pedro Alvarez-Tabío" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "Gelu Gogancea" <[EMAIL PROTECTED]> Sent: Tuesday, March 25, 2003 4:34 PM Subject: Re: mysql_query to return immediately when connection lost > Hi, > > In this cas

Re: mysql_query to return immediately when connection lost

2003-03-25 Thread Pedro Alvarez-Tabío
Hi, In this case I do have a DNS server. Any other hint please? I strongly need mysql_query to return immediately if connection is lost with the server. Any configuration parameter or similar on MySQL? Need to reconfigure something in the OS? Thanks. Pedro Gelu Gogancea wrote: > Hi, > > This is

Re: mysql_query to return immediately when connection lost

2003-03-25 Thread Gelu Gogancea
Hi, This is usually happened becuase you don't have configured a DNS server in your network. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] -

Re: mysql_query > sort

2002-11-29 Thread Roger Baklund
* Wolfgang Gliese > I want to sort my array (example: array[Ortslage, Strasse, Weg]) comming > from a query. A mysql query returns a 'resultset', not an 'array'. In PHP you can transform the resultset to an array, and this array can be sorted using a PHP function. However, this is a mysql list, an

RE: mysql_query

2002-09-24 Thread Mario Ohnewald
Great, thanks a lot! > From: Henk Huizinga [mailto:[EMAIL PROTECTED]] > > > Mario, > > This is actually an PHP question. You forgot the following code : > > $resultquery = mysql_fetch_row($result); > echo $resultquery[0]; > > Cheers, > Henk > > -Original Message- > From: Mario Ohnew