Hi Everyone,
I have spent a few hours searching on the internet, but still can not get the
information I need. So I turn to you for help.
I will be doing a web site which has a lot of data from a remote mssql server. The
scripts will be in php and run on Linux. As requirements, the mssql will
While viewing web pages, we sometimes get the following error: "Warning:
mysql_pconnect: Link to server lost, unable to reconnect in
/home/dratner/includes/common.inc on line 26 ". The offending line is this
code:
if (!$db = mysql_pconnect("db1", "diadba",
"c0s3mST"
I have a site I have to convert to frames (*ugh*) (so I'm using php frames,
better
than html frames anyway) and came up with a little problem.
On one page is a list of states, click on the state name and get a list of
dealers in
that state. This works. What doesn't work is the list of dealers page
Help-
When I run the following code instead of getting the correct result,
"Resourse id #5" is displayed. If I run the printed query from the mysql
console the output is correct.
What am I doing wrong?
Thanks in advance,
Max
$sql = "select a.domain, a.transport from transport as a, acl
I've been reading various posts in the mysql mailing list that basically say
that this functionality (unions, subselects) does not exit within mysql yet
(I am just learning php/databases).
Is there a way I can run this query in mysql? If not can I fake it out with
php? What would the best way to d
Phanivas Vemuri said:
---
I have two tables.
1.ProgramClips ( id, progSummary, category, videoFile)PRIMkey = id.
and each id may have 2 or three categories.
2.Category( number,category).
categories are :
Beef , diary, horticulture etc;
I am using PhpMyAdmin as the
Ok, you've come to the right place, so what exactly is the question?
<>< Ryan
-Original Message-
From: Phanivas Vemuri [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 12, 2002 1:26 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] A help on relational databases using php
hi all,
i need som
hi all,
i need some help regarding soem one who had worked on relational databases
suing php as the interface.
Phani.
_
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
http://join.msn.com/?page=features/virus
--
PHP Data
hi all,
I have two tables.
1.ProgramClips ( id, progSummary, category, videoFile)PRIMkey = id.
and each id may have 2 or three categories.
2.Category( number,category).
categories are :
Beef , diary, horticulture etc;
I am using PhpMyAdmin as the interface for the mySql Database.
The PhpMyAdmin c
> mysql_insert_id() is a PHP function, not a MYSQL function. You are also
> missing a close quote on your insert string. So you have to do it like
> this:
Correct, but LAST_INSERT_ID() is a MySQL function which is what he's
using...
> $sql2 = "insert into acl (adminId,transportId,securityId
$1 is a bad variable. You can't have variables that start with a number.
Try $a or $foo or $bar.
On Thu, 12 Dec 2002, mike karthauser wrote:
> If i try the below in my query i get no results.
>
> Ideally i would like to do this (not valid sql)
>
> printf("\n");
> while ($myrow = mysql_fetch_ar
mysql_insert_id() is a PHP function, not a MYSQL function. You are also
missing a close quote on your insert string. So you have to do it like
this:
$sql2 = "insert into acl (adminId,transportId,securityId) values
('$userid',".last_insert_id().",'1')";
Notice the "string".function()."string" -
Hi-
I am trying to insert information into mysql based with the sql queries
below. When I run this insert from the mysql console everything works
correct, however, when I run this through php the second sql query doesn't
execute (I'm assuming there is a problem with the last_insert_id()).
I have
yes, if your server is windows based.
Create a odbc system dsn to the access file on your server, then connect to
that dsn. You can then pull data from it, connect to mysql and insert the
data.
If I remember correctly, you had wanted your users to upload the mdb file
for you to extract the data.
I asked a question sort of alone these lines the other day so please forgive
me if it sounds familiar...
If I have a microsoft access file .mdb on my server, can I use a php page
to move the data from the file to a mysql db?
Thanks,
Eddie
--
PHP Database Mailing List (http://www.php.net/)
To
$select="select fields from table...";
$sres=mysql_query($select);
echo mysql_error();
while ($srow=mysql_fetch_row($sres))
{
$string=$srow[0];
$no_html=strip_tags($string);
if (strlen($no_html) > 30) $no_html=substr($no_html,0,30)."...";
echo("$no_html");
}
Matt
- Original Mes
oh :)
i never check those extensions... to busy for... and also tired from the
overload of boost (do programmers drink to much?? :--))
___
Mark Snijders, Developer
Atos Origin
Groenewoudeseweg 1, Room VN-515
5621 BA Eindhoven, The Netherlands
* : [EMAIL PROTEC
I'm pretty sure the .dk on the end of his e-mail address means Denmark. Glad
you guys were confused too. I was afraid that last shot of Tequila at the
bar last night really screwed me up.
> -Original Message-
> From: Snijders, Mark [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 12,
なるほど.
私も,そう言う問題に会った.
Ignatius
- Original Message -
From: "Martin Allan Jensen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, December 12, 2002 2:26 PM
Subject: [PHP-DB] flytte bsd harddisk til anden pc
Hej Allesammen, har et strt
it's swedish or something..
i don't get it and i'm dutch
if the person understands knulla then he's swedish :)
___
Mark Snijders, Developer
Atos Origin
Groenewoudeseweg 1, Room VN-515
5621 BA Eindhoven, The Netherlands
* : [EMAIL PROTECTED]
*:+31 (0)40 -
Please help. I have a basic scipt:
$connection_id=odbc_connect("$DSN","$user","$pass");
$sql="select * from whatever";
$stmt=odbc_prepare($connection_id,$sql);
$result=odbc_execute($connection_id,$stmt);
this script used to work on RH-7.3 with php-4.1.2
the script will not work anymore when i ins
Dutch, swedish...?
"Martin Allan Jensen" <[EMAIL PROTECTED]> wrote in message
002501c2a1e2$092e8640$020a@asus">news:002501c2a1e2$092e8640$020a@asus...
Hej Allesammen, har et strt problem, jeg skal IDAG skifte server, men kan
jeg bare tage mine harddiske med FreeBSD på og smide over i den n
Hej Allesammen, har et strt problem, jeg skal IDAG skifte server, men kan jeg bare
tage mine harddiske med FreeBSD på og smide over i den nye maskine og så vil det køre
eller
Lisi,
To save reinventing the wheel would strip_tags() be any use to you? (see
manual)
=dn
> I am retrieving text stored in a database, and I want to strip out any
HTML
> tags and then only display the first 30 characters with "..." to show the
> user that there is more text to view.
>
> My probl
If i try the below in my query i get no results.
Ideally i would like to do this (not valid sql)
\n");
while ($myrow = mysql_fetch_array($result)) {
$l=$myrow['coursecode'];
?>>\n");
?>
on 11/12/02 5:26 pm, Peter Beckman at [EMAIL PROTECTED] wrote:
> LEFT(str,len)
> Returns the leftmost len c
I am retrieving text stored in a database, and I want to strip out any HTML
tags and then only display the first 30 characters with "..." to show the
user that there is more text to view.
My problem is with stripping out HTML tags, the code is stripping out the
text enclosed within the HTML tag
> DOH!!! I am seriously hoping that I do not need to have the Oracle
> client installed on the webserver running the PHP queries. I have no idea
> about the client licensing, and if it involves money in any way it is
pretty
> much out of the question. Oh well... Hopefully I can find out about t
27 matches
Mail list logo