How often in a day must you do this? Every 5mn?
Ignatius
- Original Message -
From: "Leif K-Brooks" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, October 27, 2002 7:33 AM
Subject: [PHP-DB] Getting rows where column has changed?
> I
Hi everyone,
I'm using a MySQL DB and a search form. Eveery thing works fine, but when I
upload, it has a Error in query. I checked all the little details but can't
find out why? Any ideas are welcome.
Jacco
--
http://seabird.jmtech.ca
Attitude is Everything!
But Remember, Attitudes are Contagio
> Hi everyone,
> I'm using a MySQL DB and a search form. Eveery thing works fine, but
when
> I
> upload, it has a Error in query. I checked all the little details but
> can't
> find out why? Any ideas are welcome.
>
> Jacco
This one is an easy problem to fix. All you have to do is find the error
> I'm trying to make a page to help in detecting people using automatic
> refresher programs. In the table that stores user info, there is a
> column called "lastseen" which says when the user was last seen. I'm
> trying to:
> 1. Select all lastseen colmns that are less than 5 minutes old
> 2. Wa
Hi,
I just looked at the function mysql_errno, where it says that
mysql_*-functions don't issue warnings anymore and that you have to
check for errors yourself... That's what I also want but is, for
example, the database is not reachable on a call to mysql_connect, the
function still triggers a wa
> I just looked at the function mysql_errno, where it says that
> mysql_*-functions don't issue warnings anymore and that you have to
> check for errors yourself... That's what I also want but is, for
> example, the database is not reachable on a call to mysql_connect, the
> function still triggers
sorry for my "furry" message before.
I search a DB in multiple search fields and my result code looks like this:
your search returned ".$total." matches";
print "\n";
print "IcaoName (Location)Country";
while($row = mysql_fetch_assoc($result)){
print "\n"
."" . $row['Field1'] . "\n"
That's some nasty code
Two things:
1. What is $ton in your query?
2. Change your mysql_query row to this:
$result = mysql_query($query) or die("MySQL Error: ".mysql_error()."SQL:
$query");
So when your query dies, you'll know why.
Peter
On Sun, 27 Oct 2002, Seabird wrote:
> sorry
$ton is my AND/OR field. I'll change my error code and post it, thanx,
Jacco
--
http://seabird.jmtech.ca
Attitude is Everything!
But Remember, Attitudes are Contagious!
Is Yours worth Catching
"Peter Beckman" <[EMAIL PROTECTED]> wrote in message
news:20021027151406.T64513-10@;thermonucle
My error came out like this:
MySQL Error: You have an error in your SQL syntax near 'Field2 LIKE '%%'
Field3 LIKE '%%' ORDER BY ' at line 2
SQL: SELECT * FROM airline_a WHERE Field1 LIKE '%%' Field2 LIKE '%%' Field3
LIKE '%%' ORDER BY
Why does it not do this at my localhost?? I have the % around
> MySQL Error: You have an error in your SQL syntax near 'Field2 LIKE
'%%'
> Field3 LIKE '%%' ORDER BY ' at line 2
> SQL: SELECT * FROM airline_a WHERE Field1 LIKE '%%' Field2 LIKE '%%'
> Field3
> LIKE '%%' ORDER BY
You need some ANDs between each of your field LIKE '%%' clauses.
WHERE field1 LI
It seems to me you have no idea what you are doing. You really need to
learn how to troubleshoot your code, as this is a very simple problem to
fix. It's not your code. The variables you put in your SQL are empty.
Your code:
$query = "SELECT * FROM $table WHERE Field1 LIKE '%$icao%' $ton
F
Hi Peter I understand your frustration,
but how come that it works fine on my localhost, prosessing the exact same
code?? I thought it worked because it works fine locally
What is the differense in my code posted locally and remote?
Jacco
--
http://seabird.jmtech.ca
Attitude is Everything!
I also provide my searchform here. The problem I have is that everything
works when run on my localhost (which is my testing location before upload.
I have the exact same code local and remote.
My searchform should pass the code. here it comes:
Please stop responding to the list. Your problems are far to simple to
bother everyone on the list.
I have no idea what you mean when you say "locally" or "remote."
Basically your problem is that your script does not see any of the
variables. They are empty or not set. They are not getting pas
First off, use quotes. If you are going to be a good coder, always use
quotes in your HTML and your PHP.
In PHP:
$table="aviation_a"; // NOT $table=aviation_a;
Sure, they both work, but they can cause problems in the future, and it is
considered BAD CODING. USE QUOTES. Fix all your input
Hi All,
I am new to the list, as a matter of fact this is my first post so if
I'm covering territory that has been already covered please excuse me.
I am using PHP/MySQL/Dreamweaver MX. I expect the razzing to start
anytime now.;-) I am also very new to php.
I have a form that is gathering use
What's on line 48?
On Sun, 2002-10-27 at 18:43, alex hogan wrote:
> Hi All,
>
> I am new to the list, as a matter of fact this is my first post so if
> I'm covering territory that has been already covered please excuse me.
>
> I am using PHP/MySQL/Dreamweaver MX. I expect the razzing to start
Sorry..., my bad. Too wrapped up in the problem.
Notice: Undefined variable: row_rsID in
D:\web\hogana\demo\login\TMPbl2tw4o24u.php on line 48
Warning: Cannot add header information - headers already sent by (output
started at D:\web\hogana\demo\login\TMPbl2tw4o24u.php:48) in
D:\web\hogana\dem
The first question is is $row_rsID actually an array when you run the
script?
If it is, is $row_rsID['userID'] set?
If it isn't, is $row_rsID['userid'] set?
If you want to set the variable $row_rsID statically do this:
$row_rsID = array("userID"=>1);
Where does $row_rsID get set? Does it set
the rowRsId variable is never defined... that's why PHP is complaining.
On Sun, 2002-10-27 at 19:53, alex hogan wrote:
> Sorry..., my bad. Too wrapped up in the problem.
>
>
>
> Notice: Undefined variable: row_rsID in
> D:\web\hogana\demo\login\TMPbl2tw4o24u.php on line 48
>
> Warning: Canno
21 matches
Mail list logo
