SELECT id FROM logs WHERE start = $dtime - user = $user

What is wrong with this line? I m trying to ensure I get the right id by requiring two matches from the logs table. I want to match a timestamp from start and the username from user .
Thanks-
cmetcjr

Hi- if I encounter an error in the following PHP statement:

$connection = mysql_connect($host-$user-$password)
or die (mysql_errno($link) . ": " . mysql_error($link). "\n");

Although it can display the error messages to the webpage- I want all error messages to be written to a log file instead of displaying them directly to the client.

So I would to like if MySQL automatically logs all these error messages to a log file? If yes- could you please tell me where it is located?

If no- does this mean that I need to write these error messages to a text file manually?

Thank you very much for your help.

What would be the basic command to have sql grab the value of a html textbox.

example.....
<input type="text" name="uname" id="username">

What would be the SQL code to obtain the value of this textbox. ?
This isnt homework lol- just a personal web page i am creating

i have been searching for hours anyone know a free easy to understand oracle 10g tutorial? i am migrating from mysql.

thanks

for example can I have a MySQL db about 1GB and still works good?

What would be the basic command to have sql grab the value of a html textbox.

example.....
<input type="text" name="uname" id="username">

What would be the SQL code to obtain the value of this textbox. ?
This isnt homework lol- just a personal web page i am creating

i have been searching for hours anyone know a free easy to understand oracle 10g tutorial? i am migrating from mysql.

thanks

for example can I have a MySQL db about 1GB and still works good?

what does that mean? Did I do this wrong? Iam trying to figure out how to create a database. Is this going to be hard if I have never done it before? PLEASE help- thanks

I - I am trying to use MYSQL under wamp for the very first time. I need to create a database- or at least try before I end up hiring someone to do it for me..can you please tell me the very firt step I need to do ? I went under database butthere is so much info- I dont know were to begin.

Also- does this go online- live right away as Im building it? Becasue after I downloaded wamp I noticed that there was someting called side NOTE on my desktop too- but Imnot sure if this is just part of Vista?

thanks so much!!
also- it keeps saying INTRANET is turned off- what does that mean?
Thanks for all your help..I tried to tyoe root and LOL..my computer beeped really loud and scared me....This is my vert first time doing this- do you think I can do it or just hire someone instead?

Thanks so much again!!

what does that mean? Did I do this wrong? Iam trying to figure out how to create a database. Is this going to be hard if I have never done it before? PLEASE help- thanks

I - I am trying to use MYSQL under wamp for the very first time. I need to create a database- or at least try before I end up hiring someone to do it for me..can you please tell me the very firt step I need to do ? I went under database butthere is so much info- I dont know were to begin.

Also- does this go online- live right away as Im building it? Becasue after I downloaded wamp I noticed that there was someting called side NOTE on my desktop too- but Imnot sure if this is just part of Vista?

thanks so much!!
also- it keeps saying INTRANET is turned off- what does that mean?
Thanks for all your help..I tried to tyoe root and LOL..my computer beeped really loud and scared me....This is my vert first time doing this- do you think I can do it or just hire someone instead?

Thanks so much again!!

I m interested in creating my own virtual pet site- but I can t find any descriptive tutorials. All of the php tutorials I find start with "hello world" echo- and I ve gotten that now.

Does anyone know a comprehensive php utorial that can start me on a pet site- similar to teripets.com- nutrinopets.com- or misticpets.com?

Can I create the mysql database first using a different tool and then use RoR to configure and script with it? I ask because there are many other tools out there such as appgini that quickly and efficiently create mysql databases and from what I have seen- RoR is not quite so nimble in that area unless I am missing something.

Also I think we should tell all those poor people using php and javascript about ruby on rails.Newbs like myself- go for instant rails.
http://rubyforge.org/
to get on rails.

I am looking to add a comments section to my web page. I want it to be managed via a MySql database so that I can pull the e-mail addresses that are entered. Can anyone recommend a free script that is easy to install and easy to manage. My PHP knowledge is pretty minimal. Thanks-
Vivian-

That is exactly what I am looking for. I ve been searching constantly and nothing was quite right. Thanks!

what does that mean? Did I do this wrong? Iam trying to figure out how to create a database. Is this going to be hard if I have never done it before? PLEASE help- thanks

I - I am trying to use MYSQL under wamp for the very first time. I need to create a database- or at least try before I end up hiring someone to do it for me..can you please tell me the very firt step I need to do ? I went under database butthere is so much info- I dont know were to begin.

Also- does this go online- live right away as Im building it? Becasue after I downloaded wamp I noticed that there was someting called side NOTE on my desktop too- but Imnot sure if this is just part of Vista?

thanks so much!!
also- it keeps saying INTRANET is turned off- what does that mean?
Thanks for all your help..I tried to tyoe root and LOL..my computer beeped really loud and scared me....This is my vert first time doing this- do you think I can do it or just hire someone instead?

Thanks so much again!!

I m interested in creating my own virtual pet site- but I can t find any descriptive tutorials. All of the php tutorials I find start with "hello world" echo- and I ve gotten that now.

Does anyone know a comprehensive php utorial that can start me on a pet site- similar to teripets.com- nutrinopets.com- or misticpets.com?

Can I create the mysql database first using a different tool and then use RoR to configure and script with it? I ask because there are many other tools out there such as appgini that quickly and efficiently create mysql databases and from what I have seen- RoR is not quite so nimble in that area unless I am missing something.

Also I think we should tell all those poor people using php and javascript about ruby on rails.Newbs like myself- go for instant rails.
http://rubyforge.org/
to get on rails.

I am looking to add a comments section to my web page. I want it to be managed via a MySql database so that I can pull the e-mail addresses that are entered. Can anyone recommend a free script that is easy to install and easy to manage. My PHP knowledge is pretty minimal. Thanks-
Vivian-

That is exactly what I am looking for. I ve been searching constantly and nothing was quite right. Thanks!

what does that mean? Did I do this wrong? Iam trying to figure out how to create a database. Is this going to be hard if I have never done it before? PLEASE help- thanks

I - I am trying to use MYSQL under wamp for the very first time. I need to create a database- or at least try before I end up hiring someone to do it for me..can you please tell me the very firt step I need to do ? I went under database butthere is so much info- I dont know were to begin.

Also- does this go online- live right away as Im building it? Becasue after I downloaded wamp I noticed that there was someting called side NOTE on my desktop too- but Imnot sure if this is just part of Vista?

thanks so much!!
also- it keeps saying INTRANET is turned off- what does that mean?
Thanks for all your help..I tried to tyoe root and LOL..my computer beeped really loud and scared me....This is my vert first time doing this- do you think I can do it or just hire someone instead?

Thanks so much again!!

I m interested in creating my own virtual pet site- but I can t find any descriptive tutorials. All of the php tutorials I find start with "hello world" echo- and I ve gotten that now.

Does anyone know a comprehensive php utorial that can start me on a pet site- similar to teripets.com- nutrinopets.com- or misticpets.com?

Can I create the mysql database first using a different tool and then use RoR to configure and script with it? I ask because there are many other tools out there such as appgini that quickly and efficiently create mysql databases and from what I have seen- RoR is not quite so nimble in that area unless I am missing something.

Also I think we should tell all those poor people using php and javascript about ruby on rails.Newbs like myself- go for instant rails.
http://rubyforge.org/
to get on rails.

I am looking to add a comments section to my web page. I want it to be managed via a MySql database so that I can pull the e-mail addresses that are entered. Can anyone recommend a free script that is easy to install and easy to manage. My PHP knowledge is pretty minimal. Thanks-
Vivian-

That is exactly what I am looking for. I ve been searching constantly and nothing was quite right. Thanks!

I m interested in creating my own virtual pet site- but I can t find any descriptive tutorials. All of the php tutorials I find start with "hello world" echo- and I ve gotten that now.

Does anyone know a comprehensive php utorial that can start me on a pet site- similar to teripets.com- nutrinopets.com- or misticpets.com?

Can I create the mysql database first using a different tool and then use RoR to configure and script with it? I ask because there are many other tools out there such as appgini that quickly and efficiently create mysql databases and from what I have seen- RoR is not quite so nimble in that area unless I am missing something.

Also I think we should tell all those poor people using php and javascript about ruby on rails.Newbs like myself- go for instant rails.
http://rubyforge.org/
to get on rails.

I am looking to add a comments section to my web page. I want it to be managed via a MySql database so that I can pull the e-mail addresses that are entered. Can anyone recommend a free script that is easy to install and easy to manage. My PHP knowledge is pretty minimal. Thanks-
Vivian-

That is exactly what I am looking for. I ve been searching constantly and nothing was quite right. Thanks!

My apache server records an error of;
#22001Data too long for column
when i try and add the value 60+
I have the column set to varchar(5) in database
Thanks the value was actually being sent as over60 which is 6 characters!

Hello- what do you think is the best way to handle apostrophes in PHP/MySQL?

I’m writing an adventure game and the user can enter text. If they enter text with an apostrophe I need to strip this out or I get MySQL errors. Ideally I want to escape the apostrophe so it gets stored in the table and then when it’s retrieved the code recognises an escaped apostrophe and displays it correctly

How would you handle the input from the user and then display it back again?

Thanks!

Also I think we should tell all those poor people using php and javascript about ruby on rails.Newbs like myself- go for instant rails.
http://rubyforge.org/
to get on rails.

I am looking to add a comments section to my web page. I want it to be managed via a MySql database so that I can pull the e-mail addresses that are entered. Can anyone recommend a free script that is easy to install and easy to manage. My PHP knowledge is pretty minimal. Thanks-
Vivian-

That is exactly what I am looking for. I ve been searching constantly and nothing was quite right. Thanks!

My apache server records an error of;
#22001Data too long for column
when i try and add the value 60+
I have the column set to varchar(5) in database
Thanks the value was actually being sent as over60 which is 6 characters!

Hello- what do you think is the best way to handle apostrophes in PHP/MySQL?

I’m writing an adventure game and the user can enter text. If they enter text with an apostrophe I need to strip this out or I get MySQL errors. Ideally I want to escape the apostrophe so it gets stored in the table and then when it’s retrieved the code recognises an escaped apostrophe and displays it correctly

How would you handle the input from the user and then display it back again?

Thanks!

Hi-

1) Is there a way to back up mysql database to my computer? So if i join a host after some time to reupload the database back to it?

2) And is there a way of useing a Vbulltin database and then change my website to wordpress and still use the old database with all the forums and usernames etc?

I just want to to know how stressful it is.. because i m studying Computer Science and it really sucks now.. i liked it before but now everything becomes very complicated (c#- mysql- java swing..). It s not difficult but i think it s very complicated.. and in a firm a real project must be perfect.There s always possibility to make mistakes. So i m waiting answers from real programmers.

I just want to to know how stressful it is.. because i m studying Computer Science and it really sucks now.. i liked it before but now everything becomes very complicated (c#- mysql- java swing..). It s not difficult but i think it s very complicated.. and in a firm a real project must be perfect.There s always possibility to make mistakes. So i m waiting answers from real programmers.

Are you sick of having to check for wordpress updates every day in fear of being hacked? Well- fear no more because Firewall Script can protect you against

* Sql Injections
* Coding Errors
* Cross Site Scripting
* Password Theft
* Comment Spam

Firewall Script helps you stop every possible attack to your wordpress or any PHP/Mysql based website. It even stops private attacks which are not public! I highly recommend everyone this awesome product and it takes less than 2 minutes to install.

http://www.geekblogger.net/goto/Firewall_Script/97/4

More Info @ http://www.geekblogger.net

I hope you can understand this- I dont know how to explain~

If I pass a link that has ?x=a- does the page must exist too?

Example the page is problem.php- passing to answer.php

When the link writes

www.x.com/answer.php?x=a

does that mean the next page must be answer.php?x=a ?

or wit will go to

answer.php ?

How to carry on an information on a link without having to create many (same) pages?

Is there any place I can check the codes?

My computer has installed windowsxp+sp3 En Version.
Apache(2.2.4)+php(5.2.1)+mysql(5.0.15)+zend(2.7) were installed in my computer.
I according to the allocation method of Winxp sp2 Chinese version.
the message showed save the file when I running the php.
why it is? Doesn t xp sp3 can t support apache?

Warning my sql_num_rows0:supplied argument is not a valid MySQL result resource in/home/www/backedup/html/flightchecker/newtemplate/body.php on line 786?

I am using internet explorer 7 for my web applicaion. in that my applicatiob is working fine. when i run the same application in firefox 2- session variables doesnt work. and due to that my mysql queries are not working as i am taking data from session variables for where close of mysql query. please help .. i need to know how to make mozilla firefox working for sessions.

I would like to execute a mysql query like this and want to know if there is any problem with doing so.

$sql="insert into `products`(`products_quantity`)
values( mysql_real_escape_string
($_POST[ products_quantity ]) )"

is this possible

i found a tutorial that told me how to name my ip or local host to a domain name but now cant find it on net. i have a registered domain and dns so on. i want to host it using apache2.8 i have done everything to make mysql-php-apache- and phpmyadmin work together but still cant name local host and for some reason it not showing on net just my pc. any help would be appreciated.

Thanks a lot to all of you who answered my previous question.
Ok- I want to build a commercial-like dynamic website.
Can I do that by learning/using Frontpage(or Dreamweaver) together with php/mysql?
I ve been told it would be a waste of (lots of precious) time and that I d be better off using a cms like Joomla.
I ve looked at Joomla and it looks so dreary having to do all these modifications and adding plug-ins. On the other hand- is it true that learning/using php/mysql to get the functionalities that Joomla and its plug-ins offfer IS a very TALL ORDER?
I m kind of lost here as you can see!
thanks again
Dave
Can I use Dreamweaver and php/mysql to create any kind of website (with any commonly used functionalities) that I fancy?

Hi-

I m new to PHP and am trying to write code that allows a user to upload a file- along with a number of different inputs (name- description- etc.) that will all go into a MySQL database.

I ve checked countless forums and tutorials and can successfully create a script that simply uploads a file into a folder in my directory- but I can t find anything that allows me to add forms and inputs so I can get additional information in my database.

I m currently doing it from a "upload.php" file which connects to a "config.inc.php" file as well as an "uploader.php" file. The config.inc.php file also connects to a "mysqli connect.php" file.

Not sure if I m even doing it the right way- but any explicit help would be greatly appreciated!

Thanks

Thanks a lot to all of you who answered my previous question.
Ok- I want to build a commercial-like dynamic website.
Can I do that by learning/using Frontpage(or Dreamweaver) together with php/mysql?
I ve been told it would be a waste of (lots of precious) time and that I d be better off using a cms like Joomla.
I ve looked at Joomla and it looks so dreary having to do all these modifications and adding plug-ins. On the other hand- is it true that learning/using php/mysql to get the functionalities that Joomla and its plug-ins offfer IS a very TALL ORDER?
I m kind of lost here as you can see!
thanks again
Dave
Can I use Dreamweaver and php/mysql to create any kind of website (with any commonly used functionalities) that I fancy?

Hi-

I m new to PHP and am trying to write code that allows a user to upload a file- along with a number of different inputs (name- description- etc.) that will all go into a MySQL database.

I ve checked countless forums and tutorials and can successfully create a script that simply uploads a file into a folder in my directory- but I can t find anything that allows me to add forms and inputs so I can get additional information in my database.

I m currently doing it from a "upload.php" file which connects to a "config.inc.php" file as well as an "uploader.php" file. The config.inc.php file also connects to a "mysqli connect.php" file.

Not sure if I m even doing it the right way- but any explicit help would be greatly appreciated!

Thanks

I have a page which uses a session_user_id from

if(!isset($_SESSION
[ SESS_MEMBER_ID ]) ||
(trim($_SESSION
[ SESS_MEMBER_ID ])== )) {
header("location: login.php");

with a a dropdown list of 30-50 countries like

<select name="country" id="country">
<option value="Bosnia and Herzegowina">Bosnia and Herzegowina</option>
<option value="Korea- Democratic People s Republic of">Korea- Democratic People s Republic of</option>
<option value="Federated States of Micronesia">Federated States of Micronesia</option>
<option value="Sao Tome and Principe">Sao Tome and Principe</option>
<option value="South Georgia and South Sandwich Islands">South Georgia and South Sandwich Islands</option>
.
.
.
</select>

to get a row of record from

mysql_query("SELECT CName- Country-... FROM customer
WHERE CuserID =
$_SESSION
[ SESS_MEMBER_ID ] ")

But how do I fetch the Country from the table & make it the selected value in the dropdown list?

I am looking around Portland- Oregon for a summer job in the general area of computer programming. The problem is- I m not quite sure which jobs I would be able to get and where to find them.

I am a college student (computer science major) going into my junior year. I ve done some web design- but my only serious production level project was a set of relatively simple set of PHP scripts combined with MySQL to manage entries in a county wide contest in Clackamas County. However- I know several languages- though I don t have complete mastery of them. I good knowledge of the mechanics of HTML/CSS- but I m not great when it comes to layouts.

Languages:
Thorough: (X)HTML- CSS
Solid working knowledge: Python- PHP- generic XML
Basic knowledge: C++- Java- JavaScript- bash- SQL

This isn t a classified ad- I m just looking for advice as to what s out there and how to get it.

Thanks a lot to all of you who answered my previous question.
Ok- I want to build a commercial-like dynamic website.
Can I do that by learning/using Frontpage(or Dreamweaver) together with php/mysql?
I ve been told it would be a waste of (lots of precious) time and that I d be better off using a cms like Joomla.
I ve looked at Joomla and it looks so dreary having to do all these modifications and adding plug-ins. On the other hand- is it true that learning/using php/mysql to get the functionalities that Joomla and its plug-ins offfer IS a very TALL ORDER?
I m kind of lost here as you can see!
thanks again
Dave
Can I use Dreamweaver and php/mysql to create any kind of website (with any commonly used functionalities) that I fancy?

Hi-

I m new to PHP and am trying to write code that allows a user to upload a file- along with a number of different inputs (name- description- etc.) that will all go into a MySQL database.

I ve checked countless forums and tutorials and can successfully create a script that simply uploads a file into a folder in my directory- but I can t find anything that allows me to add forms and inputs so I can get additional information in my database.

I m currently doing it from a "upload.php" file which connects to a "config.inc.php" file as well as an "uploader.php" file. The config.inc.php file also connects to a "mysqli connect.php" file.

Not sure if I m even doing it the right way- but any explicit help would be greatly appreciated!

Thanks

I have a page which uses a session_user_id from

if(!isset($_SESSION
[ SESS_MEMBER_ID ]) ||
(trim($_SESSION
[ SESS_MEMBER_ID ])== )) {
header("location: login.php");

with a a dropdown list of 30-50 countries like

<select name="country" id="country">
<option value="Bosnia and Herzegowina">Bosnia and Herzegowina</option>
<option value="Korea- Democratic People s Republic of">Korea- Democratic People s Republic of</option>
<option value="Federated States of Micronesia">Federated States of Micronesia</option>
<option value="Sao Tome and Principe">Sao Tome and Principe</option>
<option value="South Georgia and South Sandwich Islands">South Georgia and South Sandwich Islands</option>
.
.
.
</select>

to get a row of record from

mysql_query("SELECT CName- Country-... FROM customer
WHERE CuserID =
$_SESSION
[ SESS_MEMBER_ID ] ")

But how do I fetch the Country from the table & make it the selected value in the dropdown list?

I am looking around Portland- Oregon for a summer job in the general area of computer programming. The problem is- I m not quite sure which jobs I would be able to get and where to find them.

I am a college student (computer science major) going into my junior year. I ve done some web design- but my only serious production level project was a set of relatively simple set of PHP scripts combined with MySQL to manage entries in a county wide contest in Clackamas County. However- I know several languages- though I don t have complete mastery of them. I good knowledge of the mechanics of HTML/CSS- but I m not great when it comes to layouts.

Languages:
Thorough: (X)HTML- CSS
Solid working knowledge: Python- PHP- generic XML
Basic knowledge: C++- Java- JavaScript- bash- SQL

This isn t a classified ad- I m just looking for advice as to what s out there and how to get it.

im thinking of making a simple database of my friends info such as phone number- addresses- email and name. instead of jotting down using pencil and key it in in computer by myself- i wanted to try a more hi-tech approach. How to make a simple form that i can upload to the internet and ask my friends to fill it- it just like registration process and when they clicked done- it will save in a database that i can access later. i heard of ASP- mySQL but i cant understand reading on my own..i need a teacher to teach me from A-Z..thx

Hi-

I m new to PHP and am trying to write code that allows a user to upload a file- along with a number of different inputs (name- description- etc.) that will all go into a MySQL database.

I ve checked countless forums and tutorials and can successfully create a script that simply uploads a file into a folder in my directory- but I can t find anything that allows me to add forms and inputs so I can get additional information in my database.

I m currently doing it from a "upload.php" file which connects to a "config.inc.php" file as well as an "uploader.php" file. The config.inc.php file also connects to a "mysqli connect.php" file.

Not sure if I m even doing it the right way- but any explicit help would be greatly appreciated!

Thanks

I have a page which uses a session_user_id from

if(!isset($_SESSION
[ SESS_MEMBER_ID ]) ||
(trim($_SESSION
[ SESS_MEMBER_ID ])== )) {
header("location: login.php");

with a a dropdown list of 30-50 countries like

<select name="country" id="country">
<option value="Bosnia and Herzegowina">Bosnia and Herzegowina</option>
<option value="Korea- Democratic People s Republic of">Korea- Democratic People s Republic of</option>
<option value="Federated States of Micronesia">Federated States of Micronesia</option>
<option value="Sao Tome and Principe">Sao Tome and Principe</option>
<option value="South Georgia and South Sandwich Islands">South Georgia and South Sandwich Islands</option>
.
.
.
</select>

to get a row of record from

mysql_query("SELECT CName- Country-... FROM customer
WHERE CuserID =
$_SESSION
[ SESS_MEMBER_ID ] ")

But how do I fetch the Country from the table & make it the selected value in the dropdown list?

I am looking around Portland- Oregon for a summer job in the general area of computer programming. The problem is- I m not quite sure which jobs I would be able to get and where to find them.

I am a college student (computer science major) going into my junior year. I ve done some web design- but my only serious production level project was a set of relatively simple set of PHP scripts combined with MySQL to manage entries in a county wide contest in Clackamas County. However- I know several languages- though I don t have complete mastery of them. I good knowledge of the mechanics of HTML/CSS- but I m not great when it comes to layouts.

Languages:
Thorough: (X)HTML- CSS
Solid working knowledge: Python- PHP- generic XML
Basic knowledge: C++- Java- JavaScript- bash- SQL

This isn t a classified ad- I m just looking for advice as to what s out there and how to get it.

im thinking of making a simple database of my friends info such as phone number- addresses- email and name. instead of jotting down using pencil and key it in in computer by myself- i wanted to try a more hi-tech approach. How to make a simple form that i can upload to the internet and ask my friends to fill it- it just like registration process and when they clicked done- it will save in a database that i can access later. i heard of ASP- mySQL but i cant understand reading on my own..i need a teacher to teach me from A-Z..thx

when i try to install my database- i get the following error message:

ERROR 1153: Got a packet bigger than max_allowed_packet bytes
ERROR 2006: Mysql server has gone away

i researched about it and found out that the server issues Packet too large error and closes the connection when it receives a packet bigger than max_allowed_packet bytes. However- I couldn t find any resources on how to set that variable to a larger value.

I will appreciate ANY suggestion...thanks!

I am looking around Portland- Oregon for a summer job in the general area of computer programming. The problem is- I m not quite sure which jobs I would be able to get and where to find them.

I am a college student (computer science major) going into my junior year. I ve done some web design- but my only serious production level project was a set of relatively simple set of PHP scripts combined with MySQL to manage entries in a county wide contest in Clackamas County. However- I know several languages- though I don t have complete mastery of them. I good knowledge of the mechanics of HTML/CSS- but I m not great when it comes to layouts.

Languages:
Thorough: (X)HTML- CSS
Solid working knowledge: Python- PHP- generic XML
Basic knowledge: C++- Java- JavaScript- bash- SQL

This isn t a classified ad- I m just looking for advice as to what s out there and how to get it.

im thinking of making a simple database of my friends info such as phone number- addresses- email and name. instead of jotting down using pencil and key it in in computer by myself- i wanted to try a more hi-tech approach. How to make a simple form that i can upload to the internet and ask my friends to fill it- it just like registration process and when they clicked done- it will save in a database that i can access later. i heard of ASP- mySQL but i cant understand reading on my own..i need a teacher to teach me from A-Z..thx

when i try to install my database- i get the following error message:

ERROR 1153: Got a packet bigger than max_allowed_packet bytes
ERROR 2006: Mysql server has gone away

i researched about it and found out that the server issues Packet too large error and closes the connection when it receives a packet bigger than max_allowed_packet bytes. However- I couldn t find any resources on how to set that variable to a larger value.

I will appreciate ANY suggestion...thanks!

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ) ORDER BY (DATEDIFF(DATE(vip)- CURDATE())>0) DESC- points DESC- lastlogin DESC at line 5

and everytime i try to add someoen it says please use the correct gateway.
tell me how to fix it.
please?

I have a database on MS SQL Server 2005. I would like to export one of the tables in it to a MySQL database.

What software do I need ? How do I proceed ??

I have been working on a comment script that has gone very well. It is written in php and has no server. Yes- this comment system has No server. So i was wondering if it is good enought to sell for maybe a low price like $5. I would be selling it for not only the script but the idea. Most comment scripts on website require servers like MySQL or SQL or maybe RSS. You can try the demo out here: http://commentdemo.awardspace.com/index.php
Please tell me if its good enough to sell or if i should give it away as open source freeware.
Ok- the comments are stored in a text file.

i need to move the data from one column in table_1 to another column in table_2

can someone please write me some syntax ?

I am playing around with Joomla but i have no idea what i am doing. Any tips for me especially when it comes to the database that i need.

Why do i need a mysql database?

How do I do a mysqldump that only exports the structure of a database and not the actual data?

I have been learning mySQL for a while now- but have come to a confusing point and need help. I purchased a server and supports mysql and php + has been enabled in the settings. The server is a NAS TS-209.

I have made a simple webpage which uses php to simply load a database and display a record. The php really have no meaning other than learning experience and comftable in this area.

I have mySQL installed on my desktop and I have created a database + table and few records- but how do I get it on my server? This is what doesn t make sense to me and cannot find information on it. Some sites just say the usual jargon but doesn t actually mention how to put it on the server.

how do I log in to the server with mysql? do I have to install mysql on the server- and create a database this way?

any general answers is a plus.

Hi i want to make a wow server just for me i dont want to host it online not at this time any way and iv tryed everything i can think of on the guides videos all that and thares a conection they all us mysql and what ever repack file they want so i tryed this and this is what i get win i try and start mysql error do you have a nother server operating on port 3306.error shutingdown shutdown complet press any thing to continue and it exits. then im told i need 2 start logon server and it says acces dinide for user root and then password is hiden so then im told i need 2 start ascent and it says main data instalation faild exiting so last i need 2 start apache and it says no liseing sockets availibale can not open login files shuting down. so if any 1 knows what is going n here plz tell me because this is driveing me crazy thx.
ok well i did not make this clear but if any one out thare knows what is going on with my program and can tell me what to do from here to get my server up and running plz tell me.

how can i make these two commands so that i can copy and paste them into sql for my different tables.

UPDATE cefil3ed
SET ENTDATE= CONCAT(MID(ENTDATE-7-4)- - -MID(ENTDATE-1-2)- - -MID(ENTDATE-4-2))

UPDATE cefil3ed
SET `UPDATE`= CONCAT(MID(`UPDATE`-7-4)- - -MID(`UPDATE`-1-2)- - -MID(`UPDATE`-4-2))

i tried using union in between them but it did not work. any suggestions ?

-on mysql
UPDATE cefil3ed
SET ENTDATE= CONCAT(MID(ENTDATE-7-4)- - -
MID(ENTDATE-1-2)- - -MID(ENTDATE-4-2))

UPDATE cefil3ed
SET `UPDATE`= CONCAT(MID(`UPDATE`-7-4)- - -
MID(`UPDATE`-1-2)- - -MID(`UPDATE`-4-2))
its just these two- the bottom one is missing parentheses thats all.
thanks.

i need to take the database backup in mysql in suse linux environment.

Is there a way to sort a query by the greater of two fields?

I have one field that stores the original post date (`original`) and another field that stores update date (`update`)- update is 0 by default. Both fields are numeric timestamps. I want to find the most recent articles (original or updated)- so i need a query that does something like:
(`original`>`update`?`original`:`update`) as `time`- ORDER BY `time` DESC

Is this possible?

This is my code

public class Main {

public static void main(String[] args) {

Connection myConnection;

System.out.println("Sample db connectivity using MySQL and netbeans");


try{

Class.forName("com.mysql.jdbc.Driver");
myConnection=DriverManager.getConnection(
"jdbc:mysql://localhost:3306/sample"-"nbenavidez"-"password"
);
}
catch(Exception e){
System.out.println("Failed to get connection - This is BSSSSS");
e.printStackTrace();
}



}

}
the error :

Failed to get connection - This is BSSSSS
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:276)
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at dbsample.Main.main(Main.java:28)
I have the connector in place (the jar file) and it does compile fine also

i know that MS SQL can support around 250-000 and ORACLE can do around 500-000-1MIL- but i dont know about MySQL?
appreciate the help!

THANKS :)

If I have this table- how do I select only 1 row each? for example 1 from felipe and 1 from pedro:

id name value
--------------
1 felipe 2
2 felipe 4
3 felipe 3
4 pedro 3
5 pedro 6
6 pedro 2

thanks for any help
The table has more than 30000 rows- some items are repeated 3 times some 20 times- I just need 1 per item

thank you all for the time

I have used these: MS office â€" Word- Excel- PowerPoint- Publisher- Exchange- Outlook (both forms) â€" Windows and Mac OS- Open Office â€" Linux- Adobe Acrobat Professional â€" All OS (including Linux implementation)- FileMaker Pro 7 (last version I’ve used)- Dreamweaver- Flash- MySQL- PHP- Apache- Unix- Ruby (coding)- PERL (don’t ask me ‘cause I forget but- I’ve done it before…LONG TIME AGO when I had no life)- Redhat- Fedora- Debian- Mepis- Mandrake. Omni-Graffle- Sound Designer Pro- Pro Tools- Custom designed Sound and Light grids using Visio and Concept Draw- Web html apps- XML
Batch mod â€" unix permissions

Plus hardware support- 3 com switches and routers
Linksys and Cisco Managed switches- routers- Networking Patching- Nortel PBX Switching schemes and management console software- Wireless Access Points â€" Linksys- Dlink- Netgear- Oronico- Apple Airport

Not too mention the telecommunications end user support.

How do I put all this into a resume succinctly? HELP!

This is my code

public class Main {

public static void main(String[] args) {

Connection myConnection;

System.out.println("Sample db connectivity using MySQL and netbeans");


try{

Class.forName("com.mysql.jdbc.Driver");
myConnection=DriverManager.getConnection(
"jdbc:mysql://localhost:3306/sample"-"nbenavidez"-"password"
);
}
catch(Exception e){
System.out.println("Failed to get connection - This is BSSSSS");
e.printStackTrace();
}



}

}
the error :

Failed to get connection - This is BSSSSS
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:276)
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at dbsample.Main.main(Main.java:28)
I have the connector in place (the jar file) and it does compile fine also

i know that MS SQL can support around 250-000 and ORACLE can do around 500-000-1MIL- but i dont know about MySQL?
appreciate the help!

THANKS :)

If I have this table- how do I select only 1 row each? for example 1 from felipe and 1 from pedro:

id name value
--------------
1 felipe 2
2 felipe 4
3 felipe 3
4 pedro 3
5 pedro 6
6 pedro 2

thanks for any help
The table has more than 30000 rows- some items are repeated 3 times some 20 times- I just need 1 per item

thank you all for the time

I have used these: MS office â€" Word- Excel- PowerPoint- Publisher- Exchange- Outlook (both forms) â€" Windows and Mac OS- Open Office â€" Linux- Adobe Acrobat Professional â€" All OS (including Linux implementation)- FileMaker Pro 7 (last version I’ve used)- Dreamweaver- Flash- MySQL- PHP- Apache- Unix- Ruby (coding)- PERL (don’t ask me ‘cause I forget but- I’ve done it before…LONG TIME AGO when I had no life)- Redhat- Fedora- Debian- Mepis- Mandrake. Omni-Graffle- Sound Designer Pro- Pro Tools- Custom designed Sound and Light grids using Visio and Concept Draw- Web html apps- XML
Batch mod â€" unix permissions

Plus hardware support- 3 com switches and routers
Linksys and Cisco Managed switches- routers- Networking Patching- Nortel PBX Switching schemes and management console software- Wireless Access Points â€" Linksys- Dlink- Netgear- Oronico- Apple Airport

Not too mention the telecommunications end user support.

How do I put all this into a resume succinctly? HELP!

I reinstalled mysql and it uses the same password- how can i remove that password?

im trying to make a maplestpory server but i cant get make a Registration link.

im trying to make a maplestpory server but i cant get make a Registration link.

I need a solid developer (or two) who is/are familiar with PHP- MySQL- Linux- Apache- Memcached- C- Actionscript 3- Ajax and smiliar applications who would be interested in working on an innovative project. Logistics- planning- fees etc are discussed in private (eg not on yahoo answers).

If anyone knows ANY really savvy developers I can get in touch with- who has experience in building scripts using the above apps- let me know!

This project will be a worthy notch on your belt.
EDIT: I have no plans to go to an employment site to find matches for my needs.. T
EDIT: I have no plans to go to an employment site to find a match for my needs. Thanks for the heads up but im side stepping the cumbersom and square practice. I just need a solid person who needs a project.. not a small one. Again- the logistics will be up to us.

I just transfered the site from hostgator to site5. It is simple html/php/mysql with no pics on any of the pages except the listings. It takes forever to load up the page. Its not just my computer its happening all around the country. I contacted site5 and they said that there was nothing wrong. Any suggestions???

the xl sheets come in every month and the existing sheets are currently manually altered by copy pasting.. which is better suited for automating this process using databases ? access or mysql ?

I dont know much about MySQL. Can you explain to me what MySQL query is?
And how can I learn to use it to access a website database?
Also- whats the relationship between MySQL and PHP?

I dont know anything about MySQL. But i need to learn how to use MySQL Query for a project.
Will I be able to do it?

Whats it about and why is it used?

I need to change data in one column of my table- example: 19870301 to 1987-03-01

How can I do this for an entire column- as I have 7 hundred something rows of data- I don t want to update every single row individually.

All the data is like this- I need to make it to the date format. but if i use the date command all my data is gone. please help

I need to know exactly what to type in-
bad data column is: CDATE
table is: cefil3

-mySQL

SendRedirect("page.jsp");

Also plz tell me what php script to write for the following:-

There should be options to enter a username and password (i know how to do this i.e. by using form ) and to click on a login button (just like how we enter into yahoo mail). Now- after clicking the login button it has to be checked whether the username and password entered are valid or not (they are stored in a MySQL table) and if valid then control should navigate to a new page say list.php

There should be a form to enter a user s username and password with a login button. Let there be multiple users so there are multiple sets of username and password on entering any of which a particular php page should open up. These username and password sets will be stored in a table inside a MySQL database. So plz tell me how to write the php code which checks for valid username and password and then redirects to a page.

There should be a form to enter a user s username and password with a login button. Let there be multiple users so there are multiple sets of username and password on entering any of which a particular php page should open up. These username and password sets will be stored in a table inside a MySQL database. So plz tell me how to write the php code which checks for valid username and password and then redirects to a page.

I am trying to select all the values from a column called "08" in reverse numerical order. When I run the following- every row returned has a value of 8- even though the actual values in the database are numbers like 236- 36- and 5. Why does the following Select statement not return the actual numerical values in the column called "08"? The column called "08" has a field type of INT(08).

$result = mysql_query ("SELECT 08 FROM May08 ORDER BY 08 DESC");

while ($row = mysql_fetch_array ($result)) {

$val=$row[ 08 ];

echo $val;

}

mysql_query("UPDATE songs SET rating = ".$rating." WHERE song_name = ".$song_name." WHERE username = ".$username." ")or die ("NOT WORKING!");

Okay- the code above doesn t work- I want it to double confirm the row that has the song_name = $song_name and the username = $username. Uh.. there s php in there too.
Thanks!

SendRedirect("page.jsp");

Also plz tell me what php script to write for the following:-

There should be options to enter a username and password (i know how to do this i.e. by using form ) and to click on a login button (just like how we enter into yahoo mail). Now- after clicking the login button it has to be checked whether the username and password entered are valid or not (they are stored in a MySQL table) and if valid then control should navigate to a new page say list.php

There should be a form to enter a user s username and password with a login button. Let there be multiple users so there are multiple sets of username and password on entering any of which a particular php page should open up. These username and password sets will be stored in a table inside a MySQL database. So plz tell me how to write the php code which checks for valid username and password and then redirects to a page.

There should be a form to enter a user s username and password with a login button. Let there be multiple users so there are multiple sets of username and password on entering any of which a particular php page should open up. These username and password sets will be stored in a table inside a MySQL database. So plz tell me how to write the php code which checks for valid username and password and then redirects to a page.

I am trying to select all the values from a column called "08" in reverse numerical order. When I run the following- every row returned has a value of 8- even though the actual values in the database are numbers like 236- 36- and 5. Why does the following Select statement not return the actual numerical values in the column called "08"? The column called "08" has a field type of INT(08).

$result = mysql_query ("SELECT 08 FROM May08 ORDER BY 08 DESC");

while ($row = mysql_fetch_array ($result)) {

$val=$row[ 08 ];

echo $val;

}

mysql_query("UPDATE songs SET rating = ".$rating." WHERE song_name = ".$song_name." WHERE username = ".$username." ")or die ("NOT WORKING!");

Okay- the code above doesn t work- I want it to double confirm the row that has the song_name = $song_name and the username = $username. Uh.. there s php in there too.
Thanks!

I have the following query for mysql but it keeps giving me an error and I am not sure why

"SELECT pd.products_name- pd.products_description- pd.products_url- p.products_quantity- p.price-p.products_weight-p.products_model-p.product_status from products_description pd- products d- where p.products=
{$_GET[ id ]}
and pd.products_id=
p.products_id "

I realize that I am not gaurding against the SQL injection I was plugging value in for testing.
the problem is in the where statement

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near where p.products= 8574 and pd.products_id= p.products_id at line 1

Can someone help please?

I am trying to select all the values from a column called "08" in reverse numerical order. When I run the following- every row returned has a value of 8- even though the actual values in the database are numbers like 236- 36- and 5. Why does the following Select statement not return the actual numerical values in the column called "08"? The column called "08" has a field type of INT(08).

$result = mysql_query ("SELECT 08 FROM May08 ORDER BY 08 DESC");

while ($row = mysql_fetch_array ($result)) {

$val=$row[ 08 ];

echo $val;

}

mysql_query("UPDATE songs SET rating = ".$rating." WHERE song_name = ".$song_name." WHERE username = ".$username." ")or die ("NOT WORKING!");

Okay- the code above doesn t work- I want it to double confirm the row that has the song_name = $song_name and the username = $username. Uh.. there s php in there too.
Thanks!

I have the following query for mysql but it keeps giving me an error and I am not sure why

"SELECT pd.products_name- pd.products_description- pd.products_url- p.products_quantity- p.price-p.products_weight-p.products_model-p.product_status from products_description pd- products d- where p.products=
{$_GET[ id ]}
and pd.products_id=
p.products_id "

I realize that I am not gaurding against the SQL injection I was plugging value in for testing.
the problem is in the where statement

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near where p.products= 8574 and pd.products_id= p.products_id at line 1

Can someone help please?

I would ve emailed yahoo about this- but couldn t find a support email address. I want to use the latest version of Wordpress and I want to use a PHPBB3 forum on my website- but I only know the username & password for my MySQL Database(s). Both of these softwares require a DSN (or DNS i don t remember what it is) & a database name to install them correctly- and I can t create a new database. I would prefer Yahoo! would update their softwares within the small business control panel- including Wordpress & PHPBB. But- since that seems unlikely- I was wondering if:
-Anyone knew a support email address for Yahoo?
-Anyone knew how I can make a new MySQL database?

I need to migrate a MySQL database from one host to another. If I export the passwords column from my user table- which is stored as BLOB and encrypted using the AES_ENCRYPT function- will that be successful- or does the AES_ENCRYPT vary machine-to-machine?

I guess the real question is- if I pass AES_ENCRYPT("somestring"-"somekey") to MySQL on two different machines- will the result be equal?

I read that mysql should hold links to the images on your filesystem instead of the images themselves. That being said- how would I format something like: C:\pictures\pic1-food-groups.jpg?

I would ve emailed yahoo about this- but couldn t find a support email address. I want to use the latest version of Wordpress and I want to use a PHPBB3 forum on my website- but I only know the username & password for my MySQL Database(s). Both of these softwares require a DSN (or DNS i don t remember what it is) & a database name to install them correctly- and I can t create a new database. I would prefer Yahoo! would update their softwares within the small business control panel- including Wordpress & PHPBB. But- since that seems unlikely- I was wondering if:
-Anyone knew a support email address for Yahoo?
-Anyone knew how I can make a new MySQL database?

I need to migrate a MySQL database from one host to another. If I export the passwords column from my user table- which is stored as BLOB and encrypted using the AES_ENCRYPT function- will that be successful- or does the AES_ENCRYPT vary machine-to-machine?

I guess the real question is- if I pass AES_ENCRYPT("somestring"-"somekey") to MySQL on two different machines- will the result be equal?

I read that mysql should hold links to the images on your filesystem instead of the images themselves. That being said- how would I format something like: C:\pictures\pic1-food-groups.jpg?

Hi- I am looking for a shared hosting plan for my website that offers a lot of memory and processing power.

I would go with a dedicated server or virtual dedicated server- but do not want to deal with setting up my own email- php- mysql- etc. servers on it. I want someone else to maintain the platform (with security updates- new versions of php- etc.) so that I can focus my time on development work.

I basically need a shared hosting plan on steroids.

Does anyone know of any good plans like this?

Thanks in advance.

hi....can the uniform server (wamp package) do a better job than configuring php and mysql with IIS to make the web site public if any one has already tried it...thank you.
ok thank you..but what is the difference between the uniform server and the ordinary wamp package..can both of them be used to build a public web server?

hi...i have wamp installed(php + mysql + apache) .. i recently installed IIS ..now php works fine with IIS but not mysql...(depending on a tutoria) i copied some dll files from the php folder to system32- windows and wwwroot directories and set the path in the environment variables to :

C:\wamp\bin\php\php5.2.5

mysql is not showing in phpinfo() ...any help is appreciated.

I read that mysql should hold links to the images on your filesystem instead of the images themselves. That being said- how would I format something like: C:\pictures\pic1-food-groups.jpg?

Hi- I am looking for a shared hosting plan for my website that offers a lot of memory and processing power.

I would go with a dedicated server or virtual dedicated server- but do not want to deal with setting up my own email- php- mysql- etc. servers on it. I want someone else to maintain the platform (with security updates- new versions of php- etc.) so that I can focus my time on development work.

I basically need a shared hosting plan on steroids.

Does anyone know of any good plans like this?

Thanks in advance.

hi....can the uniform server (wamp package) do a better job than configuring php and mysql with IIS to make the web site public if any one has already tried it...thank you.
ok thank you..but what is the difference between the uniform server and the ordinary wamp package..can both of them be used to build a public web server?

hi...i have wamp installed(php + mysql + apache) .. i recently installed IIS ..now php works fine with IIS but not mysql...(depending on a tutoria) i copied some dll files from the php folder to system32- windows and wwwroot directories and set the path in the environment variables to :

C:\wamp\bin\php\php5.2.5

mysql is not showing in phpinfo() ...any help is appreciated.

I have a DJ site with an html page. E.g housemixes.html.
On this page- I have a list of all my mixes.

I would like to have some kind of active display of information that shows the following activity for Each DJ Mix.

E.g. To record number of downloads for a file? (E.g DJ Mix 1).
and to let visitors rate a file also.

I would like to have some kind of code/script in HTML that somehow updates- next to an image/name of the file.

E.g

DJ Mix 1 (Average rating = 8.5)
DJ Mix 1 (Has been downloaded 323 times).

Is this possible please for someone with no knowledge of Web Design?

I can use Swish Max 2 in a basic manner- and have Dreamweaver CS3 for embedding Flash (swf) files into HTML files to upload to the server.

I have my own server with MySQL installed.

Maybe there is a programme somewhere someone knows of please to make this possible?

Or a service where I pay money to have this done?!

Many thanks for any advice

I want to use the wordpress cms for my website but the wordpress platform and themes are too hard to customise to make the site look the way I want it to look. I heard you can just pull the data you need from the data table in mySQL- how do you pull data from a data table.

Am I better off learning to customise wordpress or learning a bit about php to get the desired effect (the desired effect being a website that doesn t look like a shite wordpress theme)

I would like to ask how to insert entries in mysql using php on top of the table or should I say as the first row in the table so that when I query all entries- I would get the most recent once on top of the list... please help. thanksz

i need code or any suggestions to take my project database backup in to any hard drive

Hi all-
I want to know about the best host for jsp and mysql.
I need about 5GB of web space and it would be better if database space is unlimited.It would be better if one provides the list of host based on the space-reliability-support and cost.

I have a book that uses mysqli in all of the examples but online tutorials that I have seen use mysql (no i ). I m not sure what I should be using or what the difference is.

I thought I heard the i version is for use with a newer MySQL server- but I m really not sure.

I am looking for a free open source forum script and I would like to be able to have a "latest posts" modual on my html homepage. I have a host with php4/5 and I have plenty of mysql databases. If you are using a similar forum or know of one then please advise me where I can find it.

Thanks in advance

HI im getting a syntax error in my MYSQL statement- im pretty sure its because the text im adding contains an apostrophre ( ) and cancels out the PHP coding- somehow. but im not that smart in the sense of figuring out how to fix the problem- heres the coding:

//If HTTP Protocol POST is invoked then store form data in local variables and UPDATE the homepage table with the values.
if(isset($_POST[ update ]))
{
$Id = $_POST[ Id ];
$title = $_POST[ title ];
$content = $_POST[ content ];
// update the article in the database
$query = "UPDATE main_page SET title = $title - content = $content ";
mysql_query($query) or die( Error : . mysql_error());
echo "Article $title updated";

}

Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near this is the north s website at line 1

I have a book that uses mysqli in all of the examples but online tutorials that I have seen use mysql (no i ). I m not sure what I should be using or what the difference is.

I thought I heard the i version is for use with a newer MySQL server- but I m really not sure.

I am looking for a free open source forum script and I would like to be able to have a "latest posts" modual on my html homepage. I have a host with php4/5 and I have plenty of mysql databases. If you are using a similar forum or know of one then please advise me where I can find it.

Thanks in advance

HI im getting a syntax error in my MYSQL statement- im pretty sure its because the text im adding contains an apostrophre ( ) and cancels out the PHP coding- somehow. but im not that smart in the sense of figuring out how to fix the problem- heres the coding:

//If HTTP Protocol POST is invoked then store form data in local variables and UPDATE the homepage table with the values.
if(isset($_POST[ update ]))
{
$Id = $_POST[ Id ];
$title = $_POST[ title ];
$content = $_POST[ content ];
// update the article in the database
$query = "UPDATE main_page SET title = $title - content = $content ";
mysql_query($query) or die( Error : . mysql_error());
echo "Article $title updated";

}

Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near this is the north s website at line 1

Hi.

I m going to build a high scale site in php/mysql that needs to scale horizontally.

What things should the developer do and not do when writing the code and creating the database?

Thanks.

I want to make a blog and I should want to add a comment box too. What I can do. I know how can I create a form. I know to crate databases and tables. but I don t know how can we store comments. Do I want to create 1 column for 1 comment? Then If there 10 comments I want to create 10 columns. but that is not possible because i want to create 1 form for 1 comment. Then where can I store the comments. Please give the answer..please....

HI im getting a syntax error in my MYSQL statement- im pretty sure its because the text im adding contains an apostrophre ( ) and cancels out the PHP coding- somehow. but im not that smart in the sense of figuring out how to fix the problem- heres the coding:

//If HTTP Protocol POST is invoked then store form data in local variables and UPDATE the homepage table with the values.
if(isset($_POST[ update ]))
{
$Id = $_POST[ Id ];
$title = $_POST[ title ];
$content = $_POST[ content ];
// update the article in the database
$query = "UPDATE main_page SET title = $title - content = $content ";
mysql_query($query) or die( Error : . mysql_error());
echo "Article $title updated";

}

Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near this is the north s website at line 1

Hi.

I m going to build a high scale site in php/mysql that needs to scale horizontally.

What things should the developer do and not do when writing the code and creating the database?

Thanks.

I want to make a blog and I should want to add a comment box too. What I can do. I know how can I create a form. I know to crate databases and tables. but I don t know how can we store comments. Do I want to create 1 column for 1 comment? Then If there 10 comments I want to create 10 columns. but that is not possible because i want to create 1 form for 1 comment. Then where can I store the comments. Please give the answer..please....

This might be a little difficult to explain but I ll try.

In MySQL I have a table like so:
id INT(3) PRIMARY KEY NOT NULL AUTO_INCREMENT-
name VARCHAR(255)-
code VARCHAR(255)-
subclass_id INT(3) NOT NULL DEFAULT=-1

So I have a bunch of records in my table like so
1- "UK"- "UK"- -1
2- "England"- "EN"- 1
3- "Wales"- "WA"- 1
4- "Scotland"- "SC"- 1
5- "ASIA"- "AS"- -1
6- "India"- "IN"- 5
7- "China"- "CN"- 5
8- "Pakistan"- "PK"- 5
9- "Afghanistan"- "AF"- 5
10- "Northern Ireland"- "NI"- 1
.. etc ..

OK- so you may have figured out how it works - the Top level categories which are like continents/kingdoms are denoted by -1 in the subclass_id meaning they are not subclassed. But countries within the continents are subclassed by the id of the continent they come from - e.g. India is in Asia (5).

Now my question is- how do I write one SQL command that will show the top level continents with the countries in them in an ordered list like so:
Continent
Country
Country
...
Continent
Country
...

how can i make a log in sytem on my website- Any easy ways. Or do i have to learn asp/mysql stuff?

Hi.

I m going to build a high scale site in php/mysql that needs to scale horizontally.

What things should the developer do and not do when writing the code and creating the database?

Thanks.

I want to make a blog and I should want to add a comment box too. What I can do. I know how can I create a form. I know to crate databases and tables. but I don t know how can we store comments. Do I want to create 1 column for 1 comment? Then If there 10 comments I want to create 10 columns. but that is not possible because i want to create 1 form for 1 comment. Then where can I store the comments. Please give the answer..please....

This might be a little difficult to explain but I ll try.

In MySQL I have a table like so:
id INT(3) PRIMARY KEY NOT NULL AUTO_INCREMENT-
name VARCHAR(255)-
code VARCHAR(255)-
subclass_id INT(3) NOT NULL DEFAULT=-1

So I have a bunch of records in my table like so
1- "UK"- "UK"- -1
2- "England"- "EN"- 1
3- "Wales"- "WA"- 1
4- "Scotland"- "SC"- 1
5- "ASIA"- "AS"- -1
6- "India"- "IN"- 5
7- "China"- "CN"- 5
8- "Pakistan"- "PK"- 5
9- "Afghanistan"- "AF"- 5
10- "Northern Ireland"- "NI"- 1
.. etc ..

OK- so you may have figured out how it works - the Top level categories which are like continents/kingdoms are denoted by -1 in the subclass_id meaning they are not subclassed. But countries within the continents are subclassed by the id of the continent they come from - e.g. India is in Asia (5).

Now my question is- how do I write one SQL command that will show the top level continents with the countries in them in an ordered list like so:
Continent
Country
Country
...
Continent
Country
...

how can i make a log in sytem on my website- Any easy ways. Or do i have to learn asp/mysql stuff?

What is the difference between mysql_fetch_object and mysql fetch_array ?

In how many ways we can retrieve the date in the result set of MYSQL using PHP ?

What is the difference between mysql_fetch_object and mysql fetch_array ?

In how many ways we can retrieve the date in the result set of MYSQL using PHP ?

In how many ways we can retrieve the data in the result set of MYSQL using PHP?

Bake -app in C:\easyphp\www\cakephp\app (y/n)
[y] > y

Baking...
---------------------------------------------------------------
Name: app
Path: C:\easyphp\www\cakephp\app
---------------------------------------------------------------
[M]odel
[C]ontroller
[V]iew

What would you like to Bake? (M/V/C)
> C
---------------------------------------------------------------
Controller Bake:
---------------------------------------------------------------

Fatal error: Call to undefined function mysql_connect() in

C:\easyphp\www\cakeph
p\cake\libs\model\dbo\dbo_mysql.php on line 100

---------
I m using window and I need help now please :(
My site is working and it s connnected to mysql. :) I want to use bake.php to generate pages automativaly (I mean- models- views and controllers ) Please help me! It seems like my bake.php cannot connect to mysql.
I need help now ....:( Help Please :(

In how many ways we can retrieve the data in the result set of MYSQL using PHP?

Bake -app in C:\easyphp\www\cakephp\app (y/n)
[y] > y

Baking...
---------------------------------------------------------------
Name: app
Path: C:\easyphp\www\cakephp\app
---------------------------------------------------------------
[M]odel
[C]ontroller
[V]iew

What would you like to Bake? (M/V/C)
> C
---------------------------------------------------------------
Controller Bake:
---------------------------------------------------------------

Fatal error: Call to undefined function mysql_connect() in

C:\easyphp\www\cakeph
p\cake\libs\model\dbo\dbo_mysql.php on line 100

---------
I m using window and I need help now please :(
My site is working and it s connnected to mysql. :) I want to use bake.php to generate pages automativaly (I mean- models- views and controllers ) Please help me! It seems like my bake.php cannot connect to mysql.
I need help now ....:( Help Please :(

I m currently stuck deciding between 2 great free hosts!
Here s the breakdown:

Host # 1:
- short subdomain (about 3 char. long)
- cPanel w/fantastico
- PHP and Perl Support
- Unlimited Sub-domains- E-mail- & MySQL Databases
- Somewhat inactive owner
- somewhat active hostees
- very slow response (I posted a question at the forum and I only got a reply from the owner 10 days later)
- not responsible for back-ups
- owner has to review apps first
- reseller at surpasshosting

HOST # 2:
- long subdomain (about 14 char. long)
- No cPanel but has Webmin control panel instead
- Unlimited space and bandwidth
- Up to 2 subdomains (more upon request) and up to 5 websites
- PHP 5.2- Ruby on Rails 1.2- MySql 5.0- phpMyAdmin- etc.
- regular offsite back-ups
- Very active owner (I sent 2 questions through email to him already and responded less than 30 minutes!)
- Somewhat inactive hostees
- very selective when it comes to hostees (But I fit)
- own server
I m not linking to the sites because I don t want to attract applications from noobs and abusers if you know what I mean...

The site I m planning to make is a personal site and portfolio/fanlisting collective. I might buy a domain name and my own hosting account next year when I get my online payment stuff set-up. But for now- free-hosting will do.

What do you guys think? Any opinion is much appreciated.

i have create a php to connect to my database- the php will display people salary and i want to add a total in below to count all the people s salary. How can i do that?

In how many ways we can retrieve the data in the result set of MYSQL using PHP?

Bake -app in C:\easyphp\www\cakephp\app (y/n)
[y] > y

Baking...
---------------------------------------------------------------
Name: app
Path: C:\easyphp\www\cakephp\app
---------------------------------------------------------------
[M]odel
[C]ontroller
[V]iew

What would you like to Bake? (M/V/C)
> C
---------------------------------------------------------------
Controller Bake:
---------------------------------------------------------------

Fatal error: Call to undefined function mysql_connect() in

C:\easyphp\www\cakeph
p\cake\libs\model\dbo\dbo_mysql.php on line 100

---------
I m using window and I need help now please :(
My site is working and it s connnected to mysql. :) I want to use bake.php to generate pages automativaly (I mean- models- views and controllers ) Please help me! It seems like my bake.php cannot connect to mysql.
I need help now ....:( Help Please :(

I m currently stuck deciding between 2 great free hosts!
Here s the breakdown:

Host # 1:
- short subdomain (about 3 char. long)
- cPanel w/fantastico
- PHP and Perl Support
- Unlimited Sub-domains- E-mail- & MySQL Databases
- Somewhat inactive owner
- somewhat active hostees
- very slow response (I posted a question at the forum and I only got a reply from the owner 10 days later)
- not responsible for back-ups
- owner has to review apps first
- reseller at surpasshosting

HOST # 2:
- long subdomain (about 14 char. long)
- No cPanel but has Webmin control panel instead
- Unlimited space and bandwidth
- Up to 2 subdomains (more upon request) and up to 5 websites
- PHP 5.2- Ruby on Rails 1.2- MySql 5.0- phpMyAdmin- etc.
- regular offsite back-ups
- Very active owner (I sent 2 questions through email to him already and responded less than 30 minutes!)
- Somewhat inactive hostees
- very selective when it comes to hostees (But I fit)
- own server
I m not linking to the sites because I don t want to attract applications from noobs and abusers if you know what I mean...

The site I m planning to make is a personal site and portfolio/fanlisting collective. I might buy a domain name and my own hosting account next year when I get my online payment stuff set-up. But for now- free-hosting will do.

What do you guys think? Any opinion is much appreciated.

i have create a php to connect to my database- the php will display people salary and i want to add a total in below to count all the people s salary. How can i do that?

I would prefer a free site for now so I can experiment before committing. I am designing a site with a forum.
It has to support PHP and Mysql though. I did post a similar question earlier but it did not include PHP and Mysql.

Thanks

Bake -app in C:\easyphp\www\cakephp\app (y/n)
[y] > y

Baking...
---------------------------------------------------------------
Name: app
Path: C:\easyphp\www\cakephp\app
---------------------------------------------------------------
[M]odel
[C]ontroller
[V]iew

What would you like to Bake? (M/V/C)
> C
---------------------------------------------------------------
Controller Bake:
---------------------------------------------------------------

Fatal error: Call to undefined function mysql_connect() in

C:\easyphp\www\cakeph
p\cake\libs\model\dbo\dbo_mysql.php on line 100

---------
I m using window and I need help now please :(
My site is working and it s connnected to mysql. :) I want to use bake.php to generate pages automativaly (I mean- models- views and controllers ) Please help me! It seems like my bake.php cannot connect to mysql.
I need help now ....:( Help Please :(

I m currently stuck deciding between 2 great free hosts!
Here s the breakdown:

Host # 1:
- short subdomain (about 3 char. long)
- cPanel w/fantastico
- PHP and Perl Support
- Unlimited Sub-domains- E-mail- & MySQL Databases
- Somewhat inactive owner
- somewhat active hostees
- very slow response (I posted a question at the forum and I only got a reply from the owner 10 days later)
- not responsible for back-ups
- owner has to review apps first
- reseller at surpasshosting

HOST # 2:
- long subdomain (about 14 char. long)
- No cPanel but has Webmin control panel instead
- Unlimited space and bandwidth
- Up to 2 subdomains (more upon request) and up to 5 websites
- PHP 5.2- Ruby on Rails 1.2- MySql 5.0- phpMyAdmin- etc.
- regular offsite back-ups
- Very active owner (I sent 2 questions through email to him already and responded less than 30 minutes!)
- Somewhat inactive hostees
- very selective when it comes to hostees (But I fit)
- own server
I m not linking to the sites because I don t want to attract applications from noobs and abusers if you know what I mean...

The site I m planning to make is a personal site and portfolio/fanlisting collective. I might buy a domain name and my own hosting account next year when I get my online payment stuff set-up. But for now- free-hosting will do.

What do you guys think? Any opinion is much appreciated.

i have create a php to connect to my database- the php will display people salary and i want to add a total in below to count all the people s salary. How can i do that?

I would prefer a free site for now so I can experiment before committing. I am designing a site with a forum.
It has to support PHP and Mysql though. I did post a similar question earlier but it did not include PHP and Mysql.

Thanks

its connecting to the database all fine- but its not displaying anything in the database is there something wrong:

my fields are Id- and content

$query = "SELECT Id- content FROM main_page ORDER BY Id";
$result = mysql_query($query) or die( Error : . mysql_error());

while($row = mysql_fetch_array($result- MYSQL_NUM))
{
list($Id- $title) = $row;
$content .= "<li><a href=\"$self?Id=$Id\">$title</a></li>\r\n";
}

<?php

database connection coding:

$username = "root";
$password = "";
$hostname = "localhost";

$con = mysql_connect($hostname-$username-$password) or die ("Unable to connect");

$dbname = banknorth ;
mysql_select_db($dbname);
?>

help!! haha i dont have an error to go by its just not displaying anything

Bake -app in C:\easyphp\www\cakephp\app (y/n)
[y] > y

Baking...
---------------------------------------------------------------
Name: app
Path: C:\easyphp\www\cakephp\app
---------------------------------------------------------------
[M]odel
[C]ontroller
[V]iew

What would you like to Bake? (M/V/C)
> C
---------------------------------------------------------------
Controller Bake:
---------------------------------------------------------------

Fatal error: Call to undefined function mysql_connect() in

C:\easyphp\www\cakeph
p\cake\libs\model\dbo\dbo_mysql.php on line 100

---------
I m using window and I need help now please :(
My site is working and it s connnected to mysql. :) I want to use bake.php to generate pages automativaly (I mean- models- views and controllers ) Please help me! It seems like my bake.php cannot connect to mysql.
I need help now ....:( Help Please :(

I m currently stuck deciding between 2 great free hosts!
Here s the breakdown:

Host # 1:
- short subdomain (about 3 char. long)
- cPanel w/fantastico
- PHP and Perl Support
- Unlimited Sub-domains- E-mail- & MySQL Databases
- Somewhat inactive owner
- somewhat active hostees
- very slow response (I posted a question at the forum and I only got a reply from the owner 10 days later)
- not responsible for back-ups
- owner has to review apps first
- reseller at surpasshosting

HOST # 2:
- long subdomain (about 14 char. long)
- No cPanel but has Webmin control panel instead
- Unlimited space and bandwidth
- Up to 2 subdomains (more upon request) and up to 5 websites
- PHP 5.2- Ruby on Rails 1.2- MySql 5.0- phpMyAdmin- etc.
- regular offsite back-ups
- Very active owner (I sent 2 questions through email to him already and responded less than 30 minutes!)
- Somewhat inactive hostees
- very selective when it comes to hostees (But I fit)
- own server
I m not linking to the sites because I don t want to attract applications from noobs and abusers if you know what I mean...

The site I m planning to make is a personal site and portfolio/fanlisting collective. I might buy a domain name and my own hosting account next year when I get my online payment stuff set-up. But for now- free-hosting will do.

What do you guys think? Any opinion is much appreciated.

i have create a php to connect to my database- the php will display people salary and i want to add a total in below to count all the people s salary. How can i do that?

I would prefer a free site for now so I can experiment before committing. I am designing a site with a forum.
It has to support PHP and Mysql though. I did post a similar question earlier but it did not include PHP and Mysql.

Thanks

its connecting to the database all fine- but its not displaying anything in the database is there something wrong:

my fields are Id- and content

$query = "SELECT Id- content FROM main_page ORDER BY Id";
$result = mysql_query($query) or die( Error : . mysql_error());

while($row = mysql_fetch_array($result- MYSQL_NUM))
{
list($Id- $title) = $row;
$content .= "<li><a href=\"$self?Id=$Id\">$title</a></li>\r\n";
}

<?php

database connection coding:

$username = "root";
$password = "";
$hostname = "localhost";

$con = mysql_connect($hostname-$username-$password) or die ("Unable to connect");

$dbname = banknorth ;
mysql_select_db($dbname);
?>

help!! haha i dont have an error to go by its just not displaying anything

Bake -app in C:\easyphp\www\cakephp\app (y/n)
[y] > y

Baking...
---------------------------------------------------------------
Name: app
Path: C:\easyphp\www\cakephp\app
---------------------------------------------------------------
[M]odel
[C]ontroller
[V]iew

What would you like to Bake? (M/V/C)
> C
---------------------------------------------------------------
Controller Bake:
---------------------------------------------------------------

Fatal error: Call to undefined function mysql_connect() in

C:\easyphp\www\cakeph
p\cake\libs\model\dbo\dbo_mysql.php on line 100

---------
I m using window and I need help now please :(
My site is working and it s connnected to mysql. :) I want to use bake.php to generate pages automativaly (I mean- models- views and controllers ) Please help me! It seems like my bake.php cannot connect to mysql.
I need help now ....:( Help Please :(

I m currently stuck deciding between 2 great free hosts!
Here s the breakdown:

Host # 1:
- short subdomain (about 3 char. long)
- cPanel w/fantastico
- PHP and Perl Support
- Unlimited Sub-domains- E-mail- & MySQL Databases
- Somewhat inactive owner
- somewhat active hostees
- very slow response (I posted a question at the forum and I only got a reply from the owner 10 days later)
- not responsible for back-ups
- owner has to review apps first
- reseller at surpasshosting

HOST # 2:
- long subdomain (about 14 char. long)
- No cPanel but has Webmin control panel instead
- Unlimited space and bandwidth
- Up to 2 subdomains (more upon request) and up to 5 websites
- PHP 5.2- Ruby on Rails 1.2- MySql 5.0- phpMyAdmin- etc.
- regular offsite back-ups
- Very active owner (I sent 2 questions through email to him already and responded less than 30 minutes!)
- Somewhat inactive hostees
- very selective when it comes to hostees (But I fit)
- own server
I m not linking to the sites because I don t want to attract applications from noobs and abusers if you know what I mean...

The site I m planning to make is a personal site and portfolio/fanlisting collective. I might buy a domain name and my own hosting account next year when I get my online payment stuff set-up. But for now- free-hosting will do.

What do you guys think? Any opinion is much appreciated.

i have create a php to connect to my database- the php will display people salary and i want to add a total in below to count all the people s salary. How can i do that?

I would prefer a free site for now so I can experiment before committing. I am designing a site with a forum.
It has to support PHP and Mysql though. I did post a similar question earlier but it did not include PHP and Mysql.

Thanks

its connecting to the database all fine- but its not displaying anything in the database is there something wrong:

my fields are Id- and content

$query = "SELECT Id- content FROM main_page ORDER BY Id";
$result = mysql_query($query) or die( Error : . mysql_error());

while($row = mysql_fetch_array($result- MYSQL_NUM))
{
list($Id- $title) = $row;
$content .= "<li><a href=\"$self?Id=$Id\">$title</a></li>\r\n";
}

<?php

database connection coding:

$username = "root";
$password = "";
$hostname = "localhost";

$con = mysql_connect($hostname-$username-$password) or die ("Unable to connect");

$dbname = banknorth ;
mysql_select_db($dbname);
?>

help!! haha i dont have an error to go by its just not displaying anything

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax

I would prefer a free site for now so I can experiment before committing. I am designing a site with a forum.
It has to support PHP and Mysql though. I did post a similar question earlier but it did not include PHP and Mysql.

Thanks

its connecting to the database all fine- but its not displaying anything in the database is there something wrong:

my fields are Id- and content

$query = "SELECT Id- content FROM main_page ORDER BY Id";
$result = mysql_query($query) or die( Error : . mysql_error());

while($row = mysql_fetch_array($result- MYSQL_NUM))
{
list($Id- $title) = $row;
$content .= "<li><a href=\"$self?Id=$Id\">$title</a></li>\r\n";
}

<?php

database connection coding:

$username = "root";
$password = "";
$hostname = "localhost";

$con = mysql_connect($hostname-$username-$password) or die ("Unable to connect");

$dbname = banknorth ;
mysql_select_db($dbname);
?>

help!! haha i dont have an error to go by its just not displaying anything

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax

I want to develop an interactive website. Please let me know which language should I choose?

The server is responding to ping. But- I am seeing the http and mysql services down on outside monitoring (nagios). The last couple lines on the console say:

free swap: 0kb
total swap:491512kb

I m wanting to know what I should do besides resetting the server. Thanks.

hi...i configured IIS to work with php and it works fine...but some scripts in apache (wamp) didnt give any error..are now showing errors in the new configuration..and when i use the function mysql_connect it says : undefined function...i used this tutorial to setup php with IIS :

http://news.softpedia.com/news/How-to-install-PHP-on-IIS-63075.shtml

thanks alot...

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax

I want to develop an interactive website. Please let me know which language should I choose?

The server is responding to ping. But- I am seeing the http and mysql services down on outside monitoring (nagios). The last couple lines on the console say:

free swap: 0kb
total swap:491512kb

I m wanting to know what I should do besides resetting the server. Thanks.

hi...i configured IIS to work with php and it works fine...but some scripts in apache (wamp) didnt give any error..are now showing errors in the new configuration..and when i use the function mysql_connect it says : undefined function...i used this tutorial to setup php with IIS :

http://news.softpedia.com/news/How-to-install-PHP-on-IIS-63075.shtml

thanks alot...

What freeweb host with php/mysql hosting to host PHP motion?
bcuz i dont know where?my PHP motion in other freeweb hosting is not working saying>extension_dir does not exists /usr/lib/php/1020050626/
and another freewebhost>
Warning: dl() has been disabled for security reasons in /www/110mb.com/t/h/e/u/s/... on line 2
PHP script /www/110mb.com/t/h/e/u/s/... is protected by phpSHIELD and requires the phpSHIELD loader phpshield.5.1.lin. The phpSHIELD loader has not been installed- or is not installed correctly. Please visit the phpSHIELD php encoder site to download required loader.

please tell me where to free host my PHP Motion 100% WORKING . thx--iAnOdiN

What freeweb host with php/mysql hosting to host PHP motion?
bcuz i dont know where?my PHP motion in other freeweb hosting is not working saying>extension_dir does not exists /usr/lib/php/1020050626/
and another freewebhost>
Warning: dl() has been disabled for security reasons in /www/110mb.com/t/h/e/u/s/e/d/n/theusednetwork/htdocs/classes/config.php on line 2
PHP script /www/110mb.com/t/h/e/u/s/e/d/n/theusednetwork/htdocs/classes/config.php is protected by phpSHIELD and requires the phpSHIELD loader phpshield.5.1.lin. The phpSHIELD loader has not been installed- or is not installed correctly. Please visit the phpSHIELD php encoder site to download required loader.

please tell me where to free host my PHP Motion 100% WORKING . thx--iAnOdiN

The server is responding to ping. But- I am seeing the http and mysql services down on outside monitoring (nagios). The last couple lines on the console say:

free swap: 0kb
total swap:491512kb

I m wanting to know what I should do besides resetting the server. Thanks.

hi...i configured IIS to work with php and it works fine...but some scripts in apache (wamp) didnt give any error..are now showing errors in the new configuration..and when i use the function mysql_connect it says : undefined function...i used this tutorial to setup php with IIS :

http://news.softpedia.com/news/How-to-install-PHP-on-IIS-63075.shtml

thanks alot...

What freeweb host with php/mysql hosting to host PHP motion?
bcuz i dont know where?my PHP motion in other freeweb hosting is not working saying>extension_dir does not exists /usr/lib/php/1020050626/
and another freewebhost>
Warning: dl() has been disabled for security reasons in /www/110mb.com/t/h/e/u/s/... on line 2
PHP script /www/110mb.com/t/h/e/u/s/... is protected by phpSHIELD and requires the phpSHIELD loader phpshield.5.1.lin. The phpSHIELD loader has not been installed- or is not installed correctly. Please visit the phpSHIELD php encoder site to download required loader.

please tell me where to free host my PHP Motion 100% WORKING . thx--iAnOdiN

What freeweb host with php/mysql hosting to host PHP motion?
bcuz i dont know where?my PHP motion in other freeweb hosting is not working saying>extension_dir does not exists /usr/lib/php/1020050626/
and another freewebhost>
Warning: dl() has been disabled for security reasons in /www/110mb.com/t/h/e/u/s/e/d/n/theusednetwork/htdocs/classes/config.php on line 2
PHP script /www/110mb.com/t/h/e/u/s/e/d/n/theusednetwork/htdocs/classes/config.php is protected by phpSHIELD and requires the phpSHIELD loader phpshield.5.1.lin. The phpSHIELD loader has not been installed- or is not installed correctly. Please visit the phpSHIELD php encoder site to download required loader.

please tell me where to free host my PHP Motion 100% WORKING . thx--iAnOdiN

I have no clue.
Can I have an explanation along with the source- I need some guidance. I honestly am completely in the dark here.

I have Fedora 9 on this computer with the latest Apache + PHP + MySQL packages. I m also using a Netgear WPN824 v2 router (the computer is plugged into it via ethernet).

Now for some retarded reason- it all works wonderfully within our network- but outside of it (aka the actual internet)- typing the IP address does not work.

The machine with Apache is assigned 192.168.1.2. No matter how many times I have changed the port forwarding in the router settings + changed the Listening in httpd.cont it won t for some reason work. I have tried with port 80- port 85- and port 1111- and still nothing.

I have also disabled the firewall on the computer.

NOTHING WILL WORK!!!

Is there anybody kind enough to help me with a solution? :)
Oh and one more thing: yes I have been restarting Apache via "sudo apachectl graceful".
Adam M:
I actually now have:

Listen 80
Listen 85

I have no clue.
Can I have an explanation along with the source- I need some guidance. I honestly am completely in the dark here.

I have Fedora 9 on this computer with the latest Apache + PHP + MySQL packages. I m also using a Netgear WPN824 v2 router (the computer is plugged into it via ethernet).

Now for some retarded reason- it all works wonderfully within our network- but outside of it (aka the actual internet)- typing the IP address does not work.

The machine with Apache is assigned 192.168.1.2. No matter how many times I have changed the port forwarding in the router settings + changed the Listening in httpd.cont it won t for some reason work. I have tried with port 80- port 85- and port 1111- and still nothing.

I have also disabled the firewall on the computer.

NOTHING WILL WORK!!!

Is there anybody kind enough to help me with a solution? :)
Oh and one more thing: yes I have been restarting Apache via "sudo apachectl graceful".
Adam M:
I actually now have:

Listen 80
Listen 85

Like paging..
I want to sort Mysql tables and echo the results in for eg 5 columns per row.
And there should be 5 rows in a table .
Any idea how can i get it done using PHP ?

__________
I want 5 columns in a row having different sorted data through mysql querry and 5 such rows in a table..
Thanks-
Vaibhav
My email id :
dashing.vaibhav@gmail.com
Please post your answers there if you cant write the whole code here..

Hi ! I m kinda lost in my career orientation. I m actually a university student in programmation. I m good in Java- I know a bit of C- C++ and Python. I want to make the move to web programming and I serioulsy don t know where to start.

Python- Rails- ASP I seriously don t know what to learn first. I made the switch to Linux so I don t think I will be developping .NET applications. I know a bit of HTML- XML and CSS. For the database part I know Oracle and a bit of MySQL.

The main fact is that I m no expert in any language. I know how to do small things in each of them but that s it. Is that normal ?? I mean I went to college in computer science and did one year at university and I still consider myself as a beginner programmer... Never made an exe. :P

So here s my questions :
- Do I need to be an expert in XHTML and CSS to make web applications ?
- Where should I start ? I think Ruby on Rails is a great thing to start with...

Hi All- I have a site which has the Database size about 8 MB. I need a free MySQL server which allows me to host a database more than 10 MB.

I would like to learn the core of AJAX with PHP and
MySQL intergration.

Like paging..
I want to sort Mysql tables and echo the results in for eg 5 columns per row.
And there should be 5 rows in a table .
Any idea how can i get it done using PHP ?

__________
I want 5 columns in a row having different sorted data through mysql querry and 5 such rows in a table..
Thanks-
Vaibhav
My email id :
dashing.vaibhav@gmail.com
Please post your answers there if you cant write the whole code here..

Hi ! I m kinda lost in my career orientation. I m actually a university student in programmation. I m good in Java- I know a bit of C- C++ and Python. I want to make the move to web programming and I serioulsy don t know where to start.

Python- Rails- ASP I seriously don t know what to learn first. I made the switch to Linux so I don t think I will be developping .NET applications. I know a bit of HTML- XML and CSS. For the database part I know Oracle and a bit of MySQL.

The main fact is that I m no expert in any language. I know how to do small things in each of them but that s it. Is that normal ?? I mean I went to college in computer science and did one year at university and I still consider myself as a beginner programmer... Never made an exe. :P

So here s my questions :
- Do I need to be an expert in XHTML and CSS to make web applications ?
- Where should I start ? I think Ruby on Rails is a great thing to start with...

Hi All- I have a site which has the Database size about 8 MB. I need a free MySQL server which allows me to host a database more than 10 MB.

I would like to learn the core of AJAX with PHP and
MySQL intergration.

Let say productID is a primary key and running number when we enter new data. How to get 1 as three digits like 001?

I have mysql installed in my system.I want to use it in php script. to store some html form inputs.