'
range_begin = '$quantity'
ORDER BY range_begin DESC
LIMIT 1
--
Hugh Bothwell [EMAIL PROTECTED] Kingston ON Canada
v3.1 GCS/E/AT d- s+: a- C+++ L+$ P+ E- W+++$ N++ K? w++ M PS+
PE++ Y+ PGP+ t-- 5++ !X R+ tv b DI+++ D-(++) G+ e(++) h-- r- y+
--
PHP Database Mailing List (http
'
size_id = '$size_id'
range_begin = '$quantity'
ORDER BY range_begin DESC
LIMIT 1
--
Hugh Bothwell [EMAIL PROTECTED] Kingston ON Canada
v3.1 GCS/E/AT d- s+: a- C+++ L+$ P+ E- W+++$ N++ K? w++ M PS+
PE++ Y+ PGP+ t-- 5++ !X R+ tv b DI+++ D-(++) G+ e(++) h-- r- y+
--
PHP
optimize this. Anyone know the answer?
It will be faster by one store and one fetch... the
database query probably takes 1000 times as long.
I don't think the difference is worth the time you'd
take to change it.
--
Hugh Bothwell [EMAIL PROTECTED] Kingston ON Canada
v3.1 GCS/E/AT d- s
illegal strings.
--
Hugh Bothwell [EMAIL PROTECTED] Kingston ON Canada
v3.1 GCS/E/AT d- s+: a- C+++ L+$ P+ E- W+++$ N++ K? w++ M PS+
PE++ Y+ PGP+ t-- 5++ !X R+ tv b DI+++ D-(++) G+ e(++) h-- r- y+
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http
(to_roman.php);
$test = array( 8, 19, 155, 980, 9.8, -3, 3999, 4000, abc, , array() );
foreach($test as $num)
echo $num =gt; .IntToRoman($num).br/;
?
--
Hugh Bothwell [EMAIL PROTECTED] Kingston ON Canada
v3.1 GCS/E/AT d- s+: a- C+++ L+$ P+ E- W+++$ N++ K? w++ M PS+
PE++ Y+ PGP+ t
;
return(
RomanDigit($m, 'M', '', '')
.RomanDigit($c, 'C', 'D', 'M')
.RomanDigit($x, 'X', 'L', 'C')
.RomanDigit($i, 'I', 'V', 'X')
);
}
--
Hugh Bothwell [EMAIL PROTECTED] Kingston ON Canada
v3.1 GCS/E/AT d- s+: a- C+++ L+$ P+ E- W+++$ N++ K? w++ M PS
Spiderwebb [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I dont know if this is possible in PHP (Newbie) im working on a project
where each product has 3 diffierent prices depending on the amount sold so
say for example 1- 100 price A 101-299 price B and above
Rainydays Sunshine [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I need to create some kind of 10 digits serial number where I can generate
and check that it is valid. Sort of like a checksum..
How many unique values do you need, and how hard-to-fake?
I
Chris Mackenzie [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I've been trying to solve this for hours now with no end in sight, I'm
hoping that someone here might be able to help me.
I've got four tables set out as shown below:
tbl_student_details
id
Srinivasan Ramakrishnan [EMAIL PROTECTED] wrote in message
004701c206df$5a00f100$[EMAIL PROTECTED]">news:004701c206df$5a00f100$[EMAIL PROTECTED]...
The slabs do not continue for an infinite number, hence I may only have
slab
pricing for 1-10, 11-100, and 101-200 with the assumption that if
Richard Davey [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
In the 5th line I changed thread.id to thread.threadid so the name was
correct but the same error occurs.
Ok, I was guessing at your field names...
to give a perfectly satisfactory result but
George Pitcher [EMAIL PROTECTED] wrote in message
03b701c20190$8f53fe00$630db092@HLATITUDE">news:03b701c20190$8f53fe00$630db092@HLATITUDE...
My database (2 fields: Customer, Order date) contains over 15000 records
dating back to 1999.
I want to be able to show, in a web page, the following
Crosswalkcentral [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
How can i obtain the last 10 entries that are in mydatabase that have a
certain colum set to 1?
SQL does not guarantee to return your records
in any specific order unless you use an ORDER
BY
John Hughes [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I need to rebuild a PHP-mySQL site that has an extensive table
structure. Is there a way to DROP all tables that start with a
certain prefix?
First, use
SHOW TABLES FROM db LIKE prefix%
to get the
Paul [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I have a form on one server which takes a name in one field, intentionally
including spaces as a full name. That value shows up as a form variable as
I
intended when I display it on the same server. It is
If I have records like this
ID Content
1 John have a red book, and a yellow book. He give a yellow book to
Tina.
2 Luke doesn't have any book at all, he always borrow it from John.
3 John like swimming.
Can I search this records (table) for a word book and also number of
book
Its Me [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
i have the file:
edit_profile.php
Just curious: why do you have May 15th
and October 6th listed as locations?
?php
if (!isset($location))
$location = ;
$locations[] = array(
= Choose City,
Ciprian Trofin [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
price of the stock on a daily basis. My friend checks the Bucharest Stock
Exchange page, or other relevant page, and updates the price of the stock,
for
future reference.
I think there is a
Ciprian Trofin [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I think there is a easier way, that is making a script to load the
remote web page containing the updated stock price.
A second possibility: they may also make
the data available as XML (or
SELECT BlaID, MAX(BlaInfo) AS Info
FROM mytable GROUP BY BlaId
Prodoc [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
ok, sorry about that :-)
Table:
BlaID
BlaInfo
20
4
17
8
20
9
15
81
20
12
20 23
17
0
Result:
BlaID
BlaInfo
15
81
17 0
Andy [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hi there,
I am still struggling with following problem:
There are two tables in mysql
1. city fields: ID, countryid, provinceid, city
containing 2.5 million entries.
2. province
Everything is working great except the fact that when
I put some php code into the 'text' field, in order to run
en extra sql command in the page, it hangs and just
prints the code as if it was just text.
(shrug) so far as the database is concerned, it *is* just
text. If you want returned
he will have access to the first record, which I'm
displaying in a form. My question is: can another user
view the same record at the same time?
It depends entirely on where and how you get the
data. Of itself, there is nothing to prevent the same
record being displayed to any number of
Matthew Crouch [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Here's an easy one that I can't find laid out for me anywhere:
I want a self join that pairs up the id numbers of a table in every
permutation
e.g. i have id #s 1, 2, and 3
i need this result:
1
How can I accomplish the following?
I have a table called search,
I have 3 fields, city, country, type
I also have an imput box where you can type in
a search word. What I need is, say you type in
hotels germany, I need the search to break up
the sentence and then search each 3 fields
Just a simple question (I think).
When should I use tinyint over int. and what is the difference between the
two?
MySQL manual section 7.3 (data types):
tinyint (8bit), range is
0 to 255 (unsigned)
-128 to 127 (signed)
int (32bit), range is
0 to 4294967295
You can go one better than this, even...
use PHP to construct a single SQL query
using the IN( ) comparator, ie:
?php
// NOTE: this assumes that 0 is never a valid id; I just
// stuck it in to make the comma-delimiting come out right
$query = DELETE FROM tablename WHERE id IN ( 0;
Here is some code, which I modestly suggest is superior for the following
reasons:
1. Includes simply scaffolding (ie a sample form).
2. Code is separated into functions, rather than one monolithic block.
3. Somewhat improved word-counting.
==
html
head
style
Ron [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Is there a way under mysql to identify the last record in a table so that
I
can pull information that I need from that entry.
Um... sort backwards then use the first record (ie LIMIT 1)?
--
PHP Database
It looks to me like you should be dividing the data differently; something
like
(quantity, item, option, price)
VALUES
(1, '6inch', '', '29),
(1, '6inch', 'meny', 51),
(1, 'footlong', '', 45),
(1, 'footlong', 'meny', 66),
and so forth...
Raymond lilleødegård [EMAIL PROTECTED] wrote in message
Oliver Cronk [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Thanks for that answer, you filled in some of the blanks for the table /
logging solution, but I am now looking at row locking instead of a
seperate
table (and then doing things similar to what you
The problem is, somewhere in the middle of this script (more like
closer to the beginning) the script just *dies*. I say that because
there's no error message, no warnings, no footer content that's
included after the processing is done, nothing. It just dies in the
How long does this take
Venomous [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I need to make a dropdown menu from my mysql database but i don't no how
to
come about
It's the meaning that i don't get weird things in my database for instants
PI 300 or pi 300
think about what your
Chidambaram [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hi
i have to calculate the size of a remote url
ex:http://www.ee.iitm.ernet.in/index.html
i have written a php script but it returns only
the size of html page it doesnot include the images
size in
Andres Sulleiro [EMAIL PROTECTED] wrote in message
002001c18193$eacb4450$[EMAIL PROTECTED]">news:002001c18193$eacb4450$[EMAIL PROTECTED]...
I have a db table that has these columns:
id, date, time, title, body
some of the rows can have the same date and want to output the data
Chris Soyars [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Ok I need to beable to print to HTML each line on its own
right now I would have in the database:
A
B
C
D
and it will print A B C D
Help! Need this for school.
Um, br maybe?
--
PHP
Jason Wong [EMAIL PROTECTED] wrote in message
news:000301c1428d$f11b3a80$[EMAIL PROTECTED]...
The obvious first thing to do is to screen your keywords. Do not search on
common words such as:
and, if, the, in etc.
An easy way to do this is to set up an array of words
to exclude. Then you
Robert Gormley [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hi all,
I have a MySQL db which contains table test, field test... one of the
entries is
? external($url, $text); ?
Where external() is a function i've written which outputs simple text.
I
Chris Ross [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Our website was running PHP Version 4.0RC1, then our host decided to
upgrade
to version 4.0.6. Once they did this our site no longer worked every
time we went to a php page it would give an internal
Cilfa [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
$query = mysql_query(UPDATE articles SET pr='1' WHERE id='$p[id]');
But it does nothing! How can I insert multiple values (from the checkbox
array) at one time in a database?
UPDATE articles SET pr='1'
Jason Wong [EMAIL PROTECTED] wrote in message
021701c13489$245b1f40$[EMAIL PROTECTED]">news:021701c13489$245b1f40$[EMAIL PROTECTED]...
- Original Message -
From: Jack [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, September 03, 2001 10:35 PM
Subject:
Dave Carrera [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I have an array of which shows an image in a place on my page which shows
the next on the list when the page refreshes, this works fine.
What I want to do is have the image refresh on a 5 second
Markus Mayer [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Forgot to mention ... the only way to access the database on B is to
connect
to localhost there.
I would write a script on B that accepts parameters and returns the
results in easy-to-parse form
Georgie [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I have a simple php script that searchs a MySQL database and returns
results
that I made myself and I'm trying to implement code that splits the
results
into x amount of pages, buts it really tricky.
...
Andrius Jakutis [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hello,
What is the command in PHP coding, to order go to another URL?
header(Location: newurl);
Note that this must be sent before any
of the message body.
--
PHP Database Mailing List
Donald Fei [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
My PHP runs under:
Windows 2000 Professional + Apache/1.3.20 + PHP4.0.6 + MySql3.23.32
when i compile the following code:
?php
$db=dba_open(database.db,c,db2);
?
There is the error:
Fatal error:
Hugh Bothwell [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Donald Fei [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
My PHP runs under:
Windows 2000 Professional + Apache/1.3.20 + PHP4.0.6 + MySql3.23.32
Sheridan Saint-Michel [EMAIL PROTECTED] wrote in message
00f601c12ca3$8bb26420$[EMAIL PROTECTED]">news:00f601c12ca3$8bb26420$[EMAIL PROTECTED]...
From: Hugh Bothwell [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sheridan Saint-Michel [EMAIL PROTECTED] wrote in message
03a901c12c02$
Guilherme Bresser [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I have one problem.. TopSpeed don't support ODBC..
:-\
This is the only method I've seen for languages other than Clarion.
http://www.softclaim.com/odbc_interface.htm
If there ARE any
Wisam [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Do you know What's a logo worth: PRICELESS.
Do you have a logo ?
Do you have what it takes to design one ? To do it in Flash ?
Do you heve what it takes to put it on your website ? on your stationery
Matt C [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
1) I would like to pull all entries out of a table that have dates that
haven't occured yet. Basically forget anything before the current day. How
do I do that?
DELETE FROM table WHERE timestamp $now
Sheridan Saint-Michel [EMAIL PROTECTED] wrote in message
03a901c12c02$c60d4640$[EMAIL PROTECTED]">news:03a901c12c02$c60d4640$[EMAIL PROTECTED]...
I don't know if having multiple users associated with a single image is
at all beneficial, and I can see where it might cause all sorts of
problems.
Ron Gallant [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I am querying a list with a date field. I want to order the list by the
date field and only show each days date once with the other fields
showing.
(row 1) 2001-08-19 - some text here.
(row 2)
Ron Gallant [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
And my table results are shown 2 times per row.
http://www.chizeledlight.com/test.php
... at a guess, you requested the same field twice
in your SELECT statement.
I don't like the sample code given
Felipe [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Will PHP have any kind of active filter such as ASP's rs.Filer Criteria
And what about searching as ASP's rs.Find Criteria
... that's what SQL is for; in fact, I wouldn't be at all surprised
if these
Doh! I meant extract($row);
Ron Gallant [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I get
Warning: Wrong parameter count for explode() in
/www/chizeledlight/test.php on line 39
when I use this code.
The line in error is
explode($row);
--
Crosswalkcentral [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I have a form of 1/2 customer data and the other 1/2 service info. that
the
custoemr fills out and when they submit it my php scrips adds the customer
infor to the customer table but it will not
Jeff Oien [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I'm having a hard time learning how to get an average. I have a database
that gets a number and inserts in into a MySQL database every 1/2 hour
during the day. For the current half hour, I want to get
Andrius Jakutis [EMAIL PROTECTED] wrote in
message 003d01c125c2$fa6487a0$40722fd4@mano">news:003d01c125c2$fa6487a0$40722fd4@mano...
1. How to make, that I could get output of only
those entries, which name(field) is John.
SELECT * FROM table WHERE name='John'
2. How to make, that only 10
Lars B. Jensen [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
depending on what you're replacing with what, a solution is eregi_replace.
I
do not advice to upper nor lowercase the source as it will change parts of
data unwantedly.
Yes, I agree; another
Schleipp [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hi everybody,
I have created a webpage with two frames. One of this frames is a form
in which the user can change some data, which you can see in the other
frame. I want the latter frame being updated as
Russ Michell [EMAIL PROTECTED] wrote in message
news:SIMEON.10108141609.F@k1c. anglia.ac.uk...
I just needed a similar thing to occur in my app!
Just reload the page using the header function:
Once submit has been hit in one frame, pass a hidden value from Frame1
to frame2:
input
Russ Michell [EMAIL PROTECTED] wrote in message
news:SIMEON.10108141754.G@k1c. anglia.ac.uk...
I don't see what this gains you.
Well you asked if there was a way to refresh your target frame once a
submission was made from an origin frame. This method would do that.
The question was
Jon Farmer [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
From: Johannes Janson [mailto:[EMAIL PROTECTED]]
Sent: 13 August 2001 12:15
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Re: Show abbreviated article
My question is this: how can I select only those
Alex.Tesi [EMAIL PROTECTED] wrote in message
003901c123fa$1ff2da50$[EMAIL PROTECTED]">news:003901c123fa$1ff2da50$[EMAIL PROTECTED]...
Hi i have a problem printing a lob field containing an image.
The database i use is Interbase 6.0
I have a blob/lob field with a gif image inside an i like to
Sharif Islam [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I am trying to caregorize to group at the same time, but its not working.
Any hints?
Here's my code:
$temp=Dummy;
while ($row = mysql_fetch_array($result))
{
if($temp !=$row[group_name]){
Cato Larsen [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Sheridan Saint-Michel [EMAIL PROTECTED] wrote in message
00df01c12400$ad2a1220$[EMAIL PROTECTED]">news:00df01c12400$ad2a1220$[EMAIL PROTECTED]...
From: Cato Larsen [EMAIL PROTECTED]
To: [EMAIL
- Original Message -
From: Sharif Islam [EMAIL PROTECTED]
To: Hugh Bothwell [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, August 13, 2001 11:50 AM
Subject: Re: [PHP-DB] Re: Group By problem
But its displaying the same as my code:
The SQL was just for reference, to make sure
Cato Larsen [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hey!
Thanks for the help Mr. Bothwell.
But now it seems I get a new error:
;-) The error of my ways is apparent - I typed
that off the top of my head, and I got bit by
my own bug - using unescaped
Cato Larsen [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Just to have said it... Im green in both PHP4 and MySQL.
Can anyone say what I've been doing wrong here, and how to fix it, or even
better. Debug the whole shit! =)
First, make sure PHP is actually
Steve Fitzgerald [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I'm trying to display a summary list of calls with one attribute being
CallType. I have CallType and CallTypeID defined in a table name
calltypes.
The problem I am having is taking the output of
Dave Carrera [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hi All
I would like to know how to count how many downloads of a file I have on
my
site is downloaded and display something like file.name downloaded
times on my page.
I have this idea using
Steve Fitzgerald [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
echo .$list[CallID]. .$list[CallDateTime]
^^^
Try removing the leading ' . '
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For
message:
Warning: Unable to load dynamic library './php_dba.so' - ./php_dba.so:
cannot open shared object file: No such file or directory in
/home/pat/html
I did a 'find / -name php_dba.so' and came up with nothing.
Thanks in advance for any help.
Hugh Bothwell [EMAIL PROTECTED] wrote in
Sharif Islam [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Is there any way, I can get only one output.But somehow I have to
incorpate it with the other data in that column, which doesn't have
multiple entry. Any hint? thanks in advance.
!DOCTYPE HTML
select * from table where date_format(timestamp, '%y%m%d') = '010801'
Jeff Oien [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I have a timestamp field that looks like this
0109011754
but I only want to compare
010801
when doing a SELECT. Is there a way I
Steve Fitzgerald [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
What is the best method for avoiding multiple ids for the same
information.
For example: I have a table name company that has unique ids. The
CompanyID
are tied to a table name contacts which
Donovan J. Edye [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
G'Day All,
I need to establish connectivity between a Debain Linux box running PHP
4.06 and Oracle 8i running on a Win32 box. Can someone point me at some
FAQ's or other help. At present I have
Adam Lundrigan [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
What i need to do is select 10 questions from a database
(db: vpt, table: questions), and make sure that the same
question doesn't appear twice. The questions need to
appear in a random order
Patrick Callihan [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
HI,
I have compiled php4 with the following command:
/configure' '--with-mysql' '--with-apache=../apache_1.3.20'
'--enable-track-vars' '--enable-tans-sid' '--enable-dba
The function dba_open()
Koutsogiannopoulos Karolos [EMAIL PROTECTED] wrote in
message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I wan't your opinion regarding a program i am constructing. It is about an
image bank for graphic studios or anyone else who needs a program that can
insert his pictures or descriptions
Olinux O [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hi all,
I would like to display messages that are entered into
a database since the last time i checked it. [Much
like web based email marks NEW messages.]
What is the best way to do this? By adding an
Mike Gifford [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
The problem is that I am only getting one response from this query rather
than
5. I can't figure this out. What did I do to only get one response?
Try removing the ORDER BY and LIMIT and run the
Steve Fitzgerald [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I'm trying to create a join statement that pulls out a CompanyName based
on a given CompanyID that is tied to a specified ContactID.
For example, if ContactID=1 then the corresponding CompanyName
Kenn Murrah [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I'm trying to concatenate several values entered in my form, then write
them
to a TEXT field in my mySQL database. All is well, except that I want to
each value to appear on a different line. I've
Sharif Islam [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I am still trying to figure out how to do it. I want to display my result
from the data base in tree/menu like system.
Could you give us your SELECT statement and one row of returned data?
So the
Sommai Fongnamthip [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Dear,
How could I draw graph with gd by using PHP code with custom log scale?
How 'bout:
function drawLogGraph($arr) {
$xoffs = 20;
$yoffs = 180;
$drawwidth = 160;
$drawheight =
Umm... 31 entries, 1 x 31...
You might be better to choose a standard width and pad the last row with
empty cells.
Ian Grant [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hi,
Can anyone help me with this - I have a database of people, that I want to
print
Couple of comments:
1. What's with the $artist = artist; echo $mytable[$artist]; bit?
This really doesn't seem to gain you much.
2. Descriptive variable names are a Good Thing(tm).
3. Prettyprinting
4. Why are the tables in different databases to begin with?
5. Don't pull any more than
Sommai Fongnamthip [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hi,
I decide to make real time application (like stock market or online
news). How could I know when new data arrive to table and retrieve them
to
display or update in web page?
You can't,
McShen [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
how do i store multiple data in one field?
i have a table like this
+---+---+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
Try setting form.action and using form.submit() to send it ('edit.php' is
not valid javascript).
Here:
htmlheadscript!--
function submitTo(form, url) {
form.action = url;
form.submit();
}
--/script/headbody
form name=f action=submit.php
input type=submit
Ken Sommers [EMAIL PROTECTED] wrote in message
001001c107e2$b84ad5c0$aa42500c@zeospantera">news:001001c107e2$b84ad5c0$aa42500c@zeospantera...
Has anyone successfully mapped their browser to a Remote Server?
Please show your:
map from:
C:\Program Files\Apache Group\Apache\htdocs\
Map to:
- Original Message -
From: Ken Sommers [EMAIL PROTECTED]
To: PHP DB Mailing List [EMAIL PROTECTED]; Hugh Bothwell
[EMAIL PROTECTED]
Sent: Sunday, July 08, 2001 5:30 PM
Subject: Re: [PHP-DB] Re: Homesite Server Mapping
Thanks alot,
that mapping works for me too: I use
From: C
Noah Spitzer-Williams [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]...
i have two tables each with a same field and i would like to find which
table has the bigger value in this field..
is there a way to do this with one select statement?
i've tried things like:
select
How many rows are you likely to have, and how dynamic are the weights?
I think I'd add a cumulative sum column to your table, ie
idweightcum_weight
11010
25 15
3318
42038
52
How about this?
define(SECONDS_PER_DAY, 86400);
$now = (int) (time() / SECONDS_PER_DAY);
Note that this may not match the time you get from your database server,
depending on what time zones you're in.
David W. Banks [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL
From: olinux o [EMAIL PROTECTED]
To: Hugh Bothwell [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, June 29, 2001 10:25 PM
Subject: Re: [PHP-DB] Passing XML
Is this what you have in mind?
$url = 'http://website.com/document.xml';
$str = implode('', file($url));
$str = contains the xml
Consider using set_time_limit() before each sub-script executes; this will
time out on any individual script, but let you extend the limit on the
master script.
Lisa Elita [EMAIL PROTECTED] wrote in message
Um... you could look at REMOTE_HOST to get their IP address and use that to
look up the address of their server. If you assume they won't log in
long-distance, that should give you their country and state, and maybe a
useful approximation of their city.
Lisa Elita [EMAIL PROTECTED] wrote in
1 - 100 of 105 matches
Mail list logo