, company as name, 1 as fromtable FROM blabla)
UNION
(SELECT id, name, 2 as fromtable FROM blabla)
Its not an optimal query thats for sure, but it makes the PHP code
10 times easier and the result is just marvelous.
To think that I forgot all abou the UNION command, a shame, :D
--
Kim Steinhaug
points on this? I would maby think alternative 3 would be
best,
or maby alternative 2?
Maby you have some other alternatives?
--
Kim Steinhaug
-
There are 10 types of people when it comes to binary numbers:
those who understand
`,`fadresse`,`fpbox`,`fpostnummer`,`fpoststed`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
INSERT INTO `users_info` VALUES (1, 1, 1, 'Kim', 'Steinhaug', 'PB 8149
Vaagsbygd', '4622', 'Kristiansand', '8800945', '', '[EMAIL PROTECTED]', '',
'', 0, 0, 0
but this will work like a charm, :D
Kim Steinhaug
-
There are 10 types of people when it comes to binary numbers:
those who understand them, and those who don't
I was about to suggest the same, the latest builds of MySQL have theese
functions from what I knew... I think youll find what you need there.
--
Kim Steinhaug
-
There are 10 types of people when it comes to binary numbers
Take a look at the php website on the function addslashes.
You will find an example with the functions reslash and reslash.
You might have some problems regarding magic_quotes.
Ive been using the reslash and deslash for some time now without
any problems.
It might solve your problems.
--
Kim
WHERE User_ID=3;
--
--
Kim Steinhaug
--
There are 10 types of people when it comes to binary numbers:
those who understand them, and those who don't
=mysql_query($sql)or die(Insert Error: .mysql_error());
It would atleast give you a good feeling on the data getting passed to mySQL
if youre not getting any error message.
--
--
Kim Steinhaug
--
There are 10 types of people when it comes
should be avoided since there are no reason to have them.
--
--
Kim Steinhaug
--
There are 10 types of people when it comes to binary numbers:
those who understand them, and those who don't
I love that site, really the best way to get familiar with the common
systems out there.
--
--
Kim Steinhaug
--
There are 10 types of people when it comes to binary numbers:
those who understand them, and those who don't
- so do it now, :) You wont
regret it I promise you.
--
--
Kim Steinhaug
--
There are 10 types of people when it comes to binary numbers:
those who understand them, and those who don't
my validation of the login, and the user accually got the
content he wasnt allowed to see, :)
This is abit off topic, but you never know. Headers are headers, and
small things are small things...
Good luck.
--
--
Kim Steinhaug
()){
// Update the Unique visitor table
// Insert new entry with IP, Browsersession and time() into the
online database
}
As far as my midnight brain would see it this would work nicely.
--
--
Kim Steinhaug
if this makes is easier to group the
the query in some wmart way I havnt figured out at the moment.
--
--
Kim Steinhaug
--
There are 10 types of people when it comes to binary numbers:
those who understand them, and those who don't
into one.
Thanks in advance.
--
--
Kim Steinhaug
--
There are 10 types of people when it comes to binary numbers:
those who understand them, and those who don't
sekunder, 2x queries.
500x Test 2 in 0.3949 sekunder, combo query.
--
--
Kim Steinhaug
--
There are 10 types of people when it comes to binary numbers:
those who understand them, and those who don't
.
--
--
Kim Steinhaug
--
There are 10 types of people when it comes to binary numbers:
those who understand them, and those who don't.
--
www.steinhaug.com
on every pageload, maby once an hour or something.
I hope you got the the hang of it.
--
--
Kim Steinhaug
--
There are 10 types of people when it comes to binary numbers:
those who understand them, and those who don't
are looking for.
--
--
Kim Steinhaug
--
There are 10 types of people when it comes to binary numbers:
those who understand them, and those who don't
What I suggest you do, run phpMyAdmin (Or whatever you use)
and dump the table structure for your table. Also give us a few lines
of typical data from your table.
Your queries looks correct to me.
--
--
Kim Steinhaug
. Gives you larger
tables,
but no overhead.
I guess you have made indexes for your database if you have a lot of select
in it, thats far more important than optimizing at the moment.
--
--
Kim Steinhaug
--
There are 10 types
connections on their MySQL from your host, which I would think
would be alot of work to accomplish. Preparing datasets on the
different servers with a script sounds much more simple in my
opinion, after all this script will only be updated at given
intervals.
--
--
Kim Steinhaug
DOH! - A private message arrived read below
When you mention it, ofcourse this is the correct (and sane sollution). I
guess
I was giving more flesh to the bone that the previous poster posted.
Looping through when limit is there is plain and simple stupid...
Shame on me! :)
Kim Steinhaug
++){
$item = mysql_fetch_object($levels);
if($i){
// Do the output with the new object, $item
break;
}
}
--
--
Kim Steinhaug
--
There are 10 types of people when it comes to binary numbers:
those who understand them, and those
swada.. :)
--
--
Kim Steinhaug
--
There are 10 types of people when it comes to binary numbers:
those who understand them, and those who don't
instead of print.
echo Hello . $_POST[name] . !;
or
echo 'Hello ' . $_POST[name] . '!';
--
--
Kim Steinhaug
--
There are 10 types of people when it comes to binary numbers:
those who understand them, and those who don't
.
--
--
Kim Steinhaug
--
There are 10 types of people when it comes to binary numbers:
those who understand them, and those who don't.
--
www.steinhaug.com
for.
Remember ofcourse that you wuld need to use the regex syntax.
The page on mySQL covering the topic has a lot of examples.
--
Kim Steinhaug
---
There are 10 types of people when it comes to binary numbers:
those who understand them
What you do is, if my logic is correct...
Read the entire file in to a variable and send it back to
the browser with another header information, typicall
TEXT.
Just like the force download method for a PDF file, or other
files. This should work very well.
--
Kim Steinhaug
for GD just released on phpclasses.org
by the way. You need however to reprogram some og the scaling
functions, as they are a bit unfinnished.
I use GD as a backup, in case ImageMagick isnt present on
the server. But then I get those blurry ones I dont like...
--
Kim Steinhaug
!
--
Kim Steinhaug
---
There are 10 types of people when it comes to binary numbers:
those who understand them, and those who don't.
---
Aleks Kalynovych [EMAIL PROTECTED] wrote
run into problems using it, :)
--
Kim Steinhaug
---
There are 10 types of people when it comes to binary numbers:
those who understand them, and those who don't.
---
Redhat
if using the above method.
By the way, if you know of any recourses for report making and such I
would love to see them, :)
--
Kim Steinhaug
---
There are 10 types of people when it comes to binary numbers:
those who understand them
) ; $i++) {
$record=mysql_fetch_object($allrecords);
echo $record-ipcount . '-';
}
Time - 0.0101
Remarkable difference indeed! Im just happy that I just made 1 single
report script at the moment using my rather terrible queries... :)
Thanks for the help Justin!
--
Kim Steinhaug
You should check out phpmailer at sourceforge.
It solved all my problems, and will probably solve all yours to.
As a bonus, you get a mailer that has a lot of more functions,
like attachements and HTML mail and such.
--
Kim Steinhaug
programming!
--
Kim Steinhaug
---
There are 10 types of people when it comes to binary numbers:
those who understand them, and those who don't.
---
Craig Roberts [EMAIL PROTECTED
4 words!
i dont believe you!
--
Kim Steinhaug
---
There are 10 types of people when it comes to binary numbers:
those who understand them, and those who don't.
---
Unknown
alter 1 line and everything is online again.
mail() function may be more than good enough, but you might want to check
out the phpmailer which is quite awesome!
--
Kim Steinhaug
---
There are 10 types of people when it comes to binary
Thanks for the replies.
Its time for me to start do some patching for my SQL
statement, :)
--
Kim Steinhaug
---
There are 10 types of people when it comes to binary numbers:
those who understand them, and those who don't
that already work is the thing I say all day long, but I
do think however its
time to start optimizing my work before my machinery are all buildt upon old
rusty cogs, :)
--
Kim Steinhaug
---
There are 10 types of people when it comes to binary
and renders it useless
for reverse engineering. :) You might want to do the same.
Kim Steinhaug
---
There are 10 types of people when it comes to binary numbers:
those who understand them, and those who don't.
--
PHP Database Mailing List
, but same directory)
that I have to update. This makes it easy in my opinion, just connect
with FTP - Update the files and Im down.
--
Kim Steinhaug
---
There are 10 types of people when it comes to binary numbers:
those who understand them
42 matches
Mail list logo