Lost Password?

Go Back   CodeCall Programming Forum > Web Development Forum > PHP Forum
Reload this Page query wont insert?
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

PHP Forum Use this forum to discuss all aspects of PHP Development. PHP is a server-side, cross-platform, HTML embedded scripting language that lets you create dynamic web pages.

Reply
Page 2 of 2 < 1 2
 
LinkBack Thread Tools Search this Thread Display Modes
  #11 (permalink)  
Old 05-02-2008, 09:59 PM
phpforfun's Avatar   
phpforfun phpforfun is offline
Programming God
  
Join Date: Feb 2008
Posts: 541
Last Blog:
ubuntu... do not upgra...
Rep Power: 5
phpforfun will become famous soon enough
Default Re: query wont insert?
yes sir!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #12 (permalink)  
Old 05-03-2008, 02:10 AM
John's Avatar   
John John is offline
Co-Administrator
  
Join Date: Jul 2006
Age: 19
Posts: 2,364
Last Blog:
PHPUnit
Rep Power: 50
John is a glorious beacon of lightJohn is a glorious beacon of lightJohn is a glorious beacon of lightJohn is a glorious beacon of lightJohn is a glorious beacon of light
Send a message via AIM to John
Default Re: query wont insert?
Well you no longer receive a mysql error (you had three errors), and parts of the hosts profile update. Not sure why the Profile Content bit doesn't update...

Also "loggedin" (when you log in) is spelled wrong.
__________________
CodeCall Blog | CodeCall Wiki | Shareware | Linux Forum | My Blog
Chat with other CodeCall members on IRC; connect to irc.codecall.net and join #codecall
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #13 (permalink)  
Old 05-03-2008, 02:52 AM
phpforfun's Avatar   
phpforfun phpforfun is offline
Programming God
  
Join Date: Feb 2008
Posts: 541
Last Blog:
ubuntu... do not upgra...
Rep Power: 5
phpforfun will become famous soon enough
Default Re: query wont insert?
Quote:
Originally Posted by John View Post
Well you no longer receive a mysql error (you had three errors), and parts of the hosts profile update. Not sure why the Profile Content bit doesn't update...

Also "loggedin" (when you log in) is spelled wrong.
lol, all in the trial stage, will fix when sober

what did you change
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #14 (permalink)  
Old 05-03-2008, 12:58 PM
John's Avatar   
John John is offline
Co-Administrator
  
Join Date: Jul 2006
Age: 19
Posts: 2,364
Last Blog:
PHPUnit
Rep Power: 50
John is a glorious beacon of lightJohn is a glorious beacon of lightJohn is a glorious beacon of lightJohn is a glorious beacon of lightJohn is a glorious beacon of light
Send a message via AIM to John
Default Re: query wont insert?
1) mysql_error() does not expect an argument [Jordan's fault]
PHP Code:
mysql_error($connection) 
After removing $connection, I was then able to see an error:

2) You had an extra comma before WHERE
PHP Code:
lastupdated='$date', WHERE 
I was confident that would fix the problem, but it didn't...

3) So I just but backticks around all your table id's and spaced them properly and it worked....
__________________
CodeCall Blog | CodeCall Wiki | Shareware | Linux Forum | My Blog
Chat with other CodeCall members on IRC; connect to irc.codecall.net and join #codecall
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #15 (permalink)  
Old 05-03-2008, 01:12 PM
phpforfun's Avatar   
phpforfun phpforfun is offline
Programming God
  
Join Date: Feb 2008
Posts: 541
Last Blog:
ubuntu... do not upgra...
Rep Power: 5
phpforfun will become famous soon enough
Default Re: query wont insert?
Quote:
Originally Posted by John View Post
Well you no longer receive a mysql error (you had three errors), and parts of the hosts profile update. Not sure why the Profile Content bit doesn't update...

Also "loggedin" (when you log in) is spelled wrong.
Yeah, that has something to do with the RTE, ill work on that
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

Sponsored Links
  #16 (permalink)  
Old 05-05-2008, 07:26 AM
Jordan's Avatar   
Jordan Jordan is offline
Administrator
  
Join Date: Nov 2005
Location: Hendersonville, NC
Age: 25
Posts: 4,565
Last Blog:
PHP: list()
Rep Power: 50
Jordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud of
Send a message via ICQ to Jordan Send a message via AIM to Jordan Send a message via MSN to Jordan
Default Re: query wont insert?
Quote:
Originally Posted by John View Post
1) mysql_error() does not expect an argument [Jordan's fault]
PHP Code:
mysql_error($connection) 
After removing $connection, I was then able to see an error:
The argument is optional and should be the MySQL resource Link ID:

PHP Code:
string mysql_error     ([ resource $link_identifier   ] ) 
PHP: mysql_error - Manual
__________________
CodeCall Blog | CodeCall Wiki | Shareware Site | Linux Forum | Write a Blog
Don't hesitate to ask any questions that you have! Check out our ASCII Calculator!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #17 (permalink)  
Old 05-05-2008, 12:24 PM
phpforfun's Avatar   
phpforfun phpforfun is offline
Programming God
  
Join Date: Feb 2008
Posts: 541
Last Blog:
ubuntu... do not upgra...
Rep Power: 5
phpforfun will become famous soon enough
Default Re: query wont insert?
I got it all fixed, Jordan and John, you guys should go to my site and look at the RTE/WYSIWUG, its the best ive ever seen.

actually I have the "simple" version, you should google it incase you ever need it, its called tinymce
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #18 (permalink)  
Old 05-05-2008, 12:27 PM
Jordan's Avatar   
Jordan Jordan is offline
Administrator
  
Join Date: Nov 2005
Location: Hendersonville, NC
Age: 25
Posts: 4,565
Last Blog:
PHP: list()
Rep Power: 50
Jordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud of
Send a message via ICQ to Jordan Send a message via AIM to Jordan Send a message via MSN to Jordan
Default Re: query wont insert?
I've used it before. tinymce is part of Joomla!
__________________
CodeCall Blog | CodeCall Wiki | Shareware Site | Linux Forum | Write a Blog
Don't hesitate to ask any questions that you have! Check out our ASCII Calculator!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #19 (permalink)  
Old 05-05-2008, 12:45 PM
phpforfun's Avatar   
phpforfun phpforfun is offline
Programming God
  
Join Date: Feb 2008
Posts: 541
Last Blog:
ubuntu... do not upgra...
Rep Power: 5
phpforfun will become famous soon enough
Default Re: query wont insert?
Mayyyybbbeee.. when I said "can you think of a better text editor, this one sucks, its ugly", you could have said "YEAH! Tinymce! Its part of joomla!" as opposed to "nope"

lol
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #20 (permalink)  
Old 05-06-2008, 06:48 AM
Jordan's Avatar   
Jordan Jordan is offline
Administrator
  
Join Date: Nov 2005
Location: Hendersonville, NC
Age: 25
Posts: 4,565
Last Blog:
PHP: list()
Rep Power: 50
Jordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud ofJordan has much to be proud of
Send a message via ICQ to Jordan Send a message via AIM to Jordan Send a message via MSN to Jordan
Default Re: query wont insert?
The text editor you had was better, IMO. I hate TinyMCE. If you view/change the HTML source code and hit submit it wraps paragraph tags around everything.
__________________
CodeCall Blog | CodeCall Wiki | Shareware Site | Linux Forum | Write a Blog
Don't hesitate to ask any questions that you have! Check out our ASCII Calculator!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

Sponsored Links
Reply
Page 2 of 2 < 1 2

« Previous Thread | Next Thread »


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL insert and update Caspersky12 Database & Database Programming 1 02-21-2008 02:09 PM
insert values in listbox from database table yasinirshad Visual Basic Programming 1 11-20-2007 10:45 AM
Whats wrong with my query!!! Saint Database & Database Programming 2 10-22-2006 06:09 PM
Sudoku can be solved using SQL..Take a look! roger Database & Database Programming 5 07-04-2006 02:20 PM
Fast insert solution on PostgreSQL roger Database & Database Programming 0 05-11-2006 10:37 PM


All times are GMT -5. The time now is 01:32 AM.

Contact Us - Programming Forum - Archive - Top

CodeCall

Contest Stats

dargueta ........ 93.00000
John ........ 87.50000
Xav ........ 70.00000
MeTh0Dz ........ 20.00000
gaylo565 ........ 18.00000
Johnnyboy ........ 3.00000

Contest Rules

Sponsors

Linux Forums
Electronic Music

Ads