to worry if there aren't 10 left to display as limit will
just return the rows that are left.
For complete non results (like record 59 of 46) there are a few schools
of though, like doing a max/min on the id field or a row count to see
whats the possible range.
Darryl.
--
PHP Database Mailing
and that will
put you onto plenty of great tutorials.
Darryl.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
also add LIMIT 15 to your query. no point in getting all that info if you
want 15 results.
On 7/18/06, Miguel Guirao [EMAIL PROTECTED] wrote:
Use the trim function, or anoter function that just takes the n first
characters.
-Original Message-
From: Benjamin Adams [mailto:[EMAIL
with questions being answered like that, i am sure many will.
On 8/26/05, Raz [EMAIL PROTECTED] wrote:
Jordan
I am sorry that people like to ridicule noobs on this list. It was a
simple question with a simple answer. Thank you!!
Not at all, shame if you see it this way - it is mostly
$sqlstmt= CREATE USER .$adduser. PROFILE DEFAULT
IDENTIFIED BY .$addpass. DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
QUOTA UNLIMITED
ON USERS
ACCOUNT UNLOCK;
GRANT CREATE TABLE TO .$adduser.
GRANT CREATE TRIGGER TO .$adduser.
GRANT CONNECT TO .$adduser.;
for the .'s
You could use something like
$fileloc = subdir/.$_FILES[addpic][name];
-Original Message-
From: Bastien Koert [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 09, 2005 9:44 PM
To: [EMAIL PROTECTED]; php-db@lists.php.net
Subject: RE: [PHP-DB] Reg Exp to change c:\dir\dir\pic.jpg to
Hay,
I was just wondering if any of you had any links to websites that explained
php programming with Access databases.
Thanks in advance,
Darryl
Make sure that you are sending the session_start() function before you send
anything else to the web browser, it must be the first thing done as with
setting cookies
-Original Message-
From: Nayyar Ahmed [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 30, 2004 5:56 PM
To:
From what I see, the code is fine, you just haven't finished it.
mysql_query(INSERT INTO totalinfo (Username,Password) VALUES
('$loginusername','$loginpassword'),$dbh)or die (mysql_error());
}
Give that a bash
-Original Message-
From: John Hicks [mailto:[EMAIL PROTECTED]
Sent: Monday,
You may have to use $_POST.
Like - $ime = $_POST[ime];
Just put the form component name inside the square brackets of the post
function to get it to work.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 12, 2004 3:44 PM
To: [EMAIL PROTECTED]
function getIP() {
if (getenv(HTTP_CLIENT_IP) strcasecmp(getenv(HTTP_CLIENT_IP),
unknown))
$ip = getenv(HTTP_CLIENT_IP);
else if (getenv(HTTP_X_FORWARDED_FOR)
strcasecmp(getenv(HTTP_X_FORWARDED_FOR), unknown))
$ip = getenv(HTTP_X_FORWARDED_FOR);
else if (getenv(REMOTE_ADDR)
Hay,
Is there a way to make a string into an integer?
I have a value coming from a textbox and I want to check if the amount in it
is 1.
Thanks,
Darryl
Yeah, I thought so seeing as I had done it like that previously, turns out
it was something else that was causing the problem :D
Thanks anyhow
:D
-Original Message-
From: Hutchins, Richard [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 30, 2004 5:43 PM
To: 'Darryl'; [EMAIL
$val = 127.0.0.1;
$query = INSERT INTO node (uri,name) VALUES ('.$val.','bla');
Try that?
-Original Message-
From: Stefan Reimers [mailto:[EMAIL PROTECTED]
Sent: Sunday, September 19, 2004 6:37 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] SQLite problem INSERTing string
Hello,
I am
I think he wants something like;
Echo(a href=\$address\view website/a\n);
Where $address = the db entry that will store the value
-Original Message-
From: Peter Ellis [mailto:[EMAIL PROTECTED]
Sent: Sunday, August 22, 2004 6:57 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
. $timein is always
1969. Date in the database is -MM-DD. What have I screwed up ?
thanks,
Darryl
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
to create a new record in emp2 and load values.
Is there a tutorial that shows how to do something this basic ?
tips ?
thanks,
Darryl
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Does anyone know of any sites that explains how to use the Snoopy class?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
able $propTable (
ID int not null auto_increment primary key,
TourName tinytext,
TourTitle tinytext,
ViewTitle tinytext,
TourNum tinyint not null,
Applet tinyint not null,
Desc text,
TourPath text,
SmFile text,
LgFile text );
";
$result = mysql_que
part is knowing what port
the SQL server listens on (the default is 1433).
Feel free to email me if you need more help.
By the way, I understand there are major issues with SQL2000 server. In
that case, ODBC might be a bette
Like this:
if ( empty($submit) )
{
### Display the form
}
else
{
### Do some checks to make the the data is OK
### Do the Insert, or whatever else is to be done
}
- Darryl
------
Darryl Friesen, B.Sc., Programmer/A
quot;; # $var hold the _name_ of the variable
# you want to change
$$var = "blank.jpg"; # The $$ syntax is used to references the
# actual variable
See the section of the manual dealing with variables
(htt
e out of the
double quotes, like you did in the first line.
$sql = "select Primaryid from primarycodes where Code like'%" .
$row[Primaryexpertise] . "%'";
print $sql . "BR\n";
$resultp = mysql_query($sql) or die (mysql_error());
- Darryl
-------
SELECT, and you don't need to
escape the single quotes.
- Darryl
------
Darryl Friesen, B.Sc., Programmer/Analyst[EMAIL PROTECTED]
Education Research Technology Services, http://gollum.usask.ca/
Department of Com
ecord, check if it's
different than the current one. If it is, save it as the current username,
and print the login info. If it's the same, just print the login info.
- Darryl
------
Darryl Friesen, B.Sc., Programmer/Analyst
by looking at the file how to change the port
number. Also, check out the documentation that came with FreeTDS/Sybase.
- Darryl
--
Darryl Friesen, B.Sc., Programmer/Analyst[EMAIL PROTECTED]
Education Research Technology
result
set.
- Darryl
------
Darryl Friesen, B.Sc., Programmer/Analyst[EMAIL PROTECTED]
Education Research Technology Services, http://gollum.usask.ca/
Department of Computing Services,
University of Sa
The action you want is only available using JavaScript.
You need to submit the form without a submit button.
The "select" tag has the "OnChange" event which is scriptable. You
can use the JavaScript statement "this.form.submit();" associated
with the "OnChange" event.
form... select
of pages/images etc. Better to spend the time writing
PHP code. :)
- Darryl
--
Darryl Friesen, B.Sc., Programmer/Analyst[EMAIL PROTECTED]
Education Research Technology Services, http://gollum.usask.ca/
Department
($file_name !="*.php")
how come that still displays all the *.php files?
Because that's an exact string match for a file called '*.php' which
probably doesn't exist. Try some thing like
(substr($file_name, -4) != '.php')
That should exclude all files ending in '.php'.
ss running? I assume this is a unix box of some
sort. Try "ps -ef | grep mysqld". Get any results?
- Darryl
------
Darryl Friesen, B.Sc., Programmer/Analyst[EMAIL PROTECTED]
Education Research Technolog
that helps.
- Darryl
--
Darryl Friesen, B.Sc., Programmer/Analyst[EMAIL PROTECTED]
Education Research Technology Services, http://gollum.usask.ca/
Department of Computing Services,
University of Saskatchewan
r mysql server is dumping core, you've got big problems
that need addressing.
- Darryl
------
Darryl Friesen, B.Sc., Programmer/Analyst[EMAIL PROTECTED]
Education Research Technology Services, http://gollum.usask
wouldn't bother with PWS. Apache or Xitami (www.xitami.com) are far
easier to setup. I've installed PHP under both, with no problems.
- Darryl
--
Darryl Friesen, B.Sc., Programmer/Analyst[EMAIL PROTECTED]
Education
ySQl still treats it as intended. THey aren' necessary for
int columns, but it is acceptable to have them there
Thanks for pointing that out Tom. That's a good bit of info to tuck away
for later.
We've been using MSSQL Server 7 here quite a bit lately, and it isn't nearly
as forgiving. :(
It still didn't work.
just says unable to add part
$sql = "INSERT INTO ecomm (ID,part) VALUES ('$sid','$spp')";
Another thought: Are ID and part character data of some sort? If not (i.e.
if ID is an int) then remove the single quotes.
?
- Darryl
--
Darryl Friesen, B.Sc., Programmer/Analyst[EMAIL PROTECTED]
Education Research Technology Services, http://gollum.usask.ca/
Department of Computing Services,
University of Saskatchewan
37 matches
Mail list logo