QL List" <[EMAIL PROTECTED]>
Sent: Tuesday, January 07, 2003 4:12 PM
Subject: RE: [PHP] Re: PHP and MySQL bug
> Since nobody is jumping in to say it is some simple configuration/setting
> personally my next step would be to shut down all services on the box that
> aren't absol
t;MySQL List" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, January 07, 2003 5:06 PM
Subject: Re: [PHP] Re: PHP and MySQL bug
> @mysql_select_db("be"); -- this failed
> do echo mysql_error(); to see what went wrong
>
>
>
> Nuno Lopes wrote:
>
&
I'm using Windows 2000.
- Original Message -
From: "Cleber" <[EMAIL PROTECTED]>
To: "Nuno Lopes" <[EMAIL PROTECTED]>
Sent: Tuesday, January 07, 2003 10:23 AM
Subject: Re: [PHP] Re: PHP and MySQL bug
> Try add to /etc/hosts the name and ip of DB
'no db was selected')
- Original Message -
From: "David Freeman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, January 05, 2003 10:29 PM
Subject: RE: [PHP] Re: PHP and MySQL bug
> @MYSQL_QUERY("UPDATE d SET h='$h' WHERE id=
ED]>
Sent: Monday, January 06, 2003 6:28 PM
Subject: RE: [PHP] Re: PHP and MySQL bug
> This definitely sounds like a buggy installation or there may be some
> problem with the communication between the web server and the mysqld. Is
> the db on a different machine? Try using mysql_
It would be helpful if you posted that error. You can get it by changing
the die to
$queryr = mysql_query($query) or die(mysql_error());
Without knowing the error, you problem will be harder for everyone to debug.
-Original Message-
From: Nuno Lopes [mailto:[EMAIL PROTECTED]]
Sent: Mon
The problem is if I close the connection and reopen it the query is done,
but if I remain with the same connection has the previous query, mysql
returns an error.
- Original Message -
From: "Larry Brown" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Sunday, January 05, 20
To: <[EMAIL PROTECTED]>
Sent: Sunday, January 05, 2003 10:29 PM
Subject: RE: [PHP] Re: PHP and MySQL bug
>
> > @MYSQL_QUERY("UPDATE d SET h='$h' WHERE id='$id'"); // this
> > query doesn't work
>
> Personally, I'd call it bad
> @MYSQL_QUERY("UPDATE d SET h='$h' WHERE id='$id'"); // this
> query doesn't work
Personally, I'd call it bad programming practice to do a database update
and not check to see if it worked or not. In this case, how are you
determining that the query did not work? Are you manually checkin
Here is the source code:
Seleccione a localização para o download:Localização Principal";
if ($mirrors) {
echo " Mirrors";
$m=explode("»",$mirrors);
foreach ($m as $v) {
$m2=explode("!",$v);
echo "$m2[0]";
}
echo "Nota: Deve escolher o mirror mais próximo da sua localização,
para acelerar o dowloa
Personally I think the problem lies somewhere between the chair and the keyboard
(Sorry, couldn't resist) :-)
*** REPLY SEPARATOR ***
On 04/01/2003 at 4:58 PM Stefan Hinz, iConnect (Berlin) wrote:
>It doesn't work because of the /* Some code including ... */ part ;-)
>
Nuno,
> $r=MYSQL_QUERY("SELECT n,u,m,h FROM d WHERE id='$id'");
>
> /* Some code including "mysql_num_rows" and "mysql_fetch_array($r,
> MYSQL_NUM)"
> And the another query:
> */
>
> MYSQL_QUERY("UPDATE d SET h='$h' WHERE id='$id'");
>
> /* i don't know why but this doesn't work!*/
It doesn't wor
Personally I say get yourself a good simple dbconnect class and make life easy.
Also if you ever change users, database name etc, you onlu have one place to replace
it in your code.
I wrote mine based on http://www.vtwebwizard.com/tutorials/mysql/
Take a look at it. Nice and simple.
Mike
You really should be using a $link variable...it's good habit:
$link = mysql_connect(...);
mysql_select_db( "mydb" , $link);
$query = mysql_query( "select..." , $link );
$result = mysql_fetch_array($query);
Lewis
"Nuno Lopes" <[EMAIL PROTECTED]> wrote in message
003a01c2b3de$95004650$0100a8c0@pc
14 matches
Mail list logo
