• Starting today August 7th, 2024, in order to post in the Married Couples, Courting Couples, or Singles forums, you will not be allowed to post if you have your Marital status designated as private. Announcements will be made in the respective forums as well but please note that if yours is currently listed as Private, you will need to submit a ticket in the Support Area to have yours changed.

  • CF has always been a site that welcomes people from different backgrounds and beliefs to participate in discussion and even debate. That is the nature of its ministry. In view of recent events emotions are running very high. We need to remind people of some basic principles in debating on this site. We need to be civil when we express differences in opinion. No personal attacks. Avoid you, your statements. Don't characterize an entire political party with comparisons to Fascism or Communism or other extreme movements that committed atrocities. CF is not the place for broad brush or blanket statements about groups and political parties. Put the broad brushes and blankets away when you come to CF, better yet, put them in the incinerator. Debate had no place for them. We need to remember that people that commit acts of violence represent themselves or a small extreme faction.

  • We hope the site problems here are now solved, however, if you still have any issues, please start a ticket in Contact Us

  • The rule regarding AI content has been updated. The rule now rules as follows:

    Be sure to credit AI when copying and pasting AI sources. Link to the site of the AI search, just like linking to an article.

MySQL

Jump to latest Follow Reply
Sort by date Sort by votes
Pete Harcoff

Pete Harcoff

PeteAce - In memory of WinAce
Jun 30, 2002
8,304
72
✟9,884.00
Faith
Other Religion
You mean you need the code to connect to the database as well?

Here is what I generally use (note: I pieced this together from a few different functions, so hopefully it should be okay):

Code: 
$dblink = mysql_pconnect("hostname","username","password");
if ( !$dblink ) { 
   echo("ERROR: " . mysql_error() . "\n");			
}
else {
   $SQL = "SQL code goes here...";
   $query_result = mysql_db_query("database name", $SQL, $dblink);
   if ( !$query_result ) { 
      echo(mysql_error());
   }
   else {
      echo("Yay, it worked!");
   }
}
 
Upvote 0
jono1

jono1

Smart Simplicity
Oct 5, 2003
402
4
38
canberra
Visit site
✟557.00
Faith
Christian
Marital Status
Single
Politics
AU-Liberals
thanks for that pete..i think it's gotten in. problem is now it gives me this
You have an error in your SQL syntax near '; ALTER TABLE phpbb_users ADD COLUMN user_showsignatures tinyint(1) default '1' at line 1

this is the code i was given
ALTER TABLE phpbb_users ADD COLUMN user_showavatars tinyint(1) default '1';
ALTER TABLE phpbb_users ADD COLUMN user_showsignatures tinyint(1) default '1';

can you see where the problem is?
 
Upvote 0
jono1

jono1

Smart Simplicity
Oct 5, 2003
402
4
38
canberra
Visit site
✟557.00
Faith
Christian
Marital Status
Single
Politics
AU-Liberals
a friend gave me this apparenly you can't have two alter tables in the same command....still doesn't work tho...
PHP: 
<html>
<body>
<?php
$dblink = mysql_pconnect(localhost,"(user)","(password)");
if ( !$dblink ) { 
echo("ERROR: " . mysql_error() . "\n"); 
}
else {
$SQL = "ALTER TABLE phpbb_users ADD COLUMN 'user_showavatars' tinyint(1) default '1'";
$SQL2 = "ALTER TABLE phpbb_users ADD COLUMN 'user_showsignatures' tinyint(1) default '1'";
$result = mysql_query($SQL) or die(mysql_error());
$result2 = mysql_query($SQL2) or die(mysql_error());

echo("Yay, it worked!");
}
?>
</body>
</html>
 
Upvote 0
jono1

jono1

Smart Simplicity
Oct 5, 2003
402
4
38
canberra
Visit site
✟557.00
Faith
Christian
Marital Status
Single
Politics
AU-Liberals
oo, there's a mod that can do that??
then again it was a mod that was the cause of all this....kinda....i installed the mod with EasyMOD and that all worked but of course easymod doesn't do the SQL queries yet so that didn't get done and so now viewtopic.php looks for a field in the database that isn't there and gets confused and i haven't used a full stop in quite a while......
 
Upvote 0

Similar threads

Michie
Don Lemon likens church storming to Jesus cleansing temple, calls churchgoers 'entitled'
Replies
11
Views
596
Current News & Events (Articles Required)
Tuur
Tuur
Michie
They graduated from Stanford. Due to AI, they can't find a job
Replies
4
Views
378
Current News & Events (Articles Required)
mindlight
mindlight
Minister Monardo
If Seven Is A Number Of Perfection, Is Seven Demons A Perfection Of Evil?
Replies
0
Views
167
General Theology
Minister Monardo
Minister Monardo
Belonging to Abba
Cell phone service on Galaxy Watch not working, and Spectrum Mobile taking a long time to address it.
Replies
0
Views
1K
Technology
Belonging to Abba
Belonging to Abba
Michie
Eastern Orthodoxy Under Fire: Responding to Michael W. Davis
Replies
0
Views
141
One Bread, One Body - Catholic
Michie
Michie
Top Bottom
Jump to latest Follow Reply
Jump to latest Follow Reply