Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $t = select * from tabnlename where email=something
- mysql_fetch_array($t)
- echo $t['slot1'] . $t['slot1'] and on and on ...
- supemail slot1 slot2 slot3 slot4 slot5
- opera@gmail.com somedata somedata somedata somedata somedata
- kaku@gmail.com somedata somedata somedata
- nashu@gmail.com somedata
- select Count(*)
- from MyTable
- where email = $something
- <?php
- $link = mysql_connect("localhost", "mysql_user", "mysql_password");
- mysql_select_db("database", $link);
- $result = mysql_query("SELECT * FROM table1 where email='stuff@email.com'", $link);
- $num_rows = mysql_num_rows($result);
- echo "$num_rows Rowsn";
- ?>
- if ($t['slot1'] == "" ) {$s1 = $t['slot1'] ;}
- else {$s1notnull =$t['slot1'] ; }
- if ($t['slot2'] == "" ) {$s2 = $t['slot2'] ;}
- else {$s2notnull =$t['slot2'] ; }
- if ($t['slot3'] == "" ) {$s3 = $t['slot3'] ;}
- else {$s3notnull =$t['slot3'] ; }
- if ($t['slot4'] == "" ) {$s4 = $t['slot4'] ;}
- else {$s4notnull =$t['slot4'] ; }
- if ($t['slot5'] == "" ) {$s5 = $t['slot5'] ;}
- else {$s5notnull =$t['slot5'] ; }
- $array_empty = array($s1, $s2, $s3, $s4, $s5);
- $how_is_empty = count($array_empty);
- select email,slot1 as s1, slot2 as s2, slot3 as s3, slot4 as s4, slot5 as s5, (count(s1+s2+s3+s4+s5)) from tabnlename where email=something
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement