just wondering if someone can look over this for me, for some reason im getting an error saying
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /removed url on line 23
Line 23 consists of
while($row = mysql_fetch_array($sql)){
Im at a wits end, maybe ive been looking at it too long.
as always greatful for any help.
cheers
<?php
session_start();
include 'db.php';
include'header.php';
$e_username=$_GET['o_name'];
$e_email=$_GET['o_email'];
// check if the user info validates the db
$sql = mysql_query("SELECT * FROM employees WHERE e_username='$e_username' AND e_email='$e_email'");
if(!$sql){
echo"Your Details are not correct please contact the webmaster";
}
$login_check = mysql_num_rows($sql);
if($login_check > 0){
while($row = mysql_fetch_array($sql)){
foreach($row AS $key => $val){
$$key = stripslashes( $val );
}
// Register some session variables!
$_SESSION['session_e_name'] = $e_name;
$_SESSION['session_e_email'] = $e_email;
$_SESSION['session_e_username'] = $e_username;
$_SESSION['session_e_password'] = $e_password;
$_SESSION['session_e_user_level'] = $e_user_level;
$_SESSION['session_venue'] = $venue;
//mysql_query("UPDATE employees SET e_lastlogin=now() WHERE e_name='$e_name'");
foreach( $_GET AS $fieldname => $val ){
$$fieldname = stripslashes( $val );
//echo"<tr><td>$$fieldname</td><td>$fieldname<?td><td>$val</td><td>$stencils</td></tr>";
}
$sql = mysql_query("INSERT INTO neworder (o_name, o_venue, o_email, airbrush, hose, ink, mixjar, cleanbottle, gloves, alcwipes, shimbrush, powdbrush, setpowder, shimmer, vials, needleass, hoseadapt, jartop, sprayplung, connectset, screwdrivers, wrench, plyers, regulator, threadtape, velcro, extcord, compressor, supplydrawer, bin, mirrors, towels, facecloths, folders, inserts, knife, stapler, pick, qtips, toothpicks, calc, clipboard, carecards, pens, manuals, menus, mainposter, oheadposter, uvposter, stencils, uniform, extraconnector, carestamp, sprayad, alc, neworder, readorder, stencilsdoneorder, sentorder, date)
VALUES('$o_name', '$o_venue', '$o_email', '$airbrush', '$hose', '$ink', '$mixjar', '$cleanbottle', '$gloves', '$alcwipes', '$shimbrush', '$powdbrush', '$setpowder', '$shimmer', '$vials', '$needleass', '$hoseadapt', '$jartop', '$sprayplung', '$connectset', '$screwdrivers', '$wrench', '$plyers', '$regulator', '$threadtape', '$velcro', '$extcord', '$compressor', '$supplydrawer', '$bin', '$mirrors', '$towels', '$facecloths', '$folders', '$inserts', '$knife', '$stapler', '$pick', '$qtips', '$toothpicks', '$calc', '$clipboard', '$carecards', '$pens', '$manuals', '$menus', '$mainposter', '$oheadposter', '$uvposter', '$stencils', '$uniform', '$extraconnector', '$carestamp', '$sprayad', '$alc', 'yes', 'no', 'no', 'no', now())") or die (mysql_error());
if(!$sql){
echo 'There has been an error adding your order. Please contact the webmaster.';
include 'footer.php';
} else {
echo"<center>Thankyou for your order, it has been recieved and will be processed promptly.</center>";
include 'footer.php';
}
}
} else {
echo "You could not be logged in! You have supplied incorrect information.<br />
Please try again! Or contact us to report the problem if it persists.<br />";
include 'login_form.php';
}
?>
