Iv been working on this for a while and cant figure out why its not working
$userid = mysql_query(“SELECT * FROM members username = $_SESSION[‘myusername’]”);
that’s the query
<?php if($userid['location']==1)echo "Iv been working on this for a while and cant figure out why its not working
$userid = mysql_query(“SELECT * FROM members username = $_SESSION[‘myusername’]”);
that’s the query
<?php if($userid['location']==1)echo "You need to quote text values in a query and to use the array either concatenate or use braces:
[php]$query = “SELECT * FROM members username = ‘{$_SESSION[‘myusername’]}’”;[/php]
Beyond that, you haven’t shown any code or debugging attempts.
this is what I put in.
$userid = mysql_query(“SELECT * FROM members username = ‘{$_SESSION[‘myusername’]}’”);
<?php if($userid['location']==1)echo "echo $userid[‘location’];
Nothing works not even the echo $userid[‘location’];
That’s not even close. Stop using mysql and look at mysqli or PDO. Example for mysqli: http://www.google.com/search?q=mysqli+tutorial+-“w3schools.com”
after reading up on it I got it working perfect for 1 part but I`m not really strong at merging PHP and HTML i can do a little bit but i got a REALLY complicated one
<?php if($test['location']==1)echo "if tried different ways on typing it in but for some odd reason it keeps giving me multiple errors im gonna keep trying at it but so far hit a wall lol, sorry im still getting used to html and php working together probally something im over looking.
if your wondering about the echo $rows[‘part’] its so i can pull the data off on the next page that then shoots an email off to my parts department found it to be the simples way so techs don’t have to type in the part its like a quick order button click don’t type anything and walk away no more to it