View Single Post
12-17-2006, 02:31 PM
#4
Alex Eyre is offline Alex Eyre
Alex Eyre's Avatar
Status: Designer
Join date: Aug 2006
Location: Manchester
Expertise:
Software:
 
Posts: 1,132
iTrader: 5 / 100%
 

Alex Eyre is on a distinguished road

Send a message via MSN to Alex Eyre

  Old

sure, the problem was not with the syntax as I had thought, it was with the PHP code itself, I now know that you need to add a while statement to make it work, so the PHP ended up like this:


$sql = "SELECT complete, proj FROM `data` WHERE email ='{$_SESSION['email']}' ";
$result = mysql_query($sql) or die(mysql_error());
while($row = mysql_fetch_array($result)){
Above, the superglobal 'result' will later be used in the script to define data taken from the mysql, like this, which will show 'proj' column from the respective row.


$row["proj"]
Hope this helps!
Alex.