With my respects to your design may I suggest the
following:
1- Table:
CARS
car_id car_name active_flag price
1 BMWY 100
2 FORD Y 50
etc.
Then in your form you can hava a dynamic LOV:
$sql = "select car_id, car_name
from cars
where active_flag = 'Y'
I have not done it, but i can be done by using a form and
calling the shell script that does the job.
Of course shell script has to be executable by everybody.
It may be a security concern.
or, you can add the shell script to your cron tab.
and keep the password change requests in a file and chang
Dear List member,
Plesae forgive me for asking and OT question. Can you please recommend an edit
program, (Freely downloadable).
Thanks,
Erisen
Mehmet Erisen
http://www.erisen.com
-
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail.
If you are using sessions, use it as a session variable.
--- "John (News)" <[EMAIL PROTECTED]> wrote:
> I need to pass a variable e.g. $var1 from one PHP page to
> another. The
> only conditions are that the variable cannot be shown in
> the source
> code on the end users machine nor can it be pa
Hi,
I have to sweat my way through
/usr/bin/php if that does not work try /usr/local/bin/php
or ask the Unix Sysadmin.
one problem I still have to overcome is that everything
works,( I mean DB Connection etc.) but I can not use mail()
function.
Any body have any ideas why I can't use mail()
Hi do you care about case sensitivity?
Nathan Cassano <[EMAIL PROTECTED]> wrote:
select * from tbl_lit where lit_source like 'c%';
Check out http://www.sqlcourse.com/
-Original Message-
From: Wolf-Dietrich von Loeffelholz [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 1
Hi,
Sorry if I am being a rude, but you need to read the
document on how to create a table:
www.mysql.com
and
www.php.net (assuming that you will use php)
thx.
--- -=LukA=- <[EMAIL PROTECTED]> wrote:
> Hello php-general,
>
> Hi everybody
> Please help me.
> If i want to create a table in
I have installed phpBB several times. Your problem should
not be the password protected directory.
The install.php script tries to wright into the config
file.
so, you have to chmod your file and give r/w access to
everybody.
once insallation is completed, then change it the was it
was originally.
Hi All,
I am in sql mode today. Two issues that bother me:
1- I had a script"
select user_id, username from users having user_id = max(user_id)
my max user_id = 150 or something, but script kept bringing 122
I fixed the issue by using a select max(user_id) and select username from users whe
Hi,
If I have en ENUM column in a mysql table, can I leverage
this through PHP to restrict user entry with a list?
Other option that I have is to create a lookup table, or
use an array.
=
Mehmet Erisen
http://www.erisen.com
__
Do You Yahoo!?
Se
";
}
?>
--- Rasmus Lerdorf <[EMAIL PROTECTED]> wrote:
> Well, does /usr/local/bin/php exist?
>
> On Thu, 10 Jan 2002, Mehmet Kamil ERISEN wrote:
>
> > hi,
> > here is the question:
> > I know I need to add a line like:
> > #!/usr/local/bin/php
> &
hi,
here is the question:
I know I need to add a line like:
#!/usr/local/bin/php
to the begining of my php page followed by
Then set a cron job, so it runs.
I have done all that. aslo made the php file executable.
The file is executing.
First I did not put the line #!/usr/local/bin/php
and I re
hi,
download one of the php forum programs and look into their
code.
www.phpBB.com should be a good reference.
--- Dani <[EMAIL PROTECTED]> wrote:
> Hi !
>
> How do I allow HTML entries into my database?
>
> I tried to insert a pre-formated text into my database.
> When I pull the
> data out and
Hi,
thanks for the reply. I did setup the crontab already to
run every minute.
the webmaster account receives the report.
Here is the output that I get when I remove the
#!/usr/local/bin/php -q
/home/webvoire/www/cm/test.php: ?php: No such file or
directory
/home/webvoire/www/cm/test.php: =Cron
Hello All,
I have a php script that i tested first through my browser.
If has a simple mail() command.
It workd fine and I received the email.
not I tried to run it as a cron job by adding
#!/usr/local/bin/php -q
My webmaster account receives the confirmation that cron
job has run, but I do not r
If you are querying the Score >= 75 how are you ging to
take the "Consecutive" requirement into the account.
--- Martin Towell <[EMAIL PROTECTED]> wrote:
> could you change this
>
> $query2 = ("SELECT Month, Score FROM scores WHERE
> Username =
> '$Username'");
>
> to
>
> $query2 = ("SE
Hi,
If I am not missing anything, you are not sorting
SELECT Month, Score
FROM scores
WHERE Username = '$Username'
Also, the requirement is not three consecutive test in a
month, so I would not break the loop into months.
once you have it ordered it by the date :
while (list($Month, $Score
Hi,
You can store all shopping cart activites in a cookie until
it is written to your database.
When they login, call the cookie and insert the cookie SC
to the database
--- Ryan Kelley <[EMAIL PROTECTED]> wrote:
> I am writing an online store and have setup sessions to
> run when a user
Hi,
Suppose you have a table students:
student_id / student_name / GPA
here is the code:
$sql = "select *
from students";
$result = mysql_query($sql);
while(list($student_id,
$student_name,$gpa)=mysql_fetch_array($result) {
echo $student_name." has a GPA of".$gpa."";
}
btw, th
Hi,
Can anybody suggest a good reading on how to work with
arrays with multiple keys?
thanks.
=
Mehmet Erisen
http://www.erisen.com
__
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
--
PHP General Ma
Hi Jason,
I am not too familiar with IF statements in SQL, but one thing may be the reason you
see the incorrect results:
You have three tables, player, coach and co_bookmarks, but you only join player and
coach. Shouldn't you join coach with co_bookmarks.
I hope this helps.
erisen
SELECT
Dear List,
I is always a good idea to check out the manual before asking questions.
The answer to Leon's question about files is in the manual as well as the answer to
this questions. I hope the following links help.
File Operations:
http://www.php.net/manual/en/ref.filesystem.php
Bcc can be f
Hi,
As the data grows I like to add the functionality that people see 30 lines of the
result on one page. Also I like to give users the ability to sort per columns...
I know this is done pretty much everwhere. What's the best or easiest way of doing it?
Mehmet Erisen
http://www.erise
Hi,
So far the best way to troubleshoot mysql+php for me has been to add an "or die" after
the sql exec.
$crdate = date("Y-m-d");
$result = mysql_query("SELECT * FROM sites WHERE creation_date = '$crdate'
AND status = 'T'") or die ('CAN NOT EXEC SQL');
Or you can do
$sql = "SELECT * FROM sit
you can aslo go to www.php.net and read the emails from
your browser.
--- Garth Dahlstrom <[EMAIL PROTECTED]> wrote:
>
> If you don't like getting 50 messages a day, I suggest
> using this list's digest mode, then you get 1 big message
> with your daily dose of 50 messages tucked away neatly
> i
use
$sql = "select .. ";
$result = mysql_query($sql);
echo $sql;
--- louie miranda <[EMAIL PROTECTED]> wrote:
> Hi, is it possible to print the sql query? i mean
> i want to print the output of the command "SELECT * FROM
> members;"
> and output it into html, i tried
>
> print $result; -- i
I hope I am not wrong, but the problem is with the
mysql_result() functions.
Instead, I would use:
whilie ($myrow=mysql_fetch_array($result)) {
//put whatever you like here.
}
and instead of
mysql_result($result,0,"asl")
$myrow["asl"]
I hope this helps.
from the manual
http://www.php.net/manu
Hi,
In your SQL, you can say
select t1.col colt1, t2.col colt2
from table1 t1, table2 t2
where t1.something = t2.samething
In other words, you can name your columns differently in your select clause.
I
Bogdan Stancescu <[EMAIL PROTECTED]> wrote: If everything else fails, you should consider
u
Hi,
Can anybody suggest a function that will generate a random
date between
01-Jan-1967
31-Dec-1985
thanks.
=
Mehmet Erisen
http://www.erisen.com
__
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
--
PHP
Hello,
I am trying to transalte entry in Turkish Characters to
English Characters.
I wrote the following code.
function translate_turkish($string) {
$estring = strtr($string, "ç", "c");
$estring = strtr($string, "ç", "c");
$estring = strtr($estring, "ð", "g");
$estring = strtr($estr
Dear Friend,
If I were you, I would take my biz elsewhere. BTW, which company is that?
Anyway, I will recommend you to use the phpMyAdmin. It's a mysql database management
tool written in PHP, free of charge of course, that lets you manage your database.
One of the cool things it that it du
Hi,
May I suggest that you take a look at the code library at zend.com, and devshed.com .
I remember seeing a login application using the SESSIONS.
Alternatively, you can use cookies to let your browser know who is browsing.
Jack <[EMAIL PROTECTED]> wrote: Dear all
I had create the Login P
Hi,
I think I'm misunderstood. I do not want to run in cgi
mode.
Thanks,
Mehmet.
--- Martín Marqués <[EMAIL PROTECTED]> wrote:
> On Mié 19 Dic 2001 19:14, you wrote:
> > Hi All,
> > I have a good understanding of PHP. I like to read
> more
> > documentation advanced PHP topics and also some more
One problem that I have with sessions it that if your login
page is in www.yoursite.com and the you pop a page
yoursite.com I think the Session is not recognized.
just a hint.
--- William Sanchez Sanchez <[EMAIL PROTECTED]> wrote:
>
>
> I need some help with sessions. I need to pass variables
>
Hi All,
I have a good understanding of PHP. I like to read more
documentation advanced PHP topics and also some more
information on how to run PHP from Unix, as a cron job, how
can PHP scripts be called from Shell Scripts etc...
Any book or doc suggestions.
Thanks,
erisen.
=
Mehmet Erisen
Hello All,
Is anybody aware of any limitations of php on embedded if
..else statements?
For example:
if ($a>$b) {
if ($c>$d) {
this();
} else {
if ($gg==$dd) {
echo 'ladooo';
} else {
echo '
get="_blank" in the anchor tag so it
> would work just fine
> _without_ javascript ...
>
> Mark C.
>
> -Original Message-
> From: Mehmet Kamil ERISEN [mailto:[EMAIL PROTECTED]]
>
> I would use javascript for that.
> --- Brandon Orther <[EMAIL PRO
I would use javascript for that.
--- Brandon Orther <[EMAIL PROTECTED]> wrote:
> Does anyone know how I could have php open a new windows
> with the url I
> specify?
>
> Thanx,
> Brandon
>
=
Mehmet Erisen
http://www.erisen.com
__
Do You Y
what's your raw data. I mean, what is the value of
$row["mydatafield"];
--- Max <[EMAIL PROTECTED]> wrote:
> Hi to all,
>
> I'm using this to get date from mySQL database:
>
> ...
> $p_datum = $row["mydatefield"];
> $mydate = getdate($p_datum);
> $month = $mydate['month'];
> $mday = $mydate['
Hi,
I use connecticut-web.com. Pretty good. fast. The most
important value is that the customer service is excellent.
They provide email and icq service and very prompt in
returning requests.
--- R'twick Niceorgaw <[EMAIL PROTECTED]> wrote:
> take a look at aletia hosting (www.aletiahosting.com
Hi,
I think you can include pages from other sites, servers.
SESSIONS (I think) are server specific, cuz the info is
kept on the server.
If you tell me what u gonna be doing, I can give you ideas.
thx.
erisen
--- Jordan <[EMAIL PROTECTED]> wrote:
> is there anyway to drag session variables to an
top
of the index.php page.
Woow. I guess the problem was all the sudden the $SESSION[]
operations were considered output bu Header().
Gurus, do you think I am filling up my pages with garbage,
or what I am saying is making sense?
Thanks.
Erisen
--- Mehmet Kamil ERISEN <[EMAIL PROTECTED]> wrote:
Hello All,
I have switched hosting companies. previous server was
php4.04pl1 now I am on a server that is php4.06.
I have a file (functions.php) that stores all my SESSION
and other functions. A Header file, that has the general
feel and look of the site. In brief most of my pages have
include
43 matches
Mail list logo