Hi,
If a client wants an offline solution for a mysql database online, what
do you think? Is that even possible? The mysql database right now is
with the hosting company(with a private server hosting plan) somewhere
in US while the client's physical office is in Africa. What kind of
options do
Thanks! That makes senses. And once I chmod as instructed, I can create
directory in the mysql folder.
Tom Crimmins wrote:
[snip]
How can find the user mysql password? The hosting company which I got the
dedicated server package from set that up of course. Should I go to phpAdmin
and reset that p
I was told to try this:
chown mysql.mysql -R /var/lib/mysql
chmod 750 -R /var/lib/mysql
and it worked afterward. So that's the datadir permission problem.
How can find the user mysql password? The hosting company which I got
the dedicated server package from set that up of course. Should I go to
Hi,
I'm really stuck here. I'm using version 3.23.58. I tried to create a
database foo using phpAdmin(logged in as root) and got:
ERROR 1006: Can't create database 'foo'. (errno: 13)
I checked [EMAIL PROTECTED] in the user table and it has all priviledges.
Went to linux and logged in as root, log
quot;
>
> which will generate something like:
> Jordan
>
> and on your lookup, do
>
> select col1, col2, col3
> from FacDetails
> where MD5(fid) = $fid;
>
> My $0.02 cents...
>
> > > At 01:32 PM 10/17/2003, Jordan Morgan wrote:
&
e";
> echo "$title";
> echo "";
> echo " faculty\">";
>
> Also, most languages require you to escape " when used within quotes.
>
> At 01:32 PM 10/17/2003, Jordan Morgan wrote:
> >Hi,
> >
> >I'm still le
Hi,
I'm still learning on this. Pls. excuse me if I simply overlooked
something.
Originally I had this:
";
echo "$fname $lname$title";
echo "";
}
?>
to list the search results and display them as a link which will take
the user to a detailed page. However, the fid has to show up as part of
t
nd binary and those who don't" (Unknown)
> - Original Message -
> From: "Diana Soares" <[EMAIL PROTECTED]>
> To: "Jordan Morgan" <[EMAIL PROTECTED]>
> Cc: "mysql" <[EMAIL PROTECTED]>
> Sent: Friday, October 10, 2003 8:5
quot; (and not only "=").
>
> On Fri, 2003-10-10 at 05:43, Jordan Morgan wrote:
> > Hi,
> >
> > I have the following statement:
> >
> > echo "$tenureid";
> >
> > if ($tenureid=3)
> > {
> > // get faculty em
Hi,
I have the following statement:
echo "$tenureid";
if ($tenureid=3)
{
// get faculty employment record - award date
$sql = "select TD.Award_Date from TenureDescription TD LEFT JOIN
InstitutionEmployment IE on TD.TenureDescriptionID=IE.Tenure WHERE
IE.FacultyMember='$fid'";
$result = mysq
Thanks!
Paul DuBois wrote:
> At 3:29 PM -0400 9/14/03, Jordan Morgan wrote:
> >Hi,
> >
> >Can anyone of you kindly tell me what that error usually means? The
> >line number
> >given is always the last line of the script and I'm sure it means something
t;.$fname."%'
> and IE.Rank = '$rank'
> and TD.Tenure_Status like '$tenure'
> order by FP.FirstName;
>
> -Original Message-
> From: Jordan Morgan [mailto:[EMAIL PROTECTED]
> Sent: Sunday, September 14, 2003 4:28 PM
> To: David Sears
> S
ch
> info in the mysql docs.
>
> -Original Message-
> From: Jordan Morgan [mailto:[EMAIL PROTECTED]
> Sent: Sunday, September 14, 2003 2:45 PM
> To: David Sears
> Cc: [EMAIL PROTECTED]
> Subject: Re: Newbies asking help with LEFT JOIN
>
> I tried the parenthese
I tried the parentheses () first and still it didn't work. :(
David Sears wrote:
> That's parentheses () around the inner join, not braces {}.
>
> -Original Message-----
> From: Jordan Morgan [mailto:[EMAIL PROTECTED]
> Sent: Sunday, September 14, 2003 12:56
Hi,
Can anyone of you kindly tell me what that error usually means? The line number
given is always the last line of the script and I'm sure it means something in
particular but I just don't know.
Parse error: parse error, unexpected $ in XX.php4 on line 167
Thanks!
Jordan
--
MySQL General M
ID)
> on IE.Tenure=TD.TenureDescriptionID
> where IE.Department = '$dept'
> and FP.LastName like '%".$lname."%'
> and FP.FirstName like '%".$fname."%'
> and IE.Rank = '$rank'
> and TD.Tenure_Status like '$tenure'
>
Hi,
I'm working on a faculty system and currently I'm building a search
which allows users to generate a list of faculty withint a department
based on their first name, last name, rank, and tenure status. I could
do it without the tenure status criteria however I can't get it work if
the tenure st
Hi,
I'm very new to MySQL. I normally use MS Access but my project needs
MySQL. I'm able to set a field(categoryID) in table A(product) a lookup
field to another table(category) in Access but I can't find anywhere that
teaches me how to do that in MySQL.
I'm managing MySQL through a web interface
18 matches
Mail list logo
