I'm having a problem when I use mysql_fetch_array and extract() following a
left select query. As an example...
$query = SELECT id,LEFT(fluff,80) FROM sometable;
$result = mysql_query($query) or die('message');
while ($row = mysql_fetch_array($result){
extract($row);
echo P . $id . : . $fluff .
I am making a section on a web site which requires that visitors log-in.
Log-in, password, etc are in an MySQL table. I am using (via a web host) PHP
4.2.2 with global variables turned off. Until now, I have worked with a
different host in which global variables were switched on.
The way it works
[sorry for the incomplete posting of a couple moments ago. I hit ctl
something or other and outlook fired off the e-mail against my wishes!]
I am making a section on a web site which requires that visitors log-in.
Log-in, password, etc are in an MySQL table. I am using (via a web host) PHP
4.2.2
1-Since he's posting to a PHP-DB list, I think we can assume he plans
to implement it in PHP using a database to capture and store the
comments/ideas.
Correct, thank you.
Jeff - Do you have a plan in place for your DB schema or the backend
processing that might take place?
No,
I'm thinking about making a little tool where people can contribute ideas in
real time. Thus far, the best way I can see to do this is via 2 frames
Frame 1: for entering data - which is inserted into a table.
Frame 2: would select from the table. It would also refresh frequently -
say every 30
I'm working on a similar project - I'm also a newbie - here's my approach -
which is fairly simple really.
Create a database of all members that includes columns for login, name
and paymentStatus as well as any other info you need for your database.
paymentStatus would be an integer with values
I've learned the basics of PHP and MySQL by using a web hosting service over
the past few weeks. Call this site 1. And I am finally feeling that I am
getting the hang of things.
Now, another web host that I have been using is letting me try out PHP and
MySQL on their server. Call this site 2.
A couple of questions of efficiency, please:
1. If I am creating a web page with numerous PHP calls to an MySQL database
is it more efficient to have lots of small blocks of php in an html page or
is it better to have just one or two big blocks of PHP with the html code
being delivered via echo
Is there any way to receive mail via PHP?
What I am interested in doing is creating a double opt-in e-mail list
whereby someone can subscribe to an e-mail service via an on-line form. Upon
doing so, they would get a confirmation e-mail. Replying to this e-mail
would confirm the subscription and
Sorry to bother you experts with a simple question (well, two actually).
I'm new to PHP and mysql. I'm using a hosted service (so I don't have access
to configuration files, server, etc). Recently, the server crashed. Since
resurrecting, all files attempting to connect to MySQL using
$dbcnx =
10 matches
Mail list logo