Sorry for all the dead space in my last post... I cleaned it up some here...
===
I have been trying to get this to work and think I must be missing
something. I am using Kevin Yank's books and examples as a guide. Here is
what
I have been trying to get this to work and think I must be missing
something. I am using Kevin Yank's books and examples as a guide. Here is
what I have so far - this does work [as it should since Kevin created it..
8-) ]
I have a form that creates a list of items with a select link that when
cli
alchars($SRecord["ItemModel"]);
$Description = htmlspecialchars($SRecord["ItemDescription"]);
$Price = htmlspecialchars($SRecord["ItemPrice"]);
?>
Good Luck,
Frank
On 3/8/04 12:50 PM, "[EMAIL PROTECTED]"
<[EMAIL PROTECTED]> wrote:
>
Hi all,
I thought I saw the answer to this question on here but can not find the
answer ..
So,
I am doing an inner join on 2 tables and displaying the result as follows:
Code=
Cat#
Category
Model
Description
Price
Looking at your code, I do this:
Includes usually work with files that are in the same directory.
Otherwise you need to access your PHP.ini file and modify your
include_path = statement to include the complete path were your
include files reside. Look for a section labeled Paths and Directorie
Hello Irin,
Not sure where you problem is but here is what I would check first.
After you open the page that has the drop down list, view the source and
See if the OPTION VALUE= has any value assigned to it. If you are using
IE, on the menu bar click on View - Source.
Second, if that is fine,
Hi Kirt,
Your tables look ok to me... As for your question, if I were using your
example, I would link the field teams.name to players.team_name. For
example, I would set another column in the teams table to be auto
incrementing. As you add the team information, the team will get a number
automati
Hi,
I am looking at your code and have a question, in your code you have
print "" .$row ["tutor_name"].
"";
Doesn't the SELECTED piece mark everything listed as selected?? When you
bring up the page with the drop down list and open the source, what does it
show??
I handle this a little differ
Dear Jeffrey,
Yes that is clear thank you... I have used this technique in the past
But wanted to give sessions a try. I did manage to get it working. Seems
That typing code at midnight can lead to frustrating and volatile results..
Thanks again for your response...
Aleks
-Original Messag
PHP-DB
> Subject: Re: [PHP-DB] Select Value with 's
>
>
> hi
>
> hm - it would help if you'd send us the code where you generate the
> query
>
> _ma
>
> # life would be easier if i knew the source code...
>
> > Von: "Aleks @ USA.ne
St
Mary's Hospital");
anyways - shouldn't it be like this?:
$FF = "St Mary's Hospital";
$info = mysql_query('Select * From customer Where customer.customer LIKE
"'.$FF.'"');
_ma
# life would be easier if i knew the source code...
> Von: "
B] Select Value with 's
hi
think you should use ' when you create the query and " in the SQL-statement
for comparison:
$qry = 'SELECT *
FROM customer
WHERE customer.customer LIKE "'.$FF.'"';
_ma
# life would be easier if i knew the source code...
>
rning mysql_fetch_array(): supplied argument is not a valid MySQL result
-Original Message-
From: CPT John W. Holmes [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 05, 2003 1:45 PM
To: Aleks @ USA.net; 'ma'; 'PHP-DB'
Subject: Re: [PHP-DB] Select Value with &#
uld work well...
$qry = 'SELECT `customer` FROM `customerList` ORDER BY `customer`'; $res =
mysql_query($qry); while($customer = mysql_fetch_object($res)) {
echo stripslashes($res->customer).''."\n";
}
hth?
_ma
# life would be easier if i knew the source code...
>
This is a basic question but I am all messed up and need to be straightened
out..
Have a select field called customer that works great except when there is a
' in the customer name.
Have tried addslash and stripslashes but I think I might be using them
wrong.
If I addslash to the select value,
Great answer... One question though, how would you convert it back to
X,xxx.00 format??
Thanks
Aleks
-Original Message-
From: Peter Beckman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 05, 2003 10:48 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] number_format problem
On Wed,
Thanks John for the idea... will use php to extract and reparse the
values in the correct order...
-Original Message-
From: CPT John W. Holmes [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 15, 2003 5:11 PM
To: Aleks @ USA.net; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] inserting date
Hi all,
I have a large text file that I am inserting into a mysql db and seem to
have a problem with
the date format. The data is currently in the mm/dd/ format. The command
I am using is
INSERT INTO TABLE
(QID,REV,DATE)
VALUES
("619" , "12" , "1/4/2001");
I am using phpMyAdmin with the abov
Was wondering what are people using to backup their php with MySQL db"s??
Thanks for your time and input..
Aleks.
I agree with David.. however you can create a membership system using PHP
and
MySQL. I did following the information in a tutorial posted here..
http://www.phpfreaks.com/tutorials/40/0.php
Many useful tutorials here...
Hope this helps...
Aleks K
-Original Message-
From: David Smith [ma
Found the problem.. seems that spanning the sql statement with a carriage
return messed something up. It works fine now..
Sorry about the return receipt earlier... won't happen again..
Thanks
Aleks
-Original Message-
From: Aleks @ USA.net [mailto:[EMAIL PROTECTED]
Sent: Thu
I have a strange problem I am adding records into a MySQL db... there is
a description
column and everything works fine when I add a new record. When I try to edit
an existing
record it fails if I us an apostrophe ['] in the field. I thought that
addslashes would take care
of this but it is not
I have a project were I need to create a search mechanism for a large number
of documents.
I have already created a dB containing the Doc name, its URL location on the
hard drive and a description.
The search is being done against the document name. The complaint I am
getting is that the users may
23 matches
Mail list logo
