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 (
Hi there:)
Take a look at nl2br() function ..it converts \n to 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. Whe
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 session
joining the tables) The
> biggest problem tho was that I have two servers 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 fro
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 PROTECTED]">new
> 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
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
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 'date
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 primar
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 i
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.
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
> o
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 vi
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. 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-
> Fr
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 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 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. 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
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
000c01c1ac43$5ca04c40$0200a8c0@chris">news:000c01c1ac43$5ca04c40$0200a8c
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 .
Jose Maria Sala <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:
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 passwor
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 hav
when a user goes to view an html code example, say with
a hyperlink, the hyperlink is made active replacing the code with the actual
tag.
Sorry for not being clear with my first post.
Cheers, Joe
"Joe Van Meer" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">new
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 Link
One. 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 Mailing List (http://www
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 insertin
26 matches
Mail list logo
