+ Reply to Thread
Results 1 to 2 of 2

Thread: mysql_query help

  1. #1
    xsystemx is offline x10Hosting Member xsystemx is an unknown quantity at this point
    Join Date
    Mar 2009
    Posts
    4

    mysql_query help

    Code:
    <div id="col-two">
    <div class="boxed">
    <h2 class="title">SUBMIT</h2>
    <div class="content">
    <p>
    <? 
    $A = $_POST['Artist']; 
    $B = $_POST['Album']; 
    $C = $_POST['Song'];
    $D = $_POST['GuitarX'];
    $E = $_POST['GuitarH'];
    $F = $_POST['GuitarM'];
    $G = $_POST['GuitarE'];
    $H = $_POST['BassX'];
    $I = $_POST['BassH'];
    $J = $_POST['BassM'];
    $K = $_POST['BassE'];
    $L = $_POST['DrumsX'];
    $M = $_POST['DrumsH'];
    $N = $_POST['DrumsM'];
    $O = $_POST['DrumsE'];
    $P = $_POST['Download'];
    $sqlQuery1 = "SELECT * FROM `ARTIST` WHERE `ARTIST` = '$A' LIMIT 0 , 1";
    $sqlQuery2 = "SELECT * FROM `ALBUM` WHERE `ARTIST` = '$A' AND `ALBUM` = '$B' AND `YEAR` = '$C' AND `ART` = '$D' LIMIT 0 , 1";
    $sqlQuery3 = "INSERT INTO `xsystemx_songs`.`ARTIST` (`id` ,`ARTIST`) VALUES (NULL , '$A');";
    $sqlQuery4 = "INSERT INTO `xsystemx_songs`.`ALBUM` (`ID` ,`ARTIST` ,`ALBUM` ,`YEAR` ,`ART` )VALUES (NULL , '$A', '$B', '', '');";
    $sqlQuery5 = "INSERT INTO `xsystemx_songs`.`SONG` (`ID` ,`ARTIST` ,`ALBUM` ,`SONG` ,`DISC` ,`TIME` ,`TRACK` ,`CAREER` ,`TIER` ,`DOWNLOAD` ,`GX` ,`GH` ,`GM` ,`GE` ,`BX` ,`BH` ,`BM` ,`BE` ,`DX` ,`DH` ,`DM` ,`DE` )VALUES (NULL , '$A', '$B', '$C', 'NULL', 'NULL', 'NULL', NULL , NULL , '$P', '$D', '$E', '$F', '$G', '$H', '$I', '$J', '$K', '$L', '$M', '$N', '$O');"; 
    mysql_connect("localhost", "", "") or die(mysql_error());
    mysql_select_db("") or die(mysql_error());
     
    
    //THIS IS THE PART I NEED HELP DOING START
     
     
    if($A == "$sqlQuery1"){echo "VALID ARTIST";} 
    else{mysql_query("$sqlQuery3"); echo "NEW ARTIST";}
    if($B == "$sqlQuery2"){echo "VALID ALBUM";} 
    else{mysql_query("$sqlQuery4"); echo "NEW ALBUM"; }
     
     
    //THIS IS THE PART I NEED HELP DOING END
    
     
    mysql_query("$sqlQuery5")
    ?>
    </p>
    </div>
    </div>
    </div>
    Last edited by xsystemx; 05-24-2009 at 08:03 PM.

  2. #2
    trike97 is offline x10Hosting Member trike97 is an unknown quantity at this point
    Join Date
    May 2009
    Posts
    5

    Re: mysql_query help

    try connecting to the database before you run a query, in other words

    $sqlQuery1 = null

    unless you connect to the DB first.

+ Reply to Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
x10hosting free hosting for the masses
dedicated servers