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; shows

RE: mysql_query gives Resource id #3 error

2006-03-11 Thread Logan, David (SST - Adelaide)
--- -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 = SELECT

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

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=0 Yes,

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

Re: mysql_query to return immediately when connection lost

2003-03-26 Thread Pedro Alvarez-Tabío
, 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 other hint please? I strongly need mysql_query to return immediately if connection is lost with the server. Any configuration parameter or similar

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 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
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 case I do have a DNS server. Any other hint please? I strongly

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, and

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 Ohnewald