to the backend.csv file that
it uses. Everything is working properly included the submitting of the
events, and the data is being imported correctly. Has only used this script
before, or maybe has some ideas on what I need to check? Thanks in advance.
matthew de Jongh
president
the spa! internet
voice
to the backend.csv file that
it uses. Everything is working properly included the submitting of the
events, and the data is being imported correctly. Has only used this script
before, or maybe has some ideas on what I need to check? Thanks in advance.
matthew de Jongh
president
the spa! internet
voice
Here's how I do it using functional PHP programming (you may prefer using OO
PHP which I don't bother with) :
I include a generic functions file in each page. You could take it further,
opening and closing the database connection for every query, but this way is
more efficient if more than open
I'm running php 4.3.0 on windows 2000. The following code woks :
?php
if (imagetypes() IMG_PNG) {
echo PNG Support is enabled;
}
?
Producing the following output :
PNG Support is enabled
The manual suggests that the imagetypes() function has been available since
php 4.0.2. But, quoting
php_gd2.dll probably needs to be copied from your php install directory to
your windows system directory (so that it is in the path thingy). On my
system that translated to :
copy c:\php\extensions\php_gd2.dll to c:\WINNT\php_gd2.dll
for more information see,
Hi, im fairly new to php and mysql and need a little help. im running a
forum community and would like to have it run on multiple databases because
of performance issues others have encountered using the same software on on
database. My question is is it possible to have the software connect to 2
I have set up a database so that users can submit news to my website. The
only problem is they input their news article into the database through a
form but it comes out as a continuous string of text.
(a) shows what it looks like now, and (b) shows how its supposed to look.
How can they
Where exactly do I need to insert this?
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For
Sorry for putting three topics in one but they all go together so I thought
I would.
I am setting up a user login/members area!
* Firstly how do I generate a random password?
* Then how do I email it to the user?
* And now I need to know how to set a cookie with their username and
password
Thanks!
Is there anyone who can actually give me little bits of code that I need
cause I am in a rush with this
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
--
PHP Database Mailing
I am lookign for a piece of code that will detect the resolution of the user
and return a page dependant on that i.e - The table will be adjusted to suit
that.
Is there a script where I can detect what the resolution is, and also
redirect to a page depending on what resolution they are using?
Why not just create a table that will resize to any resolution?
Because I am using different sized images for the different resolutions as
well as other page thingys.
And I need the script for other things too.
So can anyone help?
I have a homepage which has a news headline system. Bascially via form the
admin of the site can submit news which appears on the front page, the only
problem is the news just keeps coming and I have a front page with too many
headlines on.
How can I make it so that say 7 articles appear on
How do I get my select form to select a value for $num_view and refesh the
page?
SELECT * FROM table_name ORDER BY n_id DESC LIMIT $num_view
I now need a dropdown box that has set values for 5,10,15 and 20 so that the
user can select a number of news articles to view and it will refresh the
From: Ben Cairns [EMAIL PROTECTED]
To: php-db [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Drop down box
Date: Thu, 1 Mar 2001 14:06:21 +
Hope this helps
-- Ben Cairns - Head Of Technical Operations
intasept.COM
Tel: 01332 365333
Fax: 01332 346010
E-Mail: [EMAIL PROTECTED]
Web:
Is there anyway of reducing bad gateway errors on my mysql messageboard,
members are starting to get really irritated by it?
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
--
PHP Database
I am setting up an episode guide for one of my favourite shows and with this
I need to include three screenshots:
episodeID_a.jpg
episodeID_b.jpg
episodeID_c.jpg
In some cases though the files will not exist and therefore I need too check
if they exist and if they don't then it will display a
Why isn't this working?
?php
$img[] = "$episodeID_a.jpg";
$img[] = "$episodeID_b.jpg";
$img[] = "$episodeID_c.jpg";
for ($x=0; $xcount($img); $x++) {
if(!file_exists($img[$x])) {
print("td align=centerimg src=\"blank.gif\" width=160 height=120
border=\"1\"/td");
} else {
Does anyone know how I can move tables from one database to another using
phpmyadmin?
Please help, thanks!
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
--
PHP Database Mailing List
it (although
the execute flag is turned off, AND the filename is difficult to get.. ) and
would like to reduce the possiblity..
any suggestions?
--
matthew knight - online developer
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED
when you say an error - do you mean any error?
or specific errors? ie., you're not getting it stuck in an infinite loop?
(cpu time flips up to that when you stick in a loop)
or is it all errors?
PHPFAN [EMAIL PROTECTED] wrote in message
9eetk0$92d$[EMAIL PROTECTED]">news:9eetk0$92d$[EMAIL
try looking at the fseek function, i think that does what you want:
http://uk.php.net/manual/en/function.fseek.php
John Starkey [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hello all.
I'm trying to set up a quick find and replace script. It's finding, and
I really need help here. What I am trying to do is the following.
-
$today = date(m.d.y);
$time = date(g:i a);
if($row[3] == $today){
if(($row[4] $time) and ($time $row[6])){
print(Now Showing);
} else {
print(Today at $row[4]);
}
}
You aren't calling mysql_query() to execute the query.
//$find is text box input
$wordsarray = explode( ,$find);
$sql = SELECT bandname FROM bands WHERE (bandname
LIKE ;
$i = 0;
while ($i count($wordsarray))
{
$word = current($wordsarray);
next($wordsarray);
$sql=$sql.$word);
The code you're referencing is my modification of his original post. :)
-Original Message-
From: Ben Bleything [mailto:[EMAIL PROTECTED]]
Sent: Sunday, July 08, 2001 8:04 PM
To: 'Matthew Loff'; 'Mark Gordon'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Dynamic SQL + result resource error
To: 'Matthew Loff'; 'Mark Gordon'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Dynamic SQL + result resource error
Guess I'm just a big dumbass then, aren't I =P
Oops.
I suppose that would cause it to fail then, wouldn't it?
= Ben
-Original Message-
From: Matthew Loff [mailto:[EMAIL
Everyone suggesting Easy! Just install Mysql! makes me laugh... :)
Jeff-- I suggest you check:
1) http://www.hotscripts.com/
2) http://www.zend.com/
3) http://www.sourceforge.com/
4) http://www.mysql.com/ (Just kidding!)
Any shopping cart that uses ODBC should work just fine-- and moreso,
What about...
SELECT WLPbib.bibID,
WLPbib.title,
WLPbib.publisher,
WLPbib.publicationDate,
WLPaddress.city,
WLPaddress.state,
WLPprofile.firstName,
WLPprofile.lastName,
WLPprofile.organization,
WLPcountry.languageName
FROM
To: Matthew Loff
Cc: 'Dobromir Velev'; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Left Join is producing duplicate results - MySQL
relational tables
Hi Matthew,
Matthew Loff wrote:
What about...
SELECT WLPbib.bibID,
WLPbib.title,
WLPbib.publisher
I think he just means a hypertext anchor, that contains a string
identifying the record.
A HREF=fun.php?id=$id
-Original Message-
From: Ken Sommers [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 12, 2001 11:27 PM
To: Rankin, Randy; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Escaping
Brad--
I see what you're trying to do. Here's how this issue with a site I
did, perhaps this will help:
Eliminate the database of images all together. Create an image that
says No Picture Available, and save it as /images/no_photo.jpg.
When (if) a user uploads a file, have it rename the file
I'm assuiming this means you're pulling the name from the DB and putting
it as the value of a text input, as in:
INPUT TYPE=TEXT NAME=name VALUE=$name
The quotes should fix that problem.
-Original Message-
From: Christopher Hebert [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July
It might help us to see exactly what the query is...
Could you insert an echo statement and let us know what SQL query it's
producing?
echo
INSERT INTO News
(NewsDate,NewsTitle,NewsText)
VALUES
('$NowDate','$NewsTitle','$NewsText')
;
-Original Message-
From: AKA Hook
PROTECTED]]
Sent: Sunday, July 15, 2001 3:56 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] PLEASE HELP! Problem with ODBC string insert
Here is the echo output.
UPDATE News SET NewsTitle = 'Text',
NewsText = 'can\'t use quotes!' WHERE NewsID = 16
Matthew Loff [EMAIL PROTECTED] wrote in message
Ken--
If you have access to that server with the SQL database... Then instead
of creating an additional PHP script on the SQL server... Could you
simply add a username/password that was allowed to access that
particular database (read-only, of course) remotely?
If that isn't an option,
and
double but nothing has worked.
There HAS to be an answer out there! Do certain SQL statements just not
work in PHP / Access? Is this a bug in Access or PHP?
If I can't get this to work then I won't be able to use PHP for this
site! Someone please shed some light on this!
Matthew Loff [EMAIL
]]
Sent: Monday, July 16, 2001 1:40 AM
To: Matthew Loff; 'PHP DB Mailing List'
Subject: Re: [PHP-DB] relay response transactions between PHP scripts on
different servers
Here's the part that confuses me:
How does MovieResponder.php on your site get the results back to my site
and back to the browser
The body of the response is the data that the
http://www.site.com/MovieResponder.php script would produce.
The fread() call that I meantioned before would read -all- of this data
into a variable.
-Original Message-
From: Ken Sommers [mailto:[EMAIL PROTECTED]]
Sent: Monday, July
1977
Movie Three 1977
Easy as that! It's a very simple concept.
-Original Message-
From: Ken Sommers [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 16, 2001 4:04 PM
To: Matthew Loff; 'PHP DB Mailing List'
Subject: Re: [PHP-DB] the body of the response
thanks for response,
I am curious
the output of http://snaps.php.net/.
Good luck!
--Matt
-Original Message-
From: Ken Sommers [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 16, 2001 4:50 PM
To: Matthew Loff; 'PHP DB Mailing List'
Subject: Re: [PHP-DB] the body of the response
MR.Loff,
I see the concept.. but i still don;t
with PHP-- I'm sure others on the list could make some great
recommendations.
--Matt
-Original Message-
From: Ken Sommers [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 16, 2001 5:17 PM
To: Matthew Loff; 'PHP DB Mailing List'
Subject: Re: [PHP-DB] the body of the response
I looked up Output
are you saying that i can grab the output of your echo() statements in
YOUR PHP script by Fopen()ing your URL in MY script and then Fread()ing
that resulting file pointer?
--Yes! That's -exactly- what I've been trying to explain. :)
That's the -best- way I can think of retrieving the info
The mysql_connect() function accepts a host name, which can be the
internet address of another machine! However-- the MySQL database on
that machine has to be set up to allow outside connections for whatever
particular username/password you are using!
Please see these pages to answer your
Message-
From: Ken Sommers [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 16, 2001 6:56 PM
To: Matthew Loff; 'PHP DB Mailing List'
Subject: Re: [PHP-DB] remote database exchange
Suppose I Need to get Vendor prices from a very large remote (Oracle)
price list . They probably don't have PHP installed
I am not familiar with Oracle, but by looking through the PHP docs, it
appears that you can't connect remotely to an Oracle server...
Am I wrong about this, or is it a limitation of the Oracle library, or
is Oracle not built to allow remote connections?
-Original Message-
From: CC
Even if a PHP host doesn't have all the DBMS extensions you need, you
could compile them and load them yourself with dl()
http://www.php.net/manual/en/function.dl.php
I thought you might want to keep that in mind, in case one particular
host has a great price but not all the features you
in:
if(!extension_loaded(mysql)) dl(mysql.so);
That's assuming that the mysql ext. is named mysql.so in a compiled
state, of course.
-Original Message-
From: Ken Sommers [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 16, 2001 9:26 PM
To: Matthew Loff; 'PHP DB Mailing List'
Subject: Re: [PHP-DB] php/mysql
modules is another story-- I'm not quite sure
how to. Can anyone else help?
-Original Message-
From: Ken Sommers [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 16, 2001 10:18 PM
To: Ken Sommers; Matthew Loff; 'PHP DB Mailing List'
Subject: Re: [PHP-DB] php/mysql/unix-Linux hosting with major
[mailto:[EMAIL PROTECTED]]
Sent: Monday, July 16, 2001 11:45 PM
To: Matthew Loff; 'PHP DB Mailing List'
Subject: Re: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS
support?
thanks Mat,
I found this FAQ:
When I try to connect to mysql from php I get this error: Call to
unsupported
. mysql.so) that you need... I'd check for .rpm
files...
-Original Message-
From: Ken Sommers [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 17, 2001 12:43 AM
To: Matthew Loff; 'PHP DB Mailing List'
Subject: Re: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS
support?
I think and hope
Whats wrong with this?? Its not working...
Search.php
?php include(search_bool.inc); ?
?php
$connection = mysql_connect($host,$dbusername,$dbpassword) or die
(Cannot connect to server.);
$db = mysql_select_db($dbname, $connection) or die (Could not select
database.);
$sqlstring = SELECT
In Oracle, the syntax for a theta-style join (the one you're describing)
is:
SELECT ...
FROM ...
WHERE item1 (+) = item2
However, MySQL doesn't support this syntax. The only way to do left
(outer) joins in mysql is the way you described:
SELECT ...
FROM ...
LEFT JOIN ... ON ... = ...
Certainly not in the PHP manual, and LIKE isn't really covered in the
MySQL manual either...
Here's a good page with an intro to SQL queries:
http://developer.ecorp.net/sqltut.htm
--Matt
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 25,
Good call, Paul...
I checked through the manual briefly to see if LIKE was in there, I
guess I missed that page.
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 25, 2001 5:08 PM
To: Matthew Loff; [EMAIL PROTECTED]; 'PHP DataBase-List'
Subject
strftime(format, strtotime($database_time_string));
format is defined in the page for strftime(). strtotime() converts
the MySQL date into a UNIX timestamp.
-Original Message-
From: Caleb Walker [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 18, 2001 4:06 PM
To: [EMAIL PROTECTED]
This has been covered countless times on the list... :)
http://www.php.net/manual/en/function.mysql-insert-id.php
-Original Message-
From: Grant Boggs [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 22, 2001 7:24 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Getting key of row just
You'll have to take care of the recursive directory walking function...
Here's code I found to get the ID3 tag from an MP3 file:
http://px.sklar.com/code.html?code_id=429
--Matt
-Original Message-
From: pjc [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 17, 2001 12:13 AM
To:
PostgreSQL does row-level locking... But I'm more familiar with MySQL,
as I presume you are...
If you want to rely on MySQL's table locking, but are worried about a
user aborting the script, see:
http://www.php.net/manual/en/ref.misc.php
A combination of ignore_user_abort() and
There should -not- be a semicolon at the end of the SQL query when using
mysql_query() through PHP...
http://www.php.net/manual/en/function.mysql-query.php
The problem lies elsewhere.
-Original Message-
From: Vera Algoet [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 17, 2001
Hello,
I am having trouble getting data from a DATETIME field in MSSQL 7.0.
The data in a general select query look like this:
2001-09-25 14:23:17.000
I can do this in MSSQL:
select * from INTERNETLOG where Datetime like %2001%
but not this:
select * from INTERNETLOG where Datetime like
ASP list members will tell you ASP is better/easier for this, PHP list
members will tell you PHP is better/easier for this.
You're asking a pretty loaded question...
I, personally, believe that PHP is much better/easier, but I learned PHP
coming from a C/C++ background.. If you have done
: Matthew Loff [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 01, 2001 10:11 PM
To: 'Radith'; '[EMAIL PROTECTED]'
Subject: RE: [PHP-DB] Newbie But Urgent
ASP list members will tell you ASP is better/easier for this, PHP list
members will tell you PHP is better/easier for this.
You're asking
Dates in MSSQL are stored as:
mon dd hh:miAM (or PM)
and ODBC converts them to:
-mm-dd hh:mi:ss.mmm(24h)
so:
select * from Internetlog where convert(varchar, LogTime, 121) like
'%2001-10-02%'
-Original Message-
From: Matthew DeChant [mailto:[EMAIL PROTECTED]]
Sent: Monday
Without spaces, the URL won't line break...
I recommend one of two things...
1) Use a for() or while() loop with substr(), to print out, say, 50
characters per line, then break to the next line, until reaching the end
of the string...
2) Use an ellipsis (...) to cut out the middle of the URL
If you use the at symbol to supress the error message from being
printed, the if() statement will still recognize an error has
occurred... So, try this:
if (@mail($email,$subject_confirm_account, $message_confirm_account,
$from_confirm_account)) {
?php
/*
Hi,
I'm new to PHP and am having trouble understanding how to use PHP
sessions. My book tells in near the beginning how to start them and register
session variables, but I can't figure out how to destroy a session or later
read those session variables. I'm also trying to do this
You are overwriting the first row.
$result = mysql_query(SELECT clubac.id AS clubacid, clubac.club_id,
clubac.ac_year, clubac.ac_type, club.id
FROM clubac, club WHERE club.id = '$club_id' AND clubac.club_id =
club.id);
if(mysql_num_rows())
while ($row = mysql_fetch_array($result)
is there any to write columns first but still call fields with headers?
as writing in a table would not allow keeping tr tags open
ie.
echocol[1];
echocol[2];
array_flip do the job?
but how?
Sean
Matthew Loff [EMAIL PROTECTED] wrote in message
005c01c163e0$5716ca20$0ce60281@bang"
of it's current function when done doing those things?
This is a pretty disasterous inability, not recognizing code blocks.
--Matthew
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list
You have the wrong list.
http://www.mysql.com/documentation/lists.html
-Original Message-
From: Jonathan Hilgeman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 20, 2001 2:56 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL Restarting A LOT
Okay, this is beginning to bug. I
Using PHP, how can I spawn a process and execute non-PHP code
off the console?
--Matthew
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL
solved my own problem.
if anyone else needs it, the function is substr($string, firstposition,
number)
http://www.devshed.com/Server_Side/PHP/StringTheory/page4.html
Mateo The Db Guy wrote:
i'm fairly new to php, and thank you in advance for helping.
is there a function that will extract the
You can system()/exec()/passthru() and run rundll32 on the library,
can't you?
-Original Message-
From: James Moore [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 09, 2001 12:34 PM
To: Alain Samoun; GRI
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]; [EMAIL PROTECTED]
You need an associating table; members and movies are in a many-to-many
relationship here.
The associating table represents the act of viewing-a-movie, and describe who
and what are involved
comme ca:
members
memberid, name
1 Fred
2 Jack
3 Jill
movies
movieid, title
1 Fear and loathing
2
you haven't shut your script with the ? before starting your HTML, near as I
can figure it
Rob Day wrote:
I've written a small script that processes a form from a webpage and sends
the submitted data as an HTML e-mail that has the form all filled out
already. I've gotten smaller versions of
your line 357 doesn't appear to have its semicolon...
Rob Day wrote:
Sorry for not giving enough info. This is right in the middle of the script.
I do have the opening and closing tags. It must ne something else.
-Original Message-
From: Matthew Crouch [mailto:[EMAIL PROTECTED
I'm no expert, and my code is probably buggy, but I think this is the gist of it:
select name=color
?
$result = mysql_query(SELECT * from colors);
while ($myrow = mysql_fetch_array($result)) {
printf(option value=%s%s/option, $myrow[colorid], $myrow[colorname]);
}
?
/select
Chris Payne wrote:
Robert--
You're on the right track... I'm assuming $row is the result of a
mysql_fetch_assoc() call, and $row['item'] contains the hashed value
(either m_r, m_c, or whatever)... Try this:
?php
$item_list = array('Mens Ring' = m_r, 'Mens Charm' = m_c, 'Womens
Ring' = w_r,'Womens Charm' =
Does anyone know if there is a way to include Arrays and/or Lists as session
variables? I'd really like to be able to add variable lists of variables to
a session.
--Matthew
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional
row affected (0.00 sec)
mysql select * from Users where usrpassword = password('joe1');
Empty set (0.00 sec)
mysql
So what on earth went wrong?? What was the difference besides field names?
I am totally lost here... Help...
--Matthew
--
PHP Database Mailing List (http://www.php.net
basically a yes or no question my brother wants me to ask:
Does PHP support these objects? If not, Can they be faked?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list
Hi,
I used to store SQL code for a transaction
directly in the PHP script which used it. It was
stored as a string. However, now I want to store
it in the database and assign it to the same
string that held it before. Not very clear, so
heres an example :
Before:
$sql_variable = select
should be simple as pie, of course, but i can't find a straightforward
syntax example in the documentation i'm trying to change the PHP date
format to mysql's
my code:
$today = date(MMDD);
$sql = INSERT into table (date) values ('$today');
and so on
is filling the date field with zeros,
Another way is to set a testing variable and then print an hr if it
changes
(this off the top of my head, probably bugs in it but you get the idea)
while $myrow=mysql_fetch_row($result) {
if $myrow[dishtype]$test {
echo hr;
//here you would print the rest of the info about the dish from the
for anyone else who needs it:
http://wwwphpbuildercom/snippet/downloadphp?type=snippetid=356
Matthew Crouch wrote:
should be simple as pie, of course, but i can't find a straightforward
syntax example in the documentation i'm trying to change the PHP date
format to mysql's
my code
i'm guessing you use mysql, so
you can use the mysql_insert_id to retrieve the most recent addition, then
select on it
$newid=mysql_insert_id();
$sql=select [the auto_increment field] from table1 where id='$newid';
Does that help?
Morten Nielsen wrote:
Hi,
I got the following insert
my guess is you've got a double-quote problem like that other guy
? $query=SELECT bank_points FROM wt_users WHERE uid={$session[uid]};
ends after the [ because of the double quote
Jennifer Downey wrote:
Hi All,
Would someone please help me with the following code?
I am trying to make
Here's an easy one that I can't find laid out for me anywhere:
I want a self join that pairs up the id numbers of a table in every
permutation
e.g. i have id #s 1, 2, and 3
i need this result:
1 2
1 3
2 1
2 3
3 2
3 1
clear enough?
--
PHP Database Mailing List (http://www.php.net/)
To
i think i got this solved; sorry about the non-php question but there
isn't a mysql newsgroup that i know of.
Matthew Crouch wrote:
Here's an easy one that I can't find laid out for me anywhere:
I want a self join that pairs up the id numbers of a table in every
permutation
e.g. i have id
Hi all,
I have seen queries of this nature before, but they never seem to get a
thorough answer - and that maybe because the issue isnt explained properly..
okay, so here is the scenario.
I have a database which features the following tables:
hst_category
hst_product
I am about to build a database of products that will store features fore ach
product in a separate table.
I need to be able to store both text and numeric values in this table, but
be able to perform mathmatical functions on the numeric variables.
is it possible to have PHP covert numbers that
) then display the result, otherwise, just display the
text.
-Original Message-
From: Russ [mailto:[EMAIL PROTECTED]]
Sent: Friday, 21 June 2002 2:53 PM
To: Matthew Nock; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Converting values from text to numerical
is it possible to have PHP covert
[mailto:[EMAIL PROTECTED]]
Sent: Friday, 21 June 2002 3:04 PM
To: Matthew Nock; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Converting values from text to numerical
Matthew:
um how about using the is_int() function to decide if the value from
your DB is a number or not?
http://www.php.net/manual
the date as text in the db you want be able to
filter out entries which are between x and y.
Good luck,
Andy
--
http://www.globosapiens.net
Global Travellers Network!
Matthew Nock [EMAIL PROTECTED] schrieb im Newsbeitrag
[EMAIL PROTECTED]"
Is it more efficient to run a SELECT query on a MySQL database that
retrieves maybe 100 records from approximately 6 tables (based on one
result - such as a product ID) and then process these results using PHP
or is it more efficient to run say 6 SELECT statements that get the exact
details
this bit from my index page is giving me 2 headaches:
1. it isn't passing anything into the URL
2. the page that gets called (name.php) sits and tries to load
forever. it looks like it's even filling up my hard drive with data (?!)
Note: it does this (#2) even if I type in the URL with a
I changed method to GET and the value of $lastname seems to be getting
passed but so is $submit, with the value Search for Last Name as you might
expect. Probably this ain't the answer
Matthew Crouch wrote:
this bit from my index page is giving me 2 headaches:
1. it isn't passing anything
Seth Yount wrote:
in you print statement you have ?lastname=%s, shouldn't that be '$s'
denoting a variable being passed? Try that out.
gl -- Seth
Matthew Crouch wrote:
this bit from my index page is giving me 2 headaches:
1. it isn't passing anything into the URL
2. the page
got my other one sorted out; thanks everyone.
now:
how do i get it so when you hit enter on the keyboard it's the same as
hitting the submit button with the mouse? When I hit enter, it clears
my form and reloads the current page.
--
PHP Database Mailing List (http://www.php.net/)
To
Question:
I want to put PHP code into database fields holding HTML text, how can I
make it execute that PHP before sending to the browser??
Currently, I get the text from MySQL and print it The browser shows
the PHP code mixed into the HTML.
Matthew
--
Anything that can
1 - 100 of 266 matches
Mail list logo