ql_query($sql);
- Darryl
----------
Darryl Friesen, B.Sc., Programmer/Analyst[EMAIL PROTECTED]
Education & Research Technology Services, http://gollum.usask.ca/
Department of Computing Services
e way, I understand there are major issues with SQL2000 server. In
that case, ODBC might be a better choice.
- Darryl
--
Darryl Friesen, B.Sc., Programmer/Analyst[EMAIL PROTECTED]
Education & Research Technology Services, http://gollum.usask.ca/
Department of Computing Ser
ing with variables
(http://www.php.net/manual/en/language.variables.php)
- Darryl
--
Darryl Friesen, B.Sc., Programmer/Analyst[EMAIL PROTECTED]
Education & Research Technology Services, h
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/Analyst[EMAIL PROTECTED]
Education & Research
able WHERE Item='Item1' OR Item='Item3'" will
work)
- Darryl
--
Darryl Friesen, B.Sc., Programmer/Analyst[EMAIL PROTECTED]
Education & Research Technology Services, http://gollum.usask.ca/
Department of Computing Services,
University of Saskatchewan
--
ased'");
You need the leading double quote before SELECT, and you don't need to
escape the single quotes.
- Darryl
----------
Darryl Friesen, B.Sc., Programmer/Analyst[EMAIL PROTECTED]
Education & Researc
ead of posting this email). Second, take the array variable out of the
double quotes, like you did in the first line.
$sql = "select Primaryid from primarycodes where Code like'%" .
$row[Primaryexpertise] . "%'";
print $sql . "\n";
$resultp = mysql_query($sql)
of the current user. As you examine each record, 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
should be fairly obvious 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
e used to jump around the result
set.
- Darryl
----------
Darryl Friesen, B.Sc., Programmer/Analyst[EMAIL PROTECTED]
Education & Research Technology Services, http://gollum.usask.ca/
Department of Computin
things easier to follow. Try:
print '' . $row['client'] .
'';
- Darryl
--
Darryl Friesen, B.Sc., Programmer/Analyst[EMAIL PROTECTED]
Education & Research Techn
> The action you want is only available using JavaScript.
>
> You need to submit the form without a submit button.
> The "" tag has the "OnChange" event which is scriptable. You
> can use the JavaScript statement "this.form.submit();" associated
> with the "OnChange" event.
>
> ... ...
> ...
It
Another reason not to do this is all the extra work in maintaining all the
different versions of pages/images etc. Better to spend the time writing
PHP code. :)
- Darryl
----------
Darryl Friesen, B.Sc., Programmer/Analy
asked in php-general.
- Darryl
------
Darryl Friesen, B.Sc., Programmer/Analyst[EMAIL PROTECTED]
Education & Research Technology Services, http://gollum.usask.ca/
Department of Computing Services,
University of Saskatchewan
---
'.php')
That should exclude all files ending in '.php'.
- Darryl
------
Darryl Friesen, B.Sc., Programmer/Analyst[EMAIL PROTECTED]
Education & Research Technology Services, http://go
re.
Is the mysql server process 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]
Educatio
akes it easier to remember).
- Darryl
----------
Darryl Friesen, B.Sc., Programmer/Analyst[EMAIL PROTECTED]
Education & Research Technology Services, http://gollum.usask.ca/
Department of Computing Services,
University of Saskatchewan
akes it easier to remember).
- Darryl
----------
Darryl Friesen, B.Sc., Programmer/Analyst[EMAIL PROTECTED]
Education & Research Technology Services, http://gollum.usask.ca/
Department of Computing Services,
University of Saskatchewan
but if you search Google you're bound to find
it.
Hope that helps.
- Darryl
------
Darryl Friesen, B.Sc., Programmer/Analyst[EMAIL PROTECTED]
Education & Research Technology Services, http://gollum.usask
ks
like this:
[mysqld]
basedir = e:/mysql/
I needed to do this before mysqld would even start.
- Darryl
----------
Darryl Friesen, B.Sc., Programmer/Analyst[EMAIL PROTECTED]
Education & Research Technology Servic
#x27;m
sure)
If your PHP script, or mysql server is dumping core, you've got big problems
that need addressing.
- Darryl
------
Darryl Friesen, B.Sc., Programmer/Analyst[EMAIL PROTECTED]
Education & Research Techn
f Apache at www.apache.org.
I 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/Anal
20 (the hex value for a space). There's
probably a PHP function to do this for you (and one to do the reverse) -- I
haven't looked.
You could try using a + instead of a space too.
- Darryl
----------
Darryl Friesen
We've been using MSSQL Server 7 here quite a bit lately, and it isn't nearly
as forgiving. :(
- Darryl
--
Darryl Friesen, B.Sc., Programmer/Analyst[EMAIL PROTECTED]
Education & Research Technolog
er to pass the _value of the $sql variable_ (i.e. your SQL query) to
the mysql_query function.
The rest looks good; except the lack of line breaks and indenting in your
code, but I tend to be anal about that sort of thing :)
- Darryl
----------
int) then remove the single quotes.
- Darryl
----------
Darryl Friesen, B.Sc., Programmer/Analyst[EMAIL PROTECTED]
Education & Research Technology Services, http://gollum.usask.ca/
Department
> It still didn't work.
> just says unable to add part
Remove the @ from @mysql_db_query and it will spit out the SQL error
explaining why the query fails. That should help for debugging.
- Darryl
------
Dar
> You're INSERT query is wrong. Take the ',$db' off the end.
^^
Oops. That's "Your". Long day.
- Darryl
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators,
quot;); mysql_close($db);exit();} }
>
> Why does this not work?
>
You're INSERT query is wrong. Take the ',$db' off the end.
$sql = "INSERT INTO ecomm (ID,part) VALUES ('$sid','$spp')";
- Darryl
One hates to be rude, but can someone reach over and slap Mike.
Or remove him from the list until he sorts out the mail problems.
- Darryl
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact
o join them?
- Darryl
------
Darryl Friesen, B.Sc., Programmer/Analyst[EMAIL PROTECTED]
Education & Research Technology Services, http://gollum.usask.ca/
Department of Computing Services,
University
2 like '%tvk%')
- Darryl
----------
Darryl Friesen, B.Sc., Programmer/Analyst[EMAIL PROTECTED]
Education & Research Technology Services, http://gollum.usask.ca/
Department of Computing Services,
University of Saskatchewan
like '%tvk%')
- Darryl
----------
Darryl Friesen, B.Sc., Programmer/Analyst[EMAIL PROTECTED]
Education & Research Technology Services, http://gollum.usask.ca/
Department of Computing Services,
University of Saskatchewan
---
h);
if ($query) {
print "Second SELECT successful\n";
} else {
print "Second SELECT failed\n";
}
?>
--
Darryl Friesen, B.Sc., Programmer/Analyst[EMAIL PROTECTED]
Education &
34 matches
Mail list logo
