Niel Archer wrote:
> Hi
>
> use a LIMIT clause in your SQL. Something like:
>
> $query="SELECT * FROM WHERE hello = '$hello' LIMIT " . ($page - 1) *
> $rows . ", $rows";
>
> then you only need specify the logic to set the page, row and
> limitations
>
>
You also typically need to use the
Forgive me for saying this, but you should be posting this to the Oracle
mailing list, not here.
David Skyers wrote:
> Hello,
>
> I have an input field that inserts data into an oracle table. The users
> of the system will be composing the data that goes into this input field
> in Microsoft Word.
BTW, not to shill, but if somebody needs a free LAMP system, you can go to
http://www.110mb.com
-Original Message-
From: Miles Thompson [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 10, 2006 5:56 AM
To: PHP DB
Subject: Re: [PHP-DB] Can you recommend Australian LAMP web hosting service
Sorry, this should have gone to PHP-general, my bad.
Wouldn't this:
$id = mysql_insert_id();
$query = "UPDATE tablename SET id=" . ($id + 1);
$result = mysql_query($query);
Be a little simpler.
But like I said, I'm confused over the need for this in the first place,
seeing as how an "auto_incremented" primary key is self-descriptive. or are
you sav
Dave W wrote:
No, I get it. I just thought that there might have been some built in
function like if(neg_num($quant - $amount))
or something like that. I know how to do it, but I thought that there
might
have been an alternate method. Just because I asked a simple question
doesn't mean I'm stup
Mark Bomgardner wrote:
I am query a database and pulling some decimal values out of the table,
but when I display whole numbers in php, it drops the decimal places.
It takes a value of 12.00 in the database and makes it 12, where I need
12.00. I am having trouble finding ways to "cast" this val
Is there any way to filter out Chinese or Asian characters from what I
get from this list? I understand that there are a lot of intelligent,
well-meaning Asians on this list but my system seems to get Montezuma's
revenge when I look at those e-mails.
--
Online library -- http://pueblonative.11
Manoj Singh wrote:
Hello All,
Is it possible to run the Linux Commands through php functions or code?
If anyone knows, please help me out.
Regards
Manoj
http://www.php.net/exec
BTW, this is very risky and exposes your server to attacks. Try to find
an alternative first before you let hac
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hayri wrote:
> can somebody tell me what the hell does mysql_fetch_assoc do ???
>
> thx
It fetches a row of a result as an associative array (hash), the same as
mysql_fetch_array($retval,MYSQL_ASSOC).
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Gavin Amm wrote:
> I'd like to avoid having to manually add all of the cols to the select
> statement if possible, so if there's a universal command I can put in
> that'd be best.
In that case, what I would do is just do your SELECT statement, sans th
Gavin Amm wrote:
> How do I limit the characters a Select statement returns?
> In Seudo code:
> SELECT * FROM myTable LIMITCHARS 30;
>
> I'm using MySQL.
>
> Thanks.
>
Do you want to limit the characters from an individual field? If so, then
SELECT SUBSTRING(FIELD1 FROM 1 FOR 30) FROM myTable
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Flint Million wrote:
> Good idea. OK so I'll create a new database with subject ID's. Now, back in
> the primary database, how can I have multiple subjects assigned to one book?
> Let's say I repeat my above example and we assign "Nonfiction" to 1,
> "
Flint Million wrote:
> Now I want to be able to do a subject listing as well as a search. For
> example, if I asked for a lsit of all subjects, I want something like:
> Nonfiction (2)
> PHP (1)
> Technology (2)
> Computers (1)
> Programming (1)
> History (1)
> Linux (1)
>
In database design, I'd
Peter Beckman wrote:
So I'm thinking about how to save credit card numbers in the DB, for
re-charging cards for subscriptions, new orders, etc.
Why, is the first question I would ask you. First off, on a new order,
why wouldn't you just save the authorization code, instead of the credit
card
On Monday 02 January 2006 8:54 pm, Ralph wrote:
> I'm building a URL based on data extracted from mySQL and I want the
> text space.gif used as my default value should the variable $picture
> by NULL.
>
> The results of the code below kick back a value for $picture when it
> is set in the database,
On Wednesday 28 December 2005 7:27 am, Rory Browne wrote:
> It'd probably be handier to use the continious file.
>
> htmldoc can be used as a gui app, so if you don't want to read the
> instructions, then that would probably be handiest.
No I want to read the instructions. And how many pages shoul
On Tuesday 27 December 2005 4:07 pm, James Lumb wrote:
> Hi,
> Does anyway know whether there is a PHP function which creates a new file?
> i know there is fwrite, fopen etc but is there any way of creating a new
> file? Thanks,
> James
>
fopen() will create a new file if you open it for writing a
On Tuesday 27 December 2005 1:13 pm, [EMAIL PROTECTED] wrote:
> Oh boy.. here we go.. hah.. can we refrain from a giant anti-Microsoft
> war type thing?
Just making a joke about the anti-Microsoft feelings out there.
--
Dr. Joseph Dolan: Isn't there a children's book about an elephant named Baba
[EMAIL PROTECTED] is bouncing e-mails.
--
Dr. Joseph Dolan: Isn't there a children's book about an elephant named Babar?
Fletch: I don't know. I don't have any.
Dr. Joseph Dolan: No children?
Fletch: No, elephant books.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit
On Tuesday 27 December 2005 7:01 am, William Stokes wrote:
> I think I need some help/ideas with this...
>
> If I can get this done how can I still display the dates in european format
> at my web page? Do I have to break the date to pieces and some how
> re-arrange it to the DD.MM. format or
On Tuesday 27 December 2005 2:00 am, Rory Browne wrote:
> /me thinks that the OP needs to DL the html.gz manual, procure
> htmldoc, chant the magic incantation(i.e. type in the correct
> command), and wait for his PDF document to appear.
okay, I'll bite, what the hell is htmldoc
--
Dr. Joseph Do
On Monday 26 December 2005 6:40 pm, adriano ghezzi wrote:
> pls could you point out which instruction should insert record in db
> thanks...
>
> 2005/12/18, Anasta <[EMAIL PROTECTED]>:
> > $sql = "UPDATE leaderboard SET Name='$Name', Rating='$Rating' WHERE
> > ID=$id";
Um, do you have the option
On Sunday 25 December 2005 3:01 pm, Thomas Bonham wrote:
> Hello,
>
> I am trying to insert a php page into a database. I need to know if
> there is something that I need to do when setting up the table, also is
> there something to do with the code.
>
> Thank You for your help
>
> Thomas
Well, y
On Thursday 22 December 2005 1:38 pm, Alex Major wrote:
> Hi there.
> I'm trying to make a scrolling news box for my website. Basically I would
> like this news box to get information from a column in my database called
> 'news_title' and display it in a scrolling news box.
> The reason I'd like it
25 matches
Mail list logo