select distinct(myCol) from table
Ron Allen wrote:
How do I select * from a table, but I do not want it to return the same
value if two fields are the same. Example
test
test
test
test
new
new
new
Results that I want are just
test
new
Any suggestions?
--
PHP Database Mailing List
Hi, I need a way of searching a file for text between two brackets, below
is an example of a couple of lines from the file I'm searching:
trtdfont size=2{L_LOGIN}/font/td/tr
trtdfont size=2{L_LOGOUT}/font/td/tr
So I'll need to search the above for text between the '{' and '}' brackets
and read
-Original Message-
From: Jamie Saunders [mailto:[EMAIL PROTECTED]
Sent: 16 July 2003 11:20
Hi, I need a way of searching a file for text between two
brackets, below
is an example of a couple of lines from the file I'm searching:
trtdfont size=2{L_LOGIN}/font/td/tr
trtdfont
Hello:
We have developed a project that runs over several database engines with
de ADODB php library. At this moment it's runing over MySQL, MSSQL
Server and Informix through the Linux Informix Client SDK ODBC driver.
We need to store non-printable characters into varchar fields (ASCII
code
I have a small problem. I need to have a form post to two different locations. If a
variable is a certain value, it goes to location_one.cgi and if it is another value,
it goes to location_two.cgi. This may turn out be a html problem but I figured php
was the way to go since it is more
you need a bit of JAvascript
Rick Dahl wrote:
I have a small problem. I need to have a form post to two different locations. If a variable is a certain value, it goes to location_one.cgi and if it is another value, it goes to location_two.cgi. This may turn out be a html problem but I figured
Have a PHP script that intervenes, ie.
// HTML File
form action=decide.php method=post
input type=radio name=variable value=0br
input type=radio name=variable value=1
/form
// decide.php
?php
if($_POST[variable] == 0) {
header(Location: location_one.cgi?variable=0);
} elseif($_POST[variable]
How can I find all the records for a single year from a db that has a datetime
column (in MySQL)?
This seems to work:
SELECT * from mytable
WHERE tstamp '2003-01-01 00:00:00'
AND tstamp '2002-01-01 00:00:00'
But this doesn't:
SELECT * from mytable
WHERE tstamp LIKE '2002%'
Is there a simpler
select * from mytable where year(tstamp) = 2003
Bill wrote:
How can I find all the records for a single year from a db that has a datetime
column (in MySQL)?
This seems to work:
SELECT * from mytable
WHERE tstamp '2003-01-01 00:00:00'
AND tstamp '2002-01-01 00:00:00'
But this doesn't:
SELECT *
Anybody have code that WORKS (hehe) for executing a MS-SQL stored
proceedure through PHP?
exec viewFacilities()
Thanks in advance!
~Steve
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
my experience in the past is just:
$SQL = sp_runthis $param1, $param2, $param3;
$RES = mysql_query($SQL);
may have to prefix with exec like you mentioned...
change sp_runthis to your procedure name... probably still works the
same..
On Wed, 16 Jul 2003, Stephen March wrote:
Anybody have
Thanks for the immediate response... it turns out my co-worker actually
had a bug in his stored proc ...
(nobody ever admits the problem is their own eh?)
hehe
~Steve
[EMAIL PROTECTED] wrote:
my experience in the past is just:
$SQL = sp_runthis $param1, $param2, $param3;
$RES =
I'm trying to use PHP 4.2.3 in a database application.
?php
print Connected?;
$dbcnx = mysql_connect(localhost,root,asda);
if (!$dbcnx) {
echo(pUnable to connect to database server./p);
exit();
}else {
print Connected!;
}
?
Gives
Connected?
Fatal error: Call to undefined function:
Hi,
Yep the subject may sound confusing so let me explain.
I have this message board that uses PHP and mysql.
Now I had to transfer the whole lot to my server, but
due to the change and a domain registration the actual
path to images in messages has changed. So in the
post on the old host it
Hi,
Yep the subject may sound confusing so let me explain.
I have this message board that uses PHP and mysql.
Now I had to transfer the whole lot to my server, but
due to the change and a domain registration the actual
path to images in messages has changed. So in the
post on the old host it
Hi,
Yep the subject may sound confusing so let me explain.
I have this message board that uses PHP and mysql.
Now I had to transfer the whole lot to my server, but
due to the change and a domain registration the actual
path to images in messages has changed. So in the
post on the old host it
Hi,
Yep the subject may sound confusing so let me explain.
I have this message board that uses PHP and mysql.
Now I had to transfer the whole lot to my server, but
due to the change and a domain registration the actual
path to images in messages has changed. So in the
post on the old host it
undefined function means you don't have mysql support compiled in...
prefixing any function with @ suppresses any error messages...
On Thu, 17 Jul 2003, Martin wrote:
I'm trying to use PHP 4.2.3 in a database application.
?php
print Connected?;
$dbcnx = mysql_connect(localhost,root,asda);
Don't know if this got answered yet. I usually do this by checking the
variable before submitting the form and then adjusting the form action. It
turns out to be a JavaScript problem.
if(variable==a){
document.form.action=location_one.cgi;
}else if(var==b){
On Thursday 17 July 2003 12:28, JeRRy wrote:
So something like this:
Hi bob img src=domain.com/emotions/board/laugh.gif
all is well, cya!
So old posts have the wrong image location but new
posts show the correct place to the image as it's
configured to do it but old posts since they are
20 matches
Mail list logo
