RE: [PHP] general apache list
apache.org or on Google for Apache Today, I think it apachetoday.org. There you will find your list. Chuck Payne -Original Message- From: electroteque [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 10:45 AM To: [EMAIL PROTECTED] Subject: [PHP] general apache list where can i find it ? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] What other list are there?
Hi, I am getting ready to start another project that will have to do a lot of math. So I need to ask some question on how to get php and mysql to do that. So can you tell what mailing list there because I think that I might have to ask other list since this is general list, I am I think this might be a little more advance. Hey, if I am wrong sorry, just thing to make sure a head of time. Thanks, Chuck Payne Magi Design and Support -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Thoughts on a simple search engine...
Ok for a simple search I should be able to create a form page and Enter the value and select the feild that Ron want to search. Example $sql = SELECT * FROM \$table\ WHERE \$field\ LIKE \'%$value%'\ ORDER BY \$input\; $table = Of course the table they want to search $field = Field that want to seach $value = value what they want to by $input = if they want to search by something other a node numder. So I if I create the form, is there way that I can have it echo on the same page if I am using a form? Chuck Payne Magi Design and Support -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] html input and php (newbie) -- What I was asking with my thoughts on Search Engine
This what I was asking, I want someone to press submit then have the returns
print out in one are of the table. So could I do this?
?php
if ($submit == click){
echo $sql_result;
}
?
So instead of doing a search.html that calls on do_search.php like most
books teach. I am wanting to do a search.php. Just print the information on
that page.
Chuck
-Original Message-
From: Jesse Cablek [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 24, 2002 3:39 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP] html input and php (newbie)
Anna Gyor mailto:[EMAIL PROTECTED] scribbled;
Hi,
I just began to learn php and I have te following code. How can I get
the input field value in the php script? Because my script doesn't
work. $UserName is always an empty string.
?php
if ($submit == click){
echo Hello, $UserName;
}
[...]
Assuming register_globals=off, use $_POST['UserName'] instead
-jesse
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] FPDF and MySQL
Hi, I found a free pdfclass called FPDF http://www.fpdf.org, that I can use with PHP to create pdf files with. Before someone tells me Read The Manual, I have read their page and used Google to search for notes on how called mysql into a PDF and I am lost. Does anyone know where there is a tutorial. Thanks, Chuck Payne Magi Design and Support -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Time Stamp
Hi,
I have a form that I am using to update a mysql table but I can get
timestamp to update. How can I pass that information to pass on. I have
READ all books and feel I have correct systax but it just not working...
input type=text name=lastupdate value=? echo date('D M d, Y H:i:s',
time()); ?
This should pass the time right?
Chuck Payne
Magi Design and Support
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Date-format
I know everyone love to quote read the manual and forget that we[newbies]
are only asking here because we need help...so here you go...
You can do the following...
DATE_FORMAT IS THE MySQL Command
And let say you want to format your date as the following mm-dd-yy(US) or
dd-mm-yy(the rest of the world).
By the way this are format keys
%m the month in numbers,
%d the days in numbers,
%y the year in number
%M spells out the month
%D gives the date with th, rd, nd all that
%Y gives all four numbers
So you do the following sql statement...
SELECT DATE_FORMAT(yourdate, '%m-%d-%y') as youwanttocallit FROM yourtable;
So in your php code you can do this from your MySQL statement...
$youwantcallit = $myrow[youwanttoit];
? echo $youwanttocallit; ?
Advance note
then if you don't want to show 00-00-00 you can do this...
if ($youwanttocallit == 00-00-00) {
$youwanttocallit = nbsp;;
}
that way you don't have a bunch of 00-00-00 showing up.
I hope that helps, because that is what the maillisting is for and not to
always quote Read the Book.
Chuck Payne
Magi Design and Support
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Help getting count to show up.
Hi,
Last night I asked for help doing counts. One of the answers I got was
really great but I can't make it work. The answer I more or less show me a
great way to create a stats page,
ex. SELECT feild1, field2, COUNT(*) FROM tables GROUP BY category, format.
But my problem is I can't get count to show. I can get two of the fields.
Below is the PHP program that I am wanting to run. How can I get count to
show? Thanks.
Chuck Payne
Magi Design and Support
?
$db = mysql_connect('localhost','user','passwd');
mysql_select_db('media',$db);
$result =mysql_query(SELECT category, format, COUNT(*) FROM library GROUP
BY category, format,$db);
if ($myrow = mysql_fetch_array($result)) {
// display list if there are no records to display
do {
printf(%s %s %sbr, $myrow[category], $myrow[format], $myrow[count]);
} while ($myrow = mysql_fetch_array($result));
} else {
// no record to display
echo 'Sorry no records were found!';
}
?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Problem with MySQL
Hi,
I am working on a movie database I have two database that I am calling from
but the problem I am having when I ask it to go and fetch all the movies
with the same title, it stops and only shows one.
Here is a basic layout...
if($videoid) {
$result = mysql_query(SELECT * FROM library WHERE videoid=$videoid,$db);
$myrow = mysql_fetch_array($result);
// The Myrows
$title = $myrow[title];
$videoid = $myrow[videoid];
$catergory = $myrow[catergory];
$appraisal = $myrow[appraisal];
// Some where here it's not working.
$sql = SELECT concat_ws(' ', fname, lname)as actor FROM actormovie WHERE
title = '$title' ORDER by lname;
$result = mysql_query($sql);
print $sql;
$actor = ;
while ($myrow = mysql_fetch_array($result)) {
$actor = $myrow[actor];
$actor .= A HREF='' . $actor . /ABR\n;
}
What am I doing wrong? It only show one record and it show more.
Chuck Payne
Re: [PHP] Brain Dead...
Ok, but I have this as an example
select name=abc size=1
option value=a selectedA/option
option value=bB/option
option value=cC/option
option value=dD/option
/select
Are you saying that abc should be $abc? I not clear.
I have for my sql as this...
db_name = xxxinks;
$table_name = ssslinks;
$connection = @mysql_connect(mybox.com,anyusers,!@#$%) or die (Couldn't
connect);
$db = @mysql_select_db($db_name, $connection) or die (Couldn't select
database.);
$sql = INSERT INTO $table_name
(abc, key_word, links, name)
VALUES
('$abc', '$keywords', '$links', '$name');
$result = @mysql_query($sql, $connection) or die(Couldn't execute query.);
but I get that it can't do the query. So I am think it not passing abc...
Chuck
- Original Message -
From: Thalis A. Kalfigopoulos [EMAIL PROTECTED]
To: Chuck PUP Payne [EMAIL PROTECTED]
Cc: PHP General [EMAIL PROTECTED]
Sent: Sunday, March 17, 2002 9:25 PM
Subject: Re: [PHP] Brain Dead...
Dropdownmenu is a select name=ddmenuoption/select
So the php variable that will hold the user's choice is stored in variable
$ddmenu.
Thus, no input needed.
cheers,
--thalis
On Sun, 17 Mar 2002, Chuck PUP Payne wrote:
I am trying to get a form to work with pull down menu. But I am so brain
dead I forgot how to get the input from the pull down menu. Where do I
put
input to pass on to php?
Chuck Payne
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Brain Dead...
When I go to post, I get the following alertCouldn't execute query so
I know I can connect, so it must be my SQL statement. That why I wondering
how to pass the menu information to php so that it can do the SQL statement.
I don't have $abc in the menu but I do have abc. So I am trying to find out
how to do that. Maybe I am going about it the wrong way.
Chuck
- Original Message -
From: Thalis A. Kalfigopoulos [EMAIL PROTECTED]
To: Chuck Payne [EMAIL PROTECTED]
Cc: PHP General [EMAIL PROTECTED]
Sent: Sunday, March 17, 2002 9:40 PM
Subject: Re: [PHP] Brain Dead...
What does I get that it can't do the query mean? What error are you
getting?
On Sun, 17 Mar 2002, Chuck Payne wrote:
Ok, but I have this as an example
select name=abc size=1
option value=a selectedA/option
option value=bB/option
option value=cC/option
option value=dD/option
/select
Are you saying that abc should be $abc? I not clear.
I have for my sql as this...
db_name = xxxinks;
$table_name = ssslinks;
$connection = @mysql_connect(mybox.com,anyusers,!@#$%) or die
(Couldn't
connect);
$db = @mysql_select_db($db_name, $connection) or die (Couldn't select
database.);
$sql = INSERT INTO $table_name
(abc, key_word, links, name)
VALUES
('$abc', '$keywords', '$links', '$name');
$result = @mysql_query($sql, $connection) or die(Couldn't execute
query.);
but I get that it can't do the query. So I am think it not passing
abc...
Chuck
- Original Message -
From: Thalis A. Kalfigopoulos [EMAIL PROTECTED]
To: Chuck PUP Payne [EMAIL PROTECTED]
Cc: PHP General [EMAIL PROTECTED]
Sent: Sunday, March 17, 2002 9:25 PM
Subject: Re: [PHP] Brain Dead...
Dropdownmenu is a select name=ddmenuoption/select
So the php variable that will hold the user's choice is stored in
variable
$ddmenu.
Thus, no input needed.
cheers,
--thalis
On Sun, 17 Mar 2002, Chuck PUP Payne wrote:
I am trying to get a form to work with pull down menu. But I am so
brain
dead I forgot how to get the input from the pull down menu. Where do
I
put
input to pass on to php?
Chuck Payne
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Brain Dead...
I think it I am the right path now, it has to do with $_GET or $_POST not
passing the information on to mysql.
But I will look at the log shortly.
Chuck
- Original Message -
From: Thalis A. Kalfigopoulos [EMAIL PROTECTED]
To: Chuck Payne [EMAIL PROTECTED]
Cc: PHP General [EMAIL PROTECTED]
Sent: Sunday, March 17, 2002 10:00 PM
Subject: Re: [PHP] Brain Dead...
Is it possible to check the Mysql log and tell us its point of view?
On Sun, 17 Mar 2002, Chuck Payne wrote:
When I go to post, I get the following alertCouldn't execute query
so
I know I can connect, so it must be my SQL statement. That why I
wondering
how to pass the menu information to php so that it can do the SQL
statement.
I don't have $abc in the menu but I do have abc. So I am trying to find
out
how to do that. Maybe I am going about it the wrong way.
Chuck
- Original Message -
From: Thalis A. Kalfigopoulos [EMAIL PROTECTED]
To: Chuck Payne [EMAIL PROTECTED]
Cc: PHP General [EMAIL PROTECTED]
Sent: Sunday, March 17, 2002 9:40 PM
Subject: Re: [PHP] Brain Dead...
What does I get that it can't do the query mean? What error are you
getting?
On Sun, 17 Mar 2002, Chuck Payne wrote:
Ok, but I have this as an example
select name=abc size=1
option value=a selectedA/option
option value=bB/option
option value=cC/option
option value=dD/option
/select
Are you saying that abc should be $abc? I not clear.
I have for my sql as this...
db_name = xxxinks;
$table_name = ssslinks;
$connection = @mysql_connect(mybox.com,anyusers,!@#$%) or die
(Couldn't
connect);
$db = @mysql_select_db($db_name, $connection) or die (Couldn't
select
database.);
$sql = INSERT INTO $table_name
(abc, key_word, links, name)
VALUES
('$abc', '$keywords', '$links', '$name');
$result = @mysql_query($sql, $connection) or die(Couldn't execute
query.);
but I get that it can't do the query. So I am think it not passing
abc...
Chuck
- Original Message -
From: Thalis A. Kalfigopoulos [EMAIL PROTECTED]
To: Chuck PUP Payne [EMAIL PROTECTED]
Cc: PHP General [EMAIL PROTECTED]
Sent: Sunday, March 17, 2002 9:25 PM
Subject: Re: [PHP] Brain Dead...
Dropdownmenu is a select name=ddmenuoption/select
So the php variable that will hold the user's choice is stored in
variable
$ddmenu.
Thus, no input needed.
cheers,
--thalis
On Sun, 17 Mar 2002, Chuck PUP Payne wrote:
I am trying to get a form to work with pull down menu. But I am
so
brain
dead I forgot how to get the input from the pull down menu.
Where do
I
put
input to pass on to php?
Chuck Payne
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
