Hi friend!
I have a question...
I have a remote database in Microsoft Access on a WinNT System, and a Apache and PHP
on Linux System. How can I connect this?
There is one function in PHP for make this:
odbc_connect(DSN,user,password)
The question is: what is DSN in my case? How I can to speci
Hi Silvia Mahiques,
> I have a question...
> I have a remote database in Microsoft Access on a WinNT System, and a Apache
> and PHP on Linux System. How can I connect this?
>
> There is one function in PHP for make this:
>
> odbc_connect(DSN,user,password)
>
> DSN (Data Source Name) in local h
Thanks Yasuo Ohgaki and Gurhan Ozen.
My system has 256mb of DDR ram, it's a Intel PIII 900Mhz processor.
Ps -aux | grep mysql shows that about all of the mysql connections uses
about 15mb of memory.
Is that too much?
My query fetches 15 records from two tables.
Here is the query:
SELECT articl
Hi there,
I have a table containing data already. Now there is another table with data
I would like to add to the other one.
As far as I know mysql does not support subselects. So how could I add this
data to the old table?
Thanx, Andy
--
PHP Database Mailing List (http://www.php.net/)
To un
Hello, i have a little problem with quotes:
- first a have a textarea in a form
- second i'm gonna check this textarea
- if all checks sussesfull I process the data, so no straings thing get in
my database or whatever (function see below)
Problem: if I get the data out of the database I sometime
see mysql.com for an insert select synthax.
maybe that helps.
6.4.3.1 INSERT ... SELECT Syntax
INSERT [LOW_PRIORITY] [IGNORE] [INTO] tbl_name [(column list)] SELECT ...
With INSERT ... SELECT statement you can quickly insert many rows into a
table from one or many tables.
INSERT INTO tblTemp2 (fl
Hi there,
I do have a sql statement where I could need some help on.
There are 3 tables: provinces, cities, countries
The result should be city, province, country but only if province is
available. If not just display city and country.!
Lets say we are searching for madrid.
I did build followi
htmlentities is producing all these signs ... :)
i'd not use them to store the data in the database, a addslashes should be
enough
use htmlentities after having extracted the data from the db again...
>>I do this with code before into database:
>>--
Hi Silvia,
You first need to link your PHP/Apache install in Linux against an ODBC
Driver Manager.
You may obtain the iODBC Driver Manager at www.iodbc.org and follow the
HOWTO on that site for linking with PHP.
Then you will need a Driver - I suggest you download OpenLink's Multi-Tier
Driver, a
well, next to nothing. i'm a scripting programmer, but i'm quite unfamiliar
with the PHP syntax. trying to find some good examples of displaying field
values from tables in a database, in such a way to display a page. in other
words, what is the best way to display a specific field value in php? a
On Wednesday 10 April 2002 21:35, Christopher L. White wrote:
> well, next to nothing. i'm a scripting programmer, but i'm quite unfamiliar
> with the PHP syntax. trying to find some good examples of displaying field
> values from tables in a database, in such a way to display a page. in other
> w
Hi All!
Can anybody here give me a hint on the following situation?
Let's say we have a result set (cursor) got from SELECT statement having too
many records to display on a single page. How to split records among several
pages executing the single query?
It's easy to scroll cursor forward using
On Wednesday 10 April 2002 18:54, andy wrote:
> Hi there,
>
> I have a table containing data already. Now there is another table with
> data I would like to add to the other one.
> As far as I know mysql does not support subselects. So how could I add this
> data to the old table?
Use "INSERT ...
Hi there:
Can canyone give me a basic insert statement to insert into two or more
tables, variables and data from one form; i.e., insert the input into
two or more tables at the "same" time?
thanx
--
Marc S. Bragg
[EMAIL PROTECTED]
Bialecki & Bragg, PC
p: 610-444-7508
f: 610-444-7548
http://ww
Hi there,
I am pretty much a newbie, I was wondering what php session variables are? I
am creating a table with php that uses mySQL "create temporary table" based
on user specified columns and some where clause stuff. The page then
displays the contents of the table with the table headings as hre
These guys probably have one for you.. "If you give a man a fish..." (as was
stated earlier in the week)
http://www.mysql.com/doc/I/N/INSERT.html
Later,
Bob Weaver
"Marc S. Bragg" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hi there:
>
> Can canyone give
I don't know that I could help much with your statement.. But you mentioned
doing if() statements in SQL queries.. Well, my programmer always writes
them into PHP scripts then just runs them from there.. Then he can include
if() conditions, or whatever else he needs.. Just a quick little
cust_impo
I really suggest you to take a look at the manual
Try
http://www.php.net/manual/en/function.mysql-unbuffered-query.php
Mail list not suitable to explain about ulimit, mamory manager, etc.
(i.e. You may want some books for this)
Your query result is exceeding memory limit that the web server
You need to look up LEFT JOIN in the documention of the database you are
using.
>
> "Andy" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > Hi there,
> >
> > I do have a sql statement where I could need some help on.
> >
> > There are 3 tables: provinces
The above post may be unclear.. What he did was used if() statements to
compare whatever and generate the query differently based on what he found..
$lotsOdata = $database->result( "SELECT * FROM someTable" );
$count = mysql_num_rows( $lotsOdata );
while( $count > 0 ) {
if( $lotsOdata[city] !
Well, if you know what cookies are, then you know what session variables
are. You just dont know that yet.. :)
Joke aside, session variables are special cookies, created by you or
your app, it is represented at the users machine only by a small cookie
with a generated ID, which again points b
On Wednesday 10 April 2002 23:26, Egil Helland wrote:
> Well, if you know what cookies are, then you know what session variables
> are. You just dont know that yet.. :)
>
> Joke aside, session variables are special cookies, created by you or
> your app, it is represented at the users machine only
use this page and it will help you
http://www.php.net/manual/en/ref.session.php
Jeroen
At 17:26 10-4-2002 +0200, you wrote:
>Well, if you know what cookies are, then you know what session variables
>are. You just dont know that yet.. :)
>
>Joke aside, session variables are special cookies, cr
Hi all,
I had to re-write this so it would at least show something on the page.
$query = "SELECT id, name, image, quantity FROM {$config["prefix"]}_my_items
WHERE uid={$session["uid"]} ORDER BY id";
$ret = mysql_query($query);
$row = mysql_fetch_array($ret);
$id = $row['id'];
$image = $row['ima
On Wednesday 10 April 2002 23:54, Jennifer Downey wrote:
> Hi all,
>
> I had to re-write this so it would at least show something on the page.
>
> $query = "SELECT id, name, image, quantity FROM
> {$config["prefix"]}_my_items WHERE uid={$session["uid"]} ORDER BY id";
> $ret = mysql_query($query);
Thank you Jason that worked out great!
Jennifer
"Jason Wong" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]...
> On Wednesday 10 April 2002 23:54, Jennifer Downey wrote:
> > Hi all,
> >
> > I had to re-write this so it would at least show something on the page.
> >
> > $query = "SEL
Hi everyone!
Is there a good tutorial on how to write html tables in PHP?
In my last post "Not displaying all records" I have the items displayig all
the contents of the table but they are in descending order.
like this
item 1
item 2
Here is the code I am using
$query = "SELECT id, name, image
The way I do this is a very simple bit of code:
Outside the "while" statement, add the line:
$column = 1;
Then, inside the "while" statement, take the statements out and
instead do something like this:
$column++;
if ($column > 3)
{
echo "";
Hi Andy,
> There are 3 tables: provinces, cities, countries
> The result should be city, province, country but only if province is
> available. If not just display city and country.!
>
> Lets say we are searching for madrid.
>
> I did build following statement:
> SELECT c.city, c.ID, p.pro
You probably want something more like this (see modified code below).
Note that if you get a lot of records, your html table will keep
expanding out to the right. You might want to break it up with rows ...
or not, as you like.
There are quite a few places that have intros to php subjects. Che
Your question is quite long and make me confused
let me repeat it once , ok?
you want to make a calendar like table display, with the function of
displaying which day got reservation
furthermore, count the right day number for different months, right??
if you are thinking what i saidi thin
Thank you all I managed to get it worked out like this
$name$quantity";
echo "$display_block";
}
echo"";
?>
Jennifer
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.344 / Virus Database: 191 - Release Date: 4/2/2002
--
is there a personal details table in your database??
if so, you may get all those value like userID,name from this table by a key
$id
on the other hand, try to not use the session to get the uid
"Jennifer Downey" <[EMAIL PROTECTED]> ¼¶¼g©ó¶l¥ó·s»D
:[EMAIL PROTECTED]
> Hi all,
>
> I guess I shoul
Hello,
I know using set cookie you should be able to set a cookie that deletes
itself when the user closes the browser, but this is not happening. For
some reason it will not create the cookie at all. Any ideas?
This is the code we are using, before the header and all that.
Thanks,
Chris
"Jason Wong" <[EMAIL PROTECTED]> skrev i meddelandet
news:[EMAIL PROTECTED]...
> On Sunday 07 April 2002 17:08, Hayan Al Mamoun wrote:
> > Dear all,
> > I have two design-identical database, one on my intranet, the other on
the
> > internet, is there any procedure that Synchronizes the content of
Dont know how to do it, but you could always try some apache newsgroup
http://groups.google.com/groups?hl=sv&group=alt.apache.configuration
"Dave Carrera" <[EMAIL PROTECTED]> skrev i meddelandet
001301c1ded0$498373c0$d95527d9@phpdevdc001">news:001301c1ded0$498373c0$d95527d9@phpdevdc001...
> Hi All
Newbie question that maybe should belong in a mysql group, but how and why
does a varchar fragment a dbase?
//Micke
"Remco Oosten" <[EMAIL PROTECTED]> skrev i meddelandet
003c01c1ded7$72877760$[EMAIL PROTECTED]">news:003c01c1ded7$72877760$[EMAIL PROTECTED]...
> I don't think you can use text(50),
you could always use a sepeate file and and then use include
("path/to/whateverfile.php"); with all your dc connection prefererences in
it...
"Dries Verachtert" <[EMAIL PROTECTED]> skrev i meddelandet
news:[EMAIL PROTECTED]
c.be...
>
> Hello,
>
> I use apache with php3 and mysql to get some data
$row returns an array, and you display only the first element
Jennifer Downey a écrit :
> Hi all,
>
> I had to re-write this so it would at least show something on the page.
>
> $query = "SELECT id, name, image, quantity FROM {$config["prefix"]}_my_items
> WHERE uid={$session["uid"]} ORDER
On Monday 08 April 2002 19:15, Michael Andersson wrote:
> What happens to a blob field with lets say a image when dumping a mysql
> table to a file?
I don't use BLOB fields. You try it and let me know ;-)
>
> > 3) Install phpMyAdmin on both machines.
>
> How do i replicate 2 mysql db:s with php
Can anyone tell me what is wrong with the code that is below? Whenever I use this it
returns all the records in the table no matter what is searched for.
Thanks for any help,
Terry
-- CODE
Search results:";
echo "";
do {
echo "".$myrow["Player"]."";
} while ($myrow=m
41 matches
Mail list logo
