Hi,
you could use IN in your query:
$sql = select * from. where id in (0// start your query
if (count($selection) = 1) {
for ($i=0;$icount($selection);$i++) {
echo $selection[$i];
$sql .= ,.$selection[$i];// add each ID to your query
}};
$sql .= ); // finish the
This should work as well (newer syntax) ?:
SELECT F.question, F.answer
FROMFaqsAS F
LEFT JOIN FaqsRelatedToProducts AS FP ON F.faqid = FP.faqid
WHERE fgnumber = '$yourfgnumber'
Use:
SELECT DISTINCT ...
when your FaqsRelatedToProducts
Hi list,
I am trying to develop a product catalog using MySQL and PhP.
A long time I was looking for some tips for the database
structure.
The idea is to have a powerfull and as much as possible
universal DB application.
Does anyone have an idea of a book, e-book, site, resource please ?
lots of excellent resources on www.devshed.com, notably a PHPShop tutorial
and a catalogue implementation.
Ignatius
- Original Message -
From: Hynek Semecký ME [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, December 11, 2002 11:54 AM
-Original Message-
From: Chris Payne [mailto:[EMAIL PROTECTED]]
Sent: 10 December 2002 23:10
I use the following code to collect date from multiple
tickboxes on my form:
if (count($selection) = 1) {
for ($i=0;$icount($selection);$i++) {
echo $selection[$i];
}};
Thanks.
I took a look at the catalog design here (devshed.com)
and I want to do something even more crazy.
I want to assign different pricelists over all or some products.
Product categories will have many to many relationship with products,
sub-categories the same and I will also have different
jou want to make it yourself even without nowing how to code it or how to
set up a database design???
just by looking to other code??
think it will be to hard for a first project.. just my idea...
kind regards,
Mark
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
I am ont interested in the code. I am interested in an idea
of a database design.
Not doing the first project neither.
But anyway, I am sure it will be difficult. Thanks
Hynek
-Original Message-
From: Snijders, Mark [mailto:[EMAIL PROTECTED]]
Sent: 11. prosince 2002 13:09
To: 'Hynek
Many of the people who will be using my php site, will also be using an app
that runs an access db. I would like to create a page on my webpage that
allows the users to click a button, and data is moved from their access db
on their machines, to my mysql db. Is this possible? I will know where
don't think it's possible @ once...
what I suggest... those people have to make a comma delimited export file,
then you make an upload page, where people can upload this file. and you
make a script so it will be imported
get the point?
kind regards
___
Mark
There are programs that can import access db files into mysql, but none that
I know of that are automated. If you have access to the access app they are
running, you can install an odbc connection from their machines to your
mysql database and modify your access app to connect to mysql and copy
I'm working in a migration of an application from MSSQL7-VB6.0-Crystal
Reports to MSSQL7-winApache-PHP4.
I'm having problems with the reporting, because I cant find an user
friendly solution for the creation of reports with PHP (I need something
similar in functionality and look and fell to the
I may be able to get my upload problem fixed by the vb app connecting to our
db and pumping over the data. Can I set up a php page or service in mysql
that once an hour, day, etc runs a clean up script?
Thanks,
Eddie
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
If you're still using MSSQL7, I'd recommend installing Crystal Enterprise on the
winApache machine. There's no reason that you need to give up Crystal to change to
PHP. If you're looking for a freeware solution, good luck. Let me know if you find
anything good. I looked to replace crystal about
At 07:34 AM 12/11/2002 +, you wrote:
I understand that the column name does not normally need quotes, but
without quotes on the column name I get a mysql error message about no
column named 'id'. Unfortunately, I cannot even get the UPDATE statement
working outside of PHP through an
i've done this in a couple ways... If you are running linux you can set up a cron job
to run regularly. You can also configure a remote machine to fire the job by using a
command line browser like wget. A lot depends on what's available to you.
Ryan
-Original Message-
From: Edward
I have now been granted access to a remote Oracle database that I
need to query. All of the work that I have done with databases and PHP has
been focused on MySQL, does anyone know of a good tutorial for PHP with
Oracle? My immediate question is how do I get logged into the remote
Hello,
I have a bit of problem with a script . . . looking for help. The
script pretty much works as it creates the table I want, However,
the display is incorrect as it states the creation was unsuccessful.
Here is the actual script:
HTML
HEAD
TITLEThis PHP script creates a
change this part so that $query is capitalized
if (mysql_db_query ($DBName, $query, $Link)){
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 11, 2002 11:23 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] A little advise please
Hello,
I have a
One thing I can help with is TNSNAME. It was very confusing for me at first, it's kind
of like an alias on steroids... It is a necessary part of connecting to an Oracle
server. TNSNAMES are declared in a file called... go figure... tnsnames. Even good
Oracle DBAs run into confusion because the
DOH!!! I am seriously hoping that I do not need to have the Oracle
client installed on the webserver running the PHP queries. I have no idea
about the client licensing, and if it involves money in any way it is pretty
much out of the question. Oh well... Hopefully I can find out about
I am using
? $result = mysql_query(SELECT * FROM courses,$db);
printf(select name=\coursecode\\n);
while ($myrow = mysql_fetch_array($result)) {
$l=$myrow['coursecode'];
?option value=?=$l;??=($_POST['coursecode']==$l)?'
selected=selected':;??=$myrow['title'];?/option?
}
printf(/select\n);
?
to
You might be interested in this project. Since it's Java, it should
work fine on Windows.
http://datavision.sourceforge.net/
--- Ryan Jameson (USA) [EMAIL PROTECTED] wrote:
If you're still using MSSQL7, I'd recommend installing Crystal
Enterprise on the winApache machine. There's no reason
You're trying to run the query twice. The first time, you're using a
lowercase q in $query, which will fail because you have defined it as
$Query. Then you're calling the function again with $Query, wihch is
why the table is getting created. You shouldn't be calling it twice,
and you need to be
A
your_id
brand_id
B
brand_id
description
A is filled with this data
1-1, 1-2, 2-2, 3-1, 3-2
how to get the your_id's with description of the brand where there are more
brand_id's to a your_id
with the next query i can get the data out with a where clause, but I want
to select only the
25 matches
Mail list logo