hi,
check the PHP Manual about MySQL functions:
http://www.php.net/manual/en/ref.mysql.php
you can also check for HTML forms (including checkboxes) here:
http://www.w3schools.com/html/html_forms.asp
and tables (for the reports):
http://www.w3schools.com/html/html_tables.asp
if you face a
Hi Grtz Erwin,
let me tell you wat i need to do.
1.) I have a login page - if the user logs in correctly i create
session(with session_start()) , a cookie is written to client +
session file to server.
2.)When the user logs off - i call the logOff.php page . The contents
are as follows
Hello Paul,
Monday, November 04, 2002, 10:00:15 PM, you wrote:
PN http://pear.php.net/bcompiler ?
PN ~Paul
super!
thnx a lot
I will try it
--
Best regards,
Alexander Kuznetsov
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hey guys I have a weird question. We are building a set of Perl modules
to edit system configuration and I've been given the job of writing a
PHP interface for it. Here's the situation:
Users.pm has all the functionality needed to safely add users to the
system. There are modules for dns,
I would like know the use of the following directory :
/usr/lib/php/extensions/no-debug-non-zts-20010901
Thanks for your help.
Pierre Vaudrey
email [EMAIL PROTECTED]
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
hi
When is create a session , and the browser refuses cookie i display an error
the the user. There was no cookie created on the clients pc (i know this)
but there is still a session file created on the server. When i use
session_destroy() the session was not deleted , why ?
Thanks
Shaun
Erwin [EMAIL PROTECTED] wrote in message
news:20021105082624.74531.qmail;pb1.pair.com...
Hi Grtz Erwin,
let me tell you wat i need to do.
1.) I have a login page - if the user logs in correctly i create
session(with session_start()) , a cookie is written to client +
session file to
I have heard about a bug in this version that also included some first 4
characters loss. Try searching
Daniele Baroncelli wrote:
Hi guys,
I have very weird problem.
I have installed the PHP version 4.2.3 on the LINUX virtual server of my web
project.
Previously I had the PHP version 4.0.6.
Your better off writing it from scratch than taking some pre-existing calendar/events
code. Break the problem up into two seperate pieces and solve for each - the creation
of a calendar view and the creation of a events view.
I am a calendar and I know how to:
Show a monthly view of myself
Did you get a request for a two part form, or for a form on 2 pages? The
problem I see is with browsers
without javascript (either turned of or not implemented)
Chris Rehm wrote:
I'd just like to see if I can get some feedback from PHP pros to see
if anyone is doing anything like this.
I've
body onload=yourForm.submit()
form name=yourForm action=mailto:address;server.net
input type=hidden name=ip value=?= $_SERVER['REMOTE_ADDR'] ?
/form
/body
is this what you want? This is too complicated, why not sending it from
the server?
Chris Shiflett wrote:
This type of question should be
Because the client did not supply you with the session id, so
session_destroy() doesn't know what file
to erase
Shaun wrote:
hi
When is create a session , and the browser refuses cookie i display an error
the the user. There was no cookie created on the clients pc (i know this)
but there is
hi,
who knows how to get all contents when i use javascript to get bookmark of
IE
ex:
window.external.ImportExportFavoritesfalse,http://localhost/test.php;);
because i use $_POST to get that data,but it can't get all data.
if it has 27593 bytes ,then only get 7XXX bytes. that means so many
I'm trying to create what I believe should be a simple script to help
with logging users into my site. My problem is that at the top of my
script I set a variable with it's value and then at later script I
cannot appear to access it.
Extract of my code is as follows and fails:
$IDField =
Allo,
Basically, my question is.. how do I do this? I am actually (for various ..
and probably stupid... reasons) trying to spawn a php process to run in the
background. This process I know will take a couple of hours to run (mailing
list stuff). I have been playing around with system to try
very true :)
thx - I will keep that in mind...
Chris Shiflett [EMAIL PROTECTED] schrieb im Newsbeitrag
news:3DC71CBE.2050703;php.net...
You can hide URLs by fetching them with one of your own PHP scripts:
base href=www.site.com
?
readfile(http://user:password;www.site.com/);
?
I think it
Are you just interested in getting the IP address of the visitor?
IF so, this info is already added to the website's apache log, so you
actually only need to go look through the log, or, if you want to make
it a bit more surgical, you can write the 'REMOTE_ADDR' variable
straight into a mysql
Marek Kilimajer [EMAIL PROTECTED] wrote in message
news:3DC7A6C3.7030105;webglobe.sk...
Because the client did not supply you with the session id, so
session_destroy() doesn't know what file
to erase
Shaun wrote:
hi
When is create a session , and the browser refuses cookie i display an
well - as far as I understand - this line...
$SessionUser = $row['.$IDFeild.'];
...should read:
$SessionUser = $row[$IDField];
so - in my eyes just a syntax error. I hope I'm right
in case you have session_autostart disabled in yout php.ini you first have
to start
the session with the
Basically, my question is.. how do I do this? I am actually (for
various .. and probably stupid... reasons) trying to spawn a php
process to run in the background. This process I know will take a
couple of hours to run (mailing list stuff). I have been playing
around with system to try to get
Hello,
How i format a number in currency ? Try find it on
php.net but i did not see nothing.
Anyone know this?
Augusto Flavio
__
Do you Yahoo!?
HotJobs - Search new jobs daily now
http://hotjobs.yahoo.com/
--
PHP General Mailing List
No way, you have to wait till garbage collector erases it
Shaun wrote:
Marek Kilimajer [EMAIL PROTECTED] wrote in message
news:3DC7A6C3.7030105;webglobe.sk...
Because the client did not supply you with the session id, so
session_destroy() doesn't know what file
to erase
Shaun wrote:
Hi,
try this function:
number_format -- Format a number with grouped thousands
Description
string number_format ( float number [, int decimals [, string dec_point
[, string thousands_sep]]])
Petr Tomenendal
On Tue, 2002-11-05 at 12:55, dark rotter wrote:
Hello,
How i format a number in
I've tried both methods without success.
header(Location: http://(user):(pass)www.mysite.com); does the transfer
but I still get prompted for a username and password by Apache
readfile(http://(user):(pass)www.mysite.com); brings a warning message.
Warning: readfile(http://...;www.mysite.com/)
http://www.php.net/manual/en/function.sprintf.php
Example 6 shows you how.
Rudolf Visagie
Principal Software Developer
Digital Healthcare Solutions
mailto:rudolf;dhsolutions.co.za
Tel: 011 6901019
Cell: 082 895 1598
-Original Message-
From: dark rotter [mailto:darkrotter;yahoo.com]
I have written 2 programs (which are very common PHP
programs) that A) Allows me to upload image files into a MYSQL database
using a simple form. And B) Allows me to retrieve and display the image
using a PHP script. This is my problem:-
I can upload the images ok. I store the binary code,
Yuk. I'll admit I don't like frames at the best of times, but is there any
reason why the two-part form can't be two *pages* rather than two *frames*?
The way I usually do that stuff is get them to fill in part a, then part b:
1) validates part a
2) decides what the part b form should look like
Just store the results of the first page into the session, get the
results from the second page, and then process everything.
Or serialize $_POST from the first page and pass it through the second
page in a hidden field.
I'd advise against using frames, just use two pages to get your results.
php-general Digest 5 Nov 2002 12:35:31 - Issue 1686
Topics (messages 122719 through 122766):
Re: Authentication with PHP and HTTP
122719 by: silver
122722 by: Chris Shiflett
122754 by: silver
122762 by: ed.home.homes2see.com
Re: [PHP-DEV] When my PHP file
Try adding header('Content-length: ' .strlen($data)); header
Darren McPhee wrote:
I have written 2 programs (which are very common PHP
programs) that A) Allows me to upload image files into a MYSQL database
using a simple form. And B) Allows me to retrieve and display the image
using a PHP
Your pseudocode is incomplete, because you do not show us where you call
this mysterious function that validates using $PHPSESSID.
The call is in the location where I have it defined.
Also, if that is really all your switch consists of, you're not really
gaining anything over using a
Hello there!
I am really new to PHP and in good old copy/paste tradition i was looking
for a script that would serve my needs - unfortunately without success.
Perhaps some of you could help me?
I am looking for a special print function:
I have three coloumns on the page. Under each there is a
Thanks guys gals, for clueing me in.
rija [EMAIL PROTECTED] 11/04/02 05:31PM
Why don't you cope with opendir / readdir () and array_rand ()
I tried it and I look ok-
But, I wonder if there are noble another way to do it?
- Original Message -
From: ROBERT MCPEAK [EMAIL PROTECTED]
To:
Why do you nee to use frames?
Wouldn't it be asier to set hidden fields in the second form and submit the
values of the first form to these hidden fields.
Personally I would submit the form into the same page
Chris Rehm [EMAIL PROTECTED] wrote in message
HI
I need to create a text file that is in a specific format from a mysql
query, and then ftp that file to another server.
The format will be something like this:
Cellphone: xx
Cellphone: xx
Cellphone: xx
Cellphone: xx
Cellphone: xx
Cellphone: xx
hi ines,
surely ther are several possibilities to solve this problem.
i would do it like this:
put your values in three arrays
suggesting your icons represents links, put a variable after each link.
with the 'switch; case' command you can evaluate the get variables, and
generate the pages with
There is nothing special about such function...
Simply pass a different GET variable
(site.com/page.php?getvariable=value) value for each column and have an
if/else logic in your PHP code.
--
Maxim Maletsky
[EMAIL PROTECTED]
www.PHPBeginner.com // PHP for Beginners
www.maxim.cx // my
Try learning about PHP CLI, it can solve some of your problems.
--
Maxim Maletsky
[EMAIL PROTECTED]
www.PHPBeginner.com // PHP for Beginners
www.maxim.cx // my Home
// my Wish List: ( Get me something! )
http://www.amazon.com/exec/obidos/registry/2IXE7SMI5EDI3
kevin [EMAIL
Can someone run over these functions I have written to explain if my
logic is correct.
I'm still new to PHP and am trying to get my head round it!
This first function is to collect a list of order numbers from my
database where checked = no.
Am I correct in assuming that the variable $orderid will
$orderid WILL NOT contain all the rows. mysql_fetch_array() returns only one row each
time it is called. Upon fetching last row, it returns NULL/FALSE/0. Therefore, as you
fetch each row, you will then execute your second function to pull all the data for
that
particular order number.
Your first function is only going to return one row of 'checked=no' records.
The second function will only return one column of the result.
What you want is a JOIN. You can do all of this with a single query. Without
knowing the format of your tables exactly, I can't give you the syntax,
though.
Hi,
double variables are rounded as integer
but GetType is 'double'
$a=10.2;
echo get_cfg_var('precision'); // print 14
echo ini_get('precision'); // print 14
echo GetType($a); // print double
echo $a; // print 10
I use php 4.1.2 / apache 1.3.24
but I have tried to upgrade to 4.2.3
without
I am pretty up to standard with getting stuff into and out of mysql,
so I am basically just in need of pointers with generating the text
file and ftp'ing automatically.
It would be an even greater plus if it wasn't actually necessary to
create a physical text file on the hard drive, but to
Hey all,
I was wondering if anyone could explain to me why I can't seem to maintain a
session using PHP 4.1.2 on my NT4 server. I am don't have any problems on my W2K/IIS5
or Linux machine. What I am doing is allowing my users to log on to the site at any
time, and then being returned to
Hi there,
I am trying to send an array to a database and visualize it again. Alltough
this sounds simple, for me hours!
I create the arry from a form, serialize it, urlencode it and send it to a
row in mysql. So far all ok, However, in mysqlfront (I suppose in every
prog.) the cell in the
Hey,
I am trying to develop a search for my database.
I used addslashes when entering the data, and then use addslashes with the
search but nothing comes up:
Select * from tblContacts, tblCountries WHERE
(tblContacts.CountryCode=tblCountries.CountryID) AND (Organization LIKE
'%o\'mallies%' )
Here I'm trying to explain my problem with better details...
I have a web server that I'm using to share file with my clients. So my
client are not using a ftp client software. Client have their own web_user
directory on my server example: ip. 202.202.020.1/adq is muy client
adq...
Clients
Don't know which database you're using but in Oracle you would use:
Select * from tblContacts, tblCountries WHERE
(tblContacts.CountryCode=tblCountries.CountryID) AND (Organization LIKE
'%o''mallies%' )
Escape(\) is only used in PHP syntax, not SQL.
Regards
-Original Message-
From:
show us your code...we can't read your mind
- Original Message -
From: alex koppie [EMAIL PROTECTED]
To:
Sent: Monday, November 04, 2002 4:58 AM
Subject: [PHP] PHP/MySql Array problem (newbie)
Hi there,
I am trying to send an array to a database and visualize it again. Alltough
this
what happens when you type:
Select * from tblContacts, tblCountries WHERE
(tblContacts.CountryCode=tblCountries.CountryID) AND (Organization LIKE
'%o\'mallies%' )
at the mysql command line?
- Original Message -
From: Paul Dionne [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday,
Hi to all,
I have a problem with function() and some variables.
The issue is this
I declare the function, suppose:
function test_func($param1) {
echo $param1;
}
when I call the function like;
?php test_func(123)?
works OK!
But if I try something like this:
?php
test_func(123);
Paul Dionne wrote:
Hey,
I am trying to develop a search for my database.
I used addslashes when entering the data, and then use addslashes
with the search but nothing comes up:
Select * from tblContacts, tblCountries WHERE
(tblContacts.CountryCode=tblCountries.CountryID) AND (Organization
First of all, you can't echo that variable in the manner you are trying.
Try this instead:
[lib.inc]
function test_func($param1) {
return $param1;
}
[main.php]
?php
// option 1
$num = test_func(123);
echo $num;
// option 2
echo test_func(123);
?
HTH
_
/ Joshua Minnie
Hi there, the php.net site said I should email you with problems.
The basic issue is that I have a user logon screen which works on a remote
server but not when developing on the same machine that is a local server.
I hold the username and passwords on mysql and ask the user for their
username
Hi there,
I posted this message yesterday:
--
I recently upgraded from PHP version 4.0-ish to 4.2.3 on my Linux/Apache
machine. AFAIK, Apache is setup correctly (it serves HTML) and PHP
works, but only from the command line. If I type php -q php.php
test.html the output of phpinfo() is
On Saturday, November 02, 2002 11:07 AM, I wrote
* I'm having a problem with the is_dir function, or maybe I don't
understand
how it supposed to work. I'm using the following code to check whether or
not a directory called $user_dir exists. If it exists, I am returned the
proper message.
On Tuesday 05 November 2002 23:56, Francisco Vaucher wrote:
This doesn't work. I need to get some variables values out of the function.
Is there a way to make te variables defined in the function 'global' ? So I
can use them after the function call.
Declare them as global:
?
doo(123);
Erwin
Thanks a million.
That's actually much simpler than I thought it would be...
I'm gonna give it a go just now, but I'm sure it will work!
Thanks again!
On Tue, 2002-11-05 at 17:09, Erwin wrote:
I am pretty up to standard with getting stuff into and out of mysql,
so I am basically just
Hi I'm building an parser for my own project called vibrant.
i need a file to be parsed, but I can't seem to get the right expression
please please help;
$src =
vibrant application=application 1
1vibrant application=application 2
2br
/vibrant
/vibrant
vibrant application=application 3
3
I'm about to undergo a creation of a Link Exchange script for my site. One of the
requirements is to have them have my button on their site in return for a button on
mine. This is required and I don't want cheating. The only way I can think of doing
this is checking their source code and making
I've seen this on a lot of news sites and such. How can I display only so many
characters, then put a ... to show that it's continued?
Thanks,
Stephen Craton
http://www.melchior.us
Life is a gift from God. Wasting it is like destroying your favorite item you
received from the person you love
$f = fopen($url_with_button,r);
$data = fread($f,100);
fclose($f);
if(substr_count($data,$your_homepage_link) == 0)
mysql_query(DELETE FROM users WHERE thereurl = '$url_with_button';);
or something like that.
On Tue, 2002-11-05 at 12:20, Stephen wrote:
I'm about to undergo a
Hi Stephen,
I've seen this on a lot of news sites and such. How
can I display only so many characters, then put a ...
to show that it's continued?
?php
$story = a really really really really long string;
$limit = 10; // how many chars to display
echo substr($story, 0, $limit). ...;
?
My credit card processor requires that I create an SSL connection in order to generate
a transaction key. How would I go about writing a script to do so. Please point me
in the right direction. The tech support says that it can only be done in ASP, but I
find that hard to believe.
--
PHP
Is it possible to get the entire url of the current page? I am particularly
interested in getting the username:password part.
http://username:password;www.mysite.com/path/to/file.php
_
Choose an Internet access plan right for you
Like:
$f = fopen(https://whatever.com,r;)
?
On Tue, 2002-11-05 at 12:31, [EMAIL PROTECTED] wrote:
My credit card processor requires that I create an SSL connection in order to
generate a transaction key. How would I go about writing a script to do so. Please
point me in the right
On Wednesday 06 November 2002 01:32, Phillip Erskine wrote:
Is it possible to get the entire url of the current page? I am
particularly interested in getting the username:password part.
http://username:password;www.mysite.com/path/to/file.php
print_r($_SERVER);
--
Jason Wong - Gremlins
Did you try getting rid of the
IfDefine HAVE_PHP4
stuff?
Lee Philip Reilly wrote:
Hi there,
I posted this message yesterday:
--
I recently upgraded from PHP version 4.0-ish to 4.2.3 on my Linux/Apache
machine. AFAIK, Apache is setup correctly (it serves HTML) and PHP
works, but only
Hi,
Wednesday, November 6, 2002, 3:21:03 AM, you wrote:
S I've seen this on a lot of news sites and such. How can I display only so many
characters, then put a ... to show that it's continued?
S Thanks,
S Stephen Craton
S http://www.melchior.us
S Life is a gift from God. Wasting it is like
Thanks for your reply. I took out the following lines, and restarted Apache,
but I still have the same problem...
/IfDefine
IfDefine HAVE_PHP
LoadModule php_module modules/mod_php.so
/IfDefine
IfDefine HAVE_PHP3
LoadModule php3_modulemodules/libphp3.so
/IfDefine
print $_SERVER['REQUEST_URI'];
--
Maxim Maletsky
[EMAIL PROTECTED]
Phillip Erskine [EMAIL PROTECTED] wrote... :
Is it possible to get the entire url of the current page? I am particularly
interested in getting the username:password part.
With print_r($_SERVER); I can get the server name and script path, but how
do you detect if username and password are in the url as in the example
below?
On Wednesday 06 November 2002 01:32, Phillip Erskine wrote:
Is it possible to get the entire url of the current page? I am
particularly
I am not sure if that is what they want. I will try it and get back. Good suggestion.
From: Adam Voigt [EMAIL PROTECTED]
Date: 2002/11/05 Tue PM 12:33:00 EST
To: [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: [PHP] Creating SSL Connection to Accept Credit Cards
Like:
$f =
I thought that using fopen to create an SSL connection was not yet supported
in PHP.
I would suggest the CURL functions for this.
--
JR
-Original Message-
From: Adam Voigt [mailto:adam;cryptocomm.com]
Sent: Tuesday, November 05, 2002 12:33 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL
Hi people,
is there a way to retrieve an array from a function ?
like:
?php
test_func($param1, $param2) {
//code
$test = array (ASD = Test1, ASDF = Test2);
return $test;
}
//outiside de function
echo $test; // - the array
?
This doesn't work. So, any clue ?
Regards and tks
I quote, from the comments on the fopen page:
Playing with fopen(https://xxx;, r) it seems that HTTPS is only
supported with OpenSSL AND PHP 4.3 . Older versions of PHP don't seem to
be able to do this.
So 4.3 or higher should work.
On Tue, 2002-11-05 at 13:01, Jonathan Rosenberg (Tabby's
Try this...
$test_arr = test_func( $param1, $param2 )
echo $test_arr;
On Tue, 2002-11-05 at 18:01, Francisco Vaucher wrote:
Hi people,
is there a way to retrieve an array from a function ?
like:
?php
test_func($param1, $param2) {
//code
$test = array (ASD = Test1, ASDF
hi,
this one worked well, but to print the array you must use print_r() instead
of echo
print_r($test);
khalid
_
Protect your PC - get McAfee.com VirusScan Online
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
Ugh. Read the in the manual about variable scope, and how to call a
function. It's all there. To get you started...
print_r ( test_func() );
Francisco Vaucher wrote:
Hi people,
is there a way to retrieve an array from a function ?
like:
?php
test_func($param1, $param2) {
//code
I'm having trouble with a script to upload images, which is baffling me
because a similar script has worked fine on other occasions. I can get
the image file uploaded to the correct directory, but it is uploading in
ASCII and I obviously need it in binary. The file name on the form is
like this:
sorry ... big said the right, but you must use print_r() if you want to
print the array
_
Internet access plans that fit your lifestyle -- join MSN.
http://resourcecenter.msn.com/access/plans/default.asp
--
PHP General Mailing
Except that https:// doesn't work with fopen until PHP 4.3.0.
Suggestions are only good if they work with a current version of PHP. :)
(No, I don't consider 4.3.0 current until it's at *least* released)
Regardless, until then, CURL support is probably the way to go.
Assuming you have curl
Duh dude, it's clear they only work in 4.3.0. I already said that in a
previous message, pay attention.
On Tue, 2002-11-05 at 13:09, Jaime Bozza wrote:
Except that https:// doesn't work with fopen until PHP 4.3.0.
Suggestions are only good if they work with a current version of PHP. :)
(No,
Part of the ugh thing is because I'm having a crappy day. However,
the main part of the ugh thing is because of people not doing any
research before posting a question here. It has nothing to do with my
wanting to answer the question or not, I enjoy helping out here, and I
have gotten
Good Afternoon People
I am trying to create a site where you can add/delete players
From a roster
So what I need help is how to automatically format the check
Boxes to appear in every row
And to know how to do the add/delete part
If anyone can come online with me and talk to me that would
What is your form tag like...
try
form action=somefile enctype=multipart/form-data
method=somemethod
On Tue, 2002-11-05 at 18:08, drparker wrote:
I'm having trouble with a script to upload images, which is baffling me
because a similar script has worked fine on other occasions. I can get
Is there anything else that I can do. I am running PHP 4.1.2 so the fopen() doesn't
work and I donot have support for CURL. Any other suggestions?
From: Jaime Bozza [EMAIL PROTECTED]
Date: 2002/11/05 Tue PM 01:09:37 EST
To: 'Ben C.' [EMAIL PROTECTED], 'Adam Voigt' [EMAIL PROTECTED]
CC:
Ok, very basic question, how do I am going through a loop 5 times, each
time, I want to store a value into an array, do I simply set the value of
$picture=array($mypics);
and each time it loops it will take the current value of $picture and then I
can get out each value by $mypics[0],
Yeah, whatever,
I looked o_O in the manual and i didn't find the answer. I wrote here and
also didn't find the answer...
Sorry if we aren't all perfect, and dedicated as you are...
Have a 'crappy day'
Francisco M. Vaucher
Departamento IT
Tyco / ADT Security Services
Buenos Aires - Argentina
On Wednesday 06 November 2002 01:54, Phillip Erskine wrote:
With print_r($_SERVER); I can get the server name and script path, but
how do you detect if username and password are in the url as in the example
below?
Basically if you don't see it when you do print_r($_SERVER) then you can't
have
It's really not that hard
Returning values from functions
http://www.php.net/manual/en/functions.returning-values.php
Variable scope
http://www.php.net/manual/en/language.variables.scope.php
It's not on the main page, you actually have to look beyond there.
Francisco Vaucher wrote:
If I understand your question, you are trying to store values into an array:
for( $=0; $i5; $i++)
{
...get $picture from somewhere...
$mypics[] = $picture;
}
To retrieve:
foreach($mypics as $pic)
{
...do something with $pic...
}
- Original Message -
From: Edward Peloke [EMAIL
Kristopher Yates wrote...
I'm trying to compile PHP4.2.3 for Mac OSX 10.2 (Jaguar). Has anyone else had
this problem (see below)?
Yes, seemingly. You can get 4.2.3 at http://www.entropy.ch/software/
macosx/php/, and this page also comments on build problems and build
instructions on the
I'm writing an SQL query in a php 4.0 script. The query pulls data from an
MS Access '97 database through an ODBC connection.
I'm having difficulties creating a condition using LIKE.
If I write the following expression, the query works:
$Query=
SELECT FieldName1, FieldName2
FROM TableName
hi,
the function array is for making a new array. Observe this code and you will
get the point
(assuming that you won't to loop for five times)
$myarr= array()
for ($i=0;$i=5;$i++)
{
$myarr[$i]=$i;
}
//you can then get the values of the array
echo $myarr[0];
echo $myarr[1]; //and like that
I am not up on my MS Access database sql but i would check to see if ms
access supports the like condition in the where clause...
On Tue, 2002-11-05 at 18:49, Don Hicks wrote:
I'm writing an SQL query in a php 4.0 script. The query pulls data from an
MS Access '97 database through an ODBC
[snip]
$Query=
SELECT FieldName1, FieldName2
FROM TableName
WHERE FieldName1 LIKE '$CriterionRecord'
;
[/SNIP]
The LIKE criteria needs to be surrounded by wildcards...
WHERE FieldName1 LIKE '%$CriterionRecord%'
HTH!
Jay
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe,
BINGO!
That was exactly what I needed!
Thanks!
Don.
===
Jay Blanchard [EMAIL PROTECTED] wrote in message
news:003801c284fc$4fd8d2b0$8102a8c0;000347D72515...
[snip]
$Query=
SELECT FieldName1, FieldName2
FROM TableName
WHERE FieldName1 LIKE '$CriterionRecord'
;
[/SNIP]
The
I am trying to develop a search for my database.
I used addslashes when entering the data, and then use addslashes with the
search but nothing comes up:
Select * from tblContacts, tblCountries WHERE
(tblContacts.CountryCode=tblCountries.CountryID) AND (Organization LIKE
'%o\'mallies%' )
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
He isn't.I create the arry from a form, serialize it, urlencode it and
send it to a row in mysql.
Alex:
Can you send me some of the code you're using?
~Pauly
On Tuesday 05 November 2002 12:09 pm, Maxim Maletsky wrote:
You can't send the whole
1 - 100 of 208 matches
Mail list logo