You could try with the operator.
!=, Not equal operator
Or you could try it this way - ISNULL(col_or_data_to_check).
Example:
mysql SELECT ISNULL(1+1);
+-+
| ISNULL(1+1) |
+-+
| 0 |
+-+
1 row in set (0.02 sec)
Aleksander
Chris wrote:
Chris
How about sending the file via SCP? (it would be a much more safer to
transfer files)
-Aleksander
Chris wrote:
ioannes wrote:
I am trying to:
- check whether an image file exists on a server,
- check whether it does not exist on another server, and if not exists
- to copy from the first
I would also suggest to limit yourself to things you actually need not
to select the whole table.
Aleksandar
Jim Lucas wrote:
Colin Guthrie wrote:
Martin Marques wrote:
SELECT * FROM company WHERE id NOT IN (SELECT companyID FROM contacts);
Not ideal as has been mentioned else where
It seems you missed my point :) if you would need all the data then
select them all, but if you need only partial data from the table then
you could limit yourself to that specific columns. I doubt everybody
need everything all the time. True?
Aleksandar
Chris wrote:
Aleksandar Vojnovic
Hi,
you should do it like this
?php
$id = $_GET['id']; // -- getting var from the url line
echo $id;
?
- Aleksandar
Ruprecht Helms wrote:
Hi,
I have the problem that a phpscript is not able to read out a value from
the browserline. In the browserline I have the URL
domain/page?id=value
In addition to Chris's suggestions you should also alter the homeid
column (set default to NULL and update the whole database which
shouldn't be a problem) so you don't have to do a double check on the
same column. I would also suggest that the TSCN_MEDIAid column should be
an int not a
60k records shouldn't be a problem. Show us the query you're making and
the table structure.
OKi98 wrote:
Rob Adams napsal(a):
I have a query that I run using mysql that returns about 60,000 plus
rows. It's been so large that I've just been testing it with a limit
0, 1 (ten thousand) on
try comparing the type:
if(0 === 0)echo 'Its not equal';
if(0 === 0)echo 'Its equal';
OKi98 wrote:
Hello,
Why does anything compared to 0 return true?
I know it might seem to be a bit off-topic, but for me it is important
for detecting if NULL value in table has been changed (for example
Hello List for the first time,
I am very new to php but impressed from what i've seen so far. I managed to
configure php w/ mysql and db2 do some selects, inserts ...
What I am inerested in is what are all those mod_php* and php_* on the
distribution's CDs e.g. if they are installed how do i
Hello List for the first time,
I am very new to php but impressed from what i've seen so far. I managed to
configure php w/ mysql and db2 do some selects, inserts ...
What I am inerested in is what are all those mod_php* and php_* on the
distribution's CDs e.g. if they are installed how do i
10 matches
Mail list logo
