offline solutions for database?

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

Re: ERROR 1006: Can't create database

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

Re: ERROR 1006: Can't create database

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

ERROR 1006: Can't create database

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,

newbie Q: How to display Search Results in a secure way?

Hi, I'm still learning on this. Pls. excuse me if I simply overlooked something. Originally I had this: ? // list matches while (list($fid, $title, $lname, $fname) = mysql_fetch_row($result)) { echo table border=2 width=400 cellpadding=2 cellspacing=2tr; echo td width=200a

Re: newbie Q: How to display Search Results in a secure way?

quotes. At 01:32 PM 10/17/2003, Jordan Morgan wrote: Hi, I'm still learning on this. Pls. excuse me if I simply overlooked something. Originally I had this: ? // list matches while (list($fid, $title, $lname, $fname) = mysql_fetch_row($result)) { echo table border=2 width=400

Re: newbie Q: How to display Search Results in a secure way?

will generate something like: a href=FacDetails.php?fid=23rh23kjne2323j4k23n234lJordan/a 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: Hi, I'm still learning on this. Pls

Re: newbie select statement question

: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Jordan Morgan Information Analyst - GeorgiaFIRST HRMS Project Board of Regents Office of Information and Instructional Technology 1865 West Broad Street, Athens, GA 30606-3539 Phone: (706) 369-6232 Fax: (706

Re: newbie select statement question

Soares [EMAIL PROTECTED] To: Jordan Morgan [EMAIL PROTECTED] Cc: mysql [EMAIL PROTECTED] Sent: Friday, October 10, 2003 8:58 AM Subject: Re: newbie select statement question Look at: if ($tenureid=3) You're not comparing $tenureid with 3, you're assigning 3 to $ternureid... If you

newbie select statement question

Hi, I have the following statement: echo $tenureidP; 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 =

Newbies asking help with LEFT JOIN

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

Re: Newbies asking help with LEFT JOIN

.%' and FP.FirstName like '%.$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 1:29 AM To: [EMAIL PROTECTED] Subject: Newbies asking help with LEFT JOIN Hi

Unexpected $ on line XX

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

Re: Newbies asking help with LEFT JOIN

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 PM To: David Sears Cc: [EMAIL

Re: Newbies asking help with LEFT JOIN

- 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 parentheses () first and still it didn't work. :( David Sears wrote: That's parentheses () around

Re: Newbies asking help with LEFT JOIN

- From: Jordan Morgan [mailto:[EMAIL PROTECTED] Sent: Sunday, September 14, 2003 4:28 PM To: David Sears Subject: Re: Newbies asking help with LEFT JOIN Hmm did what you suggested using LEFT JOIn and remove the parentheses but I still got the following message: Error in query: select

Re: Unexpected $ on line XX

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 in particular but I just don't know. Parse error

Newbie Question: how to set field a lookup field from another table?

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