I have an application that updates two MySQL database tables. One table has an
auto_increment id field. I need to use this id to link to an entry in the other
table. Is there an easy way to find out what the auto_incremented number is so I can
use it to update the other table?
Robbert van An
Try this
$temp = fgets($fp,4096);
$line = substr($temp,0,10);
Robbert van Andel
-Original Message-
From: Paul Reilly [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 07, 2003 9:06 AM
To: [EMAIL PROTECTED]
Subject: [PHP] substr() help
working on a peice of code that should be pretty
Thanks, I knew there was a function like this, but couldn't for the life of me
remember what it was or find it.
Robbert van Andel
-Original Message-
From: Jon Haworth [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 07, 2003 9:28 AM
To: Van Andel, Robbert; [EMAIL PROTECTED]
Su
What is the error message you get if you put this in
if(!mysql_query("delete from members where company='$delete')) die (mysql_error());
This would be the first step.
Robbert van Andel
-Original Message-
From: Sunfire [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 07, 2003 2:06 PM
where company =
so the $delete is blank for some reason... is it possible that submitting a
variable from 1 form to another that some wont get carried over?
- Original Message -
From: "Van Andel, Robbert" <[EMAIL PROTECTED]>
To: "Sunfire" <[EMAIL PROTECTED]>
actually use $delete in a query run:
dont know why it doesnt work...any ideas?
- Original Message -
From: "Van Andel, Robbert" <[EMAIL PROTECTED]>
To: "Sunfire" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, February 07, 2003 5:30 PM
Subject: RE: [PH
: Friday, February 07, 2003 3:16 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP] delete query doesnt work
ok i changed the endings to those to but still keep getting blank
variable in the end for $delete in the delete query
- Original Message -
From: "Van Andel, Robbert" <[EMAIL P
Try this.
void function MyExampleFunction(theelement) {
theelement.focus()
}
The variable theelement will refer to "document.form_name.element_name"
so there is no reason to repeat that portion in the function.
Robbert van Andel
-Original Message-
From: Christian Ista [mail
How do I round a number to the nearest 10 or even 5. Say I have a
number like 12. Is there an easy way to round that up to 15 or 20?
Robbert van Andel
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
The downside to this method is that many email clients (mine included) do not allow
content from the web to be downloaded or for frame displays. You can always have the
pictures linked to save on download time, but I would highly recommend that you create
your content in the body of the email.
I'm trying to make a switch statement that looks for more than one possible value.
Something similar to:
switch($color)
{
case "black" || "1":
return ImageColorAllocate($image,0,0,0);
break;
case "white" || "2":
return ImageColorAllocate($image,255,255,255);
break;
case "gra
It would be helpful to find out what error messages you are getting when you run the
script.
if(!mail($ToName." <".$ToEmail.">",$ToSubject, $EmailBody, "From:
".$FirstName."<".$Email.">")) die("Unable to send message");
would be a good start. I'm not sure if there is a system error you could rep
I have the following query:
$query = "SELECT d.utilization, d.capacity_date, d.day, i.id, i.interface, cd.date,
cd.id ";
$query .= "FROM (capacity_data as d LEFT JOIN interfaces as i ON d.interface =
i.id) ";
$query .= "LEFT JOIN capacity_date as cd ON d.capacity_date=cd.id ";
$query .=
03 3:40 PM
To: Van Andel, Robbert; [EMAIL PROTECTED]
Subject: RE: [PHP] MySQL Query Result Question
Shouldn't that be:
while($data=mysql_fetch_array($result))
{
//SSLT
}
NOTE: Added ) and changes $query to $result
-Original Message-
From: Van Andel, Robbert [mailto:[EMAIL P
yAdmin and verified that I got nothing back. I don't
know at this point. I'm at a loss.
Robbert van Andel
-Original Message-
From: Ernest E Vogelsinger [mailto:[EMAIL PROTECTED]
Sent: Friday, February 28, 2003 3:51 PM
To: Van Andel, Robbert
Cc: [EMAIL PROTECTED]
Subject: R
Thanks to everyone who responded. I've figured it out. One of those ID 10 T errors.
I was not clearing some necessary variables further down in the loop.
Robbert van Andel
-Original Message-
From: Van Andel, Robbert
Sent: Friday, February 28, 2003 3:57 PM
To: Ern
Is there a handy function in PHP that I can use to retrieve the users Windows Log in?
We are creating an application that will allow users to add comments to a mysql
database, and we would like to be able to track who is putting the comments into the
table, preferably with their windows log in.
mysql_fetch_array($result) works too. It fetches the data from the current row and is
used in conjunction with a while loop:
while($array=mysql_fetch_array($result))
{
//stuff to do with the current array
}
Robbert van Andel
-Original Message-
From: Mike Mannakee [mailto:[
I have a form that has a select form object with where I can select multiple
values. The select is called "number". When I post the form, I get a lot
of variables called $number with the various values I selected. Is there a
way that I can make this an array of values?
Robbert van Andel
Multiple the numbers by 100.
Robbert van Andel
-Original Message-
From: Joe Harman [mailto:[EMAIL PROTECTED]
Sent: Friday, July 25, 2003 10:05 AM
To: [EMAIL PROTECTED]
Subject: [PHP] How Do I Change A Number to Percentage
Hey, hope all are doing fine. can someone help me be showi
I can't help you with the while loop, but foreach loops are very nice to
work with. It took me a while to figure it out as well.
You can use the foreach to loop through all the instances of an array. This
works best when you have an associative array ($state['CA'] = "Sacremento",
$state['OR'] =
Personally, I think one of the worst replies someone on the list can do when
someone new asks a question is send only a link to the manual. It's
presumption that everyone will understand the way the manual is worded.
There have been times when it's confused me and I needed another perspective
on t
I use Jedit (www.jedit.org). It's an excellent program for many different
programming languages.
Robbert van Andel
-Original Message-
From: Adrian [mailto:[EMAIL PROTECTED]
Sent: Friday, August 08, 2003 12:27 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP] suggestion on php-editor?
the
You can download PHPMySQL and locate it in a secure portion of your site.
It's an excellent gui interface into mySQL. This tool will allow you to
upload the script file and insert the data. I'm sorry, but I don't know the
URL where to get it. Check sourceforge.
Robbert van Andel
-Origina
estion
On the same note I recommend phpMyAdmin(www.phpmyadmin.net). Its interface
is quite useful especially when you have multiple DB's to manage on the same
server.
Dan
-Original Message-----
From: Van Andel, Robbert [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 12:24 PM
The last two posts I sent to this mailing list produced a flurry of emails
from various locations including majordomo stating it couldnt' understand
the command I just sent it, a reply from a e-commerce site stating my order
has been received, and others. Anyone else running into this?
Robbert va
Andel
-Original Message-
From: Jonatan Pugliese. [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 21, 2003 9:38 AM
To: Van Andel, Robbert; [EMAIL PROTECTED]
Subject: Re: [PHP] Mailing List Weirdness
yes
me too
- Original Message -
From: "Van Andel, Robbert" <[EM
ECTED]
> Sent: Thursday, August 21, 2003 9:25 AM
> To: '[EMAIL PROTECTED]'
> Subject: RE: [PHP] Newbie Question
>
>
> On the same note I recommend phpMyAdmin(www.phpmyadmin.net). Its interface
> is quite useful especially when you have multiple DB's to manag
I am trying to query a database looking for results that match an array of values I
have set.
The variable array is call group and has about 10 elements. Is there a way that I can
query the database using just $group instead of having to use the following:
SELECT * FROM `table` WHERE groupname
Thanks, I knew it was something simple but I couldn't find it on the 'Net.
Robbert van Andel
-Original Message-
From: CPT John W. Holmes [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 18, 2003 1:14 PM
To: Van Andel, Robbert; [EMAIL PROTECTED]
Subject: Re: [PHP] Mysql Quer
Unless I'm completely mistaken, the BCC field will not show up when the email is
delivered.
Robbert van Andel
===
-Original Message-
From: Tim Thorburn [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 18, 2003 1:19 PM
To: [EMAIL PROTECTED]
Subject: [PHP] mass
Is there a way that I can prevent session variables getting values from
query strings. I want them to receive values only from posted forms.
Robbert van Andel
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I believe the variable passed is actually an array ($email_recipients[0],
$email_recipients[1]...etc).
Robbert van Andel
-Original Message-
From: Johnny Martinez [mailto:[EMAIL PROTECTED]
Sent: Monday, June 16, 2003 9:27 AM
To: [EMAIL PROTECTED]
Subject: [PHP] HTML...
Hi all,
I'm try
This may not be the best place to ask this question, but I'm running into a
problem when I perform a left join sql statement in PHP. The sql statement
is as follows:
SELECT p.id
pid,p.designID,p.project_name,p.node,p.received,p.lots,p.ugfootage,p.aerialf
ootage,p.node,c.* FROM projects as p LEFT
34 matches
Mail list logo