Anyone knows a list for discussion SQL questions?
On the off chance that this *is* an appropriate list here goes:
I want to select tickets from two tables that registers support tickets and
events related to the ticket. No problem.
Tickets go through various stages, REGISTERED, OPEN, CLOSED in
Use this function:
header("Location: another_script.php");
codemax.
""Miles Scruggs"" <[EMAIL PROTECTED]> wrote in message
000601c0b097$f72e70a0$0232000a@engr">news:000601c0b097$f72e70a0$0232000a@engr...
> Is there a way to jump out of one script and into another like with
> cflocation() in CF.
Just out of curiousity, say if I was to develop an e-commerce site for a
client and the scripts used to execute it were written in PHP, under what
circumstances, if any, am I required to pay for Zend Licencing?
In other words, if I set up the client's entire server; Apache, PHP... the
whole works
I have a client who would like to make some simple database-driven pages
using PHP and MySQL, but he doesn't know how to use either. He asked me
if there was a program that he could use to create pages that would be
easier than having to learn both PHP and MySQL. I've always done
everything from
Cool!
Just came across this, looks like PHP will make life simple.
http://www.php.net/manual/en/function.array-flip.php
Array_flip() returns an array in flip order.
Example 1. Array_flip() example
$trans = array_flip ($trans);
$original = strtr ($str, $trans);
example:
$a[0]="abc"; $a
Hello php mania,
i was connecting into mysql using mysql_connect, and i just saved
the return value from this funtion. now i want to use this connection
id in the other page so i dont have to connect into mysql again.
is it possible for me to do that ?
anybody could tell me the different
Hi. Does anyone currently work with PHP, Flash 5, and MySQL together?
--
Shane Aldrich
Graphic Insight
3014 N. Hayden Road
Suite 114
Scottsdale, AZ 85251
480.423.3524
FAX 480.423.1987
www.graphic-insight.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROT
I didn't understand you, the page you pointed is just like your page, record
by record one just after the other. It has only a link to reorder the query
by another field.
HTH
Jayme.
-Mensagem Original-
De: olinux o <[EMAIL PROTECTED]>
Para: <[EMAIL PROTECTED]>
Enviada em: sexta-feira, 2
Congratulations !! Very good solution ! Simple and efficient !
Cheers,
Jayme.
-Mensagem Original-
De: Michael Rudel <[EMAIL PROTECTED]>
Para: <[EMAIL PROTECTED]>; 'PHP-DB mailinglist' <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Enviada em: sexta-feira, 23 de março de 2001 08:29
Assunto: RE
I don't know if you need a special class to send an email, the php mail
function do this in a way you can read it on every browser or email program
.
HTH
Jayme.
-Mensagem Original-
De: Xsarus Internetdiensten <[EMAIL PROTECTED]>
Para: <[EMAIL PROTECTED]>
Enviada em: sexta-feira, 23 de ma
A good advice is put an error checker after every mysql command, this way
you can track errors :
> include("../includes/connect.inc.php"); file://connect to the
database
> $query = "SELECT m_sender, m_date, m_subject FROM messages WHERE m_id =
> '$m_id'";
> $result = mysql_query($query ,
"select data_name,data_number from myTable order data_number DESC"
The "DESC" is descending.
HTH
Terry
On Friday, March 23, 2001, at 03:02 PM, Sunil Jagarlamudi wrote:
>
> I am trying to read a file which has two columns with names and numbers and
> I am trying to sort them numerically, wi
Thanks,
I have finally figured out the syntax for nl2br(), which doesn't seem very
clear in the manual.
I used:
$data = nl2br($data);
That returns just what I expect. However, now I have to get rid of the all
the s that I have inserted into my data while I was trying to figure
this out.
Thank
nl2br()
> -Original Message-
> From: Shope, Glenn [mailto:[EMAIL PROTECTED]]
> Sent: 23 March 2001 20:49
> To: '[EMAIL PROTECTED]'
> Subject: [PHP-DB] Line Breaks
>
>
> Still haven't figured it out...
>
> I have read several entries about preserving line breaks when displaying
> text f
olinux wrote:
> You have to escape your ""
>
>> $query = "SELECT m_sender, m_date, m_subject FROM messages WHERE m_id =
>> '$m_id'";
>
> try this
> $query = "SELECT m_sender, m_date, m_subject FROM messages WHERE m_id =
> \"$m_id\"
> ";
No that isn't the problem.
It is valid to change qu
I am trying to read a file which has two columns with names and numbers and
I am trying to sort them numerically, with the
highest at the top. Is there anyway you can do that in php ?
Thank You
Sunil
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
F
I am running a webserver on machine A, and a postgres server on machine
B. Reading the docs for PG_CLOSE it appears that a PG_CLOSE is not
required, however our postgres box has the following:
[sbrinker@samco sbrinker]$ ps aux | grep postgres
postgres 6347 0.0 0.0 16920 ?SW Feb
Still haven't figured it out...
I have read several entries about preserving line breaks when displaying
text from a mySQL database, but I have had no success.
How would I prevent data in a single field containing line breaks from being
displayed in HTML as a single line?
For example:
A person
You have to escape your ""
> $query = "SELECT m_sender, m_date, m_subject FROM messages WHERE m_id =
> '$m_id'";
try this
$query = "SELECT m_sender, m_date, m_subject FROM messages WHERE m_id =
\"$m_id\"
";
- Original Message -
From: "Martin Skjöldebrand" <[EMAIL PROTECTED]>
To: <
Going bonkers again ...
I have this in a script.
Where m_id is passed to the page and connect.inc.php is my database
connection script which works nicely with all other pages. Still I get:
Warning: Supplied argument is not a valid MySQL-Link resource in
/chroot/htdocs/helpdesk/scripts/viewme
Hello...
What you can do is create different users tables within the Database...
Then write a script that checks the username and passwords for each
Database, during login.
Like do a SELECT username FROM usertable
if (!username)
then echo
..
Or stick with one user and o
You can get an idea here of what I would like to do
http://www.bestbuy.com/ComputersPeripherals/DrivesStorage/CDRW.asp?m=488&cat=511&scat=514
So all information is displayed side by side, most of
the time used to help decide between 2 or 3 products
[bestbuy limits 10 selections in their comparis
same user, different passwords? Not sure you can. If you have to do this
then I would issue a different account for each user/database combo you
have. (i.e. _cal) and give each account a separate password.
Why do you want to do this? You can control access for an account on a
database level. T
Depends on what registers are. If they are people then I would just shoot
then and get it over with. :)
Seriously, if you mean how do you delete records form a table that are more
than a month old (let's say 30 days to make it simply) then you need to have
a timestamp field in your table. Then
how could I configure diferent user password to each database on my
server???
--
--
Romeo Manzur
Web Application Developer
iSilicom
Av. 27 de Febrero 904-A Desp 1, Centro
C.P.:86000
Villahermosa, Tabasco, Mexico
Tel.:(52)(9)3-12-4790
--
How could I automatly delete registers from a table that have a month
old???
--
--
Romeo Manzur
Web Application Developer
iSilicom
Av. 27 de Febrero 904-A Desp 1, Centro
C.P.:86000
Villahermosa, Tabasco, Mexico
Tel.:(52)(9)3-12-4790
Todd,
I don't believe that there is an all-in-one compile that you can install,
but you can certainly install Interbase, Apache and PHP on Linux and compile
them yourself and make them work. Alternately, I'm sure there are 100 or so
people on this list whom you could hire to get it up and running
I have Interbase working on my client's WIN 2K platform with IIS as well
as on mine; however, I do not have any experience with Linux/Apache
(other than Apache running in DOS on my notebook for "on-the-road"
programming). The client would now like to move over to a more stable
environment: Linux!
Hi
does anyone has Information about using a SAP R3 Database with PHP4?
thx Robert
--
C o d i t o , e r g o s u m !
I code, therefore I am!
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTE
Sergio,
The error indicates PHP cannot find your odbc.ini file that contains your
DSNs.
Try passing its location in:
putenv("path/to/your/pesky/odbc.ini");
HTH
Best regards,
Andrew
--
Andrew Hill - OpenLink Software
Director Technology Evangelism
eBusiness I
Huy,
how to build mails in PHP with txt-mails AND HTML-mails AND visible in Webmail (like
Hotmail, USANet)
With the class below I can only make HTML-mails readable in Outlook etc.
Why are the mails not shown in USANet?
Daniel Kieviet
Xsarus Internetservices
Holland
[EMAIL PROTECTED]
http://ww
Or try this one, its simple but more universal and very usefull for eg. testing.
... and a bit mor structured >8)=)
\n";
$columns = mysql_num_fields( $sql_result );
for ( $i = 0; $i < $columns; $i++ )
{
echo "".mysql_field_name( $sql_result, $i )." \n"
Hello,
I'm trying to use php with ibm-db2 but I obtain this error:
Warning: SQL error: [unixODBC][Driver Manager]Data source name not
found, and no default driver specified, SQL state IM002 in SQLConnect in
login.php on line 11
This is my code:
$dsn="MYDB";
$u
This isn't going to be the most helpful answer, because I'm wondering why
you'd want to do this in the first place.
All you really have to do is create a new array from the existing result
set, transposing the columns.
The number of elements in the array will be the number of car_ID's that are
34 matches
Mail list logo