Something like this, perhaps?
?
// your INSERT to first table here.
$insert_id = mysql_insert_id();
$sql = SELECT MAX(SecondID) FROM LookupTable WHERE FirstID = $insert_id;
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$max_second_id = $row[0];
$sql = INSERT INTO LookupTable
Try something like this:
INPUT type=checkbox
name=?php echo( $row['name'] ) ; ?
value=1
?php echo( $row['homeno'] == 0 ? : checked ) ; ?
(value is a dummy value - HTML will POST the name=value pair only if
checked.)
HTH
Ignatius
Bartosz was correct in saying that you should use your query to sort,
rather than sorting array. And the array is actually sorted, although
it keeps its index. See the manual reference on arrays to see how they
work. To iterate over sorted arrays, use the foreach() construct.
Anyway, the
Hey there all
This is more than likely a common question, anyone have any guidelines, do's
or dont's
about converting an access db to mysql db...
Regards
Chris
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi,
Check out MyAccess at http://www.accessmysql.com/. It works for me. The
manual points out some things to keep in mind when converting.
/Dann
-Oprindelig meddelelse-
Fra: Chris Grigor [mailto:[EMAIL PROTECTED]]
Sendt: 10. september 2002 11:48
Til: [EMAIL PROTECTED]
Emne: [PHP-DB]
also http://www.dbtools.com.br this will work both ways accessmysql also
supports excel , dbf, csv etc etc
Steven
- Original Message -
From: Chris Grigor [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, September 10, 2002 10:47 AM
Subject: [PHP-DB] Conversion from access to
both tools don't work okay for me, i'm just using the export tool in
MsAccess then convert database to xml, and thanks to PHP, i convert that to
mysql queries.
Just one problem when i want to convert binary data (pict or others), still
haven't find a suitable solution for that.
Best regards,
Untitled
Document ---
- Qbit Web developer tel.: 0108256721 - 0108256722
fax: 0108256712 email: [EMAIL PROTECTED] http://www.qbit.gr
- Original Message -
From: nikos [EMAIL PROTECTED]
To: Chris Grigor [EMAIL
You should install MyQDBC. Then use it to export the Access tables in
MySQL
Nikos
--
--
--
- Original Message -
From: Chris Grigor [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
You should install MyQDBC. Then use it to export the Access tables in
MySQL
Nikos
--
--
--
- Original Message -
From: Chris Grigor [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
You should first check if checkbox value stored in the databese is 1 or 0.
After use an if clause:
if ($checkbox==1) {
echo input type=\checkbox\ name=\checkbox\ value=\1\ checked
}
elseif ($checkbox==0) {
input type=\checkbox\ name=\checkbox\ value=\0\
}
Nikos
Try remove (;) at the end of the expresion, before quote (): VALUES
('$first_name','$location','$phone', '$blabla')...(;)...
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, September 10, 2002 4:38 AM
Subject: Re: [PHP-DB] whats wrong with my sql
Also check the archives for the php-db list. Questions very similar to this
get asked just about every week and you might be able to find more
information there.
Rich
-Original Message-
From: nikos [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 10, 2002 7:51 AM
To: PHP-mailist
Hi
I am trying to have previous and next links in my php script
wich i make a select from a table. I am using postgresql
anybody has a link for a tutorial or a sample code doing this?
Ângelo Marcos Rigo
Webmaster Colégio Anchieta
http://www.colegioanchieta.g12.br
--
PHP Database Mailing
Hello, Angelo.
Try pn.class.php at www.phpclasses.org
AMR I am trying to have previous and next links in my php script
AMR wich i make a select from a table. I am using postgresql
AMR anybody has a link for a tutorial or a sample code doing this?
www.pskov.ru
--
Best Regards,
Andrey
David,
You will be pleased with OpenLink Software's ODBC Drivers. This
requires setting up PHP --with-iodbc, as per the HOWTO's on
http://www.iodbc.org and the ODBC drivers are available as a free 30-day
download from our site.
Please let me know if you have any questions.
Best regards,
Most likely the datatype you are using for the id field is tinyint, auto
increment. The tinyint datatype only goes to 127, so once you get to 127, it
tries to assign the same value for the next one. Try changing your id
datatype to int.
HTH
Maureen
Brtosz Matosiuk [EMAIL PROTECTED]
Is there a way that I can sort data twice when it is being pulled from the
DB? Here is a sample line of my code:
$result = mysql_query(SELECT * FROM pfiles WHERE cdate = '2002-07-01'
ORDER BY 'cdate' DESC, $link);
I would like to be able to sort this data FIRST by 'cdate' then by 'vendor'
Is
Hi All,
I HOPE this is the right place for this.. if not I am sorry!!!
I'm hoping someone can put me on a clear path of how to do what I am
asking here.
I Have a shopping cart... and in this shopping cart I want to feature
some items in a pop_up window when the user is ready to check out -
Umm, the body tag in HTML has an onLoad parameter.
So:
body bgcolor=black onload=javascript:window.new('url');
That code for the window.new is probably wrong, but that will do it.
Adam Voigt
[EMAIL PROTECTED]
On Tue, 2002-09-10 at 11:20, Aaron Wolski wrote:
Hi All,
I HOPE this is the
$result = mysql_query(SELECT * FROM pfiles WHERE cdate = '2002-07-01'
ORDER BY 'cdate' DESC, $link);
I would like to be able to sort this data FIRST by 'cdate' then by 'vendor'
Is this possible?
Yes.
Just add another sort criterium to your query like this:
$result = mysql_query(SELECT *
Hi.
You cannot call PHP script from JavaScript in any simple way.
It can be possibly done by including JavaScript code generated
by PHP script through script src=script.php..., but it is too
complicated.
I think it will be better to do this like this:
user have selected some items and goes to
A bit of a strange way would be to always pop the window and at that point have the
PHP decide what to put in there. If there is not offer you want to include you could
simply thank them, or you could even produce an inline window.close(); javascript
call. The only problem with that is that
I am making a web form for entering/editing/deleting items from a database,
the entering and deleting
parts work fine. The editing part is giving me some problems -
Here's the code -
?
include connect;
if ($submit) {
// if no ID then we're adding a new rma, else we're editing an
Hello,
I'm having trouble connecting via ODBC using the Microsoft text driver on a win2k box.
I read the KB article at
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q178717 and it seems to
suggest that I should be able to select data from a text source. Here is what I have
so
Hi,
I had a similar problem to this shopping cart some time ago, and I handled
it that way:
Within a form the user (it's made for salesmen) can add lines of articles,
text etc to build up an offer.
The price for the added articles can be choosen from different pricelists
given in a database.
To Whom It May Concern,
I've been working for the last few months (delayed often, but mostly the
last few weeks) on what I've been tenatively calling ODBC2. Basically
this is what I'd like to see PHP v 5 have as it's default ODBC system.
Some general notes about it:
- It will break BC. I
Hi Dan,
On 11/09/02, Dan Kalowsky [EMAIL PROTECTED] wrote:
- It will support ODBC v 3.0 and greater only. With the needs of many DBs
...
I would like to add this into the current PHP system, to allow users to
start playing with and testing as well. Well probably just as soon as I
finish
On Wed, 11 Sep 2002, Wez Furlong wrote:
I know this probably isn't the kind of comment you want just now, but...
If this is to support ODBC v3+, why not call the functions odbc3_xxx instead
of odbc2_xxx? I think this could help prevent some head-scratching a little
later down the track.
Hmm, is there no way to make the functions work with both odbc versions?
Have an odbc_set_version(int) function that can set the version of
odbc to use. The default can be version 3. This way, with the addition
of a single function call, scripts can provide BC.
Shane
Dan Kalowsky wrote:
my input.html has errors in it.
wrong
form method=post action=input.php enctype=multipart/form-data
correct
form method=POST action=input.php
strange thing is it used to work. anyhow thanks for the help.
Nikos wrote:
Try remove (;) at the end of the expresion, before quote (): VALUES
On Tue, 10 Sep 2002, Shane Caraveo wrote:
Hmm, is there no way to make the functions work with both odbc versions?
Have an odbc_set_version(int) function that can set the version of
odbc to use. The default can be version 3. This way, with the addition
of a single function call, scripts
Ok, then I would be for ODBC 3 for PHP 5 as the standard. An ODBC 2
extension can be shuttled out to PECL for those who may need it. But
for BC issues, there is still the nameing convention. I would personaly
prefer that the odbc functions stay odbc_*, rather than to start
iterating
[EMAIL PROTECTED]
Sincerely,
Robert
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
-Original Message-
From: rdelgar [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 10, 2002 9:07 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] [EMAIL PROTECTED]
[EMAIL PROTECTED]
Sincerely,
Robert
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
35 matches
Mail list logo
