on 24/07/02 4:04 PM, Philip J. Newman ([EMAIL PROTECTED]) wrote:
so how would i get the $username and $password into the session
session_register('$username','$password');
READ THE MANUAL
php.net/session_register tells you EVERYTHING you need to know, including
examples and user
Here's the URL for mod_layout if anybody's interested...
http://software.tangent.org/projects.pl?view=mod_layout
It's powerful, but just a little heftier than what I want. Since all I need
is .html and .htm support, I think I'm just going to end up modifying my
http.conf - I'd rather mess with
Hi Gurus,
I am using PHP 4.1.1, Postgresql 7.2 and Perl 5.6.0 on Linux.
I want to delete files in a directory,which were created 15 days back.
I can not do it, with PHP filesystem and directory functions, as PHP runs as
"nobody" user.
Can anybody pls. help me ?
Thanking you all in
Ok i have simple issue, i'm stuck at one point.
I have a table Clientdetails which contains
ClientID.
I have created another table Authentication with 2
fields, ClientID and Password.
I want to pick up the ClientID from table
Clientdetails and insert ClientID and a Password i
have generated
Thanks!
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Thanks Richard, actually your comments really help. As I said to a few
others who replied directly, I feel like it is something I ought to be
doing. But most of my development is small-scale and I work alone. There
is no external pressure to do so. Furthermore, I fear that if I were to
I don't see why your code is so wrong but neither do I see what it
reall does. YOu are changing the clientID with some simple function into a
password? As in everybody can do that trick by himself and login as whoever
he wants ..
What I'll mostly do for such things, is use this self written
I'm currently developing a Remote CMS for a site.
I'm working on the image upload and want to create a smaller thumbnail type
image (thought 200x180 instead of 50x50)
I know I'm going to need either imagecopyresize() or imagecopyresample(). I
don't know which would be better for this purpose
On Wednesday 24 July 2002 15:48, Nicholas Mercier wrote:
I'm currently developing a Remote CMS for a site.
I'm working on the image upload and want to create a smaller thumbnail type
image (thought 200x180 instead of 50x50)
I know I'm going to need either imagecopyresize() or
i am using dreamweaver mx and want to acheive the following
9:00 task 1
9:30 task 2
10:00 task 3
task 4
task 5
10:30 task 6
i have a recordset that displays the tasks ordered by the time but what i
dont want is to display the time for every item, or if an
I have a user authentication system using sessions
it checks username and password against a database.
if correct it sets a variable in the session cookie (via $_SESSION) and
redirects to the protected page which checks for that variable.
if the user/pass is wrong it redirects to an error page.
Hi!
Could someone help me with a replace that takes all occurances of ,
that is space more than one, and replaces them with
?
Sincerely
Victor
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
$new = preg_replace('/[ ]{2,}/',$old);
HTH
Andrey
- Original Message -
From: Victor Spång Arthursson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 24, 2002 12:05 PM
Subject: [PHP] trim away x 1 number of spaces from a strin
Hi!
Could someone help me with a replace
php.net/str_replace
On Wednesday 24 July 2002 02:05 am, Victor Spång Arthursson wrote:
Hi!
Could someone help me with a replace that takes all occurances of ,
that is space more than one, and replaces them with
?
Sincerely
Victor
--
Go to Heaven for the climate, Hell for the
I've currently made a signature uploader.
I know the code that shows a drectory's contents but whats the code to
delete something?
- Dale
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
At 09:35 PM 7/23/02 -0500, Richard Lynch wrote:
Any one please let me know how to use PHP to add new user to a domain for
using mail (sendmail).
Remember what Richard said... mucking around with real users is DANGEROUS!
I solved the problem with Qmail, vchkpw and qmailadmin. No coding on my
unlink()
Dale wrote:
I've currently made a signature uploader.
I know the code that shows a drectory's contents but whats the code to
delete something?
- Dale
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hmmm, interesting I didn't know about this and didn't see it in the
docs. So now I know for my next upgrade.
Anyway, my upgrade is in, and through the mails it should be clear to those
who thought how terribly difficult and time consuming it is/was to do the
upgrades that it was in fact
I am using PHP 4.1.1, Postgresql 7.2 and Perl 5.6.0 on Linux.
I want to delete files in a directory,which were created 15 days back.
I can not do it, with PHP filesystem and directory functions, as
PHP runs as
nobody user.
To delete a file the user running the web server needs to be able
Richard Lynch [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]...
#!/usr/local/bin/php -q
?
// don't timeout!
set_time_limit(0);
// set some variables
$host = 1.2.3.4...;
$port = 1234;
$command = /usr/games/fortune;
# I must be missing something, cuz I don't see where this
Hi, i dont know if im always going to use mysql, thow your solution to my
problem will be something like this:
SELECT DATE_FORMAT( endret_dato, \%d%m%Y\ ) as endret_dato
, headline
, news
from rnr_news
order by endret_dato desc
limit . $index . , . ($index+10));
Thanx for your help!
-R
John
Whats the difference between 'mysql_db_query' and 'mysql_query'?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
mysql_db_query has been depreciated since PHP 4.0.6
ctan wrote:
**
This Message Was Virus Checked With : SAVI 3.59 May 2002
Last Updated 8th July 2002
On Tue, 2002-07-23 at 21:35, David Robley wrote:
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] says...
I tried to upgrade from PHP 4.2.1 to 4.2.2 due to the security bug
announce in the web site. When I do make install, it stopped with
errors. The following are the last few lines
Neil Freeman wrote:
mysql_db_query has been depreciated since PHP 4.0.6
Yep.. but thats not the only different...
mysql_db_query() have an extra parameter that is what Database you want
to execute your query in...
mysql_query() just use the database you have selected with f.ex.
Hewwo all,
(please be so kind as to CC me in replies as I am not a subscriber to
this mailing list (yet))
The following code snippet always outputs You have visited this page 1
times!. What am I doing wrong?
?php
session_start();
if (!isset($HTTP_SESSION_VARS['counter'])) {
Assuming you are installing from your php-4.2.2 directory, it would appear
the libphp4.so hasn't actually been made, which would point to a possible
error in the configuration parameters. I am also assuming your php 4.2.1
made OK which would mean all necessary libraries etc are available on
On 7/24/02 1:33 AM, Philip J. Newman [EMAIL PROTECTED] wrote:
I have started a session on the server, and now would like to add a user
name and password, and some other information to the session to carry it
across all the other pages that are in this session. Any hints on where to
start?
Hello
Newbie here that can't seem to find a workaround for the following
problem.
I am running Apache on a Mac OS X.1
When I try to start up, I receive the following error:
Multiple definitions of symbol _XML_DefaultCurrent
All of this started right after I installed php4. I have installed
On Wed, 2002-07-24 at 08:29, Ian Ball wrote:
Assuming you are installing from your php-4.2.2 directory, it would appear
the libphp4.so hasn't actually been made, which would point to a possible
error in the configuration parameters. I am also assuming your php 4.2.1
made OK which would
Here's how to get it to work (thanks to somebody on Google Groups)...
1. Open up the file php_functions.c in /sapi/apache2filter/
2. Change MODULE_MAGIC_AT_LEAST to AP_MODULE_MAGIC_AT_LEAST (Note the
addition of AP_)
3. Save the php_functions.c file and try running configure again
Keep in
Is it possible to create an object from a clas which name is in a variable.
Example: (doesn't work)
$object = new ${$classname};
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Thx for quick reply,
If I use the following:
$object = new {classname};
I get this a parse error:
Parse error: parse error, expecting `T_STRING' or `T_VARIABLE'
or `'$'' in
/home/sites/projects.virtuosys.nl/web/cm/includes/class_crm.inc.php on
line 29
From that I conclude that
clipped
how about this curve... getting PHP to append a line to the apache log.
How about reading the documentation?
Deserved that for not being clear enough... see below.
My apologies if I missed the word access log or even assumed you meant
error log when you just said log.I shouldn't
whats the reason why www.php.net/docs.php has been down for days? why is it
still saying this error?
Warning: main(geoip.inc) - No such file or directory in
/local/Web/sites/phpweb/include/prepend.inc on line 6
Fatal error: Failed opening required 'geoip.inc'
Well, I think the solutions or ideas are maybe a bit too involved.
I was hoping that the errors I am interested in were already logged by
default to some obscure location, and I *could* if needed just go and
scrutinize them by hand.
But, it seems like a detailed (specially mysql) error log does
Hi,
I'm currently locked in a battle with PHP and file uploads. I've
searched the list to no avail. I actually found a guy with the same
problem who ended up using perl to make this work. I'm trying to avoid
that.
The problem is, I'm dealing with huge POST uploads (100+ mb). And
everytime
I am new to using PHP on RedHat 7.3 and am running into a problem with
ldap_connect(). When I attempt to run ldap_connect, I get the error:
Call to undefined function: ldap_connect()
The system I am working on has the default install of Redhat 7.3 with Apache
version Apache/1.3.23. It has
I will find out about the phpinfo(). I have looked at the options in cURL
and I haven't seen one that would enable it to get the certificate from the
credit bureau. I will keep checking. Um, I have used cURL with the credit
bureau #2 and they send the encryption packages over and all I had to
I'd like to post a follow-up to my previous message on this subject.
Please still CC me when replying, thanks.
New test code:
?php
session_start();
if (!isset($HTTP_SESSION_VARS['counter'])) {
$HTTP_SESSION_VARS['counter'] = 1;
} else {
$HTTP_SESSION_VARS['counter']++;
}
if
I alway knew there is an easier way to do that. Problem is just don't know
it. I like your example and it is an wonderful example. I can use it. One
quick question. The function, posttofunction(), is that a make-believe
function? I check PHP.net and it doesn't have this function, so I
Doing that right now! Just like a basic upgrade.
Thanks,
FletchSOD
Matt Schroebel [EMAIL PROTECTED] wrote in message
4B08FD7DB3CBD4119F560002A508C453015B38DA@hsus3">news:4B08FD7DB3CBD4119F560002A508C453015B38DA@hsus3...
From: Scott Fletcher [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July
It work very nicely The whole process take 30 to 45 minutes for just
one server. I wonder how does someone did 12 computers in 10 minutes.
Cool!
Matt Schroebel [EMAIL PROTECTED] wrote in message
Prolly a silly question, but I have a session process that never really
ends as it is supposed to allow the user to carry on submitting etc.
So I don't know where and when to end the session, and if it is really
nescessary to end a session?
Obviously a logout button will do the trick, but
Is there a way to redirect to a different script in PHP? I call it
redirecting, but can't find it in the documentation using that track.
I have a script...that if a certain criteria is met, I want to load a
different script. Haven't been able to figure that out yet. I have gotten
about it by
Check under header() in the docs...
.: B i g D o g :.
- Original Message -
From: Roberts, Mark [EMAIL PROTECTED]
To: PHP Mailing list (E-mail) [EMAIL PROTECTED]
Sent: Wednesday, July 24, 2002 8:28 AM
Subject: [PHP] Re-directing
Is there a way to redirect to a different script in
Use header() function..
Header('Location: script name');
Best Regards
Balaji
-Original Message-
From: Roberts, Mark [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 24, 2002 7:58 PM
To: PHP Mailing list (E-mail)
Subject: [PHP] Re-directing
Is there a way to redirect to a different
Hi,
Thursday, July 25, 2002, 12:20:47 AM, you wrote:
P Prolly a silly question, but I have a session process that never really
P ends as it is supposed to allow the user to carry on submitting etc.
P So I don't know where and when to end the session, and if it is really
P nescessary to end a
Hi,
which version of libpng and libjpeg is needed to use the bundled libgd
in the current php tree.
I using libpng 1.2.3 and php crashes with a segfault
and with libjpeg62 (6b Mandrake RPM) in apache logs:
gd-jpeg: JPEG library reports unrecoverable error: JPEG parameter struct
mismatch:
PHP redirects using the header() function, but it's not very useful if information has
already been sent to the browser. ANY information, including a hard return. So if
you have a login script, you would start your session, register any variables, then
redirect.
?php header(Location:
Hi,
Wednesday, July 24, 2002, 5:04:06 AM, you wrote:
MD I just wrote this message in the wrong list so i'll be short...
MD I have two classes:
MD - mysql_connection
MD - data_collection
MD data_collection REQUIRES a mysql_connection object to work. So i decided to
MD pass this object in the
Well you can actually,
If you start your script IMMEDIATELY (well before you output anything) with:
?php
ob_start();
This will buffer output so you can use your header anywhere in your script
eg
header(location.php);
exit;
and then if you weren't redirected then you send the output with
Awesome! Learn something new everyday!
That's why I love this list :o)
Martin Clifford
Homepage: http://www.completesource.net
Developer's Forums: http://www.completesource.net/forums/
Chris Sharkey [EMAIL PROTECTED] 07/24/02 11:01AM
Well you can actually,
If you start your script
Say it is not so.
I hear the PHP 4.2.2 will only set the last cookie delivered by a browser
to a variable in the PHP environment.
Is this true?
**
John Huggins
VANet
[EMAIL PROTECTED]
http://www.va.net/
**
--
PHP
Well my RedHat system got hosed, so I reinstalled everything. I'm back to
installing PHP now, and I'm wondering if it's safe for me to run ./configure
multiple times. Here's the situation:
I want to compile with gd support, and pdflib, and a bunch of other options.
Instead of running a whole huge
Hi,
Thursday, July 25, 2002, 1:41:25 AM, you wrote:
CG Well my RedHat system got hosed, so I reinstalled everything. I'm back to
CG installing PHP now, and I'm wondering if it's safe for me to run ./configure
CG multiple times. Here's the situation:
CG I want to compile with gd support, and
I now understand why I'm having trouble communicating with the credit
bureau. I did sucessfully get through to them the first time,
unfortunately, I was able to get through, through security breach at the
credit bureau. The credit bureau there was not design to work with cURL, so
the encryption
Your problem is very simple. You're beginning a new session every
execution, without checking if a session is already going. So every time it
comes back around it's looking for the variables in the current session,
which every time just began.
Check for an existing session first like:
I have just recently just signed up for virtual hosting with a MySQL
database. They do not have a PHPMyAdmin interface too access the
database. All they have given me is my username and password and the
server too login too. They suggested that I install PHPMyAdmin on my
workstation and access
Why don't you just install a copy on the server? If the only access you have
is through the mysql monitor program then you must have shell access so
installing your own copy of phpMyAdmin should not be an issue.
But, if your going to access it remotely from a win machine I would use
MySQL-Front
It's not normal that I've come across. Any hosting company I've ever dealt with
(albeit not many, still three different ones), have all offered phpMyAdmin for
interfacing with MySQL. And honestly, if the host REQUIRES you to do it, then they
aren't worth hosting with. You'll find that will
PHPMyAdmin must be run a server, or alteast a workstation with PHP's
MySQL extension installed on it, so are you sure he didn't mean, install
PHPMyAdmin yourself on there server (the one with the account your
paying for), in like your webdirectory (which is incredibly easy and
simple to do)?
When they say, install it on your workstation are you sure they mean your
desktop computer?
phpMyAdmin is not a normal install on your desktop (unless you run a server
with PHP and MySQL on your desktop, which you may do)
It's very straight-forward to install phpMyAdmin on your web site. And
I have a couple of scripts that fail with the error of:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result
resource in...
I'm new to both SQL and PHP and I'm wondering if I have some setting
turned off or what.
Here's the piece of code that is failing (the second line
I've never had any luck using PHPMyAdmin for dumping databases. They always
time out over the 30 second limit. I know if it was my installation, I could
fix it, but these are usually with hosting companies, where that's the only
access they provide. It's very much a pain in the butt...
---John
You might want to consider a slightly different approach - that being to
use your php code to generate a delimited file of your data and use
either mysqlimport from the command line if you can, or the LOAD DATA
INFILE sql statement to load the file into your database. That's going
to be a lot
I can almost guarantee that it's not the second line that is failing,
the problem here is that $result is not containing naything, and that is
normally due to the fact that you are not connecting to the db, or the
table tablename is not there.
I use the following format as my standard MySQL
Try using mysql_query(); instead of mysql_db_query(); The SQL query is the
first parameter in this function. The second parameter is a pointer
connecting to the mysql server. The pointer is generated by mysql_connect()
and you'll also need to select the database with mysql_select_db(). But
I encountered that same timeout problem once, and I wound up just installing
my own copy of PhpMyAdmin in an .htaccess protected directory on the server,
and extending the time limit there. It only took about 10 minutes to set
up, and as an added bonus it was a more recent version of PhpMyAdmin
With phpMyAdmin, just scroll down until you see the dumping section. Select the
appropriate information, tick the save as file box, then Go. It'll prompt you to
save the file. You just use that file, then, as a query to your next database.
Martin
1LT John W. Holmes [EMAIL PROTECTED]
You beat me too the punch and I think you explained it better than me, but
just one minor little thing to note. Where you said..
if ( $result = mysql_query($sql))
This is not a valid way to check if the query has returned anything.
mysql_query() returns FALSE on error. So if there was no
Yes, what on earth was I thinking!
should be:
...
$result = mysql_query($sql);
if (mysql_num_rows($result)) {
$row = mysql_fetch_assoc($result);
} else {
echo whatever;
}
...
Kevin Stone wrote:
You beat me too the punch and I think you
I'm putting together a message board, and I'm having
problems with hitting the return(enter) key within my
textarea.
I've looked around for a solution, I tried
wrap=hard, wrap=soft and wrap=vitual and none of
them worked (should they? I may have done it wrong?)
and I also tried nohardbreaks and
Shouldn't it be:
$result = mysql_query($sql, $link_id);
PHP will be quick to tell you that there is a missing link identifier in the
mysql_query() call. It's happened to me plenty of times. HTH!
Martin Clifford
Homepage: http://www.completesource.net
Developer's Forums:
I've never had a problem with this. Even using a textbox with only the required
parameters works fine as far as hitting the return key to get a newline. If you're
talking about hitting the return key to submit, that's something else entirely, hehe.
Martin Clifford
Homepage:
At 11:26 AM 7/24/2002 Wednesday, Martin Clifford wrote:
Shouldn't it be:
$result = mysql_query($sql, $link_id);
Actually mysql_query should default to the last database connection opened
if no link identifier has been specified.
So the link identifier to not absolutely required.
Phillip
--
Yes, it is pretty safe to run ./configure more than once. The 1st time, it
create the config.cache and so on. The 2nd time, it use the config.cache
and other stuffs instead of starting from scratch. To redo everything from
scratch. I believe one of those config.* files need to be removed so
On Thursday 25 July 2002 00:34, Matthew Bielecki wrote:
I have a couple of scripts that fail with the error of:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result
resource in...
I'm new to both SQL and PHP and I'm wondering if I have some setting
turned off or what.
On Wednesday 24 July 2002 23:41, Chris Garaffa wrote:
Well my RedHat system got hosed, so I reinstalled everything. I'm back to
installing PHP now, and I'm wondering if it's safe for me to run
./configure multiple times. Here's the situation:
I want to compile with gd support, and pdflib, and
On Wednesday 24 July 2002 22:22, Scott Fletcher wrote:
It work very nicely The whole process take 30 to 45 minutes for just
one server.
You've got a slow computer and/or you type too slow ;-)
I wonder how does someone did 12 computers in 10 minutes.
Cool!
For me it was a case of
On Wednesday 24 July 2002 21:48, Reid Sutherland wrote:
Hi,
I'm currently locked in a battle with PHP and file uploads. I've
searched the list to no avail. I actually found a guy with the same
problem who ended up using perl to make this work. I'm trying to avoid
that.
The problem is,
Jason Wong wrote:
Apparently that is how it will work in a _future_ version of PHP. But for now
it's all stuffed in RAM until the complete file is received.
That's crazy. Maybe I don't understand enough of how PHP deals with
various web servers and maybe that's why this is the way it is.
Well I think you were correct about not connecting to the db, but I don't
understand why. I wrote another little script just to test the
connection.
?php
$link = mysql_connect(servername,username,password)
or die(Couldn't make connection.);
$diditwork = mysql_select_db(news, $link);
(This was from an email sent to Gabor, and the site said this address was for help)
This is not a definition of the $blah variable. $blah = 1; would be a definition.
I've never had any problems using just $blah; before, it never errored on me once, is
there any reason it does this? (by the
From: Scott Fletcher [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 24, 2002 2:53 PM
Subject: Re: [PHP] Running ./configure multiple times
Yes, it is pretty safe to run ./configure more than once.
The 1st time, it
create the config.cache and so on. The 2nd time, it use the
I would recommend Smarty (http://smarty.php.net). Smarty is unique (?)
in that it compiles templates into PHP code -- making it one of the
faster templating engines out there.
I use Smarty love it.
Cheers,
Hans
On Wed, 2002-07-24 at 15:02, Remy Dufour wrote:
Hi,
Im currently working with
I have a column in one of my mysql tables which holds the date time that
the record was inserted. When I run a query later on I want to display the
date, but if the date is today or yesterday I want to display today or
yesterday instead .. how do i compare to stored date with todays date?
That should definitely be working. Only thing I can think of is that you're
database name isn't correct. You're certain news is the full name of the
database.. I mean it's not news_com or something like that? The $link
must be valid becuase the script isn't ending with Couldn't make
I'm trying to remove all \'s from a string before printing it, but strtr
still treats it as an escape character. How do I remove them? Anyone?
--
The Health TV Channel, Inc.
(a non - profit organization)
3820 Lake Otis Pkwy.
Anchorage, AK 99508
907.770.6200 ext.220
907.336.6205 (fax)
Web:
RTM. stripslashes()
---John Holmes...
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 24, 2002 5:21 PM
Subject: [PHP] Removing \ From a String?
I'm trying to remove all \'s from a string before printing it, but strtr
still treats it as an
Unfortunatelly I changed my ADLS setting from IP static to IP dynamic
and now nobody, me too, can access to my data.
My question is if exist a Free WEB Server where I can place my data
using PHP and MySQL support?
Thank you and have a nice day
Tiziano Crimella - Switzerland
--
PHP General
easyDNS.com provide a dynamic dns solution to your problem
Zac
- Original Message -
From: crimix [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 24, 2002 10:03 PM
Subject: [PHP] Free WEB Hosting with PHP and MySQL support
Unfortunatelly I changed my ADLS setting from
If you want to continue to host it yourself, and simply want a stable
address, try this: http://www.dynip.com/. I've used it for FTP serving
before, and it works very well.
Wm
Crimix [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Unfortunatelly I changed my
As I written to zac, I tried avoid this problem with Dns2Go but the
Client application send the Ip of my router and not that of my computer.
Tiz
Wm wrote:
If you want to continue to host it yourself, and simply want a stable
address, try this: http://www.dynip.com/. I've used it for FTP
..and how poor would the performance be if there were 813 shots in the
movie? Thanks for your help
How fast/big is the surfer's computer?
It's the work on THEIR side that matters.
PHP can spew out 813 shots pretty quickly.
For that matter, if the movie itself is static, you can use PHP to
You can also checkout OASIS
http://oasis.sourceforge.net/
It's pretty good software, but i'm unable to use it here because it
doesn't have as man features as OAS from RealMedia which my manager is
used to.
http://www.realmedia.com
It's expensive and doesn't really integrate into PHP. but it's
Anyway, with asides to the snooty RTFM reply I got, I thought I'd share.
Turns out the \'s that I was having problems getting rid of were written
there from a form post that was used to collect the data. I still haven't
found a way to remove them after reading them from the file, but I did
Is there anyways to speed up MySQL queries? Or showing the results through
PHP? I have several queries that have about 8 left joins or so.. Yes very
huge and when you have lots of people using these functions at once it
really slows down.. Are there any practices that you can think of that would
Mysql 4 can cache queries. You can try using temporary tables, so you can
break up joins.
Also, perhaps making a rawdata table placeholder. Put a timestamp field
on your columns. Make the query and store somewhere the query itself, the
results and the time they were last modified. Then when
i use seconds in place of time alot.
using the PHP time() function and Date() functions u can do a lot.
instead of a time / date TIMESTAMP field type i use an INT type
i then call the $the_time = Time(); and insert that.
then u can manipulate the hell outta that INT value from the DB with php's
1 - 100 of 155 matches
Mail list logo