The Shed is going Social! Join us on FaceBook and Twitter and chime in on the conversation.
|
 |
|
Dev Shed Forums
> Programming Languages
> PHP Development
|
mysql_query stuff
Discuss mysql_query stuff in the PHP Development forum on Dev Shed. mysql_query stuff PHP Development forum discussing coding practices, tips on PHP, and other PHP-related topics. PHP is an open source scripting language that has taken the web development industry by storm.
|
|
 |
|
|
|
|

Dev Shed Forums Sponsor:
|
|
|

May 15th, 2000, 10:59 AM
|
|
Junior Member
|
|
Join Date: Feb 2000
Location: NY, NY,USA
Posts: 18
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Here are a couple of lines of code, the top "if" clause is executing, but the mysql_query insert isn't working, but the bottom will work with no problems. The if's are checking to see how many images were uploaded on the previous form. Any ideas what the problem might be?
if ((ereg("none", $image1) != 1) && (ereg("none", $image2) != 1) && (ereg("none", $image3) == 1)){
mysql_query ("insert into case_studies (project_id,abstract,blurb,logo,screen_capture1,site_url,logo_yellow,related1,related2,related3,rela ted4,related5) values ('$proj_id','$abstract','$blurb','$newlogo','$newimage2','$site_url','$newlogoyellow','$related1','$ related2','$related3','$related4','$related5')");
print "2"; //to check to make sure this is executing
}
if ((ereg("none", $image1) != 1) && (ereg("none", $image2) == 1) && (ereg("none", $image3) == 1)){
mysql_query ("insert into case_studies (project_id,abstract,blurb,logo,screen_capture1,site_url,logo_yellow,related1,related2,related3,rela ted4,related5) values ('$proj_id','$abstract','$blurb','$newlogo','$newimage2','$site_url','$newlogoyellow','$related1','$ related2','$related3','$related4','$related5')");
print "1"; //to check to make sure this is executing
}
|

May 15th, 2000, 05:34 PM
|
|
Apprentice Deity
|
|
Join Date: Jul 1999
Location: Niagara Falls (On the wrong side of the gorge)
Posts: 3,237

Time spent in forums: 4 m 8 sec
Reputation Power: 17
|
|
I don't see anything wrong but then again looking at someone else's code makes me cross-eyed
add:
print mysql_error();
after each query to see what the problem is. This will print the error that mysql is returning as there must be something it doesn't like about the query if the "2" is printing and it isn't inserting.
|

May 16th, 2000, 12:13 AM
|
|
Contributing User
|
|
Join Date: May 2000
Posts: 36
Time spent in forums: < 1 sec
Reputation Power: 14
|
|
|
seing only the snipet and none of the db might I suggest make sure the db is conected by calling up a record and print it. if you have not done so.
|
Developer Shed Advertisers and Affiliates
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
Rate This Thread |
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
HTML code is Off
|
|
|
|
|