mlSpecialChars($headers[$line])."'";
Which should display.
--
Mike Karthauser
Managing Director - Brightstorm Ltd
Email >> [EMAIL PROTECTED]
Web >> http://www.brightstorm.co.uk
Tel >> 0117 9426653 (office)
07939 252144 (mobil
> Just wana ask is it possible to have only one form and when i submit, it
> should INSERT data into 2 diff tables??
> Hope u get my idea...
It is possible. You just need to do 2 single inserts to one to each table.
--
Mike Karthauser
Managing Director - Brightstorm L
ith web analyzer
http://www.websiteoptimization.com/services/analyze/
This is by far the most useful dev tool I have found recently. Saves
touching dial ups for testing..
--
Mike Karthauser
Managing Director - Brightstorm Ltd
Email >> [EMAIL PROTECTED]
Web >> http://www.brig
> is there a PHP function that wil return the names of the columns for a given
> table?
You need to use an SQL function called DESCRIBE
http://www.mysql.com/doc/en/DESCRIBE.html
HTH
--
Mike Karthauser
Managing Director - Brightstorm Ltd
Email >> [EMAIL PROTECTED]
Web
gt; username and password for mysql is in their respective places.
Logging in as root with no password remotely is not good. Try making another
user logged in locally with user and password, then try that from remote.
--
Mike Karthauser
Managing Director - Brightstorm Ltd
Email >
> However, when i connect to that computer from my windows computer and go to
> the phpmyadmin url it wont let me do anything. Ive set all the priveleges
> to allow full access in every way, but it still wont let me access it
What error do you get?
--
Mike Karthauser
Managing
resizing 200Mb
images are going to take ages.
--
Mike Karthauser
Managing Director - Brightstorm Ltd
Email >> [EMAIL PROTECTED]
Web >> http://www.brightstorm.co.uk
Tel >> 0117 9426653 (office)
07939 252144 (mobile)
Snailmail >> Unit
s there a way to make sure the data is 'clean' before entering into the
> table?
Do something like this:
$pagetext=ereg_replace(" "," ",$pagetext);
To strip the s
--
Mike Karthauser
Managing Director - Brightstorm Ltd
Email >> [EMAI
on 15/9/03 1:46 pm, Alain Barthélemy at [EMAIL PROTECTED] wrote:
> http://localhost/~webpage/?chosenLettre=65 /// where is $PHP_SELF
Try using $_SERVER['PHP_SELF']
--
Mike Karthauser
Managing Director - Brightstorm Ltd
Email >> [EMAIL PROTECTED]
here. You're testing to see if one
> string is greater than another... how can strings be greater than or less
> than? Why don't you just check for $myrow['date'.$i] != '-00-00' ??
Thanks. I'll make your change.
Ta.
--
Mike Karthauser
Managing Direct
te, 8, 2);
$dv[1] = substr($date, 5, 2);
$dv[2] = substr($date, 0, 4);
$display_date = implode ("-",$dv) ;
print("$display_date");
}
}
print_dates($bookdate);
?>
Which does what I need. The tricky bit was the //loop
cheers
--
Mike Karthauser
Managing Director - Bri
-00-00 and I wish to ignore these.
I'm trying to work out how to set up a loop to extract positive dates from
my db so I end up with
$bookdate[0] = '2003-09-01';
$bookdate[1] = '2003-09-02'; etc
Can anyone provide me with some help in this extraction?
Thanks in adva
he bottom frame aswell or only the top
> frame?
They are separate. Localhost knows nothing about the bottom frame as it is
only loaded by the frameset when it is client side.
It behaves the same way as if you had 2 browser windows open pulling in the
two URLs.
--
Mike Karthauser
Managing
his useful, too. Thanks a lot.
http://www.protx.com/ provide a gateway for oscommerce. Its in the
contributions section. Easy to install and the cheapest gateway we;ve seen.
--
Mike Karthauser
Managing Director - Brightstorm Ltd
Email >> [EMAIL PROTECTED]
Web >> http:/
on 25/6/03 4:15 pm, Ron Allen at [EMAIL PROTECTED]
wrote:
> Does anybody have an idea how-to use Flash and PHP to access a MySql
> database. I know how to use PHP and mysql with no problem to pull info, but
> with Flash I am struggling.
Look on flashkit.com
--
Mike Karthauser
affiliate. I think
that should save you some time ;-)
--
Mike Karthauser
Managing Director - Brightstorm Ltd
Email >> [EMAIL PROTECTED]
Web >> http://www.brightstorm.co.uk
Tel >> 0117 9426653 (office)
07939 252144 (mobile)
Snailmail
on 18/6/03 12:20 pm, John W. Holmes at [EMAIL PROTECTED] wrote:
> Not really a PHP question...
This is a php db list though.
> SELECT DISTINCT title FROM ...
Thanks for this.
--
Mike Karthauser
Managing Director - Brightstorm Ltd
Email >> [EMAIL PROTECTED]
Web
-
1 | pie.jpg | pie |
3 | pie2.jpg| pie2|
_
Many thanks/
mikek
--
Mike Karthauser
Managing Director - Brightstorm Ltd
Email >> [EMAIL PROTECTED]
Web >> http://www.brightsto
; include file through your web server.
That is what I meant by more secure. Putting files below webroot prevents
webusers from getting at them.
--
Mike Karthauser
Managing Director - Brightstorm Ltd
Email >> [EMAIL PROTECTED]
Web >> http://www.brightstorm.co.uk
T
t;);
> OCIExecute($query);
> ?>
>
> Thank you
Use an include file buried below your site root with
$user=USER1;
$pass=USER1PASS;
Then you should be able to do:
Include"/path/to/pass.inc.php";
$conn = OCILogon("$user","$pass");
Which is m
on 11/6/03 4:09 pm, mike karthauser at [EMAIL PROTECTED] wrote:
> I want to select item_code, qty from cart where cookie_id =
> $_COOKIE["cartId"]
>
> //the above select needs work
>
> And then email these to the client which I would do using php's mail
> f
ly trying to work out how to extract the contents of the cart,
convert the item_id to its item_code from products and then dump the results
to an email..
Can anyone provide me with some help in where to start.
thanks
--
Mike Karthauser
Managing Director - Brightstorm Ltd
Email
on 6/6/03 5:52 pm, André Sannerholt at [EMAIL PROTECTED] wrote:
> I'm wondering how to transfer variables in a php-document to the same script
> after the form has been submitted!?
if ($_POST['submit']) {
//stuff
} else {
// form stuff
}
HTH
--
Mike Karthaus
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 >
on 19/3/03 9:32 am, Achieve IT at [EMAIL PROTECTED] wrote:
> $company_name = $HTTP_POST_VARS['company_name'];
You also need $address_region = $HTTP_POST_VARS['address_region'];
Else you arent going to be able to pick up the variable or its value.
--
Mike Kartha
eate it on the fly or are you looking
to link to it in the PHP?
You can link flash to php and import variables using action script.
I am unsure what you are trying to achieve as your questions are a little
vague. Plus this is a database list.
--
Mike Karthauser
Managing Director - Brightst
on 18/3/03 8:44 am, rajni arya at [EMAIL PROTECTED] wrote:
>Does PHP supprots Flash files on Open BSD platform ?
Is that flash as in macromedia? What do you want PHP to do to the files?
--
Mike Karthauser
Managing Director - Brightstorm Ltd
Email >> [EMAIL PROTE
heir client machine then you're
going to have to do it server side.
Your script will upload and then resize.
--
Mike Karthauser
Managing Director - Brightstorm Ltd
Email >> [EMAIL PROTECTED]
Web >> http://www.brightstorm.co.uk
Tel >> 0117 9426653 (o
tent and link them via a simple
Previous | 1 2 3 4 5 | Next
type of scenario.
I got a query thus
$result2=mysql_num_rows($result);
to count our results. Does anyone have any pointers on what to do next?
Cheers
mikek
--
Mike Karthauser
Managing Director - Brightstorm Ltd
Email >&g
on 26/2/03 12:58 pm, MaN at [EMAIL PROTECTED] wrote:
> And also use $_POST[SUBMIT] or set register_globals On
Just use $_POST[SUBMIT]
register_globals was turned off for security reasons. You are compromising
the security of your system if you turn it back on.
--
Mike Karthauser
Manag
mysql database from duplicating the records?
any help would be appreciated.
cheers
mikek
--
Mike Karthauser
Managing Director - Brightstorm Ltd
Email >> [EMAIL PROTECTED]
Web >> http://www.brightstorm.co.uk
Tel >> 0117 9426653 (office)
esult if the
string appears.
so searching for 'Training Course" will find results like
Training Course 1
Training Course 2
Training Course n, etc.
Is LIKE the best way to do this or should i be using wildcards?
--
Mike Karthauser
Managing Director - Brightstorm Ltd
Email >>
s/ or some tutorial that i can
read though?
Thanks..
BTW kettles on if anyone wants a brew..
--
Mike Karthauser
Managing Director - Brightstorm Ltd
Email >> [EMAIL PROTECTED]
Web >> http://www.brightstorm.co.uk
Tel >> 0117 9426653 (office)
on 16/12/02 5:15 pm, mike karthauser at [EMAIL PROTECTED] wrote:
> I have a field in a news CMS that could contain " Infact most of the time it
> does in the form of URL's etc. Getting the data initially into the database
> is no problem - Infact MySQL shows has no toruble wit
a character
when i load them into my edit field.
I can imagine this is a common probem in CMS - any suggestions on a quick
fix..?
cheers
mikek
--
Mike Karthauser
Managing Director - Brightstorm Ltd
Email >> [EMAIL PROTECTED]
Web >> http://www.brightstorm.co.uk
,len)
> Returns the leftmost len characters from the string str:
>
> mysql> SELECT LEFT('foobarbar', 5);
> -> 'fooba'
>
> This function is multi-byte safe.
>
>
> select left(coursecode,40) from courses
> On Wed, 11 Dec 2002, mike kartha
only the first 40 characters of the title - even
though the full title lives in the db still (it is used throughout the
site)?
cheers
--
Mike Karthauser
Managing Director - Brightstorm Ltd
Email >> [EMAIL PROTECTED]
Web >> http://www.brightstorm.co.uk
Tel >
on 9/12/02 2:58 pm, Hutchins, Richard at [EMAIL PROTECTED]
wrote:
> Premature clickage...
>
> Or you could use a mediumint or int. Just check the mysql manual and select
> the int type that suits the size of your db best.
Ta. Thats working now.
Thanks from a 3 week old newb
| NULL||
| title | varchar(255) | YES | | NULL||
++--+--+-+-++
--
Mike Karthauser
Managing Director - Brightstorm Ltd
Email >> [EMAIL PROTECTED]
Web >> http://www.brightstorm.co.uk
We have been entering data into a mysql table and it has got to id=127 and
then stopped us from entering anymore data.
When i built the table i must have specified the size wrong. Can anyone
recommend how to fix this?
regards
mikek
--
Mike Karthauser
Managing Director - Brightstorm Ltd
Email
R['PHP_SELF'], $myrow["id"], $myrow["date"]);
} while ($myrow = mysql_fetch_array($result));
} else {
// no records to display
echo "Sorry, no records were found!";
}
--
Mike Karthauser
Managing Director - Brightstorm Ltd
Email >> [EMAIL PROTECTED]
W
;);
?>
Once i have selected from the drop box the variable is submitted back to my
table and saved.
When re-edit the data - the record already has a value for catcode which i
want to reflect within the drop box - in html it would be the addition of
selected="selected" within t
dreamweaver into a form box and posting it to the table.
What would a good varchar(?) be for say 5K of data?
cheers
mikek
--
Mike Karthauser
Managing Director - Brightstorm Ltd
Email >> [EMAIL PROTECTED]
Web >> http://www.brightstorm.co.uk
Tel >> 01
employee list
$result = mysql_query("SELECT * FROM address",$db);
if ($myrow = mysql_fetch_array($result)) {
// display list if there are records to display
do {
printf("%s\n", $_SERVER['PHP_SELF'],
$myrow["id"], $myrow["name"]);
} while ($myr
http://www.devarticles.com/art/1/23
All fine until it starts using globals...
My dev server is running php4.2.3 with globals off, mysql 3.23.52 on freebsd
4.7 stable.
Can anyone recommend any good tutorials for my query?
thanks
mikek
--
Mike Karthauser
Managing Director - Brightstorm Ltd
45 matches
Mail list logo
