Thanks Stuart!
Karl
Sent from losPhone
On Jul 2, 2011, at 8:45 AM, Stuart Dallas wrote:
On Sat, Jul 2, 2011 at 9:01 AM, Karl DeSaulniers
wrote:
Hello All,
Happy pre independence for my American PHPers. And good health to all
others.
Have a quick question..
I have this code I use for the
On Jul 2, 2011, at 3:01 AM, Karl DeSaulniers wrote:
Hello All,
Happy pre independence for my American PHPers. And good health to
all others.
Have a quick question..
I have this code I use for the end of line characters used in my
mailers.
[Code]
// Is the OS Windows or Mac or Linux
if (
On Jun 30, 2011, at 9:57 PM, Guru™ wrote:
I have a question about php-mysql. Is it possible that I can have 2
different fields in a mysql table, and when a user fill out the form
for the
first time the input goes to first field and when the second user
fill out
the form the input goes to 2nd
Hi Guru,
You could disable the input field or set it to readonly after it has
been filled in...
disabled="disabled" />
or
readonly="readonly" />
but you will have to do that client side with some javascript.
Unless you have the page refresh after each field is filled in, then
you could di
Hi list,GURU,
For the first notice error, if you try to get value from post,get variable
and the value is not sent or not present you have this kind of notice
error, this is why you have to check for every get/post value if it's set
or it's secure and you can do it with isset or empty:
example:
$s
On Fri, Jun 24, 2011 at 16:07, Paul Wilson wrote:
> please remove me from this list
Email php-db-unsubscr...@lists.php.net.
--
Network Infrastructure Manager
http://www.php.net/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
please remove me from this list
On Fri, Jun 24, 2011 at 3:02 PM, Troy Oltmanns wrote:
> Hey php-dbers,
>
> I have a helper script that connects to an MSsql database to select
> retailer
> location information, which is then processed into mysql statements to be
> inserted into another remote dat
The error is pretty explicit - there is no field in your table called
'250kbps'. What you should have is a field (column) called "speed" for
example, with values from 1...5 or whatever. To the users they will only
deal with actual speed values on their screen if you use the speeds as the
valu
Thanks everyone.
> If there is no purpose, I would make the values of the inputs the values you
> want to store in your database.
> Muuch easier..
>
So I am trying to keep this simple and just assign the value with the
radio button and then insert it into mysql database, but with the
following co
Hi Chris,
Here is the corrected code. Yes, call the function before the SQL
SELECT like so.
You may have to work with it a bit. This was just off the top of the
head.
But now that I look at it, I think Jim may be right.
What's the purpose of the inputs having 1, 2, 3, etc and not the
0-250
I guess if you are storing the value of "post_tptest" in the database, it
should return the same value what the user selected in the radio option. If
I am right in your display you are just calling the data from the database.
Check if the data is properly storing the radio button values in the
data
On Thu, Jun 23, 2011 at 14:18, Chris Stinemetz wrote:
> So far I am good on creating the form and submitting it to mysql
> database and calling the submitting value from a different script.
>
> My question is: How can I make it so when a user selects radio option
> value "1" it will then be displ
On Thu, Jun 23, 2011 at 16:08, Chris Stinemetz wrote:
>
> I must be missing something. I am just getting a blank page. Your help
> is greatly apprecieated.
This is why you're supposed to take the advice and write it out
yourself, not copy and paste the code. ;-P
By copying and pasting t
On Jun 23, 2011, at 2:32 PM, Karl DeSaulniers wrote:
Try this...
function getSpeed($val) {
if($val != 'undefined') {
switch ($val){
case "1":
$post_tptest = "0-250kbps";
break;
>
> Use an if or a switch. For example:
>
I think your suggestions are exactly what I am looking for. I am not
sure exactly where to place it. Do I insert it after the query
statment?
Thank you,
Chris
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.n
On Thu, Jun 23, 2011 at 15:46, Chris Stinemetz wrote:
>>
>> Use an if or a switch. For example:
>>
>
> I think your suggestions are exactly what I am looking for. I am not
> sure exactly where to place it. Do I insert it after the query
> statment?
During your while() loop. This line her
I also think you need to use the mysql_free_result like so..
echo '';
while($row = mysql_fetch_assoc($result))
{
echo '' .
$row['mar_name'] . '';
mysql_f
On Thu, Jun 23, 2011 at 2:49 PM, Daniel P. Brown
wrote:
> On Thu, Jun 23, 2011 at 15:46, Chris Stinemetz
> wrote:
>>>
>>> Use an if or a switch. For example:
>>>
>>
>> I think your suggestions are exactly what I am looking for. I am not
>> sure exactly where to place it. Do I insert it after
Try this...
function getSpeed($val) {
if($val != 'undefined') {
switch ($val){
case "1":
$post_tptest = "0-250kbps";
break;
case "2":
On Mon, Jun 20, 2011 at 3:49 PM, Karl DeSaulniers wrote:
> Try..
>
> $posts_sql = "SELECT posts.post_store, posts.post_content, posts.post_date,
> posts.post_by, users.user_id, users.user_name FROM posts LEFT JOIN users ON
> osts.post_by = users.user_id WHERE posts.post_store = "
> .mysql_real_esc
Try..
$posts_sql = "SELECT posts.post_store, posts.post_content,
posts.post_date, posts.post_by, users.user_id, users.user_name FROM
posts LEFT JOIN users ON osts.post_by = users.user_id WHERE
posts.post_store = " .mysql_real_escape_string($_GET['id'])." ORDER
BY posts.post_date DESC";
Chris,
Try this:
http://dev.mysql.com/doc/refman/5.0/en/order-by-optimization.html
On 20 June 2011 20:56, Chris Stinemetz wrote:
> I have the bellow sql query. What is the correct way to add ORDER BY
> posts.post_date DESC
>
> I would like to add it to the end of my query, but I am just gettin
i have removed them and it works when i remove the $_GET on the locid and
catnaam in the first query.
it just loads all pictures from the whole table. but i only want the
pictures that not only have that certain location id but are in that
location aswell.
with the query i have now it loads the pi
Try remiving the single quotes around myPage and showRecords.
On 15/06/2011 6:38 PM, "Taco Mathijs Hillenaar-Meerveld" <
tm.hillen...@gmail.com> wrote:
> Hello everyone,
>
> I have followed only a short course in PHP and have a book 'PHP for
dummies'
> but i can't find a solution for my problem.
>
On Tue, 14 Jun 2011 00:50:39 -0500
Chris Stinemetz wrote:
> On Tue, Jun 14, 2011 at 12:31 AM, Chris Stinemetz
> wrote:
> > I created the below delete function, but it doesn't seem to be working
> > correctly. When I enter the correct password it get my echo "Incorrect
> > Password Did not Delete
create a file with phpinfo() and make sure mysqli is listed in the loaded
modules
On Tue, Jun 14, 2011 at 12:07 PM, Niel Archer wrote:
>
> > Hello everyone,
> >
> > I am in the process of learning php and I was trying to connect to a
> mysql
> > database on my own computer(localhost). I have don
> Hello everyone,
>
> I am in the process of learning php and I was trying to connect to a mysql
> database on my own computer(localhost). I have done the following as
> prerequisites:
>
> copied the dll files in system32
> removed the semicolon(;) from extension=php_mysqli.dll
You should NOT n
On 13 June 2011 15:28, C0mf0rtably Numb <08.kus...@gmail.com> wrote:
> My php and apache are working fine together. I was doing good with php and
> apache until I decided to work with mysql. I will have a look at all the
> links you provided and see if gives me a solution. Thanks.
>
> On Mon, Jun 1
On 13 June 2011 14:12, C0mf0rtably Numb <08.kus...@gmail.com> wrote:
> Any help?
>
> On Mon, Jun 13, 2011 at 5:38 PM, C0mf0rtably Numb <08.kus...@gmail.com>wrote:
>
>> Hello everyone,
>>
>> I am in the process of learning php and I was trying to connect to a mysql
>> database on my own computer(loc
On 13 June 2011 13:26, C0mf0rtably Numb <08.kus...@gmail.com> wrote:
> Okay. I tried using that too. If I run this:
> $link = mysql_connect('localhost', 'root',
>
> 'Password123');
> if (!$link) {
> die('Could not connect: ' . mysql_error());
> }
> echo 'Connected successfully';
> mysql_close($
Okay. I tried using that too. If I run this:
I get the error: *Fatal error*: Call to undefined function mysql_connect()
in *C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\a.php* on
line *2
*I think there is something wrong with my configuration.
On Mon, Jun 13, 2011 at 6:00 PM, mr
Your error message is about class not found.That means there is no class
named "MySQLi".Please use a textbook with online manual
http://www.php.net/manual/en/ref.mysql.php
On 06/13/2011 02:08 PM, C0mf0rtably Numb wrote:
> Hello everyone,
>
> I am in the process of learning php and I was trying to
> Hello all,
>
> Not sure what I am doing wrong.
>
> I have a simple form that populate the variables in a mysql query. I
> know the selected values are making it to the form porcessing script
> because I can echo them on the processing script as indicated below.
>
> You Selected Cell_Sect = 1_1
Give the user show view permission
http://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html#priv_show-view
On 06/06/2011 7:57 AM, "Ron Piggott" wrote:
>
> I created a VIEW “table” yesterday. Last night when the cron job ran to
back up the database I received this error:
>
>
> mysqldump: Cou
Google "php4 to php5 converter" or "php4 to php5 conversion"
That should set you on your way.
The best way I have read to do this is just run your code on a php5
server and build in php error detection of some kind, then just fix
the errors as they come.
:)
Best,
Karl
On Jun 3, 2011, at 6
--
From: "Richard Quadling"
Sent: Friday, June 03, 2011 7:26 PM
To: "Dr Vijay Kumar"
Cc:
Subject: Re: [PHP-DB] Converting from PHP4 to php5
On 1 June 2011 13:52, Dr Vijay Kumar wrote:
i AM WONDERING IF SOMEONE CAN TAKE
--
From: "Richard Quadling"
Sent: Friday, June 03, 2011 7:26 PM
To: "Dr Vijay Kumar"
Cc:
Subject: Re: [PHP-DB] Converting from PHP4 to php5
On 1 June 2011 13:52, Dr Vijay Kumar wrote:
i AM WONDERING IF SOMEONE CAN TAKE
On 1 June 2011 13:52, Dr Vijay Kumar wrote:
> i AM WONDERING IF SOMEONE CAN TAKE UP CONVERSION OF MY SOFTWARE FROM PHP4 TO
> PHP5
Whilst there will be many aspects of the code that will run quite
happily, there are several features that have been deprecated and/or
removed, depending upon the vers
Richard & I are waiting for an answer from someone..???
--
*Best,
*
*Guru™*
On 1 June 2011 14:26, HallMarc Websites wrote:
> Without looking at the rules (Sry barely have time to reply!) I don't think
> this is appropriate for this list. I am fairly certain it is against the
> rules to ask/offer work on here.
> Can anyone confirm or deny?
>
> Thank you,
> Marc Hall
> Hall
> i AM WONDERING IF SOMEONE CAN TAKE UP CONVERSION OF MY
> SOFTWARE FROM PHP4 TO
> PHP5
>
Without looking at the rules (Sry barely have time to reply!) I don't think
this is appropriate for this list. I am fairly certain it is against the
rules to ask/offer work on here.
Can anyone confirm or den
I am not a master but as per my knowledge your software which is in PHP4
should work properly in PHP5 too.
--
*Best,
*
*Guru™*
Shahriyar Imanov wrote:
Hey guys,
I wonder if anyone can help me to find php_interbase.dll file for PHP
5.3.x [VC9], which works with Embarcadero Interbase. I tried those
which come with PHP distribution: apparently they all work with
Firebird only. When I tried them, they say I don't have
usern
Code runs smoothly now, thanks. It's always great to pick up diverse coding
tips through the conversations here.
2011/5/30 Nazish
> That did the trick: I was over-enthusiastic in my usage of
> die(mysql_error).
>
> I initially used mysql_error to troubleshoot another problem (which has now
> re-
That did the trick: I was over-enthusiastic in my usage of die(mysql_error).
I initially used mysql_error to troubleshoot another problem (which has now
re-emerged), but that's a different question which is puzzling me. The error
message ($alert = "Username already exists!";) displays on the page
try this instead..
if(mysql_num_rows($check) > 0) {
//true
} else {
//false
}
and yes, Peter's right... please dont make everything die().
Karl
On May 30, 2011, at 3:43 PM, Peter Lind wrote:
On 30 May 2011 22:31, Nazish wrote:
Hi all,
I've run into a little barrier, and I'
On 30 May 2011 22:31, Nazish wrote:
> Hi all,
>
> I've run into a little barrier, and I'm wondering whether you have any
> insights. I'm entering values into a MySQL database. Before running the
> mysql_query, I'm checking if the value already exists (using mysql_num_rows
> == 0). If the value al
Good 2 hear.
Pay it forward.. :)
On May 27, 2011, at 4:50 PM, David McGlone wrote:
On Fri, 2011-05-27 at 16:13 -0500, Karl DeSaulniers wrote:
To get row 0
make the for loop change to
for($i=-1;
Karl, it's completely working now, I changed empty back to !isset and
that did the trick. Got
Actually you can keep $i as zero, it should still get row 0 now that
I think of it.
dont know how your table is set up so hard to tell.
On May 27, 2011, at 4:31 PM, David McGlone wrote:
On Fri, 2011-05-27 at 16:13 -0500, Karl DeSaulniers wrote:
To get row 0
make the for loop change to
f
To get row 0
make the for loop change to
for($i=-1;
Best,
Karl
On May 27, 2011, at 4:08 PM, Karl DeSaulniers wrote:
Hi David,
Yeah sorry, that was all of the top of the head, so I apologize if
anything was incorrect.
I am glad you got it working though..
Best,
Karl
On May 27, 2011, at
Hi David,
Yeah sorry, that was all of the top of the head, so I apologize if
anything was incorrect.
I am glad you got it working though..
Best,
Karl
On May 27, 2011, at 3:50 PM, David McGlone wrote:
On Fri, 2011-05-27 at 14:48 -0500, Karl DeSaulniers wrote:
Hi David,
Try this..
if(!isse
On Fri, 2011-05-27 at 14:48 -0500, Karl DeSaulniers wrote:
> Hi David,
> Try this..
>
> if(!isset($_POST['ErrorCode'])) {
> die('You did not enter an error code!');
> } else {
> $errorcode = $_POST['ErrorCode'];
> $sql = mysql_query("SELECT * FROM Sheet1 WHERE errorcode='".
> $e
Oh I forgot..
... WHERE errorcode='".mysql_real_escape_string($errorcode)."');
Best,
Karl
On May 27, 2011, at 2:48 PM, Karl DeSaulniers wrote:
Hi David,
Try this..
if(!isset($_POST['ErrorCode'])) {
die('You did not enter an error code!');
} else {
$errorcode = $_POST['ErrorC
Hi David,
Try this..
if(!isset($_POST['ErrorCode'])) {
die('You did not enter an error code!');
} else {
$errorcode = $_POST['ErrorCode'];
$sql = mysql_query("SELECT * FROM Sheet1 WHERE errorcode='".
$errorcode."' ");
if($sql && mysql_numrows($sql) > 0) {
$stmt->rows() should give you the number of rows returned.
Giff
On Mon, 2011-05-23 at 18:53 -0400, Ron Piggott wrote:
> What command will tell me the # of rows the SELECT query retrieved using
> Prepared Statements.
>
>
> $dsh = 'mysql:host=localhost;dbname='.$database;
> $dbh = new PDO($dsh,
That's a very good point,
but since I use postgres that's one point that doesn't affect me and as
such didn't cross my mind at the time.
(Postgres uses schemas where mysql uses databases, a different database
on postgres usually means a different database machine. And joining
tables from differe
I would keep the db names and/or schema names in your queries.
It clarifies what you are doing with the query making it easier for
someone else to debug, improve, ... Certainly for those not familiar
with your db structure.
I am not aware of any drawbacks that can result from this. (Ok, maybe
y
thank you for explaining this to me Amit. It works. Ron
The Verse of the Day
“Encouragement from God’s Word”
http://www.TheVerseOfTheDay.info
From: Amit Tandon
Sent: Friday, May 06, 2011 5:49 AM
To: Ron Piggott
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] COUNT and OUTER JOIN results
Dear Ron
Take your condition to ON cluause. So your on clause (for LEFT JOIN) would
read something like
ON `prayer_request_category`.`
reference` = `prayer_requests`.`prayer_request_category_reference`
AND
`prayer_requests`.`approval_
level` IN ( 1, 3 )
`prayer_requests`.`prayer_request_type` =
Gavin Chalkley wrote:
> Is there no way of setting unique .ini?
>
> As I am running multi Dev sites from Xampp, of which require different
> includes and other settings
>
> On 2 May 2011 18:31, Barry Stear wrote:
>> You just need to update the php.ini file that you have making any changes
>> ne
Is there no way of setting unique .ini?
As I am running multi Dev sites from Xampp, of which require different
includes and other settings
On 2 May 2011 18:31, Barry Stear wrote:
> You just need to update the php.ini file that you have making any changes
> necessary. I would suggest making a bac
See:
http://us2.php.net/manual/en/migration5.php
That gives details of migration from PHP4 to PHP5. There are also guides
for migration between each major point release:
http://us2.php.net/manual/en/migration51.php
http://us2.php.net/manual/en/migration52.php
http://us2.php.net/manual/en/mig
On 24 April 2011 05:19, listread wrote:
> While listing each row in a MySQL database, I need to call a function or
> another php file for each row.
>
> How can I make the while-loop wait for the called function to complete
> before continuing to the next row in the while-loop?
>
> Thanks!
>
> - Ro
On Thu, Apr 21, 2011 at 14:50, Fred Silsbee wrote:
> Fatal error: Call to undefined function mysql_errors() in
> /var/www/html/log_book_MySQLnew.php on line 261
The function is mysql_error().
--
Network Infrastructure Manager
http://www.php.net/
--
PHP Database Mailing List (http://ww
Jim, thanks for your help...
I send because the first emial was replied saying to send again to see if I
am a spamer...
Thanks again.
2011/4/20 Jim Giner
> oh - and by the way - don't email people directly. We are all reading
> the list, so send your mail to the list and not to everybody as we
Methinks you are correct. MAYBE I should have written the code too!
"Ken Kixmoeller" wrote in message
news:banlktinmme9ws1ztrepum+fnmmsywan...@mail.gmail.com...
On Tue, Apr 19, 2011 at 7:41 PM, Jim Giner
wrote:O
> No follow-up? I must have made complete sense!! :)
Either that or (based on the
On Tue, Apr 19, 2011 at 7:41 PM, Jim Giner
wrote:O
> No follow-up? I must have made complete sense!! :)
Either that or (based on the initial post) he had *no* idea what you
were talking about.
Ken
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/uns
Thank you for the suggestion. This is the actual query that I implemented:
Amazing how this works. Ron
SELECT SUM( `impressions_total` ) AS impressions_total , SUM( `usage_total` )
AS usage_total FROM (
(
SELECT IF ( SUM( `web_advertisements_our_clients_usage`.`
Looking at all that code you already wrote, you're not that much of a
newbie.
Read up on functions. (A function is merely the same code you already run
but it's set aside, out of the main execution path of your script, so that
you can call it from anyplace that you need to execute that particu
On Wed, Apr 13, 2011 at 11:08 AM, Jim Giner
wrote:
> Without looking at your HUGE code stream, I'm curious what your question
> really is. If you know how to send an email, and you know how to update
> your table, then isn't your task simply to send an email after updating the
> table?
Yes.
> I
Hey friend.
The problem is here:
( SELECT `reference`, `organization` FROM `ministry_profiles`...
In a subselect, you must select just one column. You are selecting two
"reference" and "organization".
If you really need both, so you must do two subselects: one for
"reference" and another for
On 2011-04-08, at 1:57 AM, Karl DeSaulniers wrote:
> Ooops.
> Sry, forgot an escape.
>
> $q = "UPDATE expiringleases SET Cricket_Region =
> '".mysql_real_escape_string($Cricket_Region)."', Market =
> ".mysql_real_escape_string($Market)."' WHERE Search_Ring =
> '".mysql_real_escape_strin
Ooops.
Sry, forgot an escape.
$q = "UPDATE expiringleases SET Cricket_Region =
'".mysql_real_escape_string($Cricket_Region)."', Market =
".mysql_real_escape_string($Market)."' WHERE Search_Ring =
'".mysql_real_escape_string($id)."'";
mysql_query($q) or die(mysql_error());
Best,
Karl
O
Hi Chris,
Try this..
Or season to taste..
$q = "UPDATE expiringleases SET Cricket_Region =
'".mysql_real_escape_string($Cricket_Region)."', Market = ".
$Market."' WHERE Search_Ring = '".mysql_real_escape_string($id)."'";
mysql_query($q) or die(mysql_error());
Best,
Karl
On Apr 8, 2011, at
Hi Chris,
I believe you only need to do a htmlspecialchars when displaying data
as readable text that your retrieved from the database after inserting.
And probably some other situations as well, but I don't think you
need to do htmlspecialchars on the
mysql_real_escape data when inserting into
I am pretty sure it is in my code. I am just getting an error form one
of my echoes. Still can't get it to work correctly though. Any help is
greatly appreciated.
Thank you,
Chris
http://www.w3.org/TR/html4/strict.dtd";>
Edit Record
'.$error.'';
}
?>
ID:
First Name: *
L
The two query statements are different - in one you quote $id and in the
other you don't.
It is definitely a mysql error so it's not the line you suggested.
"Karl DeSaulniers" wrote in message
news:6fe62364-f9fc-4612-8c5d-6ce48fc66...@designdrumm.com...
>I believe this line should read..
>
>
I believe this line should read..
ini_set('display_errors', 1);
Just something I think I caught. Might not be your solution though.
HTH,
Karl
On Apr 7, 2011, at 11:00 PM, Chris Stinemetz wrote:
ini_set('display_errors', '1');
Karl DeSaulniers
Design Drumm
http://designdrumm.com
--
PHP D
Hi Guru,
Glad to hear it's working! Yes the mail function will be able to
handle all the fields, it should be as simple as repeating what you've
already done for all of the remaining fields
- Will
On Apr 4, 2011, at 1:09 PM, Guru™ wrote:
Hi Will,
Below is my final PHP code, and its wo
Hi Will,
Below is my final PHP code, and its working now. However this is just a
small piece of the form that I have created. In my original form I have more
then 50 fields and variables. Now I am not sure how to expand this code
having all 50 fields. Can the mail function will take that much fiel
Hi Guru,
Have you already made the php script that includes the "mail" function? If
there is an error in your php that is preventing the mail function from
working properly, I or someone else may be able to help you correct it if
you were to send the php you have written so far.
-Will
2011/4/4 Gu
On Sat, Mar 26, 2011 at 9:44 PM, Brian Smither wrote:
> Would you try an experiment?
Thanks for for the suggestion but this didn't seem to work. I beleive
it is a header conflict based on what I have researched.
I just can't seem to find a solution.
>
> In this line:
> $sql = ("SELECT * FROM evd
On 2011-03-26, at 9:00 AM, Richard Quadling wrote:
> Hi.
>
> What preferences do you all have when using SQL. Stored Procedures or
> PHP generated dynamic SQL or parameterized static SQL.
I used both. SPs work for some of the larger reports, especially when combined
with a view or two. For m
On Saturday, March 26, 2011, Richard Quadling wrote;
> What preferences do you all have when using SQL. Stored Procedures or
> PHP generated dynamic SQL or parameterized static SQL.
> Whichever you use how do you test them? Do you use unit testing in
> your PHP code? If so, do you also have unit
On Wed, 23 Mar 2011 15:59:50 -0500
Chris Stinemetz wrote:
> Hello,
>
> echo "You Selected the following:Market = $term Cell_Sector =
> $term2Timestamp = $term3"; ?>
note the closing PHP tag above, and now
this line here, is not in php, and does not echo the php variables.
>
>
> // I thin
On Tue, Mar 8, 2011 at 11:16 AM, Ron Piggott
wrote:
>
> I am wondering if there is a way to do an UPDATE query where only some of the
> text changes.
>
> The column I need to modify is named “toll_free”
> What I need to search for is: 800-
> I need it to replace it with is 1-800-
> - BUT I don’t
Try this,
$String = strtolower($String);
or
$String = strtoupper($String)
then plug into MySQL
Best,
Karl
On Mar 19, 2011, at 1:21 PM, Oddity Software LLC wrote:
Need a custom function:
BEGIN
DECLARE c CHAR(1);
DECLARE s VARCHAR(128);
DECLARE i INT DEFAULT 1;
DECLARE bool INT DEFAU
Need a custom function:
BEGIN
DECLARE c CHAR(1);
DECLARE s VARCHAR(128);
DECLARE i INT DEFAULT 1;
DECLARE bool INT DEFAULT 1;
DECLARE punct CHAR(17) DEFAULT ' ()[]{},.-_!@;:?/';
SET s = LCASE( str );
WHILE i < LENGTH( str ) DO
BEGIN
SET c = SUBSTRING( s, i, 1 );
IF L
On Fri, Mar 18, 2011 at 17:35, Jim Giner wrote:
> first time poster
There's no need to test. We've known it's worked for years.
--
Network Infrastructure Manager
http://www.php.net/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On 14 March 2011 15:42, Gary wrote:
> I have a table in a mysql db that has 3 columns that I want to insert
> (update) data if the row&column is empty (IS NULL). However I want to start
> at the first column, if this column is not null, then move to insert the
> data into column 2, if that is emp
Do not forget to use TRIM function as well:
LENGTH(TRIM(fax))
in order to elliminate leading and trailing spaces.
Aurel
- Original Message -
From: "Geoffrey Pitman"
To:
Sent: Friday, March 11, 2011 7:59 PM
Subject: [PHP-DB] RE: SELECT WHERE length of content question
You should b
On Wed, Mar 9, 2011 at 17:49, Ron Piggott
wrote:
>
> Is there a command in mySQL that would allow me to SELECT the rows where the
> `fax` column is more than 11 characters long?
There is.
SELECT * FROM tblName WHERE CHAR_LENGTH(fax) >= 11;
(Presuming you meant greater than or equal
Have a look at this:
http://dev.mysql.com/doc/refman/5.1/en/string-functions.html#function_char-length
On Thu, Mar 10, 2011 at 9:49 AM, Ron Piggott wrote:
>
> Is there a command in mySQL that would allow me to SELECT the rows where
> the `fax` column is more than 11 characters long?
>
> OR
>
> D
Koert
Sent: Tuesday, March 08, 2011 11:20 AM
To: Ron Piggott
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] UPDATE query
On Tue, Mar 8, 2011 at 11:16 AM, Ron Piggott
wrote:
I am wondering if there is a way to do an UPDATE query where only some of
the text changes.
The column I need to modify
I was wondering this Bastien. Ron
The Verse of the Day
“Encouragement from God’s Word”
http://www.TheVerseOfTheDay.info
-Original Message-
From: Bastien Koert
Sent: Tuesday, March 08, 2011 11:20 AM
To: Ron Piggott
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] UPDATE query
On Tue
On Tue, Mar 8, 2011 at 11:16 AM, Ron Piggott
wrote:
>
> I am wondering if there is a way to do an UPDATE query where only some of the
> text changes.
>
> The column I need to modify is named “toll_free”
> What I need to search for is: 800-
> I need it to replace it with is 1-800-
> - BUT I don’t
Are you getting any error msg while installing it. Try to get a new copy of
php-mysql from internet and install it.
On Tue, Mar 8, 2011 at 4:17 PM, Scott Wen wrote:
> Hi,
>
> I installed mysql and php. Its OK. After I install php-mysql, the
> following messages come out.
>
> PHP Warning: PHP
Hey friend!
You can use the PDOStatement::RowCount, but there is a problem
(extracted from the PHP Manual,
http://php.net/manual/en/pdostatement.rowcount.php):
PDOStatement->rowCount - Returns the number of rows affected by the
last SQL statement. If the last SQL statement executed by the
ass
Try the stripslashes() function.
See on http://php.net/manual/en/function.stripslashes.php for details.
Best regards.
Steven
Hi All,
I have a list of product in which WIRE MESH 24G X 3/4" is one of them.
When
I am trying to print the same its coming like WIRE MESH 24G X 3/4\". I
want
to re
Thanks Geoff Lane, I saw my mistake. Their was no scloth100_qty in my mysql
table. Once again Thanks buddy :)
On Tue, Mar 1, 2011 at 4:53 PM, Geoff Lane wrote:
> On Tuesday, March 1, 2011, Richard Quadling wrote;
>
> > Can you tell me what column in the table is scloth100_qty? I can't find
> it
901 - 1000 of 23728 matches
Mail list logo