[SOLVED] Loop Error

[Zepo.]

$apps = mysql_query("SELECT signupid,name.gamename,sn,email,pass,position,info,time,ip FROM apply");
while ($apps = mysql_fetch_array($apps)){

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource.

The loop works, its just that it gives that warning....

[redarrow]

wht this part mate is it a join name.gamename

[Zepo.]

$apps = mysql_query("SELECT signupid,name,gamename,sn,email,pass,position,info,time,ip FROM apply");
while ($apps = mysql_fetch_array($apps)){

 

Sorry.

[MadTechie]

try this

 

<?php
$apps = mysql_query("SELECT signupid,name,gamename,sn,email,pass,position,info,time,ip FROM apply") or die(mysql_error());
while ($apps = mysql_fetch_array($apps)){
?>

 

whats the error ?

[redarrow]

add this please

 

sorry i got beat lol

 

<?php
$apps = mysql_query("SELECT signupid,name,gamename,sn,email,pass,position,info,time,ip FROM apply")or die(mysql_error()); // if a error show it.....

echo $apps; // if the error dosent show cheek query

while ($apps = mysql_fetch_assoc($apps)){
?>

[Zepo.]

It doesnt die, and it echos Resource id #9

[redarrow]

try

<?php
$apps = mysql_query("SELECT `signupid`,`name`,`gamename`,`sn`,`email`,`pass`,`position`,`info`,`time`,`ip` FROM `apply`")or die(mysql_error()); // if a error show it.....

echo $apps; // if the error dosent show cheek query

while ($apps = mysql_fetch_assoc($apps)){
?>

[Zepo.]

No difference. The weird part is that its actually working, just coming up with that error though.

[redarrow]

try assoc not array

[Zepo.]

I did, nothing.

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource

[Zepo.]

Bump.

[MadTechie]

lol, i should of noticed..

 

try changing to

<?php
$mySQL = mysql_query("SELECT signupid,name,gamename,sn,email,pass,position,info,time,ip FROM apply")or die(mysql_error());

while ($apps = mysql_fetch_assoc($mySQL)){
?>

[Zepo.]

Yup worked, that makes since to me now, defining a query to the same thing thats an array. Gotcha, thanks.