k. If it's an
application that, especially, is accessible on the internet, you definitely
need to validate and ensure that you're receiving sane input.
--
Gary
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
ble is
defined. How are you assigning the values to the variables that you are trying
to insert into the database? Do you have register_globals enabled?
--
Gary
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
/* Release the resources */
pg_free_result($query_resources[0]);
pg_free_result($query_resources[1]);
pg_free_result($query_resources[2]);
return true;
}
Any comments, criticisms, or suggestions are very much appreciated.
Thank you,
Gary Chambers
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
.
I have been looking over the manual and boards but am not finding a
solution.
Can anyone point me in the right direction.
--
Gary
__ Information from ESET Smart Security, version of virus signature
database 5952 (20110314) __
The message was checked by ESET Smart Secu
ot;;
print "\n";
}
This is the page that I am unable to get to call the checkbox selections
" ;*/
}
echo "$choice";
/*echo $_SESSION['county$i'];
echo $_SESSION['counties'];
echo $_SESSION['name'];
echo "$count_choice";
echo &
of virus
> signature database 5078 (20100501) __
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
>
Ron
Take a peek at this
http://fpdf.org/
Writing to a pdf from php is very cumbersome, this seems to take some of the
sting out.
Ga
Has anyone found anything in their travels around the web?
The manual is okay, but the examples are so simplistic it's difficult
to understand how it should really be used. For example, if I have a
loop of pg_send_execute based INSERT statements inside a transaction*,
and one of them fails, how an
On 4/22/10, Niel Archer wrote:
>> What could be causing this please? Going direct, using pg_connect, is
>> not a problem.
> Make sure you have the PDO
> postgres driver enabled in your php.ini, it does not use the same driver
> as the Postgres extension.
Aha! Okay, thanks! It's working now...
--
What could be causing this please? Going direct, using pg_connect, is
not a problem.
The code in question looks like
$pdo = new PDO('pgsql:host=localhost;port=5432;dbname=mydb', 'dbuser',
'dbpass');
(I think - I've yet to be able to debug it down to a single line)
--
PHP Database Mailing List (h
On Tue, Apr 13, 2010 at 10:40 AM, Firan Corneliu wrote:
> Are you sure you're not using q instead of g :)
Err. My first thought was "What a strange thing to ask." Then I looked...
Thanks. I'd been looking at that for a good hour or so... *embarrassed*
--
PHP Database Mailing List (http://www.ph
What the...
What is causing this? I can use "pg_connect" without complaint, why
does pq_query give this problem? PHP 5.3.1 FWIW.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On 4/13/10, Chris wrote:
> Gary . wrote:
>> Is it possible to skip column(s) in the target table when using
>> pg_copy_from?
...
> It seems not from looking at the php manual.
>
> You could use http://www.php.net/manual/en/function.pg-put-line.php instead.
Yeah. I was ho
Is it possible to skip column(s) in the target table when using
pg_copy_from? When I tried to bulk insert some data from a csv
file by way of pg_copy_from I received the error "Warning:
pg_copy_from() [function.pg-copy-from]: Copy command failed:
ERROR: permission denied for relation xyz", pretty m
tted the form about 12 times per
second.
Any thoughts?
Gary
__ Information from ESET Smart Security, version of virus signature
database 4895 (20100225) __
The message was checked by ESET Smart Security.
http://www.eset.com
--
PHP Database Mailing List (http://w
Daniel,
Now that is just funny stuff...
Have you tried
http://lmgtfy.com/?q=access+denied+for+user+odbc+localhost
or the newer
http://www.lmbify.com/search.php?s=access+denied+for+user+odbc+localhost
"Daniel Brown" wrote in message
news:ab5568160906180636r239f214eh7e4871da7139c...@mail.g
Hi,
I don't know of a tool, although there may be one.
If the pages are really simple I would think that it wouldn't be that hard to
redo them by hand.
Gary
> -Original Message-
> From: Koller Michel [mailto:[EMAIL PROTECTED]
> Sent: Thu, May 08, 2008 7
Hi,
I suggest you echo $del_str to see exactly what your query is.
There may be something unexpected in $_GET['Id'].
Echo the whole query so you can see everything in context.
Gary
> -Original Message-
> From: Javier Viegas [mailto:[EMAIL PROTECTED]
> Sent: Tue, Apr
to be changed to set the proper port number? (My guess
is probably)
Or is the host you're trying to connect to unreachable?
Or is the port being blocked by a firewall?
Once you get the connection working you can remove the echo.
Gary
> -Original Message-
> From: gary balka
_html/baddblog/wp-config.php:11)
in
/hermes/bosweb/web250/b2508/ipw.testgbalkam/public_html/baddblog/wp-includes/functions.php
on line 1438
Error establishing a database connection
- Original Message -
From: "Gary Wardell" <[EMAIL PROTECTED]>
To: "'gary ba
I'm pretty new to php and mysql. And I just found this news group about 4
minutes ago.
What I need to know, is how do I connect a wordpress application, located on
a web server to a database located on my own computer. The reason for doing
this instead of syncing the dbs is the Sql server on t
I know the feeling.
I've been trying to hookup MYSQL as a linked server on MS SQL Server. There
are a few articles out there that make mention of it
but no where does anybody say exactly how to do it.
Gary
> -Original Message-
> From: Graham Cossey [mailto:[EMAIL PROTEC
Ahh, to bad, I started using it with 5.0. I'm also a long time user of SQL
Server.
Sorry if I caused confusion.
Gary
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi,
The way I think I'd approach it is to use an outer join where table a is joined
to a subquery where the subquery returns only the
max timestamp from table b.
Gary
> -Original Message-
> From: Graham Cossey [mailto:[EMAIL PROTECTED]
> Sent: Thu, March 06, 2008 5:17 PM
tely independent.
>
Assuming that they are interacting through forms on the pages in the different
windows, why not put the UID of the record they are
accessing in a hidden field in the form?
Gary
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
PROTECTED] <-- 3 *fields*
Chris Carter,[EMAIL PROTECTED] <-- 2 *fields*
And both only result in one record for each CSV line?
Or do PHP and MySql handle CSV files different from most other applications?
Gary
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
password from the logon and compare
the encrypted versions; rather than decrypting for
the compare.
Gary
> -Original Message-
> From: Nasreen Laghari [mailto:[EMAIL PROTECTED]
> Sent: Sat, February 16, 2008 10:18 PM
> To: php-db@lists.php.net
> Subject: [PHP-DB] Pass
BC timeout to 10
seconds, but that doesn't change the socket timeout. It will still wait for
the 30 or 60 seconds, or whatever it is, before
abandoning the socket.
This is a Windows thing and has to do with the way they implemented sockets.
Gary
> -Original Message-
> From: iOD
the code is wrong but
didn't know why, which is why I didn't respond earlier.
Gary
> -Original Message-
> From: Peter Westergaard [mailto:[EMAIL PROTECTED] Behalf Of
> Peter Westergaard
> Sent: Tue, January 08, 2008 11:09 AM
> To: php-db@lists.php.net
> Subject:
Or even if it's not in a table, put a div around it and use: style="
text-align: right " or equivalent css
Of course this assumes he's using html to display it.
Gary
> -Original Message-
> From: Bastien Koert [mailto:[EMAIL PROTECTED]
> Sent: Tue, J
tions?
Also, in terms of the developer, would this be covered under errors and
omissions insurance, or would they take the position that
the developer should have known better and was negligent in creating a
non-compliant system leaving the developer on the hook for
damages?
Gary
> -
That's 3DES, or
triple DES, not DES)
But like Chris said: if you don't have to, dont do it.
But if you must, encrypt all of the personal information data points, not just
the CC info.
Gary
> -Original Message-
> From: Chris [mailto:[EMAIL PROTECTED]
> Sent: Tue, December 18
Hi,
I'm a beginner at PHP and MySql but a long time MS SQL server user.
Maybe it should be `advertisements`.`displayed` instead?
I just did a test and my Query browser doesn't like `interestcodes.id` but
likes `interestcodes`.`id`. Notice the quotes
(accents) on each side to the per
that perhaps the IP address of
the web server has changed. Either way, whatever authentication is used may
need to be looked at and corrected.
I can't think of anything else that might be the problem.
Gary
> -Original Message-
> From: Tim Daff [mailto:[EMAIL PROTECTED]
> Sen
I agree with this. Never use a subquery when a join will work. The
optimizer with thank you with performance.
James Ausmus wrote:
On 10/3/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hi J,
Checkout this,
SELECT * FROM tbl_company where id not in (SELECT companyID from
tbl_contacts)
I know you really meant :
${"image".($key+1)} = $_FILES['pictures']['name'][$key];
And it works!!!
Thanks oh so very much!
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 30, 2006 11:46 PM
To: Gary E. Terry
Cc: php-db@l
OK.. I am a moron.. Forgot that I had changed the name of the field in the
form, and got sidetracked and didn't change it in the
php... But, still not working correctly.
Here is the output: Array -- Array -- Array
from:
$error) {
if ($error == UPLOAD_ERR_OK) {
echo "$error_codes[
Nope... here is the output.
"-- -- Array ( [error] => )"
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 30, 2006 10:56 PM
To: Gary E. Terry
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] Arrays from forms
Gary E. Terry wrote:
>
quot;;
/*
$query = "INSERT INTO `inventory` (`make`, `model`, `year`, `color`,
`description`, `image1`, `image2`, `image3`, `status`)
VALUES ('$make', '$model', '$year', '$color', '$description',
'$image1', '$image2&#x
ssage-
From: Chris [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 30, 2006 10:10 PM
To: Gary E. Terry
Cc: PHP DB
Subject: Re: [PHP-DB] Arrays from forms....
Gary E. Terry wrote:
> I don't know if we are on the same page here... Maybe we are and I am just
> an idiot.
>
> T
I have a problem. I have done this before, but can't find the files.
I am using the following function to upload files from a form.
foreach ($_FILES["pictures"]["error"] as $key => $error) {
if ($error == UPLOAD_ERR_OK) {
echo "$error_codes[$error]";
move_uploaded_file(
I need to compare PHP 4 code with PHP 5 interpreter on same machine.
I am following the examples in Adam Trachtenberg's Upgrading to PHP 5
(O'Reilly 2004) listed in "Appendix C: Installing PHP 5 Alongside PHP 4"
with regard to using virtual hosting and relative ports on Apache httpd.
I have also r
pare it down to your needs, but it's really a cure-all when what you
need is an abstraction layer that works for YOUR needs!
Don't be afraid to try slimming it down, but I'd keep an original copy
somewhere in case you find that your paring knife was a little too
sharp!!
G.~
Gary
27;,'$password','$datetoday'
,'$datetoday','$expirydate','123.123.123.123')";
Gary Every
Sr. UNIX Administrator
Ingram Entertainment Inc.
2 Ingram Blvd, La Vergne, TN 37089
"Pay It Forward!"
-Original Message-
From: HarryG
Got a question can one send a full array to another page with out
having out put each value stored in it manually?
On Sun, 03 Oct 2004 05:54:54 +0530, Amit Arora
<[EMAIL PROTECTED]> wrote:
> You can set this to anything you want.
>
> http://www.url.com?new_field=value
>
> And you can get the va
I have a page where I need to access two different databases in mysql.
After accessing the first database I used mysql_close($connection);
and then code to access the other database. The first database access
works fine, the second gives me the following error message:
*Warning*: mysql_query(
Check to see if your register_globals is set to off in php.ini. If so
(likely, since it defaults to that value) you'll need to access your
POST and GET variables like this:
GET vars:
$var = $_GET['var'];
POST vars:
$var = $_POST['var'];
Gary Every
Sr. UNIX Administr
a sql statement, etc I assign $line_no = __LINE__ and if an exception
gets thrown, the $line_no is captured, and I can use the info to print
to the logs or the screen or ...
G.
Gary Every
Sr. UNIX Administrator
Ingram Entertainment Inc.
2 Ingram Blvd, La Vergne, TN 37089
"Pay It Forward!"
K, first off I'm brand new to PHP and databases. So I
hope my question isn't stupid or unfitting to the
list.
Welcome! Only those that don't ask are unfitting
I am creating a "search and results" page of, right
now 3 fields with more to add.
Perhaps not necessary to my question, I have c
ry, the " " is
just putting a space inside the query, and it is valid
Gary Every
Sr. UNIX Administrator
Ingram Entertainment Inc.
2 Ingram Blvd, La Vergne, TN 37089
"Pay It Forward!"
-Original Message-
From: Stuart Felenstein [mailto:[EMAIL PROTECTED]
Sent: Wednesday, S
You need to add slashes to your return:
Return "";
Or use single quotes:
Return '';
Gary Every
Sr. UNIX Administrator
Ingram Entertainment Inc.
2 Ingram Blvd, La Vergne, TN 37089
"Pay It Forward!"
-Original Message-
From: Hafidz Abdullah [mailto:[E
The answer to that is SPEED. Nothing short of Oracle comes even
close
Gary Every
Sr. UNIX Administrator
Ingram Entertainment Inc.
2 Ingram Blvd, La Vergne, TN 37089
"Pay It Forward!"
-Original Message-
From: Lester Caine [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August
7;) {
$last_name = $_POST['last_name'];
$sql_start .= "last_name LIKE '%$last_name%' AND ";
}
... ## for the rest of the fields
// Trim off the last AND
$sql = rtrim($sql_start," AND ");
And then do the $sql
Gary Every
Sr. UNIX Admini
Fixed my own problem.
Within the tag, you can use "autocomplete=off"
To turn off the prompting or the autocompletion of any field. Apologize
for this off-topic post, but I was searching for a non-javascript
server-side solution
Gary Every
Sr. UNIX Administrator
Ingram Entertainm
I'm trying to turn off the save password function so that I can do an
auth page that refuses to save passwords on the client side. I've tried
some JS but it works only in IE, not Netscape.
So, I'm looking for a server-side solution to this.
Any ideas?
Gary Every
Sr. UNIX Admin
e1 that have an
associated name in table2 as well as the date (NOW())
It will have no indexes, though, so you could use the ALTER TABLE
command after it was created.
See :
http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html
for more info on the create table syntax
Gary Every
Sr. UNIX Admin
If you aren't using a unique key, you can always use "LIMIT 1" at the
end of your query, but unless your ORDERing correctly to get the exact
data row you want to update, this can have unexpected results.
Gary Every
Sr. UNIX Administrator
Ingram Entertainment Inc.
2 Ingram Blvd
Here's a quick and easy one though:
"SELECT * from your_table WHERE your_date_field BETWEEN '2004-06-01' AND
'2004-06-15'";
Gary Every
Sr. UNIX Administrator
Ingram Entertainment Inc.
2 Ingram Blvd, La Vergne, TN 37089
"Pay It Forward!"
-Orig
call code is $callcode";
You don't need to store the call code, since you can recreate it using
the autoincrement, the date field, and str_pad. Of course, if space is
not an issue, you could always store the concatenated string into
another column.
Gary Every
Sr. UNIX Administrator
Ingra
Actually it would be:
UPDATE table SET dateTime=NOW() WHERE record_id='$the_one_you_want';
Or
INSERT INTO table (record_id,dateTime) VALUES
('$the_one_you_want',NOW());
Gary Every
Sr. UNIX Administrator
Ingram Entertainment Inc.
2 Ingram Blvd, La Vergne, TN 3
Look at:
http://www.phpclasses.org/browse/package/92.html
It's a pager class that does:
<< Previous 1 2 3 4 5 6 7 8 9 10 Next >>
Gary Every
Sr. UNIX Administrator
Ingram Entertainment Inc.
2 Ingram Blvd, La Vergne, TN 37089
"Pay It Forward!"
-Original Message
Thanks for the info Hans!
I've got it working now.
-Original Message-
From: Hans Lellelid [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 13, 2004 7:28 PM
To: Gary Theisen
Cc: '[EMAIL PROTECTED]'
Subject: Re: Secure MySQL Access md5()
Hi,
Passwords in the mysql.user
Hi all,
I've got:
WinNT
php 4.3.1
phpmyadmin 2.5.6
MySQL 4.0.18-nt
I can connect to my db via my php script using:
[php]
$connection = mysql_connect ("localhost", "root", "")
[/php]
That works no problem.
This will not work however:
[php]
$somePass = md5("somePass");
$connection = m
only want to control that db & table through the command line on the server
itself.
How/What do I need to configure??
Thanks,
Gary
You could do this:
Build a sql statement, then connect to each of the servers and save the
results in a variable,
$result_1
$result_2
Then do:
$result_all = array_merge($result_1,$result_2,...)
The result sets have to have identical layouts, though.
Gary Every
Sr. UNIX Administrator
Hi all,
I've recently upgraded my mysql to v 4.1.1 (on win nt 4.0) and set the
Passwords in the user table to the mysql Password() function.
Now, this doesn't work anymore when call from a php web script (which is a
good thing, cause it's plain text):
mysql_connect ("localhost", "theID", "the
rt for reverse-engineering XML schema from database
* Use Criteria OO query system instead of writing SQL queries
* Generated methods to easily & efficiently work with (foreign key) relationships
Gary Every
Sr. UNIX Administrator
Ingram Entertainment Inc.
2 Ingram Blvd, La Vergne, TN 370
Testing, have received no emails since 11:45
Gary Every
Sr. UNIX Administrator
Ingram Entertainment Inc.
2 Ingram Blvd, La Vergne, TN 37089
"Pay It Forward!"
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
) 555-1212
Some other formatting hints for this:
$first = ucfirst(strtolower($first));
will give you "John" even if the DB has "JOHN" or "john"
Gary Every
Sr. UNIX Administrator
Ingram Entertainment Inc.
2 Ingram Blvd, La Vergne, TN 37089
"Pay It Forward!"
---
Select * from table1 t1, table2 t2, table3 t3
WHERE ((t1.thread_ref IN (1,2,3,4,5,6,7,8,9,10)) or (t2.thread_ref IN
(1,2,3,4,5,6,7,8,9,10)) or (t3.thread_ref IN (1,2,3,4,5,6,7,8,9,10)))
Gary Every
Sr. UNIX Administrator
Ingram Entertainment Inc.
2 Ingram Blvd, La Vergne, TN 37089
"Pay It Fo
You're missing a ' in your include statement, after .php
Gary Every
Sr. UNIX Administrator
Ingram Entertainment Inc.
2 Ingram Blvd, La Vergne, TN 37089
"Pay It Forward!"
-Original Message-
From: J. Kevin C. Burton [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February
Haven't been following this thread, but here's how we do it:
If($bgc == '') {
$bgc = "#DD";
} elseif($bgc == "#FF") {
$bgc = "#DD";
} else {
$bgc = "#FF";
}
Gary Every
Sr. UNIX Administrator
You should try this:
Header("Content-Type: text/plain");
Header("Content-Disposition: attachment; filename=file.csv");
Then output the text you want to send. Make sure you double-quote it so that the
newlines work!
$eol = "\n";
echo "Field 1,Field 2,$field_variable,$eol"
..
This sends a st
Try:
CREATE table new_table SELECT * from old_table limit 1;
delete from new_table;
This will give you the same structure in both tables, and the deletion will make the
new_table empty.
-Original Message-
From: Adam i Agnieszka Gasiorowski FNORD [mailto:[EMAIL PROTECTED]
Sent: Monday,
Or do the same with the BETWEEN keyword:
SELECT * FROM dates WHERE store='$store' AND date BETWEEN DATE_SUB(now(),
interval 3 day) AND DATE_ADD(now(), interval 3 day)
Richard Davey wrote:
Hello Cameron,
Tuesday, December 2, 2003, 1:08:19 AM, you wrote:
CS> $sql = "SELECT * from dates where st
Check out SQLite
BENARD Jean-philippe wrote:
Hi,
We use ORACLE DataBase for all our projects and we "can't install"
mysql/postgresql on our server. A new project needs a little database (only
1 table). I heard about something like an API in order to use text files in
place of real databa
Don't you need to start your form BEFORE your 's
-Original Message-
From: jas [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 11:38 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] form not working...
For some reason my form to edit selected items is not working, I think I
need a new
Just do an extract on your $_GET var (if security concerns are negligible)
Say you get line is:
?sid=123&form=12
// Execute this
extract($_GET)
// You end up with:
$sid == "123";
$form == "12";
Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
"
ript
$lim = $page[$pagid] // which would equal "0,10"
$sql = "SELECT columns from table limit $lim";
and so on . ..
Does that help?
Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
"Pay It Forward"
mailto:[EMAIL PROTECTED]
http://accessin
But do you have php compiled --with-curl?
check phpinfo();
Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
"Pay It Forward"
mailto:[EMAIL PROTECTED]
http://accessingram.com
> -Original Message-
> From: Joseph Allard [mailto:[EMAIL PROTECTED]
Try the rtrim function in php
Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
"Pay It Forward"
mailto:[EMAIL PROTECTED]
http://accessingram.com
> -Original Message-
> From: Shaun [mailto:[EMAIL PROTECTED]
> Sent: Friday, October 03, 2003 10
This has got to be really simple & I feel really stupid having to ask but...
I'm a very green n00b writing my first php script.
I have a VERY simple MySQL table which I would like to display a bunch of
hyperlinks (one hyperlink per row) but I dont want the user to see the
actual webpage addresss.
e select_id='1'. You can use the same table with different
select_id's for different dropdowns.
Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
"Pay It Forward"
mailto:[EMAIL PROTECTED]
http://accessingram.com
> -Original Message-
> From
>
>
> El Mié 24 Sep 2003 07:24, nabil escribió:
> > Dear all;
> >
> > I have been using Mysql for a long time, but I have a benchmark Q.
> >
> > Is pgsql , better ? faster ? more reliable than mysql ?
>
> Maybe not faster in FTS, but surely MORE reliable!!!
>
> > any comment ?
> > Some people
The best way to do this is a text field, NOT a textarea, and if need be, use
multiple fields. A textarea, by look and definition is inviting carriage
returns to be used. Limit the users to the input you want, and remember,
GIGO (garbage in, garbage out)
Gary Every
Sr. UNIX Administrator
Ingram
Try unset after the if statement
if ($nameb == ""){
$query = "SELECT * FROM recipes WHERE points $pointsb";
} else {
$query = "SELECT * FROM recipes WHERE name = '$nameb'";
$new_nameb = $nameb;
unset($nameb);
}
Gary Every
Sr. UNIX Admi
Youy could use:
if(!$result) {
// Don't display
} else {
echo "Title";
}
You fill in the blanks
Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
"Pay It Forward"
mailto:[EMAIL PROTECTED]
http://accessingram.com
> -Original Message--
Well, you're initializing $food to ""; then testing to see if it has a
value, which it never will.
If you're getting the $food variable from a POST or a GET op, you'll need to
grab it from the appropriate array,
$food = $_POST['food'];
echo $food;
to see wha
Check out the php function number_format($field,0)
Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
"Pay It Forward"
mailto:[EMAIL PROTECTED]
http://accessingram.com
> -Original Message-
> From: Chris Mach [mailto:[EMAIL PROTECTED]
> Sent: Thursd
> // Do some number crunching here //
>
> $newnow = $now-$numweeks;
>
> echo $now;
>
> $converted_date = date("d-m-y",$now);
>
> echo "$converted_date";
You should be running your $convewrted_date on $newnow, not $now
Gary Every
Sr. UN
Do you have select permissions on that DB/table?
If you have GRANT permissions, try
GRANS SELECT, INSERT, UPDATE, DELETE ON db.tablename to
'youruser'@'your.ip.address' IDENTIFIED BY 'yourpassword';
your.ip.address can be substituted with localhost if you'
Create a create_date table with one record, one or two fields, and put the
last refreshed time/date in it. If that's expired, refresh
Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
"Pay It Forward"
mailto:[EMAIL PROTECTED]
http://accessingram.com
> ---
Looks like the first question was answered correctly, for the second one
look at the ltrim and rtrim functions.
$var = "";
$var = rtrim($var);
echo ":$var:";
output is
::
Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
"Pay It Forward
20,10 it will return 10 records starting
at record 20.
More info at
http://www.mysql.com/doc/en/SELECT.html
Search for limit on that page.
Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
"Pay It Forward"
mailto:[EMAIL PROTECTED]
http://accessingram.com
>
t; at the end
of the sql statement.
Don't worry about the values in the column, just the amount of records you
want to return
Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
"Pay It Forward"
mailto:[EMAIL PROTECTED]
http://accessingram.com
> -Orig
hat two users
with the same password may have completely different hash strings.
Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
"Pay It Forward"
mailto:[EMAIL PROTECTED]
http://accessingram.com
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL
Or
$sql = "SELECT concat(LEFT(columnName,255),"...") FROM tableName";
Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
"Pay It Forward"
mailto:[EMAIL PROTECTED]
http://accessingram.com
> -Original Message-
> From: Hutchins, Rich
just by changing the $cols_wanted variable
Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
"Pay It Forward"
mailto:[EMAIL PROTECTED]
http://accessingram.com
> -Original Message-
> From: Becoming Digital [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June
the $$key assigns whatever $key is to a variable with that value, e.g.
$key = "sid";
$value = "W";
So:
$$key = $value;
will make the following true:
$sid == "W";
It's a pretty good way of re-doing pages that were written with
register_globals=on to run with
.Name like '%$name%'
AND whatever_field_you_want IS NOT NULL
AND whatever_other_field IS NOT NULL";
Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
"Pay It Forward"
mailto:[EMAIL PROTECTED]
http://accessingram.com
> -Original Message
If this is a cut-n-paste of the code, check the line below for spelling:
"begin prcoedurename('[EMAIL PROTECTED]','3');end;";
^^^
Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
"Pay It Forward"
mailto:[EMAIL PROTECTED]
h
1 - 100 of 156 matches
Mail list logo
