Hi there:)
I use odbc so you'll have to change your functions if you're using mysql
//connect to db
$connectionToDB = odbc_connect(cdconsultant, joecon, joecon);
//create query statement
$sqlr = SELECT DISTINCT category FROM CONSULTANT ORDER BY category ;
//execute the sql statement (query)
Hi there:)
Take a look at nl2br() function ..it converts \n to br tag
HTH Joe :)
Jairo Tcatchenco [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hi all!
I have a table in postgres with a field type text, where I can
store a formated text. When I
Hi there :) One of the most common methods of achieving this is by using
session variables. First the user logins in through a form with a username
and a password, you check these against the database to make sure they are
who they say they are, once that is established you could create a
perfect solution yet :)
is there such a thing? :)
Jd Daniels [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I am just going to interject a second here... sorry :P
About storing images on a server... I did that for awhile, but once i hit
1000+ images, my
Hi again JD...I got to thinkin':)
Just out of curiosity...how many images were you bringing back from the db
when your script timed out?
I store the path of my image in the db and echo it out when I need to.
Cheers Joe:)
Jd Daniels [EMAIL PROTECTED] wrote in message
[EMAIL
working as web farms. if
one
domain needed access to the photos from another domain located on the
other
server, I could not open the photos. (For resizing and such) When they are
in the db, I can get them from anywhere.
JD
-Original Message-
From: Joe Van Meer [mailto:[EMAIL PROTECTED
Hi there, sounds like you do not have the proper read/write permissions on
that file.
HTH Joe :)
Penockio [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I can't use sql command insert into but I can use select and it
condition.I use DSN that provide by ODBC
Thx Jakob,
appreciate the help
Cheers Joe :)
Lerp [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hi there. Got a bit of a snag. I'm migrating an ASP app to PHP with a
mssql7.0 backend. The snag is this, I have a 'starttime' field in my db
using the
Hi there. You bet you can have relationships between tables! You accomplish
this by setting primary keys and foreign keys when you create you tables.
When you assign a unique identifier to a table not only do you assign a name
such as employeeid for example, you also have to set it as the primary
Hi Danny, you could use a cookie to store the user's username and password
once they first successfully login the first time or even better upon
signing up to your site. Then, on the login page(or whatever page is
displayed prompting a login) you could check for the cookie at the top and
redirect
Hi. addslashes() going in to db, stripslashes() coming out :)
HTH Joe :)
Todd Williamsen [EMAIL PROTECTED] wrote in message
002601c1b033$382a4700$f6b2d83f@goofy1">news:002601c1b033$382a4700$f6b2d83f@goofy1...
Paul,
It is being inserted into a database
-Original Message-
From:
Hi Ken,
The %s is a method of formatting a string. Why not try echo or print
command instead?
As for the other problem on line 26, the mysql_query returns a resource id #
(an integer). You'll have to use that number in your loop to retrieve the
results after.
Here's an example:
$connectionid
Hi. Post up some code so the ng can help you out. :)
Justin Hall [EMAIL PROTECTED] wrote in message
01c1b015$54445250$fdd80918@CT41311A">news:01c1b015$54445250$fdd80918@CT41311A...
I have a script that calls a function to perform a query using the
arguments sent to the function via
Why couldn't you use something like this:
$mystr = substr($mystr, -3);
Joe
Jeroen Timmers [EMAIL PROTECTED] wrote in message
003001c1b026$97373cb0$7f6440d4@jeroen">news:003001c1b026$97373cb0$7f6440d4@jeroen...
you can take the function substr from php in combination with strlen
(lenght
of a
Try looking at the unlink() function. It removes files off of the web
server.
HTH Joe :)
Todd Williamsen [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I created a couple of forms where one inserts new contact data with a
file,
in this case its a resume.
ammendment:
use the unlink() function once you have confirmation of a successful update
:)
HTH Joe :)
Todd Williamsen [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I created a couple of forms where one inserts new contact data with a
file,
in this case its
Hi there, make sure you aren't outputting anything to the browser prior to
sending headers ie the echos on top of page 3. When you register a session
variable you should assign it a value ie:
session_register(mysessionvar);
$mysessionvar = $whateveryouwish;
Also make sure session_start(); is at
Hi there, you could grab the whole file name from db, form, etc... strip it
down to the '.jpg' , concatenate $IDNUMBER . $NUMBER OF PICTURE , then
rename it using the combination of $IDNUMBER . $NUMBER OF PICTURE .
?php
$myfile = 'webgraphic.jpg';
$IDNUMBER = 55;
$NUMBEROFPICTURE = 999;
hi there. check out the image functions : 'imagecreatefromjpeg',
'imagecopyresized', 'imagecreatefromgif', and 'imagecreate' in the php
manual http://www.php.net
hth joe
;0
Chris Payne [EMAIL PROTECTED] wrote in message
hi there. if you are unable to set it on the db end why not insert/update
the current date along with your insert and update queries?
hth joe :)
Todd Williamsen [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I want the date to automatically be updated. So if a
did test to see if $id was actual the value you were expecting? is $id an
auto increment field?
Chris Payne [EMAIL PROTECTED] wrote in message
000c01c1a23a$ef779900$0200a8c0@chris">news:000c01c1a23a$ef779900$0200a8c0@chris...
Hi there,
Can anyone see what is wrong with this query? I am trying
Hi there, you could use the SUM function in your sql statement...like SELECT
SUM(count_view) FROM TABLENAME;
Hope this helps :) Joe
Barry Rumsey [EMAIL PROTECTED] wrote in message
3C4C4D15.0A.00872@weiz-main">news:3C4C4D15.0A.00872@weiz-main...
In one of my tables I have a
Post up some code and somebody will help :) Joe
James Kupernik [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I'm creating this form where the person needs to enter a password to move
on. When they enter the password it just loops back to enter the password
Hi there...I have a db filled with various HTML code examples, tags, etc...
how would I format it so that it would appear like A href='index.php'Link
One/a. I was using the strip_tags() function and quickly found out that
this wasn't the best way to do it :)
Cheers, Joe:)
--
PHP Database
to view an html code example, say with
a hyperlink, the hyperlink is made active replacing the code with the actual
a href tag.
Sorry for not being clear with my first post.
Cheers, Joe
Joe Van Meer [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hi t
Hi there. I have a small php app connected to sqlServer db. The app is used
as a code library for various programming languages. My problem is this, I
would like to be able to insert the code for a function (the actual code)
into the db. However, I keep running into the quote problem when
26 matches
Mail list logo
