Pi_Mastuh

Complex SQL Query Help Needed

Pi_Mastuh replied to Pi_Mastuh's topic in MySQL Help

I'm not sure how to get it to check all of those conditions though. I tried using parentheses inside of parenthesis and it didn't work.

January 29, 2011
3 replies

I am trying to run a rather complex query, and am getting the error: "Every derived table must have its own alias." I haven't done this kind of complex SQL before, could somebody tell me what I'm missing here? Thanks! $SQL2 = "SELECT * FROM shiftsIn WHERE date='$day' AND month='$month' AND year='$year' AND busID='$userBusID'"; $SQL = "SELECT * FROM ($SQL2) WHERE (startTime<='$startTime2' AND endTime>='$endTime2') OR (startTime IS NULL AND endTime IS NULL)"; $resultShifts = mysql_query($SQL,$connection) or die(mysql_error()); $numShifts = mysql_num_rows($resultShifts);

January 28, 2011
3 replies

Syntax Error when combining AND and OR

Pi_Mastuh replied to Pi_Mastuh's topic in MySQL Help

Makes sense, thanks!

January 25, 2011
3 replies

Syntax Error when combining AND and OR

Pi_Mastuh posted a topic in MySQL Help

I am trying to run a select query, and am not sure why I'm getting a syntax error. $SQL2 = "SELECT * FROM messages WHERE to='$username' OR (to='ALL' AND busID='$busID')"; $result = mysql_query($SQL2,$connection) or die(mysql_error()); "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'to='lynsey93' OR (to='ALL' AND busID='1')' at line 1" Could anybody shed some light on the situation?

January 24, 2011
3 replies

Tables are moving

Pi_Mastuh replied to Pi_Mastuh's topic in CSS Help

Here's my code, is there something wrong in it?: <? session_start(); $session=session_id( ); include ("secure/config.php"); //WHEN YOU PUT THIS ON THE PAGES ADD A secure/ BEFORE CONFIG.PHP! ?> <script language="JavaScript" type="text/JavaScript">  </script> <META NAME="Description" CONTENT="Net-Petz is the newest virtual pet site on the internet. It has fun games, lots of cool petz to adopt, and tons of awesome items! It's completely free!"> <META NAME="Keywords" CONTENT="petz, net, virtual, pets, pet, fun, games, game, "> </head> <body> <? if ($preuserID == 0) { include ("../oops.htm"); die; } ?> <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="1155" id="AutoNumber1" height="802"> <tr><td width="1483" height="138" valign="top" align="right" <? $rand = rand (1,10); if ($rand == 1) { echo "background=SB1_anubis.png"; } elseif ($rand == 2) { echo "background=SB1_bromaro.png"; } elseif ($rand == 3) { echo "background=SB1_fang.png"; } elseif ($rand == 4) { echo "background=SB1_kitachia.png"; } elseif ($rand == 5) { echo "background=SB1_coarattla.png"; } elseif ($rand == 6) { echo "background=SB1_dragonous.png"; } elseif ($rand == 7) { echo "background=SB1_fizz.png"; } elseif ($rand == { echo "background=SB1_woofosa.png"; } elseif ($rand == 9) { echo "background=SB1_worfoli.png"; } elseif ($rand == 10) { echo "background=SB1_lionaya.png"; } ?> colspan="2"> <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber3" height="113"> <tr> <td width="15%" height="104" colspan="3" rowspan="3"> </td> <td width="31%" height="40"> </td> <td width="54%" height="104" rowspan="3"> </td> </tr> <tr> <td width="31%" height="23"> <? if ($preuserID != 0){ print "<a href=http://www.net-petz.com/reg/lookup.php?Name=$preuserName>$preuserName</a>"; } else { print "Guest"; } ?> - <? if ($preuserID != 0){ print "<a href=http://www.net-petz.com/reg/bank.php>$points NPz</a>"; } else { print "0 NPz"; } ?> - <? if ($preuserID != 0 AND $activePetID == 0) { print "No Active Pet"; } elseif ($preuserID != 0){ print "<a href=http://www.net-petz.com/reg/petDetails2.php?monopetID=$activePetID>$activePetName</a> is Active"; } else { print "No Active Pet"; } ?></td> </tr> </table> </td> </tr><tr><td> <div style="background-image:url("SB3.png"); height:600px; height:100px; padding: 10px; text-align:center"> .: Main :. <? if ($preuserID != 0){ echo "<a href=http://www.net-petz.com/reg/home.php>Home</a>"; } else { echo "<a href=http://www.net-petz.com>Home</a>"; } ?> <a href="http://www.net-petz.com/reg/mypets.php">My Petz</a> <a href="http://www.net-petz.com/reg/myitems.php">Inventory</a> <? if ($preuserID != 0){ echo "<a href=http://www.net-petz.com/reg/logout.php><- Logout</a> "; } else { echo "<a href=http://www.net-petz.com/login.php>Login -></a> "; } ?> .:Explore:. <a href="http://www.net-petz.com/reg/netlandia.php"> Netlandia</a> <a href="http://www.net-petz.com/reg/city.php">Net-City</a> .:Interact:. <a href="http://www.net-petz.com/reg/messageboard.php"> Net-Boards</a> <a href="http://www.net-petz.com/reg/inbox.php">Net-Mail</a> <a href="http://www.net-petz.com/reg/lookups.php">Lookups</a> <a href="http://www.net-petz.com/reg/ushops.php">User Shops</a> .:Fun:. <a href="http://www.net-petz.com/reg/games.php">Game Room</a> <a href="http://www.net-petz.com/reg/stuff.php">Fun Stuff</a> .:Options:. <a href="http://www.net-petz.com/reg/userInfo.php"> User Options</a> <a href="http://www.net-petz.com/reg/luedit.php">Lookup Options</a> <a href="http://www.net-petz.com/reg/boardpreff.php"> Board Options</a> .:More:. <? if ($preuserID != 0){ echo "<a href=http://www.net-petz.com/reg/help.php>About Us</a>"; } else { echo "<a href=http://www.net-petz.com/help.php>About Us</a>"; } ?> <? if ($preuserID != 0){ echo "<a href=http://www.net-petz.com/reg/contact.php>Contact Us</a>"; } else { echo "<a href=http://www.net-petz.com/contact.php>Contact Us</a>"; } ?></td> </div> </tr> </table> </td> <td width="1213" height="1002" valign="top" align="center" rowspan="2"> <? include ("secure/randoms.php"); ?> <? //PAGE CONTENT ?> <? //END PAGE CONTENT ?> </td> </tr> <tr> <td width="270" height="415" valign="top" align="right"> </td> </tr> </table> </body> </html>

April 21, 2007
5 replies

Tables are moving

Pi_Mastuh replied to Pi_Mastuh's topic in CSS Help

I got this: http://i98.photobucket.com/albums/l247/Thomalor/sc3.jpg

April 19, 2007
5 replies

Tables are moving

Pi_Mastuh replied to Pi_Mastuh's topic in CSS Help

How do I do that? Here's the code I'm using: <? session_start(); $session=session_id( ); include ("secure/config.php"); //WHEN YOU PUT THIS ON THE PAGES ADD A secure/ BEFORE CONFIG.PHP! ?> <script language="JavaScript" type="text/JavaScript">  </script> <META NAME="Description" CONTENT="Net-Petz is the newest virtual pet site on the internet. It has fun games, lots of cool petz to adopt, and tons of awesome items! It's completely free!"> <META NAME="Keywords" CONTENT="petz, net, virtual, pets, pet, fun, games, game, "> </head> <body> <? if ($preuserID == 0) { include ("../oops.htm"); die; } ?> <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="1155" id="AutoNumber1" height="802"> <tr><td width="1483" height="138" valign="top" align="right" <? $rand = rand (1,10); if ($rand == 1) { echo "background=SB1_anubis.png"; } elseif ($rand == 2) { echo "background=SB1_bromaro.png"; } elseif ($rand == 3) { echo "background=SB1_fang.png"; } elseif ($rand == 4) { echo "background=SB1_kitachia.png"; } elseif ($rand == 5) { echo "background=SB1_coarattla.png"; } elseif ($rand == 6) { echo "background=SB1_dragonous.png"; } elseif ($rand == 7) { echo "background=SB1_fizz.png"; } elseif ($rand == { echo "background=SB1_woofosa.png"; } elseif ($rand == 9) { echo "background=SB1_worfoli.png"; } elseif ($rand == 10) { echo "background=SB1_lionaya.png"; } ?> colspan="2"> <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber3" height="113"> <tr> <td width="15%" height="104" colspan="3" rowspan="3"> </td> <td width="31%" height="40"> </td> <td width="54%" height="104" rowspan="3"> </td> </tr> <tr> <td width="31%" height="23"> <? if ($preuserID != 0){ print "<a href=http://www.net-petz.com/reg/lookup.php?Name=$preuserName>$preuserName</a>"; } else { print "Guest"; } ?> - <? if ($preuserID != 0){ print "<a href=http://www.net-petz.com/reg/bank.php>$points NPz</a>"; } else { print "0 NPz"; } ?> - <? if ($preuserID != 0 AND $activePetID == 0) { print "No Active Pet"; } elseif ($preuserID != 0){ print "<a href=http://www.net-petz.com/reg/petDetails2.php?monopetID=$activePetID>$activePetName</a> is Active"; } else { print "No Active Pet"; } ?></td> </tr> </table> </td> </tr> <tr> <td width="325" height="657" valign="top" align="right" background="SB3.png"> <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="103%" id="AutoNumber4" height="42"> <tr> <td width="7%" height="27" align="center"> </td> <td width="51%" height="27" align="center" valign="top"> </td> <td width="92%" height="27"> </td> </tr> <tr> <td width="7%" height="536" align="center"> </td> <td width="51%" height="536" align="center" valign="top"> .:Main:. <? if ($preuserID != 0){ echo "<a href=http://www.net-petz.com/reg/home.php>Home</a>"; } else { echo "<a href=http://www.net-petz.com>Home</a>"; } ?> <a href="http://www.net-petz.com/reg/mypets.php">My Petz</a> <a href="http://www.net-petz.com/reg/myitems.php">Inventory</a> <? if ($preuserID != 0){ echo "<a href=http://www.net-petz.com/reg/logout.php><- Logout</a> "; } else { echo "<a href=http://www.net-petz.com/login.php>Login -></a> "; } ?> .:Explore:. <a href="http://www.net-petz.com/reg/netlandia.php"> Netlandia</a> <a href="http://www.net-petz.com/reg/city.php">Net-City</a> .:Interact:. <a href="http://www.net-petz.com/reg/messageboard.php"> Net-Boards</a> <a href="http://www.net-petz.com/reg/inbox.php">Net-Mail</a> <a href="http://www.net-petz.com/reg/lookups.php">Lookups</a> <a href="http://www.net-petz.com/reg/ushops.php">User Shops</a> .:Fun:. <a href="http://www.net-petz.com/reg/games.php">Game Room</a> <a href="http://www.net-petz.com/reg/stuff.php">Fun Stuff</a> .:Options:. <a href="http://www.net-petz.com/reg/userInfo.php"> User Options</a> <a href="http://www.net-petz.com/reg/luedit.php">Lookup Options</a> <a href="http://www.net-petz.com/reg/boardpreff.php"> Board Options</a> .:More:. <? if ($preuserID != 0){ echo "<a href=http://www.net-petz.com/reg/help.php>About Us</a>"; } else { echo "<a href=http://www.net-petz.com/help.php>About Us</a>"; } ?> <? if ($preuserID != 0){ echo "<a href=http://www.net-petz.com/reg/contact.php>Contact Us</a>"; } else { echo "<a href=http://www.net-petz.com/contact.php>Contact Us</a>"; } ?></td> <td width="92%" height="536"> </td> </tr> </table> </td> <td width="1213" height="1002" valign="top" align="center" rowspan="2"> <? include ("secure/randoms.php"); ?> <? //PAGE CONTENT ?> <? //END PAGE CONTENT ?> </td> </tr> <tr> <td width="270" height="415" valign="top" align="right"> </td> </tr> </table> </body> </html>

April 18, 2007
5 replies

Tables are moving

Pi_Mastuh posted a topic in CSS Help

I have a sidebar made using tables and the image as the background, but when there's content in the main table to pushes on the sidebar tables thus misaligning the text. I have some images: http://i98.photobucket.com/albums/l247/Thomalor/sc1.jpg http://i98.photobucket.com/albums/l247/Thomalor/sc2.jpg

April 17, 2007
5 replies

Page is blank

Pi_Mastuh replied to Pi_Mastuh's topic in PHP Coding Help

Oh! That shouldn't be on this one, it's the script that tells it to say "you're not logged in" if you're not, but you shouldn't be logged in on the login page

April 17, 2007
4 replies

Page is blank

Pi_Mastuh posted a topic in PHP Coding Help

When I go to this page it's just a blank screen. Would anyone be able to tell me what's wrong? <? session_start(); $session=session_id( ); include ("secure/config.php"); //WHEN YOU PUT THIS ON THE PAGES ADD A secure/ BEFORE CONFIG.PHP! ?> <script language="JavaScript" type="text/JavaScript">  </script> <META NAME="Description" CONTENT="Net-Petz is the newest virtual pet site on the internet. It has fun games, lots of cool petz to adopt, and tons of awesome items! It's completely free!"> <META NAME="Keywords" CONTENT="petz, net, virtual, pets, pet, fun, games, game, "> </head> <body> <? if ($preuserID == 0) { include ("../oops.htm"); die; } ?> <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="1155" id="AutoNumber1" height="802"> <tr> <td width="1483" height="138" valign="top" align="right" <?php $imgs = ('anubis','bromaro','fang','kitachia','coarattla','dragonous','fizz','woofosa','worfoli','lionaya'); $rand = rand (0,9); echo ' background="SB1_' . $imgs[$i] . '"'; ?> colspan="2"> <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber3" height="113"> <tr> <td width="15%" height="104" colspan="3" rowspan="3"> </td> <td width="31%" height="40"> </td> <td width="54%" height="104" rowspan="3"> </td> </tr> <tr> <td width="31%" height="23"> <? if ($preuserID != 0){ print "<a href=http://www.net-petz.com/reg/lookup.php?Name=$preuserName>$preuserName</a>"; } else { print "Guest"; } ?> - <? if ($preuserID != 0){ print "<a href=http://www.net-petz.com/reg/bank.php>$points NPz</a>"; } else { print "0 NPz"; } ?> - <? if ($preuserID != 0 AND $activePetID == 0) { print "No Active Pet"; } elseif ($preuserID != 0){ print "<a href=http://www.net-petz.com/reg/petDetails2.php?monopetID=$activePetID>$activePetName</a> is Active"; } else { print "No Active Pet"; } ?></td> </tr> </table> </td> </tr> <tr> <td width="325" height="657" valign="top" align="right" background="SB3.png"> <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="103%" id="AutoNumber4" height="42"> <tr> <td width="7%" height="27" align="center"> </td> <td width="51%" height="27" align="center" valign="top"> </td> <td width="92%" height="27"> </td> </tr> <tr> <td width="7%" height="536" align="center"> </td> <td width="51%" height="536" align="center" valign="top"> .:Main:. <? if ($preuserID != 0){ echo "<a href=http://www.net-petz.com/reg/home.php>Home</a>"; } else { echo "<a href=http://www.net-petz.com>Home</a>"; } ?> <a href="http://www.net-petz.com/reg/mypets.php">My Petz</a> <a href="http://www.net-petz.com/reg/myitems.php">Inventory</a> <? if ($preuserID != 0){ echo "<a href=http://www.net-petz.com/reg/logout.php><- Logout</a> "; } else { echo "<a href=http://www.net-petz.com/login.php>Login -></a> "; } ?> .:Explore:. <a href="http://www.net-petz.com/reg/netlandia.php"> Netlandia</a> <a href="http://www.net-petz.com/reg/city.php">Net-City</a> .:Interact:. <a href="http://www.net-petz.com/reg/messageboard.php"> Net-Boards</a> <a href="http://www.net-petz.com/reg/inbox.php">Net-Mail</a> <a href="http://www.net-petz.com/reg/lookups.php">Lookups</a> <a href="http://www.net-petz.com/reg/ushops.php">User Shops</a> .:Fun:. <a href="http://www.net-petz.com/reg/games.php">Game Room</a> <a href="http://www.net-petz.com/reg/stuff.php">Fun Stuff</a> .:Options:. <a href="http://www.net-petz.com/reg/userInfo.php"> User Options</a> <a href="http://www.net-petz.com/reg/luedit.php">Lookup Options</a> <a href="http://www.net-petz.com/reg/boardpreff.php"> Board Options</a> .:More:. <? if ($preuserID != 0){ echo "<a href=http://www.net-petz.com/reg/help.php>About Us</a>"; } else { echo "<a href=http://www.net-petz.com/help.php>About Us</a>"; } ?> <? if ($preuserID != 0){ echo "<a href=http://www.net-petz.com/reg/contact.php>Contact Us</a>"; } else { echo "<a href=http://www.net-petz.com/contact.php>Contact Us</a>"; } ?></td> <td width="92%" height="536"> </td> </tr> </table> </td> <td width="1213" height="1002" valign="top" align="center" rowspan="2"> <? include ("secure/randoms.php"); ?> <? //PAGE CONTENT ?> Login</div></td> </tr> <tr> <td bgcolor="#CEE7FF"> <div align="center"> <form method="POST" action="reg/secure/index.php"> <table width="300" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="219"> User Name: </td> <td width="181"> <input type="text" name="preuserName" size="20"> </td> </tr> <tr> <td width="219"> Password:</td> <td width="181"> <input type="password" name="preuserPassword" size="20"> </td> </tr> <tr> <td colspan="2" height="2"> <div align="center"> </div></td> </tr> <tr> <td colspan="2" height="2"> <div align="center"> <input type=submit name="Submit" value="Submit"> </div></td> </tr> </table> </form> <? //END PAGE CONTENT ?> </td> </tr> <tr> <td width="270" height="415" valign="top" align="right"> </td> </tr> </table> </body> </html>