Yes,
option value=? echo $row-id; ? ? echo $selected; ? selected
You've hardcoded selected there and also expect it to be set
dynamically.
--
Maxim Maletsky
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi All,
I have a situation where I need to get data from more than one table, but where the
fields in the table are identical, the two tables are holding data for different
years. The queries I would like to execute would be something along the lines of this:
-
SELECT SUM(T1.F1) AS C1,
SELECT SUM(T1.F1) AS C1, SUM(T2.F1) AS C2 FROM T1, T2
Hi,
T1,T2 is a join of the two tables which means that you combine each value of T1 with
each value of T2. This is why you don't get the result you want. In your case I simply
would do two querys as it won't make any problems:
SELECT SUM
You could also look at a site like javascript.internet.com and look up a
pre-written phone number validation script and do the validation on the
client side in addition to or instead of doing it on the server side.
One reason you may want to consider doing client-side validation for
something
thanks, i think your probably right.
Another problem I have is trying to sum the totals of F1 over muliple tables, what I
would like is to be able to use the UNION statement but my site is hosted and they are
not using version 4x of MySQL.
Is there any work around for this using a single SQL
Hi All, I have a date format of -MM-DD in MySQL and am showing it on a PHP page.
However I want to show it as
2 February, 2003
or 2 February
Can someone please help me. The date will not necessarily be todays date (I looked at
the datetime() function and the getdate() function but
strftime()
offers a lot of formatting options for dates.
Hope it helps.
RUBANOWICZ Lisa wrote:
Hi All, I have a date format of -MM-DD in MySQL and am showing it on a PHP page. However I want to show it as
2 February, 2003
or 2 February
Can someone please help me. The date will not
Or if you want to change it when you're pulling out of mysql you can use
the DATE_FORMAT( ) function...
hth
jeff
John Krewson
Good day all,
I have just began work on a project to let users subscribe to a service and
place orders into a database that is VFP 6 based.
Using PHP4, I am able to interface with their program (that also uses ODBC
locally) in all aspects (INSERT, UPDATE, DELETE, and SELECT).
My worries come
I have just began work on a project to let users subscribe to a service
and
place orders into a database that is VFP 6 based.
Using PHP4, I am able to interface with their program (that also uses ODBC
locally) in all aspects (INSERT, UPDATE, DELETE, and SELECT).
My worries come when
$query = mysql_query(SELECT UNIX_TIMESTAMP(fieldname) AS date WHERE id = '1';);
$array = mysql_fetch_array($query);
$mydate = date(j F, Y,$array[date]);
Change fieldname and the where clause, and that should work.
If you want to further munipulate how it looks, just look at the
date
Hi, need some help.
i will try to explain my self.
I have a sendmail in GNU/linux, and a radiator GNU/Linux with Mysql. I have
to give a diferente user for de dialup login and the sendmail, cause i can't
or i dont know a way to change the user and pass for the user in the two
servers. Like this,
It IS following your \n, but HTML doesn't know what a newline is. Do
a vbiew source and you'll see that it's got line breaks.
You need to use BR or P tags so that *HTML* knows what you want
from it.
As for property_type, print_r($row) in the while statement to see
what's coming out of the db.
I try to write very clean code. However, there is one thing that always bugs
me - using heredoc syntax in a function. Code in the function really should
be indented (or 4 spaces for PEAR types), but, to quote the documentation,
the closing identifier must begin in the first column of the line.
I'm looking for a sample code that process an image upload AND
insert it in a MySQL blob file.
Thanks.
---
Stéphane Pinel - Exenevex SA
---
--
PHP
I think you might find it a better option to upload the image to a folder on
the server and save the image path in the db...not the actual image.
Eddie
-Original Message-
From: Stéphane Pinel [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 03, 2003 1:03 PM
To: 'PHP DB'
Subject:
Regardless of the final decision (directory vs BLOB) this topic is covered
just about every week on this list. If you check the archives you'll find a
wealth of information out there regarding uploading, storing and retrieving
images and the benefits and disadvantages of each possibility.
If
De: Stéphane Pinel [EMAIL PROTECTED]
Date: Lun 3 fév 2003 19:57:25 Europe/Paris
À: [EMAIL PROTECTED] (Edward Peloke)
Objet: Rép : [PHP-DB] Uploading an image then storing it in a MySQL
blob field
Le lundi, 3 fév 2003, à 19:44 Europe/Paris, Edward Peloke a écrit :
I think you might find it
There's an alternate route, but I've used it only over a network, not
across the internet.
Create a keys table which has two fields - tablename and keyvalue.
Create a Get_VFP_Key function with one parameter, the tablename, which
returns the keyvalue for that table name.
Get_VFP_Key gets a
Helloo people,
I have a question about MySQL, i use MySQL 3.23.55 together with PHP
4.3.0 on my windows XP system. Does the version of MySQL supports InnoDB
tables? And how do i do it i have noticed that in PhpMyAdmin i
cannot choose this table format..., but i gues that has more to do
I usually do something like this:
function somefunction(){
//Do whatever
print
END
Whatever
text
here
END
;
}
Rob Day wrote:
I try to write very clean code. However, there is one thing that always bugs
me - using heredoc syntax in a function. Code in the function really should
be
the function you need is
DATE_FORMAT()
select event, DATE_FORMAT(my_time,'%d-%m-%Y) as mytime From mytable;
mytime will be in the form dd-mm-, the %d specifier will give you the
prefferred output
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
Currently they are using a VFP client app, the actual program is not installed.
I just discovered that the suggestion you offered (about a key table) is
being used by this client.
Would the sys() function work through ODBC w/o the full VFP install?
How do I lock the database through PHP and
At 06:25 PM 2/3/2003 -0500, Brian Evans wrote:
Currently they are using a VFP client app, the actual program is not
installed.
I just discovered that the suggestion you offered (about a key table) is
being used by this client.
Would the sys() function work through ODBC w/o the full VFP
OK, I know what I have to do. I thank you for all of your help and I will
use your idea of a select, then update and then capture all errors to try
again.
Hopefully, this will minimize problems in the future.
Thanks,
Brian
PJC Services
At 06:45 PM 2/3/2003, you wrote:
At 06:25 PM 2/3/2003
I want to pass some variables named a1, a2...aX in a form. So I wrote a
couple of lines to do the trick:
for($i=1;$i=$X;$i++)
{
echo input type=\hidden\ name=\q$i\ value=\$q$i\\n;
}
But there is just one problem. How do I pass the correct value?
This is what I want the loop to do:
echo
heredoc is the fastest way to get lazy. use inline php then, easier and
can use tabs, no? Tabs of 4 spaces are, normally, the most prefered.
--
Maxim Maletsky
[EMAIL PROTECTED]
On Mon, 3 Feb 2003 11:47:12 -0600 Rob Day [EMAIL PROTECTED] wrote:
I try to write very clean code. However, there
I'm trying to use dgssearch, from digitalgenesis.com, and am unable to find
any help. I'm hoping to find someone with some experience working with this
script. I'm using it on Win2k with an MSSQL 7 server (please don't chastise
me, I'm setting up a linux server at home so I can get away from
Marcel [EMAIL PROTECTED] wrote:
Can you clarify? Possibly show how the result should look in the page after
parsing. I'm sure I can help but your question is a bit unclear.
I want to pass some variables named a1, a2...aX in a form. So I wrote a
couple of lines to do the trick:
Rob,
I've come across the same dilema. To keep things clean while using the
convenience of heredoc you can write the heredoc in a seperate file and
include_once() the file.
Larry
Rob Day [EMAIL PROTECTED] wrote:
I try to write very clean code. However, there is one thing that always bugs
me
Sorry, I see that I've got the a's and q's mixed up.
I'll try to clarify it some more by giving an example with 2 variables.
$q1 = first_var;
$q2 = second_var;
for($i=1;$i=2;$i++)
{
echo input type=\hidden\ name=\q$i\ value=\$q$i\\n;
}
The output should now be:
input type=hidden name=q1
Unknown Sender [EMAIL PROTECTED] wrote:
As mentioned in another reply, in MySQL all fields can have quotes regardelss of
type. If you really need to tell, use this:
if(!is_numeric($value)) {
$value = ' . $value . ';
}
I guess this is mostly a MySQL question, but perhaps PHP has a
Hello folks, I need help with the following. I'm recording machine
production and 'health' status information into a Oracle 9.2 DB. That's
working great, rock solid, great admin tools, etc.
I've been trying to use the Rockwell Software tools to get the data out onto
the web in a pretty
OK, now I get it:
$input = 'input type=hidden name=q' . $i . ' value=' .
${$q . $i} . ' . \n;
print($input);
This one isn't well known so don't forget it!! ;)
Larry
Marcel [EMAIL PROTECTED] wrote:
Sorry, I see that I've got the a's and q's mixed up.
I'll try to clarify it some
Hello I'm a beginner, I'm reading the PHP's manual but I can't test the
examples because always receipt the following error message:
Call to undefined funciont:name of any function that I want to use
I can't understand why! Please help... :-(
Thank you very much,
Tom.
--
PHP Database
I have a question about MySQL, i use MySQL 3.23.55 together with PHP
4.3.0 on my windows XP system. Does the version of MySQL supports
InnoDB
tables? And how do i do it i have noticed that in PhpMyAdmin i
cannot choose this table format..., but i gues that has more to do
with
the
On Tuesday 04 February 2003 11:29, Tomás Liendo wrote:
Hello I'm a beginner, I'm reading the PHP's manual but I can't test the
examples because always receipt the following error message:
Call to undefined funciont:name of any function that I want to use
I can't understand why! Please
37 matches
Mail list logo