I am running PHP with Abyss Webserver on Windows XP Home, and MySQL works
OK. If I am not using the mysql console, I use PHPMyAdmin as a friendlier
front end for MySQL.
Rob
"Larry R. Sieting" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> At 07:44 PM 7/31/2003 +0100, John Ryan wrot
It might be a good idea to set a cron job to send say, 100 at a time over
the space of a few hours, to avoild killing the mail server or the server
blocking connections from you.
Also - use the BCC field to send the mail, this means only one connection
will need to be made to the mail server per b
Hi everyone,
How do you include linebreaks, paragraphs etc into text output from a mysql database
with php through a loop for all the records in a text field? This is not row
formatting but column info formatting e.g. story_abc TEXT;
Format text in story_abc field see e.g.
www.neilmar.com/falm
if there are line feeds in the text, you can use the function nl2br($text);
www.php.net/nl2br
if you require more, you may have to add logic. around headers/titles
etc...
hth
jeff
Hi,
I have a page layout problem and on the site I am
using PHP and mysql. It's easier to show the problem
I am having, than if anyone can help they can view the
source of the page and see exactly what is wrong.
It;s a HTML output problem somewhere but I am using
PHP and fetching data constantle
Hi All,
Sorry for OT post but need some info.
Does anyone know a good tutorial that explains regular expressions in
DUMMY terms?
I have a list of characters that I need to check to see if they are in a
string. I tried creating an array of the characters but some of them are
like ' " and ` wh
Aaron,
It's not a tutorial, but if you look at the stripos() function on PHP.NET
there are some good examples of expressions that check for multiple
characters (needles) in a given string (haystack) both in the description of
the function and the user contributed notes at the bottom. Those might b
Hi!
I just need to know how to enter the data submitted by an html form into a
MySQL DB.
I have already created the form, and the variables in that form - just need
to know the query use to insert that data.
Thanks
- Crash
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe,
Plz Ignore.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Try one of these:
http://zez.org/article/articleprint/11
http://www.javaworld.com/javaworld/jw-07-2001/jw-0713-regex_p.html
Doug
On Fri, 1 Aug 2003 11:34:16 -0400, Aaron Wolski wrote:
>Hi All,
>
>Sorry for OT post but need some info.
>
>Does anyone know a good tutorial that explains regular
I want all the records from two joined tables but where the JOIN applies
(say I join on the ID field and not all LEFT table IDs are in the RIGHT
table) I only want the records which comply with a test. I tried:
SELECT tbl1.fld1, tbl2.fld1 FROM tbl1 LEFT JOIN tbl2 ON tbl1.ID=tbl2.ID
WHERE tbl2.tes
I just need to know how to enter the data submitted by an html form
into a
MySQL DB.
I have already created the form, and the variables in that form - just
need
to know the query use to insert that data.
The query will be something like
INSERT INTO tablename (column1, column2, column3, ...) VALU
I assume that would be placed before the:
...
Also, is the form action still
From: Larry E. Ullman <[EMAIL PROTECTED]>
To: "Crash" <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MySQL
Date: Fri, 1 Aug 2003 12:16:17 -0400
I just need to know how to enter the data submitted by
Hi!
I tried doing this through the news server, but something messed up.
I just need to know how to make an HTML form write to a MySQL DB.
This is what I have so far.
DB
Home | Display All
| Search
Total Entries:
http://dataguy/logo_small.jpg>
Title for page
View your source. You're missing a before the colon on that
line that exists on all the other lines. What does this have to do
with PHP?
--- JeRRy <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have a page layout problem and on the site I am
> using PHP and mysql. It's easier to show the problem
> I a
On Saturday 02 August 2003 01:46, Jeff wrote:
> I tried doing this through the news server, but something messed up.
>
> I just need to know how to make an HTML form write to a MySQL DB.
> This is what I have so far.
[snip]
And does it work? If it works then congratulations. If it doesn't work,
No it dosn't work.
I don't know *how* it dosn't work. That's why I'm asking for a hand.
When I run the page it returns a " Parse error: parse error, unexpected
T_STRING in C:\FoxServ\www\encana_db.php on line 48 "
Which is:
INSERT INTO gradients (kwo, lsd, date, well, field, uni, license,
for
Sorry, I just realized that's an older copy of the code, here is the updated stuff -
(It's just one more line, the line that's giving me greaf. :P )
DB
Home | Display All
| Search
Total Entries:
http://dataguy/logo_small.jpg>
Title for page
First of all, get rid of all those extraneous open and close (
?> wrote:
> Sorry, I just realized that's an older copy of the code, here is
> the updated stuff - (It's just one more line, the line that's
> giving me greaf. :P )
>
> $link_id = mysql_connect("localhost","admin","***")
>
Yes I'm new at this - sorry for sounding like an idiot. I'm a network guy,
not a coder by any means - just learning. (Company "project")
> First of all, get rid of all those extraneous open and close (
> ?>(or is this code cobbled from
>other places?).
No, that's plagerisum. :P Doing this all
Try this:
$strSQL = "INSERT INTO gradients (kwo, lsd, date, well, field, uni, license,
formation) VALUES
('$kwo', '$lsd', '$date', '$well', '$field', '$uni', '$license', '$formation')";
$result = mysql_query($strSQL, $dbHandle) OR DIE("Error retrieving records.");
Quoting Jeff <[EMAIL PROTE
K, that got my a bit further, now it shows half the page but stops at the
line:
$result = mysql_query($strSQL, $dbHandle) OR DIE("Error retrieving
records.");
With error:
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource
in C:\FoxServ\www\encana_db.php on line 40
Error
Myfault.. you should be using link_id instead of dbHandletry this:
$result = mysql_query($strSQL, $link_id) OR DIE("Error retrieving records.");
Quoting Jeff <[EMAIL PROTECTED]>:
> K, that got my a bit further, now it shows half the page but stops at the
> line:
>
> $result = mysql_query($
Oh, and another thing, in this book I have, they say to give the forum
action .
Yet it dosn't give a value to $PHP_SELF.
IS this correct?
"Jeff" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> K, that got my a bit further, now it shows half the page but stops at the
> line:
>
> $r
Well, it worked for ONE submission I was so excited. :)
Then I went back to enter another test, and when I went back to the page, it
displayed everything up to that line again, but JUST output, " Error
retrieving records. "
??? Why woudl it work just once?
"Mel Hodges" <[EMAIL PROTECTED]>
How do I go about getting dynamically created pages to be listed in search
engines?
Harlan
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
GAH! I don't userstand why this woudl work onyl once, then return a
Error retrieving records.I've even recreated the sql DB, same result.
"Jeff" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Well, it worked for ONE submission I was so excited. :)
>
> Then I went back to enter
Hi All,
I'm trying to get some code to display like:
Manufacturer 1
Type 1
Type 2
Type 3
Manufacturer 2
Type 1
Type 2
Type 3
Manufacter 3
Type 1
Type 2
Type 3
My code is:
{$manufResult
['manufacturer']}";
On Saturday 02 August 2003 04:42, Harlan Lax wrote:
> How do I go about getting dynamically created pages to be listed in search
> engines?
If using Apache, you can use mod rewrite to make them look static. Search
archives or google for more info.
Another method is to make your links look like:
Hello,
As a recent flurry of activity has commenced within Command Prompt we
have released
upon this rather unround earth, plPHP. Yes it is trigger safe, yes you
can write UDF's in
PostgreSQL with PHP now.
Find it here:
http://www.commandprompt.com/entry.lxp?lxpe=260
Have a glorius weekend.
> Any idea's on where to throw a echo "";
>
put the echo ""; inside the first if statement. thus each new
manufacturer type is preceded by a blank line.
>...
>while ($manufResult = db_fetch($manufQuery)) {
>
>if ($thread_manufacturer != $manufResult['manufacturer'])
>{
>
I'm trying to do a full text search to a MySQL database and have a problem
being able to read the results:
here is my code:
---
$query = "SELECT name,title,branch,section_one,section_two,MATCH
(section_header,section_one,section_two,section_footer) AGAINST
('".$searchCriter
On Saturday 02 August 2003 11:48, Lee Templeton wrote:
> The first row retrieved from the results list works and returns the row
> with Resource id #3 prefixed to the prinouts. After the first row all
> futher retrievals fail.
The variable $results is stressed by being forced to do two different
33 matches
Mail list logo