try:
select
date_format(date_add(arrivaldate1, INTERVAL nights1 DAY), '%Y-%m-%d') as
dept_date1
from mytable
where
(date_add(arrivaldate1, INTERVAL nights1 DAY) BETWEEN '2003-02-01' AND
'2003-02-10')
regds,
-Original Message-
From: Dhaval Desai [mailto:[EMAIL PROTECTED]
This is a forwarded message
From: Tom Rogers [EMAIL PROTECTED]
To: Richard Kurth [EMAIL PROTECTED]
Date: Saturday, March 1, 2003, 5:59:11 PM
Subject: [PHP] Help!! with array's Please
===8==Original message text===
Hi,
Saturday, March 1, 2003, 4:28:27 PM, you wrote:
RK
hi there i am setting up a test replication slave server as a mysql db
master backup if it fails , i would like to know how to dynamically connect
to the slave if the master fails , something really strange i have set the
host like localhost:3307 for the slave but is still connecting to the master
Hi all,
are there any restrictions for mail function, when I use Bcc? how
many email adresses can i put in Bcc, are there any PHP
restriction, or just memory restriction, or something else?
Thanx a lot
Mirza
[EMAIL PROTECTED]
--
PHP General Mailing List
Hello,
I did my first PHP extension (a simple template engine), and I found out I
could not ude V_OPEN() - it simply crashed PHP.
I then searched the web and found somebody mentioning something about a
function called VCWD_OPEN(), which works perfectly, but is not
documented
Any idea why
Check that php_gd2.dll is in your C:\PHP\ folder.
Anthony Ritter [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
I run the following script:
?
phpinfo();
?
// the page loads o.k. when the semi-colon remains as in:
;extension=php_gd2.dll
but if I remove the semicolon as in:
i am having a terrible time killing the session
someone please please help me...
This one works for me:
session_start();
$_SESSION = array();
session_destroy();
But I am surprised that there is no single command to kill the session.
The semantics of session_destroy() suggest that it does
Data from POST is a hash table of strings, so you should use this to check
for zero:
if ($_POST['field'] == 0)
// Zero was entered
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
how would you show a header message or basically force apache to show an
error page of its own like 401 if someone hits cancle on the php auth header
function?
and i have a line like:
header(WWW-Authenticate: basic realm='a realm name');
//i know what that means look at next line...
At 05:09 01.03.2003, Philip J. Newman said:
[snip]
I would like to check for HTTP:// at the start of a string and for at least
1 . and a / at the end of a string.
I have tried ereg, but the documentation is not too clear how to format.
At 05:40 01.03.2003, Philip J. Newman said:
[snip]
Is there a way to PING a URL and check if it returns a valid code like 200
... ??
[snip]
Ping doesn't return a 200 OK code... If you want to check for the
I am putting my gamma-epsilon-psycho telepathy beamer to the maximum but
there are too many coders inbetween us, i cannot receive you.
Please give a little hint on what these functions are and what value comes
from where and goes where.
At 04:00 1-3-2003, you wrote:
I'm trying to implement the
why not try it and let us know.
--- Jean-Christian Imbeault [EMAIL PROTECTED]
wrote:
Is addslashes() multi-byte safe?
I will bu sing it to escape multi-byte input and
wouldn't want it to
mangle anything...
Thanks,
Jc
--
PHP General Mailing List (http://www.php.net/)
To
Dear Sirs,
I wa using
my @InBody = STDIN;
To get data from email after piping. I am not sure that what I should use to
have same result with php?
I just want to have email' s data into my php script to handle.
Best Regards
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe,
Can anyone tell me if it is possible (and how) to use defined constants
within here document content? I've not been successful finding anything
on this in the online docs.
Thanks!
Dan
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
php-general Digest 1 Mar 2003 16:29:34 - Issue 1912
Topics (messages 137664 through 137694):
Checking for HTTP:// at the start of a string and more
137664 by: Philip J. Newman
137665 by: Rasmus Lerdorf
137688 by: Ernest E Vogelsinger
IS there a way.
Hello,
It doesn't look like it - a note in the constants manual entry reads:
PHP has no way of recognizing the constant from any other string of
characters within the heredoc block
Danny.
-Original Message-
From: Daniel R. Hansen [mailto:[EMAIL PROTECTED]
Sent: 01 March 2003 15:57
To:
On Sat, 1 Mar 2003 17:26:37 +0300, you wrote:
Dear Sirs,
I wa using
my @InBody = STDIN;
To get data from email after piping. I am not sure that what I should use to
have same result with php?
Hi,
Read the section beginning with Table 23-2. CLI specific Constants
here:
I'm trying to implement the following functionality into the file
test.php:
When I scroll down the page and then hit a button, the page
should remember
the scrolled position, refresh the page and then scroll down to the
remembered position. I've almost managed to make this work, but
What I would recommend is PHPmyAdmin. I believe it's open source and written
in PHP specifically as a utility for mySQL.
I'm sure you can find it at sourceforge.net (or a similar site) .
Jeremy N.E. Proffitt [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
I need to create some simple
If I exec a command like ifconfig, I'd like to be able to parse. What is
the best way to go about thihs? An example output from ifconfig is:
Check http://www.php.net/manual/en/function.passthru.php
Rich
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit:
I run the following script:
?
phpinfo();
?
// the page loads o.k. when the semi-colon remains as in:
;extension=php_gd2.dll
but if I remove the semicolon as in:
extension=php_gd2.dll
the page won't load and the server hangs up.
..
\\
hi there i am setting up a test replication slave server as a mysql db
master backup if it fails , i would like to know how to
dynamically connect
to the slave if the master fails , something really strange i have set the
host like localhost:3307 for the slave but is still connecting to
the
At 16:56 01.03.2003, Daniel R. Hansen said:
[snip]
Can anyone tell me if it is possible (and how) to use defined constants
within here document content? I've not been successful finding anything
on this in the online docs.
Actually I did try it and couldn't think of a way to work around the matter.
Thanks for the suggestion.
-Original Message-
From: Ernest E Vogelsinger [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 01, 2003 12:56 PM
To: Daniel R. Hansen
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] Constants
Hi,
Thanx for yor reply. Well It worked for me with the same query when I used
HAVING instead of where. This is what I got from Mysql Database. However
the solution that you have showed is reall good as well.
Thanx
-Dhaval
From: Uttam [EMAIL PROTECTED]
To: 'Dhaval Desai' [EMAIL
Is there a way that i can restrict access to an entire directory using
PHP/MYSQL so only valid users in the Database can have access to a resource?
--
Philip J. Newman.
Head Developer
[EMAIL PROTECTED]
+64 (9) 576 9491
+64 021-048-3999
--
Friends are like stars
You can't allways see
Check out :
Authenticating against .htpasswd style files.
http://www.weberdev.com/index.php3?GoTo=get_example.php3?count=109
Sincerely
berber
Visit http://www.weberdev.com/ Today!!!
To see where PHP might take you tomorrow.
-Original Message-
From: Rob Packer [mailto:[EMAIL
I'm building a site that allows ppl to upload images. PHP was compiled with
the GD lib so I'm able to verify all sorts of info about the image for
validation. However, I was wondering if there is a way to convert a
non-jpeg image to jpeg just by using the GD functions as opposed to using
Don't reinvent the wheel :)
http://www.phpadsnew.com/one/
Then how would people learn? Eventually everyone that
knows how to make the wheel will die and the knowledge
to make it will be forgotten.
J.
__
Do you Yahoo!?
Yahoo! Tax Center -
The other problem is that if I open two browser
windows to your site, one after the other, and see
two banners, and then click on the first one, am
I going to go to the site for the second one?
Yes, that is one of the main problems. Would using
sessions help end this?
J.
Would this do it for you?
No, that is that the problem. Showing the banner is.
It's when they click on it.
__
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/
--
PHP General Mailing List
Hello,
I didn't find in the doc how to:
- Know the full path of the current directory. Like /var/www/to/the/path
- Know under which user work apache, to know when I create a file whose
file it is...
Thanks.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit:
Hello,
I have a file that the content always change every second or so. I want to
display this to the web. Is this possible to do using PHP? If yes how?
I can have the content displayed to the web only update every 5 seconds or so,
for example. Will this put the server into heavy load?
If PHP
Hello,
I was wondering how I could download a file via FTP in parts. (For eg
0bytes - 400 byes and then from 401 bytes to 801 bytes)
Thank you,
- Siddharth Hegde
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Vincent M. [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hello,
I didn't find in the doc how to:
- Know the full path of the current directory. Like /var/www/to/the/path
try using dirname(__FILE__) or dirname($_SERVER['PATH_TRANSLATED'])
- Know under which user work apache,
Question:
is it better to store user names as upper and lower case? should they bee
converted to one case?
I have a script the checks for names and ...
Mark is not the same as mark, or MaRk ...
is there a way of making a string into lower case?
--
Philip J. Newman.
Head Developer
[EMAIL
LOL got a reply to this before i ever got the message my self ...
- Original Message -
From: Philip J. Newman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, March 02, 2003 10:56 AM
Subject: [PHP] Upper and lower case.
Question:
is it better to store user names as upper and
At 19:28 01.03.2003, Daniel R. Hansen said:
[snip]
Actually I did try it and couldn't think of a way to work around the matter.
Thanks for the suggestion.
-Original Message-
From: Ernest E Vogelsinger [mailto:[EMAIL PROTECTED]
You simply could have
At 21:12 01.03.2003, Philip J. Newman said:
[snip]
Is there a way that i can restrict access to an entire directory using
PHP/MYSQL so only valid users in the Database can have access to a resource?
[snip]
1) Put
Is there an easy way to create a calendar in PHP, such as a calendar
function? All I need is a dynamically created calendar to link to other
pages.
Jason D. Williard
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Check http://www.cascade.org.uk/software/php/calendar/
I've used that one on several sites.
-Original Message-
From: Jason D. Williard [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 01, 2003 4:28 PM
To: [EMAIL PROTECTED]
Subject: [PHP] Calendar
Is there an easy way to create a
Rich,
I've checked my php.ini files on my drive and all I've got is one.
The php_gd2.dll file is in:
C:/PHP/extensions
There was no default folder called extensions when I installed PHP so I made
a directory called extensions under PHP.
Everytime I take out the semicolon in the .ini file, the
P.S.
If you get a moment, maybe you could send me a .txt file of your php.ini
file along with you php_gd2.dll setup.
That way I could check line for line.
Many thanks,
TR
---
[This E-mail scanned for viruses by gonefishingguideservice.com]
--
PHP General Mailing List (http://www.php.net/)
To
Hello all,
I've got several questions and i'm hoping i can find answers or links to
places which contain the answers.
1. How can i set a script to run at a certain time?
For example, say i want to send a mass e-mail at 5:00pm every night which
contains the latest updates to the website. I
At 00:49 02.03.2003, The Head Sage said:
[snip]
1. How can i set a script to run at a certain time?
*nix: use cron (man crontab)
Windows: use the at command (help at)
2. How do i open a HTML file, extract all the text and then break up the
text into
Untested:
if (preg_match('/^http:\/\/[^\.\s]+\.[^\s]+\/$/i', $string))
// valid string
else
// invalid string
Should match a string beginning with 'http://', followed by one or more
characters that are no dots or whitespace, followed by a dot, followed by
one or more characters that are
Rich,
I've checked my php.ini files on my drive and all I've got is one.
The php_gd2.dll file is in:
C:/PHP/extensions
There was no default folder called extensions when I installed
PHP so I made
a directory called extensions under PHP.
Everytime I take out the semicolon in the .ini
I know this is probably an easy question, but I am
using stripslashes() on a textarea var, and I don't
think it's working. It doesn't error, but in the
testarea it doesn't seem to work. Ex:
$var = Thank's;
$var = stripslashes($var);
echo $var;
Output = Thank\'s
Any ideas? Thanx.
-Dade
At 01:17 02.03.2003, Kris Jones said:
[snip]
Untested:
if (preg_match('/^http:\/\/[^\.\s]+\.[^\s]+\/$/i', $string))
// valid string
else
// invalid string
I've also been looking for this information. Can you please point me to a
list of those
At 01:48 02.03.2003, Dade Register said:
[snip]
I know this is probably an easy question, but I am
using stripslashes() on a textarea var, and I don't
think it's working. It doesn't error, but in the
testarea it doesn't seem to work. Ex:
$var = Thank's;
Well, only diff is it's a POST from a textarea. With
magicquotes on, you're right, it makes Thank's
become Thank\'s. how can I get rid of that? I'm
posting it to a text file.
-Dade
--- Ernest E Vogelsinger [EMAIL PROTECTED]
wrote:
At 01:48 02.03.2003, Dade Register said:
At 02:05 02.03.2003, Dade Register said:
[snip]
Well, only diff is it's a POST from a textarea. With
magicquotes on, you're right, it makes Thank's
become Thank\'s. how can I get rid of that? I'm
posting it to a text file.
is it better to store user names as upper and lower case? should they
bee
converted to one case?
Store it where? It depends if the place you store it in and the
comparisons there are going to be case sensitive or not. Most database
fields are going to be case sensitive while a PHP comparison
Dan --
Just a short followup to your note, though I hope to come back to it when
I get a breather.
Yes, anything is possible if you have the gumption :-) You sound like
you've been around the web a bit and aren't scared, so feel free to dig
in and try it. PHP is a fairly easy language to
I have a form that allows someone to upload a text file, the contents of
which will be inserted into the database. When I fread() the file, there is
some garbage at the beginning and end of the text.
Here's what the text looks like:
This is the sentence of text.
Here's what it looks like
I have a form that allows someone to upload a text file, the contents
of
which will be inserted into the database. When I fread() the file,
there
is
some garbage at the beginning and end of the text.
Here's what the text looks like:
This is the sentence of text.
Here's what it
Has anyone successfully gotten fusebox for php to work on AIX w/
4.3.1? The server I am using has globals turned off, but I have this in
the index file,
extract($_SERVER);
extract($_GET);
extract($_POST);
extract($_COOKIE);
but all I get is a blank screen. The code is fine because when it is
I know I am doing the exact thing you are If you
or someone else doesn't mind, could you look @
http://dragonz-cavern.mine.nu/poems.phps and see what
I'm doing wrong? I am trying to parse it before it
gets stored in my txt file. plz help. I'd really
appreciate it.
-Dade
--- Ernest E
Are you using Apache2? IIRC, there was a bug where data would get added
to the POST data, or something along those lines...
What if you just look at the file with a regular text editor? Do you see
that data there after it's uploaded and written to the server, or does
it just appear into the
At 03:37 02.03.2003, Dade Register said:
[snip]
I know I am doing the exact thing you are If you
or someone else doesn't mind, could you look @
http://dragonz-cavern.mine.nu/poems.phps and see what
I'm doing wrong? I am trying to parse it before it
gets
Thanx a lot for your help.
It adds to the .dat file. it's not fgets().
Dade [EMAIL PROTECTED]'s
That's from the dat file. any other ideas?
-Dade
--- Ernest E Vogelsinger [EMAIL PROTECTED]
wrote:
At 03:37 02.03.2003, Dade Register said:
[snip]
I know I
At 04:03 02.03.2003, Dade Register said:
[snip]
Thanx a lot for your help.
It adds to the .dat file. it's not fgets().
Dade [EMAIL PROTECTED]'s
That's from the dat file. any other ideas?
[snip]
add this line
If your server is IO bound and not CPU bound in most cases it will
continue to serve requests as long as the maximum number of concurrent
connections is not exceeded or they don't timeout.
In any case your server should not give a 404 error because of being I/O
bound, 404 means document not
I know this is a php forum. Please don't be upset with
me, but I have a JS problem which nobody I know can
seem to figure out. Here goes:
script LANGUAGE=JavaScript
var w1 = 1000;
var h1 = 672;
if (w1 = screen.width){
if (h1 = screen.height){
document.write(a
document.write(a
href=/pics.php?view=popupimage=2003-01-January/image1.jpg
onclick=NewWindow(this.href,'popup','1000','672','no');return
false;img
src=/pics/2003-01-January/image1-thumb.jpg
border=0 alt=Image 1 of 64/anbsp;)}
Shouldn't you be escaping some quotes here? The string your
I am wondering if anyone out there has some really good references in
regards to scripts distributed as open source using the GPL. In the last
three years that I have worked on open source projects I have seen several
people steal a program, change the name and then try to distribute it as
They're doing nothing wrong as long as they distribute the source under
the GPL.
Jeff Lewis wrote:
I am wondering if anyone out there has some really good references in
regards to scripts distributed as open source using the GPL. In the last
three years that I have worked on open source
php-general Digest 2 Mar 2003 04:34:21 - Issue 1913
Topics (messages 137695 through 137752):
Re: Constants and Here Document Interpolation
137695 by: Danny Shepherd
137707 by: Ernest E Vogelsinger
137708 by: Daniel R. Hansen
137722 by: Ernest E Vogelsinger
I generally use the BSD license for my code and PHP scripts, in some
cases I have used the GPL but IMHO the GPL is too restricting so I live
what I preach and release my code under the BSD License.
As far as people stealing code and renaming it I've seen several
commercial programs that are
And they aren't, that is our main issue...
So with the GPL, someone can change say...10 lines and rename the scripts
and distribute it as their own?
Jeff
- Original Message -
From: Leif K-Brooks [EMAIL PROTECTED]
To: Jeff Lewis [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday,
Rich,
I've got five screenshots at this URL:
www.gonefishingguideservice.com/php1.htm
If you get a chance please take a look.
I got php_gd2.dll from the zipfile (see photo) and the extensions
sub-directory was not there when I installed.
Many thanks,
TR
Yes. Just look at Linux, and its many distributions. Most have changed
more than 10 lines, but I don't believe the GPL says how much must be
changed.
Jeff Lewis wrote:
So with the GPL, someone can change say...10 lines and rename the scripts
and distribute it as their own?
--
The above
Greetings all.
I have used strtotime() function in the past, and done this:
if($time = strtotime('24 hours ago')) {
$new = new!;
}
with it being in UNIX time stamp .. But now I have a different client where
the time stamp in mysql is formatted like:
2002-08-29 10:53:09
what function would I
Greg Beaver wrote:
Vincent M. [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hello,
I didn't find in the doc how to:
- Know the full path of the current directory. Like /var/www/to/the/path
try using dirname(__FILE__) or dirname($_SERVER['PATH_TRANSLATED'])
I have used strtotime() function in the past, and done this:
if($time = strtotime('24 hours ago')) {
$new = new!;
}
with it being in UNIX time stamp .. But now I have a different client
where
the time stamp in mysql is formatted like:
2002-08-29 10:53:09
what function would I use in
Hello,
I am the bus stop boy. The business I was talking about is an php
gallery editor. You can see mine in action here:
My photos of Montreal:
http://www.siova.net/photos/index.php?type=mtlimg=mtl_diapo=0pref_size=512version=2
My photos of Toulouse, the city I was born in:
hi
basic question about www-authenticate header...(least i hop its simple)
i have the code:
?php
header(WWW-Authenticate: basic realm='a realm');
header(HTTP/1.0 402 Unauthorized);//dont understand
//what this line does
echo you didnt login yet\n; //understand it but want
//something else like a
sorry, I do not see how that will work. I need a function that will know if
2002-08-29 10:53:09 was 24 hours ago, and if true, new will appear.
warm regards,
Sebastian - [BBR] Gaming Clan
http://www.broadbandreports.com
- Original Message -
From: John W. Holmes [EMAIL PROTECTED]
To:
Hi,
Sunday, March 2, 2003, 3:39:37 PM, you wrote:
S Greetings all.
S I have used strtotime() function in the past, and done this:
if($time = strtotime('24 hours ago')) {
S $new = new!;
S }
S with it being in UNIX time stamp .. But now I have a different client where
S the time stamp in mysql
Hi,
I have a problem in grabbing data from a file.
I need to fetch data from raw log files and display it
in a proper tabular manner.
The log file contains:
AWSTATS DATA FILE 5.0 (build 1.345)
# If you remove this file, all statistics for date
2002-12 will be
I would like yo show the users in a list that have a date that is more than
60 days old.
$sql = SELECT * FROM stompers WHERE sUpdated
from_unixtime(unix_timestamp(now())-(15760*60)) AND sActive = 'Y' ORDER BY
sUpdated DESC;
This don't quite work ..
Any suggestions?
--
Philip J. Newman.
Not directly PHP related, but I'm building a site in PHP at the moment, so
I've been doing a bit of research...
I've been on the net for years, coding and surfing and coding. And not
always in that order. ;) But only recently have I heard about web beacons,
or single-pixel gifs. Seems every
Greetings All...
Usually I am helping others on the list but this time I am asking for
help!!
I was wondering if someone could offer some clarity for me as
my years of using Apache has never seen the following as a possibility.
Background: This server is using PHP along with Apache
If a server
Jean-Christian Imbeault [EMAIL PROTECTED] wrote:
Is addslashes() multi-byte safe?
I will bu sing it to escape multi-byte input and wouldn't want it to
mangle anything...
Partially yes.
Strings encoded in GB2312(CP936), big5, Shift_JIS are known to be
clobbered by addslashes().
UTF-8,
Moriyoshi Koizumi wrote:
Partially yes.
Strings encoded in GB2312(CP936), big5, Shift_JIS are known to be
clobbered by addslashes().
Sh*t ... and I just added a whole bunch of addslashes() to my code to
prevent SQL attacks. And of course my web pages are for Japanese ... and
most of them will
Jean-Christian Imbeault [EMAIL PROTECTED] wrote:
Moriyoshi Koizumi wrote:
Partially yes.
Strings encoded in GB2312(CP936), big5, Shift_JIS are known to be
clobbered by addslashes().
Sh*t ... and I just added a whole bunch of addslashes() to my code to
prevent SQL attacks. And
This recent thread from the mysql list explains a lot about the
problem.
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:15034
hth,
Doug
On Sat, 1 Mar 2003 12:24:57 +0100, Frank Keessen wrote:
Hi All,
I'm trying to get a random record each time this script runs; Only it's giving me
everytime
Is addslashes() multi-byte safe?
I will bu sing it to escape multi-byte input and wouldn't want it to
mangle anything...
Thanks,
Jc
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi All,
I'm trying to get a random record each time this script runs; Only it's giving me
everytime the first record back.. No random at all..
// generate and execute query
$query = SELECT stedenid, naamstad, stadomschrijvk FROM steden ORDER BY RAND() LIMIT
1;
$result = mysql_query($query) or
Hi All,
I'm trying to get a random record each time this script runs;
Only it's giving me everytime the first record back.. No random at all..
// generate and execute query
$query = SELECT stedenid, naamstad, stadomschrijvk FROM steden
ORDER BY RAND() LIMIT 1;
$result =
Thanks guys for the info; I will speak to my ISP!
Have a nice weekend!
Regards,
Frank
- Original Message -
From: Rich Gray [EMAIL PROTECTED]
To: Frank Keessen [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Sunday, March 02, 2003 2:36 AM
Subject: [PHP-DB] RE: [PHP] Random
You might try getting the random number before the query.
-Original Message-
From: Rich Gray [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 01, 2003 8:37 PM
To: Frank Keessen; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [PHP-DB] RE: [PHP] Random not working?
Hi All,
I'm trying to
Mark wrote:
--- Daniel Harik [EMAIL PROTECTED] wrote:
Hello,
I have 2 tables users table, that stores user info, and photos
table,
i want to select all users with one photo form photos table,
but i don't
want it to be photos * users = result.
Is there way to do it?
Paul Burney wrote:
on 2/28/03 3:15 PM, Daniel Harik at [EMAIL PROTECTED] appended the
following bits to my mbox:
Thank You for your reply, but the problem is that users may have many
photos, and i need to get only one, i use folllowing sql:
SELECT users.username, photos.file FROM users
From an email. Reposting to to list for thos who might have the same
question later on :)
Moriyoshi Koizumi wrote:
Oops, I should have said mbstring.encoding_translation=on actually :)
Ok. Turning that on.
In which case I am safe :) But then again anyone who would want to try
an SQL injection
96 matches
Mail list logo