Meethoo
as it says in the PHP documentation, you can access a MySQL server whether
it's on the same machine as the PHP install or not.
ie. mysql_connect('localhost', $user, $pass)
OR mysql_connect('111.111.111.111', $user, $pass)
Beau
// -Original Message-
// From: Meethoo Salim [mailto
hello there ,
i have my Mysql server installed on a different machine- how ca li access
it?
can someone help me out please
regards
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Just looking at our php.ini file and we use an external machine to send
mail with when calling the mail() function.
I think you just need to change the directive for the path/URI to the
mail server you wish PHP to use, in your php.ini file.
HTH :-)
Russ
-Original Message-
From: Bartek P
Of course, but
PHP is on Linux machine where I don't have sendmail, because my
mail server is on different machine, and that's my problem
Bartek
- Original Message -
From: "Russ" <[EMAIL PROTECTED]>
To: "Bartek Pawlik" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, August 01
Could you not simply extract all the email addresses from the DB as you
would any other data, then loop thru the result set calling PHP's mail()
function for every record retrieved?
while($row=mysql_fetch_assoc($result))
{
extract($row);
//Presume's '$email ' is the name of the field in which ema
Sorry to be a little bit off topic.
I need a tool or script in PHP, that will automaticaly send e-mails to receipients
taken from database.
For example 1 the same e-mail to 1000 receipients. B
Mail server is on different machine.
Thanks in advance
did you mean you need help with an sql query for this?
sounds like
select id, group, name from MYTABLE order by group;
since i cant read your mind and you didnt specify anything else and since
this is a php-db mailing list, hope that's what you are asking for... of
course i could me a mile off
Hello,
On 07/25/2002 04:35 PM, Andrew Hill wrote:
> Manual,
>
> Certainly - please help us pinpoint any issues.
>
> Dan Kalowsky has done some great work in resolving lingering ODBC issues
> in PHP, and I help in my way with testing and iODBC support.
>
> I respect the work you have done
Me personally, so I can echo out the variable to see if the query is
making sense. Look at it as a debugging...
Brian Graham wrote:
>Are there any benefits to assigning a query to a variable?
>
>
>
>
>
--
Gerard Samuel
http://www.trini0.org:81/
http://dev.trini0.org:81/
--
PHP Databas
Hi..
I need to get 2 groups of random result with 1 group always on top of the
other.
Can anyone help me with this please..
Something like
id|group|name
21john
51smith
32 1sara
12 1michael
Ron Wallace wrote:
> thanks, helpers, but I think I have a simple solution:
> I will insert a space at the front of the string,
> where the db must accept and retain it.
>
> BTW, here is the SQL I am working with:
> //
> elseif ($desc==desc) {
> $sql="
thanks, helpers, but I think I have a simple solution:
I will insert a space at the front of the string,
where the db must accept and retain it.
BTW, here is the SQL I am working with:
//
elseif ($desc==desc) {
$sql="SELECT bandid, bandname, bandesc, bin
I think the other replies to this are missing the point.
You want to search a text field for the word Wash, and want to put the space in so you
can search with the space, eliminating words which begin with wash. But then, if you
think about it, that means you'd have to search for commas, and fu
Yes, I see a few benefits.
1. It makes the code easier to read.
2. It makes the code easier to debug.
Imagine the following:
$sql = "SELECT * FROM tblName";
$result = mysql_query($sql);
Now if you want to print the sql and not do the select, you would simply add a line
$sql = "SELECT * FROM t
sure there are, you can call the query in multiple places, for example:
$sql = mysql_query("INSERT INTO $table_name WHERE db_field =
$search_string");
Then say you have a routine to check for missing for elements and you would
like to log failed vs. successfull attempts your code flow would be
s
Ron
I do believe that placing a space in '%$var %' will do the same as a
varchar and sprip it off the end. Not positive. However I believe
something like this will do the trick:
SELECT something
FROM a_file
WHERE replace(CONCAT_WS('','.',a_file.field,'.'),' ','.') LIKE '%.$var.%'
HTH... Dan
Ron
Richard,
You are correct. For Ron to achieve his goal, the SQL needs to be changed
to:
WHERE name = '$var'
If you use the LIKE operator and have a trailing %, that is telling mySQL to
match the first characters exactly and then match ANY trailing characters.
If you use the equals opera
I haven't set up any text-based searches before, but when you say:
If the user types 'Wash' I don't want any matches for
'Washington', 'Washing', etc.
Aren't you, in essence, saying that you want to search for "Wash"? Meaning
that your query could just say WHERE name = '$var' (where $var is set
How can I add a space to the end of a varchar string
in mysql? I can't seem to do it directly, and I tried
str_pad and other things, but no luck so far. The db
doesnt hold the value of the space...its getting
trimmed somewhere(?)
The reason I want to do this is so I can search for
exact matches
Are there any benefits to assigning a query to a variable?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Look at the date functions at:
http://www.mysql.com/doc/D/a/Date_and_time_functions.html
and search for the date_format table
Within it you will see the following:
%U Week (00..53), where Sunday is the first day of the week
%u Week (00..53), where Monday is the first day of the week
%V
On Wed, 31 Jul 2002 21:19:00 +0800
Jason Wong <[EMAIL PROTECTED]> wrote:
> On Wednesday 31 July 2002 20:56, Dib, Walid (MED, Stagiaire GEMS) wrote:
> > How can i print the fiscal week number on a web page??
>
> 1) Work out an algorithm to calculate the fiscal week
> 2) Implement algorithm in php
On Wednesday 31 July 2002 20:56, Dib, Walid (MED, Stagiaire GEMS) wrote:
> How can i print the fiscal week number on a web page??
1) Work out an algorithm to calculate the fiscal week
2) Implement algorithm in php
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software
How can i print the fiscal week number on a web page??
Thanks a lot!
Walid
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[snip]
First of all, sorry for the additional cross post. MeetUp.com lacks the
ability to let you contact other folks who have signed up. In my general
area, Massachusetts, there are a bunch of tiny groups scattered about,
and I'd like a chance to get all of them to converge in one place to make
t
Hello Rasmus,
Sorry to bother you, but lerdorf.com is currently down.
Regards, John
PS: I have been reading your new Programming PHP book. I love it!
"Rasmus Lerdorf" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I would suggest looking into MySQL's replic
hi ...
you need to install
flex
http://www.sunfreeware.com/programlistsparc9.html
regards
ChrisPr
> -Original Message-
> From: Jan Feller [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, July 31, 2002 08:36
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Error: ./configure --with-pgsq
I just installed flex package and now it´working...
Thx anyway
--
GMX - Die Kommunikationsplattform im Internet.
http://www.gmx.net
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
28 matches
Mail list logo
