Re: [PHP-DB] SELECT problem between MySQL 3.23 and MySQL 4
Chris Payne wrote:
> I'm using Booleans in my searches (New to it) but it works perfectly
on my
local 3.23 version of MySQL, but on the main server which uses version 4 of
MySQL I get an error so there's an error in my Syntax. Here's what I
currently use:
[snip]
LENGTH(REPLACE(LOWER(def),LOWER('as'),'')))
[snip]
And here's the error I receive on the remote MySQL 4 server:
>
Warning: Bad arguments to implode() in
/var/www/html/www.planetoxygene.com/htdocs/funcs_mysql_boolean.php on line
45
You have an error in your SQL syntax. Check the manual that corresponds to
your MySQL server version for the right syntax to use near ') -
LENGTH(REPLACE(LOWER(),LOWER('as'),''))) /LENGTH('as'
This is not a MySQL 3 vs. MySQL4 issue. If it was, this is the wrong
list, anyhow.
Take a look at the line of the query you _say_ you're running that I've
included above and take a look at the last line of the error that you're
getting from MySQL.
See the difference? Good... now troubleshoot.
--
---John Holmes...
Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/
php|architect: The Magazine for PHP Professionals – www.phparch.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] SELECT problem
Hello PHP world!!! i've just finisched installing Apache 1.3.27 with PHP4 and 1.4 in Windows 2000. I've installed all off the scripts that function all right in Linux Red Hat in Windows 2000, but when it comes to do a simple select to a table that does exist and the select is all right there appears a message as if the query weren't all right at all: Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in g:\apache\apache\htdocs\digimedia\adm_central\index.php on line 18 What could it be? I really appreciate the great help you have been giving to me these days. Thank you very much!!! Could you show us what code you're using? That'd be more helpful. Also do consider using the mysql_error() function to see what MySQL thinks the problem is. Larry PS Could you turn off the HTML formatting in your email? The purple prose is jarring. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] SELECT problem
echo("");
HTH
Jayme.
-Mensagem Original-
De: Julio Cuz, Jr. <[EMAIL PROTECTED]>
Para: <[EMAIL PROTECTED]>
Enviada em: quinta-feira, 22 de fevereiro de 2001 18:33
Assunto: [PHP-DB] SELECT problem
> Hi--
>
> What's wrong with this line of code?
>
> echo(" NAME='campus'>");
>
>
>
> Julio Cuz, Jr.
> Riverside Community College
> [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] SELECT problem (2)
You probably want
this.options[this.selectedIndex].value
> -Original Message-
> From: Julio Cuz, Jr. [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, February 22, 2001 2:36 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] SELECT problem (2)
>
>
> Hi--
>
> Sorry, I forgot to finish the previous e-mail: What's wrong
> with this line?
>
> echo(" onChange=\"window.location=\"$PHP_SELF?campus+=\"this.value\"\"\"
> NAME='campus'>");
>
> I'm trying to RELOAD the current page with the new value of
> "$campus" after
> the user selects a campus from a drop-down menu. But I can't get the
> "this.value" line to pass the value of "$campus" to the new
> loaded page.
>
> Help!
>
>
>
> Julio Cuz, Jr.
> Riverside Community College
> [EMAIL PROTECTED]
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
