I know how to use it with MySQL but how do you use the function
substring with a variable?
Thanks
Dallas Freeman
www.php.net
function: substr
and you'll see
please first search, then ask!
-Original Message-
From: Dallas Freeman [mailto:[EMAIL PROTECTED]
Sent: donderdag 20 maart 2003 9:13
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Substring ?
I know how to use it with MySQL but how do you use
Dear Mark,
Thanks for your note but no one really explains the function at all,
they just write the function and that's it.
Thanks for giving me the correct function name to use, from what I
found, substring was the name of the function.
Thanking You,
Dallas Freeman
-Original
Just a quick message to say that this email forum is the best I've seen.
Everyone responds quickly, the forum contains experts who really know
there stuff, and nobody will snob you off.
Thanks to those who have replied to my messages and to others.
It has been a really good learning
At this moment, our hearts should reach out to the people of Iraq who are now faced
with the brutality of an oppressive US regime.
Bush is now acting like a dictator, worse than Hitler, and is a shame for all peace
loving US citizens.
I sympathise with all the technocrats of our own software
Largely off topic palso.
This mailing list does not care about what you have to say on this subject.
It is a great professional tool for many of us, and does not need to be
polluted.
Ignatius
- Original Message -
From: [EMAIL PROTECTED]
To:
I'm trying to interlace the results from a left-join
query with a regular select result. I have two tables:
Aplications and States (state as in: the states of
Florida and California). Each aplication in the
Aplications table contains a state_id, which matches
an id of a state in the States table.
Hi everyone
This is what I want to do:
I have a file on each workstation that gets created each time the pc is
rebooted - the file save the pc configuration plus the current user logged
onto the machine, I want to read from that file variables so that I can
save
it to my mySQL database and
Hi everyone
This is what I want to do:
I have a file on each workstation that gets created each time the pc is
rebooted - the file save the pc configuration plus the current user logged
onto the machine, I want to read from that file variables so that I can save
it to my mySQL database and run
Hello,
I have been using php --with-interbase for some time
and I enjoy using php scripts to everything so I did
some small scripts to use as a datapump to the interbase.
My scripts relay on the fact that I can have two
simultaneos connections to the different databases
in order to pump data from
Not really true, unless I learned programming in a different way ;-)
I mean, if I send an update query, like update table set
field1=$nfield1, field2=$nfield2 ..., I don't know WHICH fields have
changed. mysql_affected_rows() only reports how many records were
changed. So, if I want to know
I think Jeremy means how to use it as an integer, if it is stored as a
string. In this case, use $intvalue = $strvalue + 0, where $strvalue is
0, 1 and so on.
Edwin
Jeremy wrote:
Hey folks,
Im apologize that this is just a really easy general php question but any help would
be appreciated.
if
Jan,
You cannot get access to files on the client side with PHP, because
there is no connection with the client. Have your client copy the file
to a directory on the server, that is accessible for PHP and then read
them from there. If you use unique names, e.g. workstation names, you
should
-Original Message-
From: Matthew Moldvan [mailto:[EMAIL PROTECTED]
Sent: 19 March 2003 18:32
I am assuming English isn't your first language.
Yes, fuck is definitely swearing, cursing, or whatever else
you would like
to call it. And yes, it is considered rude in our culture.
Hi all,
Anyone has interact with c-tree databases using php.
Where can i found help about it?
Thanks in advance,
Gabriel.
Hi,
I found the Full Search Class that will help me to
find a word in any column.
http://aspn.activestate.com/ASPN/Cookbook/PHP/Recipe/125901
I have tried printing the results with print_r along
the following code mentioned on the page,
$mysearch = new MysqlSearch;
on 3/20/03 1:45 AM, olinux at [EMAIL PROTECTED] appended the following bits to
my mbox:
[ and ] are illegal characters. #javascript
I'm coming into this a bit late, so I'm not sure exactly what you wish to
do.
You can use JavaScript to refer to checkbox items in the format:
Hi,
I have a problem that lets you add a record to a database. THere is a
problem with it, and the following is the area of the program where it has
problem.
$created_date = date('m, d, Y');
$title = strip_tags($title);
$keywords = strip_tags($keywords);
where my $content value is osmethign like this.
Step 1: Access the homepage
Step 2: type in your username under the field 'username'
and after the addslashes funciton there would be \ around the 'username'
like this..
\'username\'and now after running this program I got an error
Actually, that eliminated the error messages but it still hasn't fix the
problem
I did what you saidbut now in my MSSQL table, the content column has
somethign like thsi
Step 1: blah blah balh
Step 2: blah balh balh \'Username\'
so it included the slashes...I just learned that mSSQL doens;t
Umm, how about using str_replace to replace the quotes for there ASCII
equivalent's,
and when you print them out in HTML they will be interpreted properly,
or you
could str_replace them back.
On Thu, 2003-03-20 at 11:23, Poon, Kelvin (Infomart) wrote:
Actually, that eliminated the error
hi
im having major problems deleting multiple messages from the guestbook i
have created
im new to php so any replies to this problem will have to easy for me to
understand
i have got my guestbook reading and showing entries and have added
checkboxes under each entry for the deletion process
hi
im having major problems deleting multiple messages from the guestbook i
have created
im new to php so any replies to this problem will have to easy for me to
understand
i have got my guestbook reading and showing entries and have added
checkboxes under each entry for the deletion process
Ok So I have my Database/Tables all set up. What I wanna know how to do /
find a tutorial on is how I might go about including details longer than
255 characters that are referenced by a mysql query. So basically I have
some thing like this on the inputs:
First:
Last:
Email:
Comments:
Now the
on 20/3/03 6:11 pm, Adam Venturella at [EMAIL PROTECTED] wrote:
Anyway if someone could point me in the right direction I would be very
appreciative.
Change your column type to TEXT rather than varchar(255)
--
Mike Karthauser
Managing Director - Brightstorm Ltd
Email[EMAIL
Possibly use a column type of TEXT for the comments column in your table?
-Original Message-
From: Adam Venturella [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 20, 2003 1:12 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Including Details in MySQL longer than 255
characters
Ok
Thanks,
I totally forgot about that type...
And thanks to everyone else who replied!
-a
Mike Karthauser [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
on 20/3/03 6:11 pm, Adam Venturella at [EMAIL PROTECTED] wrote:
Anyway if someone could point me in the right direction I would
Can anyone out there compare these two using with mysql and web apps -
What I can gather so far from my limited experience with both and a
little googling:
1. Built in mysql_ functions in php (does perl have this?)
2. Php may be faster.
3. Embedded in html - no separate cgi directory needed.
4.
I am looking to display results of a query inside of an html table. When I tested to
see if this was correct it returned with a blank page on my website.
Here is my code:
TIA
Michelle
/* If there was a problem with the query... */
if (!$result || @mysql_num_rows($result) 1)
{
print(No
In response to your bullet points...
1. Built in mysql_ functions in php (does perl have this?)
Perl does not have built in functions for MySQL or any
other database. The Perl functions are all added through modules. This is
somewhat annoying as compared to PHP
Mignon --
The short answer is that the two are fairly equivalent and if you're
asking the question then you're not going to run up against the nitty
gritty differences for a while.
In general, I bet you get more PHP is better answers on this list ;-)
Both can talk directly to databases, both
Scott --
...and then NIPP, SCOTT V (SBCSI) said...
%
...
% correct any of my errors. One other big advantage of PHP is this mailing
% list. The people in this list are quite knowledgeable and extremely
% helpful. I honestly have not found a group this supportive and responsive
Aha -- you
You appear to have a ton of extra braces. I've modified your code below.
That should do it, though keep in mind that your HTML is faulty too,
though most browsers will probably tolerate it. :)
--Dave
Michelle Whelan wrote:
I am looking to display results of a query inside of an html table.
Hello All,
Thanks for the all info !! I've done my query like this:
SELECT id,SUBSTRING(FROM_UNIXTIME(unixtime),1,10) as
unixtime,ip,porta_snmp,porta_switch,ip_cliente,mac_cliente from teste group
by unixtime,porta_switch,porta_snmp;
I've used SUBSTRING to get rid of the time from my
Mike,
Try mysql_fetch_array instead of mysql_fetch_row
--
Beverly Steiner
[EMAIL PROTECTED]
-Original Message-
From: Mike Delorme [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 20, 2003 12:01 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Not seeing whats wrong with
I mean, if I send an update query, like update table set
field1=$nfield1, field2=$nfield2 ..., I don't know WHICH fields have
changed. mysql_affected_rows() only reports how many records were
changed. So, if I want to know which fields have changed, I should
check
it before I send the query?
I am having a problem with a parse error.
error:
Parse error: parse error, unexpected ')' in
/Users/timbest/Sites/cajunmikes/inc/menupage.php on line 75
Fatal error: Cannot instantiate non-existent class: menu in
/Users/timbest/Sites/cajunmikes/TMPfj18cc2i20.php on line 7
The issue I am having
On 20 Mar 2003 at 12:43, Mignon Hunter wrote:
Can anyone out there compare these two using with mysql and web apps -
Well you've got a few good responses on this so I'll just add a bit.
If you do Perl you really *ought* to do mod_perl. It not only gives
you all the speed of PHP if not more,
[EMAIL PROTECTED] wrote:
IBI I am having a problem with a parse error.
IBI error:
IBI Parse error: parse error, unexpected ')' in
IBI /Users/timbest/Sites/cajunmikes/inc/menupage.php on line 75
IBI Fatal error: Cannot instantiate non-existent class: menu in
IBI
Hello, thanks for all replies guyes :)
i di this before reading them
?
include (db.php);
header(Content-type: text/plain);
echo
!DOCTYPE NETSCAPE-Bookmark-file-1
!--This is an automatically generated file.
It will be read and overwritten.
Do Not Edit! --
TitleBookmarks/Title
There are two ways that I know of the adjacency model
and nested sets.
adjacency model uses a table structure like
category_id | parent_id | category_name
so if i want to see all categories belonging to
category 12
- SELECT * FROM cat_table WHERE parent_id=12;
there are a few articles out
41 matches
Mail list logo