Hello,
I have a little problem with a sql command string
$q = UPDATE episodes SET episode_title = '$_POST[episode_title]' ,
episode_scheduleddate = .strtotime($_POST['episode_scheduleddate']).
, episode_description = '$_POST[episode_description]' WHERE episode_id
= $_POST[episode_id];
I keep
try ..
$q = addslashes(UPDATE episodes SET episode_title = '$_POST[episode_title]'
,
episode_scheduleddate = .strtotime($_POST['episode_scheduleddate']).
, episode_description = '$_POST[episode_description]' WHERE episode_id
= $_POST[episode_id]);
or try
$q = UPDATE episodes SET episode_title =
Manu Gupta wrote:
try ..
$q = addslashes(UPDATE episodes SET episode_title = '$_POST[episode_title]'
,
episode_scheduleddate = .strtotime($_POST['episode_scheduleddate']).
, episode_description = '$_POST[episode_description]' WHERE episode_id
= $_POST[episode_id]);
or try
$q = UPDATE episodes
I need a simple php mysql image upload script with display script too and to
make this easier the mysql database table to use
On Thu, May 28, 2009 at 4:19 PM, Wilson Osemeilu engrwi...@yahoo.comwrote:
I need a simple php mysql image upload script with display script too and
to make this easier the mysql database table to use
STFW
--
Bastien
Cat, the other other white meat
Chris wrote:
My point here was the if you index on (a, b), you don't need to index on
(b, a) if both a and b are present in your where clause. The index is
read from left to right -- not the where clause.
Sure you do. Look at the OP's problem and you'll see you still do.
To quote:
As
robertom wrote:
Chris wrote:
Roberto Mansfield wrote:
It shouldn't matter what order the columns are referenced. Mysql is
smart enough to optimize the query based on the available indexes.
In some cases yes but as with anything there are exceptions :)
mysql (and every other db) gets it wrong
Roberto Mansfield wrote:
It shouldn't matter what order the columns are referenced. Mysql is
smart enough to optimize the query based on the available indexes.
In some cases yes but as with anything there are exceptions :)
mysql (and every other db) gets it wrong sometimes.
In fact, it
Chris wrote:
Mysql will actually only use one index per table. I was surprised to
find this out but it's mentioned in
http://www.amazon.com/High-Performance-MySQL-Jeremy-Zawodny/dp/0596003064/
- page 64 (just looked it up to include a page ref).
No idea if this is mentioned anywhere on the
Chris wrote:
Roberto Mansfield wrote:
It shouldn't matter what order the columns are referenced. Mysql is
smart enough to optimize the query based on the available indexes.
In some cases yes but as with anything there are exceptions :)
mysql (and every other db) gets it wrong sometimes.
It shouldn't matter what order the columns are referenced. Mysql is
smart enough to optimize the query based on the available indexes. In
fact, it should be good enough just to create an index on each column
that will be searched -- not on combinations of columns. Do you have any
performance
I guess EXPLAIN will do the job for you. First of all in order to ensure
what is the index used by your queries and then how to improve
performance by making the right indexes.
Theodoros Goltsios
Kinetix Tele.com Support Center
email: [EMAIL PROTECTED], [EMAIL PROTECTED]
Tel. Fax: +30
Hello
I did look into the info from EXPLAIN. I can create the indexes also but
then I have to create indexes with all permutation of column order if I want
to get good performance from all search query regardless of what order user
enters the column.
On 10/23/07, Theodoros Goltsios [EMAIL
Na Derro Cartwright wrote:
I am trying to simply display all the values from a simple query but I
am recieveing an error that I have to upgrade my client. I am not sure
what that means.
Put the full message in to your preferred search engine - I know the
message you mean and I'm sure one of
Chris wrote:
Na Derro Cartwright wrote:
I am currently running php4 with mysql 5. when I try to run a query
using the mysql command I recieve and error that reads the resource
id and a number. What does that mean?
Firstly always cc the list - others will be able to provide their
input and
I am trying to simply display all the values from a simple query but I
am recieveing an error that I have to upgrade my client. I am not sure
what that means.
Chris wrote:
Na Derro Cartwright wrote:
I am currently running php4 with mysql 5. when I try to run a query
using the mysql command
Chris wrote:
Na Derro Cartwright wrote:
I am currently running php4 with mysql 5. when I try to run a query
using the mysql command I recieve and error that reads the resource
id and a number. What does that mean?
Firstly always cc the list - others will be able to provide their
input and
Can PHP 4 work with MYSQL 5?
Na Derro Cartwright wrote:
Can PHP 4 work with MYSQL 5?
Yep.
--
Postgresql php tutorials
http://www.designmagick.com/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Diane wrote:
I just switched a customer from one Windows host to another. The new
host is a Windows only shop, and not overly familiar with MySQL and PHP.
My customer has two PHP applications, both important to the site.
Everything else is ASP or ASP.NET.
When the new host installed PHP and
I just switched a customer from one Windows host to another. The new
host is a Windows only shop, and not overly familiar with MySQL and PHP.
My customer has two PHP applications, both important to the site.
Everything else is ASP or ASP.NET.
When the new host installed PHP and MySQL, the
Have you made any progess with this yet? Could it simply be a delay due to
replication log size before the replication is triggered...its much more a
mysql issue than a php one...
Bastien
From: David Brinks [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Php with MySQL
I seem to be having a problem when using php with a replicated database and
the replicated database not being updated correctly. I have verified that
replication in general works. When transactions are entered through either
a perl script or through console, the replicated client receives the
Can someone help me out with an issue I'm having?
Here is my code:
$res = mysql_query(SELECT ZG_LATITUDE, ZG_LONGITUDE FROM zip_code
wherezg_zipcode = '$zip');
List($Lat,$Lon) = mysql_fetch_row($res);
$Lat1 = ($Lat-2);
$Lat2= ($Lat+2);
$Lon1= ($Lon-2);
$Lon2= ($Lon+2);
//echo ($Lat1);
Hey,
That is a lot of code, so I only skimmed it, but right off the bat i
noticed that you are missing a space in between WHERE and zg_zipcode,
as shown below:
$res = mysql_query(SELECT ZG_LATITUDE, ZG_LONGITUDE FROM zip_code
wherezg_zipcode = '$zip');
should be:
$res = mysql_query(SELECT
ReClMaples wrote:
$zipcode = mysql_query(
SELECT * FROM zip_code where ZG_LATITUDE = $Lat1
and ZG_LATITUDE = $Lat2 and ZG_LONGITUDE = $Lon1 and ZG_LONGITUDE =
$Lon2);
Try putting single quotes around the variables in your query string;
mysql sees them as strings, not variables:
... ZG_LATITUDE =
($res);
$Lat1=Lat-2; $Lat2=Lat+2; $Lon1=Lon-2; $Lon2=Lat+2;
Now you can use the values in your final query.
Hth Henrik Hornemann
-Oprindelig meddelelse-
Fra: ReClMaples [mailto:[EMAIL PROTECTED]
Sendt: 16. april 2005 22:38
Til: php-db@lists.php.net
Emne: [PHP-DB] PHP and MySql question
is below those
lines, can anyone see what I have that is incorrect here?
-Original Message-
From: Henrik Hornemann [mailto:[EMAIL PROTECTED]
Sent: Monday, April 18, 2005 2:44 AM
To: php-db@lists.php.net
Subject: SV: [PHP-DB] PHP and MySql question
Hi,
Your problem is that your variables
Hello, I'm kinda new at PHP programming with MySQL. I am having an issue
and am not sure if this is the corret way to do this: Here is my code, I'll
start there:
?php
$Lat1 = mysql_query(
SELECT (ZG_LATITUDE-2) FROM zip_code where zg_zipcode =
'$zip');
if (!$Lat1) {
plese don't ask qustion i am now start to do php and my sql don't sent
any mail please
On Thu, 10 Mar 2005 20:37:02 +1100, Guy Harrison
[EMAIL PROTECTED] wrote:
Hi all,
I'm new to PHP, but have been doing a lot of work with the MySQL 5.0 alphas
looking at the stored procedure
Hi all,
I'm new to PHP, but have been doing a lot of work with the MySQL 5.0 alphas
looking at the stored procedure implementation. I wanted to work with
stored procedures in the PHP mysqli interface, but it doesn't seem to be
ready for them yet.
The things I want to do with stored procedures
Robby Russell [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
On Mon, 2004-08-09 at 20:45, Sukanto Kho wrote:
Hi all,
My php files run well in my local PC
but some of PHP and mysql script just getting error when running in
webhosting server.
I found out that the problem is
Hi all,
My php files run well in my local PC
but some of PHP and mysql script just getting error when running in webhosting server.
I found out that the problem is in the way webhosting server handling global variable.
for example :
In my local PC : $_GET['var'] is different with $var
On Mon, 2004-08-09 at 20:45, Sukanto Kho wrote:
Hi all,
My php files run well in my local PC
but some of PHP and mysql script just getting error when running in webhosting
server.
I found out that the problem is in the way webhosting server handling global
variable.
for example :
This is my setup: Not really worried about security.
W2kPro w\sp4
Mysql 5.O
Mysqlcc0.9.4
Php 5.0.0.b3 [As CGI]
Apache2.0.48
I can now connect to my server from anywhere using Mysqlcc or another server... home,
work, etc.
I can run Php scripts.
I can connect to the Apache Server.
Login to
Is it possible to use PHP under one Apache WEB application in order to
access
MySQL and at the same time PostgreSQL?
different databases ?
Yours Sincerely
Morten Gulbrandsen
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
PROTECTED]cc:
e Subject: [PHP-DB] php and MySQL and
PostgresSQL at the same time
El Jue 02 Oct 2003 08:22, Morten Gulbrandsen escribió:
Is it possible to use PHP under one Apache WEB application in order to
access
MySQL and at the same time PostgreSQL?
different databases ?
Depends on how the question was made.
Yes you can access diferent database engines from the
Greetings,
Prior to PHP 4.2.3, when inserting values from an array into mysql I could
do the following:
(assuming that $a is an array())
$qid = mysql_query( INSERT INTO table (info) VALUES ('$a[2]') );
However this logic now fails with the following error:
Parse error: parse error,
Hello,
I have a question, not sure if what I am looking for
is available at all or a smaller program of the full
sized program I am looking for but thought I'd ask to
see if anyone knows of a program or a program they may
of created.
On my personal Computer I run a Windows OS and on my
server
I already have installed a PHP program that I can
run/test PHP scripts and thought I'd ask here if
anyone knew of a mysql one. (I thought since a PHP
program is available on Windows OS maybe a mysql one
was too?)
There is...
http://www.mysql.com/ for more info
.: Allowee
--
PHP
Does PHP have support for MySQL 4? If I install MySQL 4, and rebuild PHP
with --with-mysql, is that sufficient to get MySQL 4 support?
Ben
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On Monday 31 March 2003 04:46, Benjamin Higgins wrote:
Does PHP have support for MySQL 4? If I install MySQL 4, and rebuild PHP
with --with-mysql, is that sufficient to get MySQL 4 support?
Yes.
--
Jason Wong - Gremlins Associates - www.gremlins.biz
Open Source Software Systems Integrators
*
Sure does - sure is.
-Original Message-
From: Benjamin Higgins [mailto:[EMAIL PROTECTED]
Sent: Monday, 31 March 2003 6:47 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] PHP and MySQL 4
Does PHP have support for MySQL 4? If I install MySQL 4, and rebuild PHP
with --with-mysql
Hi,
I have a PHP page that writes to a mysql database.
Now I have got that bit to work well. Now I want to
send out an email once a person submits the details.
So on the database I grab fields like name, gender,
email etc... Now I want to grab the email and send
out an email something like
On Monday 10 March 2003 10:44, JeRRy wrote:
Now name is fetched from the name they give on the
form. So how would I send an email out automatically
once they submit it?
mail()
Also, but not really required yet but ideas
appreciated, if the email BOUNCES is their a way to
remove the entry
Post your code.
-Original Message-
From: Chris Deam [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 30, 2003 2:27 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] PHP-WIN MYSQL Double results
Please help:
I am getting double results when loading an html/php page. I am
Hi, I had already install mysql and php, the apache was in my linux
distribution (Mandrake) and also one php, but i have install the last
version in rpm.
I have stop and start the apache, and the php works without any problem.
But when i call to a mysql function in the php code its give to me
Nguyen [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 10, 2003 1:33 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] PHP and mySQL help!
Thanks for the quick reply! Perhaps I should describe my problem more
specifically so that u could have a better idea:
The code
Hi! I have a PHP page with a few text areas where users can enter
different combination of fields to query a mySQL database. An example
of a query would be like this:
$query = SELECT build_ids.build_id, build_ids.username, build_ids.host,
build_ids.configuration,
/
-Original Message-
From: Dzung Nguyen [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 10, 2003 12:45 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] PHP and mySQL help!
Hi! I have a PHP page with a few text areas where users can enter
different combination of fields to query a mySQL
Thanks for the quick reply! Perhaps I should describe my problem more
specifically so that u could have a better idea:
The code on PHP page to create forms for users to input field names:
$tempdate = $date ;
$tempselect = $select ;
echo font size=$fontsize-1Choose datebr/font
form
: Re: [PHP-DB] PHP and mySQL help!
Thanks for the quick reply! Perhaps I should describe my
problem more
specifically so that u could have a better idea:
The code on PHP page to create forms for users to input field names:
$tempdate = $date ;
$tempselect = $select ;
echo font size
Hi,
i apologize in advance for my stupid question. I installed RedHat8.0 with built in
apache 2 and php 4.2.2
By looking at phpinfo() i see that php has been compiled with --with-mysql,shared and
php works but it seems that mysql is not enabled. Why? how can i use mysql with php?
what have i
Hi Franco,
did you install MySql? Check http://www.mysql.com/ to get the newest
release.
Best regards
Claudia
-Ursprüngliche Nachricht-
Von: franco stridella [mailto:[EMAIL PROTECTED]]
Gesendet: Sonntag, 29. Dezember 2002 16:47
An: [EMAIL PROTECTED]
Betreff: [PHP-DB] php and mysql
1. Is mysqld running? I don't remember if the default configuration
for RH8.0 sets it to start on system boot.
The easy way to check is:
ps aux | grep mysql
or
mysqladmin -u root ping
will return MySQL is alive if the server is running.
2. See chapter 2.4 of the MySQL
Hello,
I have created a website (www.mirax.cz) with a database mysql 3.23.33 and used PHP
4.0.4pl1. Everything functions perfect ONLY at my W98. As soon as I want to use the
same database exported to linux(PHP 4.2.2) or w2000(PHP 4.2.3) both with mysql
3.23.54, it has problems like this:
The simplest solution is to edit php.ini on your Linux box and set the
parameter register_globals to ON. As of PHP4.2.0 the default setting
is OFF and new super globals are available.
A better solution is to update your windows box to the same version of
PHP so that you are programming to the
Three words:
php dot net
--Dave
On Fri, 2002-12-06 at 23:19, Jason Wong wrote:
On Saturday 07 December 2002 11:54, Dallas wrote:
hey, i'm just new to using php and mysql
i would like to know how to do the following for a assignment of mine
(shopping site):-
and if I could ask for
hey, i'm just new to using php and mysql
i would like to know how to do the following for a assignment of mine
(shopping site):-
and if I could ask for full codes, and only relevant coding, no extra stuff
plz
*connect to the mysql database and display results in random areas of the
page
(the
On Saturday 07 December 2002 11:54, Dallas wrote:
hey, i'm just new to using php and mysql
i would like to know how to do the following for a assignment of mine
(shopping site):-
and if I could ask for full codes, and only relevant coding, no extra stuff
plz
Should you be asking for a
First time playing with PHP, Apache, and MySQL. I have a simple form error
and I don't know how to solve it. I was doing the Webmonkey PHP/MySQL
tutorial and when I started using forms with $PHP_SELF I started getting
errors with variables not defined.
PHP 4.2.3
MySQL 4.0 Windows 2000
Apache
Dear Readers,
Is there anybody who nows about a php-script which can be used to download email from
a pop-account and then put the e-mailmessages and their attachments into a MySQL
database.
I want to use it to create a database of all e-mailmessages send to our company. This
will greatly help
- Original Message -
From: Chris [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, September 09, 2002 11:03 PM
Subject: [PHP-DB] php - checkboxes - mysql
Greetings,
I am just starting with php and need some help/code example for
setting checkbox values from mysql. My setup
--
--
---
- Original Message -
From: Chris [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, September 10, 2002 12:03 AM
Subject: [PHP-DB] php - checkboxes - mysql
Greetings
Subject: Fw: [PHP-DB] php - checkboxes - mysql
You should first check if checkbox value stored in the databese is 1 or 0.
After use an if clause:
if ($checkbox==1) {
echo input type=\checkbox\ name=\checkbox\ value=\1\ checked
}
elseif ($checkbox==0) {
input type=\checkbox\ name
Greetings,
I am just starting with php and need some help/code example for
setting checkbox values from mysql. My setup is the following:
The mysql database holds data and checkbox values in respective columes.
For example
nameaddress phone homeno workno pagerno
I am setting up a web page system which involves html pages, php pages and
mysqldatabase.
I have a number of questions and do not know where to find answers.
If I display the rows from a database table in a php generated html table
is it possible to mark a row so that it can be deleted or
I'll add this snippet in to prevent accidental deletes:
a href=delete.php?id=' . $row[id] . ' onClick='return confirm(\Do
you really want to delete this record?\)' ' . $row[name] . '/a
On Wednesday, June 5, 2002, at 09:20 AM,
[EMAIL PROTECTED] wrote:
One way to do it would be thusly:
Hi,
I am setting up a web page system which involves html pages, php pages
and mysqldatabase.
I have a number of questions and do not know where to find answers.
If I display the rows from a database table in a php generated html
table is it possible to mark a row so that it can be
Using simple test scripts, I'm connecting to a MySQL DB through PHP after
inputting info into a form and hitting submit. Something is putting three
records instead of one into the mySQL DB.
For instance:
the two variables are: $event_title and $event_desc. These are gotten from
the form
get a record on the initial load, when $event_title and
$event_desc are empty, on the submit, when they have values, and on the
following reload, if you do one.
Hope this helps - Miles Thompson
At 07:28 AM 12/9/2001 -0500, Lynne wrote:
Using simple test scripts, I'm connecting to a MySQL DB
Dear all
I had a security problem with my homepage. I'm using the IIS 4 to host my
webpage, and i got the php to run as the script of the webpage and the
database i'm using for the database is mysql.
Here is my question :
There is a table in mysql which will let user to input some records to,
OK, I have found some more time to work on my PHP project. The problem is
indicated in the following line:
$tables = mysql_list_tables($db_names[$db_num]) or die(Couldn't list
databases.);
I took the variable $db_num and replaced it with a value of 1 as follows:
$tables =
PROTECTED]]
Sent: Wednesday, October 24, 2001 7:54 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] PHP and MySQL queries...
Agreed. This is especially useful when you need to conserve every
byte you
can; a timestamp of 10/24/2001 or something similar is going to take
10
:[EMAIL PROTECTED]]
Sent: Wednesday, October 24, 2001 7:54 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] PHP and MySQL queries...
Agreed. This is especially useful when you need to conserve every
byte you
can; a timestamp of 10/24/2001 or something similar is going to
take
Title: RE: [PHP-DEV] RE: [PHP-DB] PHP and MySQL queries...
http://mysql.com/documentation/mysql/bychapter/manual_Reference.html#Date_and_time_types
Mysql permits all manner of formats for date/time storage,
and a whole slew of functions for retrieving date/time
info in useful, meaningful
-Original Message-
From: Tim Foster [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 8:19 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [PHP-DEV] RE: [PHP-DB] PHP and MySQL queries...
snip... (been doing VBScript on ASP for several years,
tho).
I feel sorry for you
From: Chris Newbill [mailto:[EMAIL PROTECTED]]
snip... (been doing VBScript on ASP for several years, tho).
I feel sorry for you. :)
;) Never fear. It works, does what it needs to do (so long as it's properly patched ;)
and
I make a fist-full of money for moon-lighting. Can't complain too
How about using 3 select menus:
* One for the day called 'dayselect'
* One for the month called 'monthselect;
* One for the year called 'yearselect'
When you get the values from the selects to perform query's upon, re-arrange the order
the dates
come in:
In your form they'll be in the order:
Title: RE: [PHP-DEV] Re: [PHP-DB] PHP and MySQL queries...
In these days and times, conservation of a meg of disk
space is really not a consideration. Not the primary one anyway.
The data should be stored in a format such that the
storage itself and then retrieval can be executed
I'm using Php 4.0.1 pl2-9 and Mysql 3.23.22 and gets the following error in
Mysqls logfile:
010711 10:58:52 Aborted connection 381 to db: 'improvement' user: 'webusr'
host: `web.local' (Got an error reading communication packets)
After a while mysql doesn't accept more connection because it has
That is what I thought, so I set $db_num to another number and still came up
with the same error.
jkd
Darren [EMAIL PROTECTED] wrote in message
9e42lj$s7b$[EMAIL PROTECTED]">news:9e42lj$s7b$[EMAIL PROTECTED]...
I think the 0 is referring to your $db_num
Jonathan Duncan [EMAIL PROTECTED]
Miles Thompson [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Jonathan .. see below.
At 08:38 PM 5/18/01 +, Jonathan Duncan wrote:
Miles
Thank you for the response. I did some debugging and the value of $dbs
is 2.
I am not sure of what example you
I believe you want to look at this page:
http://www.thickbook.com/books/phpfe_errata.phtml
--
++
| Julie Meloni ([EMAIL PROTECTED]) |
||
| PHP Essentials and PHP Fast Easy |
| http://www.thickbook.com
YES!! I just had a feeling the book was wrong. That did get rid of the
error. However, it did not completely solve my issue. Now when I run the
script I just get the message Couldn't list databases. This just happens
to be the die message for the same line of code that I have been looking
I think the 0 is referring to your $db_num
Jonathan Duncan [EMAIL PROTECTED] wrote in message
9e3suq$17r$[EMAIL PROTECTED]">news:9e3suq$17r$[EMAIL PROTECTED]...
I am making a script to access MySQL and when I run it I get this:
Warning: 0 is not a MySQL link index in
Jonathan .. see below.
At 08:38 PM 5/18/01 +, Jonathan Duncan wrote:
Miles
Thank you for the response. I did some debugging and the value of $dbs is 2.
I am not sure of what example you are referring to. I am not using the
manual currently, although I have the PDF version of it.
I just downloaded MySQL-3.23.36.tar (Which is the Source tar) from their
site and I have php-4.0.4pl1. I have installed MySQL and it is ready to
go. I know this for I can connect via the MySQL Monitor. When I try to
configure php with the line "./configure
--with-apache=/usr/local/apache_1.3.19
try the tutorial at www.thickbook.com or at www.devshed.com for setting
everything up.
olinux
- Original Message -
From: "Mike Corredea" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 19, 2001 10:02 AM
Subject: [PHP-DB] PHP and MySQL
I just downloaded MySQL-3
[In a deadpan voice...] Oh, what a fascinating twist.
http://marc.theaimsgroup.com/?l=php-db is where this particular list is
archived.
That's where you can learn a lot about the individual programs, and you may
find out little bits of wisdom like: each database has strengths and
weaknesses,
I have three tables, whereby I have used a select statement to extract
some of the fields from each and one of the tables.
e.g.
$sqlstmt ="SELECT stock_in.id, equip.equip_type, equip.brand,
equip.model, vendor.name ";
$sqlstmt.="FROM stock_in,equip,vendor ";
$sqlstmt.="WHERE equip.id=equip_id
printf("%snbsp;", $myrow["equip_type"]); //no table name
did not work, and did not display the content
But if I apply the extract on $myrow, it worked..
extract($myrow);
printf("%snbsp;", $equip_type);
Thanks
regards
CC Zona wrote:
In article [EMAIL PROTECTED],
[EMAIL PROTECTED]
I have read and have reccommended several times: "PHP Fast and Easy Web
Development" By Juli C Meloni.
ISBN: 0-7615-3055-X
Prima Tech publishing
#---#
"Believe nothing - consider everything"
Can someone recommend a book that shows how to use PHP and MySQL.
I need to see how to pass parms from a form to a PHP so I can Update, Add
and Delete records.
Thanks for the help.
Jim Ray
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For
I would recommend the first two books listed on this page:
http://www.webdesigns1.com/php/books.php
I've read both.
Jeff Oien
Can someone recommend a book that shows how to use PHP and MySQL.
I need to see how to pass parms from a form to a PHP so I can Update, Add
and Delete records.
hi, you could do it in a easier way, first put real names for the fields in your
form:
div align="left"login :
input type="text" name="login"
/div
br
div align="left"group :
input type="text" name="group"
/div
Hi,
my exact problem is the following. Here is my form :
div align="left"login :
input type="text" name="field[0]"
/div
br
div align="left"group :
input type="text" name="field[1]"
First, try just calling the form action like:
form action="luquery.php?DB=csjoaTA=associatesSortField=company"
method="POST"
Turning the amp; into chars (maybe my mail prog formatted it like this?
...nevertheless..)
Also, try doing:
$result=mysql_query("select * from $TA where
http://www.weberdev.com/index.php3?GoTo=get_example.php3?count=1825
-Original Message-
From: Kevin Connolly [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 06, 2001 12:28 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] php and mysql file insertion!
Hi,
I have a MySQL database
1 - 100 of 106 matches
Mail list logo