omic
> > > Agriculture
> > >
> > > Computers
> > >
> > >
> >
> > Also, you shouldn't have all of the radio buttons associated with the
> > same variable checked. In fact, if this is a quiz, none should be
> > checked
If the threadID column is an int, you don't need to wrap the $threadID
variable in quotes.
HTH ~randy
On Tue, 14 Sep 2004 00:05:56 +0200, -{ Rene Brehmer }-
<[EMAIL PROTECTED]> wrote:
> hi gang
>
> I'm working on optimizing the SQL for my forum system, but have run i
ll it).
$sql = "SELECT * FROM $table"; // works
$sql = 'SELECT * FROM '.$table; // works
$sql = 'SELECT * FROM $table'; // doesn't work
randy
--
randy [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I'm confused. How does this pertain to php-db? Let's keep this shit
off the list please.
Yours Truely,
Randy
On Sun, 5 Sep 2004 17:47:15 +0200, Torsten Roehr <[EMAIL PROTECTED]> wrote:
> "Theeb Basheer" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL
You can get rid of the open paren in the echo statement.
randy
On Wed, 1 Sep 2004 10:24:07 -0700 (PDT), Judy Picard
<[EMAIL PROTECTED]> wrote:
>
> --- Judy Picard <[EMAIL PROTECTED]> wrote:
>
> > Date: Wed, 1 Sep 2004 09:25:08 -0700 (PDT)
> > Fr
l/bin/mysql everytime you want
to use the command line).
>
> Again, please excuse my ignorance, but here is an opp to educate those of us stuck
> in a MS POV. Thank you in advance.
NP. Hope this helps.
>
> Michael
--
randy [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
or die(mysql_error());
>
> //create nice message for user
> $msg = "The $topic_title topic has been created.";
> ?>
>
>
> New Topic Added
>
>
> New Topic Added
>
>
>
> -
> Form code
> --
>
> include 'menufile.php';
> ?>
>
>
> Add a Topic
>
>
> Add a Topic
>
> Your E-Mail Address:
>
> Topic Title:
>
> Post Text:
>
>
>
>
>
>
--
randy [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
---
> Search the list archives before you post
> http://marc.theaimsgroup.com/?l=php-db
> --
> /*
> Left to themselves, things tend to go from bad to worse.
> */
>
>
>
> --
> PHP Database
7;t know how to enter in LF or
> > CR in a vim search string.
> >
> > Hope this clarifies.
> >
>
> --
>
> Michael Cortes
> Fort LeBoeuf School District
> 34 East Ninth Street
> PO Box 810
> Waterford PA 16441-0810
> 814.796.4795
>
>
Lgui.exe, it still gives me the same problem...
>
--
randy [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
yeah yeah...it's damn near 4 in the morning here...my brain isn't
exactly on at the moment.
:)
On Wed, 18 Aug 2004 11:35:59 +0100, Ford, Mike [LSS]
<[EMAIL PROTECTED]> wrote:
> On 18 August 2004 11:24, randy wrote:
>
> > $chkboxes = $_POST['ch
t;
>
> How about showing us some code kind of hard to help without that...
>
> --
>
> ---John Holmes...
>
> Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/
>
> php|architect: The Magazine for PHP Professionals â www.phparch.com
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
randy [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
ne formed incorrectly for an XLS file, can anyone see if
> I need to use any special characters rather than a comma?
>
> fwrite($filesession,"$id,$new,$recno,$category,$product,$description,$unit,$
> certificate,$instock,$orderpt,$ordernow,$vendor,$unitcost,$unitsell\015\012"
called if an assertion fails.
> ;assert.callback = 0
>
> ; Eval the expression with current error_reporting(). Set to true if you want
> ; error_reporting(0) around the eval().
> ;assert.quiet_eval = 0
>
> [Ingres II]
> ; Allow or prevent persistent links.
> ingres.al
t find a solution to get it work.
> >>
> >>Is there way to get it work?
> >>
> >>Regards
> >>Dani
>
>
> CaptionKit http://www.captionkit.com : Production tools
> for accessible subtitled in
By Shiloh's description, I think you want to replace AND with OR -
using AND will only return rows that contains every word, while using
OR will match any row that has any of them.
On Wed, 30 Jun 2004 23:22:04 -0400, John W. Holmes
<[EMAIL PROTECTED]> wrote:
> For that simple example, you can just
I'm not sure where the value of $counter is coming from, but it you're
getting it from a SQL SELECT query, it would be more efficient to just
use:
UPDATE statistics SET VALUE(`counter` = `counter`+1)
It's just one less query on the DB, which could make a difference if
you're getting heavy traffic.
I have a form which captures US addresses ( address, city, state ) and
telephone numbers ( 10 digit ) and am writing this data to a MySQL table. I
need to expand this to capture non-US info, so I was hoping for some
guidance on forms and table structures. I have googled this to death and
still have
'textually', but he is _determined_ that he must have the graphic 'drag and
drop' feature.
There may be another method ( Javascript ? ) to accomplish the same effect.
I am certainly open to any advice and/or opinions. Any pointers would be
_greatly_ appreciated.
Thanks,
Randy Rankin
ALUES ($tmp, $td )";
Randy
-Original Message-
From: Rankin, Randy [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 04, 2003 1:56 PM
To: '[EMAIL PROTECTED]'
Subject: RE: [PHP-DB] Datetime help in an INSERT...
If you are using MySql with the date field is of type timestamp, you s
If you are using MySql with the date field is of type timestamp, you should
have to insert anything using the query. It will update automatically when
the record is inserted and/or updated.
ie; $denylog = "INSERT INTO deny (account, td ) VALUES ($tmp, $td )";
Randy
-Origin
t3!=$row['cat3']) {
$indent="3-";
$cat3=$row['cat3'];
echo "$indent $cat3";
}
}
Hope that helps.
--
Best regards,
Randy
Wednesday, March 26, 2003, 8:18:50 PM, you wrote:
> I have a table with
Thanks to everyone for your help. I was able to work out the logic last
night based on your fine suggestions and all is well!
Thanks again.
Randy
> -Original Message-
> From: "1LT John W. Holmes" <[EMAIL PROTECTED]>
> Sent: Monday, March 03, 200
remaining cars, originally numbered 1-29 would become 2-30.
I hope I explained thourougly. Any suggestions would be appreciated.
Randy
store the first id? When
would you want that?
------
Randy Phillips www.phillips-it.com
phillipsIT, L.L.C. voice: 636.390.9468
Senior Web Developer
a single insert statement, or does it
matter?
--
Randy Phillips www.phillips-it.com
phillipsIT, L.L.C. voice: 636.390.9468
Senio
.
Thanks,
--
Randy Phillips www.phillips-it.com
phillipsIT Voice: 636.390.9468
Senior Web DevelopereFax: 501.423.3817
be great to hear from you.
Thanks again for all your help!
Randy
- BEGIN CODE --
image_bin_data;
$new_w=75;
$new_h=75;
Header("Content-type: image/png");
$src_img=@ImageCreateFromString($image);
$dst_img=@ImageCreate($new_w, $new_h);
ImageCopyResample
Thanks Marco!
It's working now. Based on your suggestion, here is waht I came up with.
It's working now.
Randy
SNIP
Tra
first record
of each array is not being echoed. If I run the query in MySQL, all rows are
returned, so it must just be something I am not seeing in the code (which is
posted below). Thanks in advance for any help.
Randy
-- START EXAMPLE
group based on the
group_id? How would I loop through to create a table for each group?
Thanks inadvance for any help.
Randy Rankin
te
FROM training
This produces the following:
start_date: September 16, 2002
end_date: Sepetember 20, 2001
Based on the above, I would like to echo out something like this:
You will be in training September 16 - 20, 2002.
Is this possible?
Th
Nato,
Try something like this:
$num = mysql_numrows($result);
if ($num == 0)
{
echo "There were no records found.";
}
else
while ...
-Original Message-
From: Natividad Castro [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 24, 2002 11
If anyone is interested, this is what I finally came up with. I'm not sure
how graceful it is, but it works ;)
";
echo "End of Period: $period_last_day";
?>
-Original Message-----
From: Rankin, Randy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 19, 2002 8:57
I am trying to
determine these dates for a report that generates previous quarter sales
based on today (whatever 'today' might be). Hope that's clear.
Thanks in advance,
Randy Rankin
Try this:
$six_months_from_now = date("Y-m-d", mktime(0,0,0, date(m)+6, date(1),
date(Y)));
echo "Six Months From Now: $six_months_from_now";
-Original Message-
From: its me [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 17, 2002 12:28 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] increase
]";
}
?>
-----
Randy
-Original Message-
From: chad kellerman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 14, 2002 6:47 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] creating a drop down menu from mysql categories
Hello everyone,
I am a little new to the list. I have been reading a lot of t
ox. Based on the user selection, the 2nd
drop down box would be populated with the distinct 'make' for that model
(ie; if the user selects Ford in the first drop down, the 2nd drop down
would be populated with Explorer, Expedition, Ranger, etc.).
Thanks,
Randy Rankin
| $100 | $200 | $300 | $300 | $300 | $300 | $300 |
Widget 2 | $300 | $200 | $500 | $300 | $300 | $300 | $300 |
.
.
.
I have posted order_summary.php below.
Any thoughts?
Thanks,
Randy Rankin
order_summary.php
>> Why are you iterating through the array?
Inexperience.
Thanks for the help guys. I'll give it a try.
Randy
-Original Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 13, 2002 11:43 AM
To: 'David Fudge'; [EMAIL PROTECTED]
Subjec
uld like to grab the first and last record in the
array so that the final result would be to echo something like "This report
is from $start_period through $end_period".
Hope that makes sense ...
Thanks in advance for any help.
Randy Rankin
Nevermind, I figured it out. There was a duplicate OCIfetchinto statement
in the script.
Randy
-Original Message-
From: Rankin, Randy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 12, 2001 10:12 AM
To: PHP List
Cc: Barker, John
Subject: [PHP-DB] OCI Query Results
We are using
in the result set. Does anyone have any thoughts. I can post code
sample if needed.
Randy
I am in need of someone that is very good at PHP and MySQL to view my
scripts and discuss with me in detail on how to speed up my scripts and how
to speed up mysql some. if you are interested please send me credentials
and rates ASAP please send them to [EMAIL PROTECTED]
Thank you,
Randy
of a connect script that I run using
OCI calls:
<%
$connection = OCILogon ("user","pass","sid");
if ($connection == false)
{echo OCIError($connection)."";
exit;
}
OCILogoff ($connection);
%>
Hope that helps,
Did you install the Oracle client?
-Original Message-
From: Tom Tsongas [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 07, 2001 11:53 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] OCI support not functioning
Hi folks. I posted on the install board but I figured I would run this
by the gu
ecute a query with a table name like v$instance?
TIA,
Randy Rankin
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
again everybody!!
Randy Rankin
-Original Message-
From: Ken Sommers [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 12, 2001 10:27 PM
To: Rankin, Randy; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Escaping &
Please explain the dynamic link .
is that in the documentation somewhere>
und for X" where X is the letter immediately preceding the
ampersand.
Does anyone know how to get around this?
TIA,
Randy Rankin
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list
http://www.microsoft.com/KB/Articles/Q128/8/08.HTM
-Original Message-
From: Dalyyla [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 22, 2001 7:32 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] odbc with ms access
hi,
Access to data with ms access via odbc is kinda slow . I would like to
kn
.
Thanks in advance,
Randy Rankin
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
to do is assign the results of the field real_name to a variable
called $salesperson, but I cannot seem to get it to work.
Thanks inadvance for your help,
Randy Rankin
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mai
Try this:
http://www.devshed.com/Server_Side/PHP/SoothinglySeamless/
Randy Rankin
Ben Cairns wrote:
>
> I have nearly 18 Months devel on Windows, but we are now moving to Linux,
>
> I have never installed PHP On Linux before, so could someone pls give me
an
> 'Installat
Does the Connection ID change if I use persistent connection through PHP
using mysql_pconnect()?
Is it possible to retrieve CONNECTION_ID() this though PHP?
-Original Message-
From: The Tilghman [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 29, 2001 4:31 PM
To: 'Randy Jo
When I run any kind of query this is the value of result Resource id #2
Example
$result= mysql_query (" Select * from ACCT_TBL ") or die
("Error".mysql_error());
print result;
any ideas?
randy
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-ma
uestion is will result be equal to "" if the query statement doesn't
return any data?
thanks
randy
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
56 matches
Mail list logo