continued prob w/ mysql_fetch_array function

[ATS16805]

FORUM MODERATORS:
i marked my own thread resolved before i should have. i thought i had solved the problem, but i had only really got half of it. i hope that someone could mark it unresolved. thanks!

i'm still stuck on how to use this mysql_fetch_array function again that i need to pull the results from my query

i've shown my table in almost every post i've made about this-- not for any other reason that i made it, and it could perhaps provide a useful supplement to my illustration of my code problems. i hope no one is annoyed by it. 🙂

	<form method=\"post\" action=\"$_SERVER[PHP_SELF]\" >

	<p><strong>Headliner:</strong>
	<br />
	<select name=\"artist_id1\">
		<option value=\"\">-- Select Headliner --</option>";

	while ($recs1 = mysql_fetch_array($artist_ids)) {
		$artist_id1 = $recs1['artist_id'];
		$artist_name1 = stripslashes($recs1['artist_name']);

		$display_block .= "<option value=\"$artist_id1\">
			$artist_name1</option>";
	}
	$display_block .= "</select>
	<p><strong>First Supporting Act:</strong>

	<select name=\"artist_id2\">
		<option value=\"\">-- Select First Support --</option>";

getartists();

	while ($recs2 = mysql_fetch_array($artist_ids)) {
		$artist_id2 = $recs2['artist_id'];
		$artist_name2 = stripslashes($recs2['artist_name']);

		$display_block .= "<option value=\"$artist_id2\">
			$artist_name2</option>";
	}
	$display_block .= "</select>

as you can see, i even tried creating a function called getartists(), as in

function getartists() {
	$get_artist_ids = "select artist_id, artist_name from artist_info order by artist_name";
	$get_artist_ids_res = mysql_query($get_artist_ids) or die(mysql_error());

$artist_ids = $get_artist_ids_res;

global $artist_ids;
}

but it's not working either--- at least now how i'm using it!

help? :queasy:

[peppeto]

You can call your fuction like this
function getartists() {

global $artist_ids;
$get_artist_ids = "select artist_id, artist_name from artist_info order by artist_name";
$get_artist_ids_res = mysql_query($get_artist_ids) or die(mysql_error());
// this is worng $artist_ids = $get_artist_ids_res;
return $result;

}
//you call hier your function
$resultArtist = getartists();
$numArtist = mysql_num_rows($resultArtist);
if ($numArtist !=0)
{
while ($rowArtist = mysql_fetch_array($resultArtist))
{
$id = $rowArtist ["id"];

}
}
///// this is just a Idea how to go ferther

[ATS16805]

thank you! this definitely gives me something to go on-- and exactly what i needed!

[ATS16805]

okay... hmmm. i'm still a bit unsure of how to use this...

is the logic here

if ($numArtist !=0)
{
while ($rowArtist = mysql_fetch_array($resultArtist))
{
$id = $rowArtist ["id"];

}
}

supposed to replace the logic at the first part here?

if (mysql_num_rows($artist_ids) < 1) { 
        // NO RECORDS 
        $display_block .= "<p><em>Sorry, no artists exist to select!</em></p> 
                            <p>Please <a href=\"addartist.php\">go add the Artists first</a>, then come back and 
                            add the Concert Date</p>"; 
    } else { 
    $display_block = "<h1>Add a Date:</h1> 
    <form method=\"post\" action=\"$_SERVER[PHP_SELF]\" > 

    <p><strong>Headliner:</strong> 
    <br /> 
    <select name=\"artist_id1\"> 
        <option value=\"\">-- Select Headliner --</option>"; 

    while ($recs1 = mysql_fetch_array($artist_ids)) { 
        $artist_id1 = $recs1['artist_id']; 
        $artist_name1 = stripslashes($recs1['artist_name']);

??

and how do i replicate this bit of code using the function $resultArtist = getartists(); as you've presented for me

<select name=\"artist_id1\"> 
            <option value=\"\">-- Select Headliner --</option>"; 

    while ($recs1 = mysql_fetch_array($artist_ids)) { 
        $artist_id1 = $recs1['artist_id']; 
        $artist_name1 = stripslashes($recs1['artist_name']); 

        $display_block .= "<option value=\"$artist_id1\"> 
            $artist_name1</option>"; 
    } 
    $display_block .= "</select>

once i get that, i'll be home-free. i'm sorry to ask you to hold my hand through this, but i've been trying w/ it for a while and unable to get it to work... can't get past

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Apache\Apache2\htdocs\wwwroot\Crowbar\web_app\add_date.php on line 29

LINE 29 being this part in mine

if (mysql_num_rows($artist_ids) < 1) {
		// NO RECORDS